Hi,

The error you’re seeing happens because standard_price is a product template field, not a variant field, and Odoo doesn’t handle updates well when you try to import it through product.product (variants). That’s why creating new products works, but updating existing ones with just the internal database ID fails and throws the “tuple index out of range” error. The correct way is to export products from Products (product.template), include the “ID” or “External ID” along with the fields you want to update (like standard_price), and then re-import that file. If you really need to update variant-specific fields, you should work with Product Variants (product.product) but identify them using either External IDs or a combination of template and attribute values rather than relying on the raw database ID. This way, Odoo knows exactly which record to update and won’t throw errors.

Hope it helps.

I have tested with as simple dataset as follows:

I have made an export and tried to import the same data, but I encounter the same error every time.

Hello Mikko,

  It sounds like you're encountering a common issue related to data import in Odoo. This error typically occurs due to a mismatch in the expected format or a misalignment in the data columns. Here's how you can address this:

  1. Double-check the CSV or Excel file format. Ensure that the headers in your import file match exactly with the field names in Odoo for product variants (product.product model).

  2. Verify the ID column. The ID should be the external ID if you're updating existing records. If the external ID is not known, use the database ID but ensure it's correctly mapped.

  3. For the 'tuple index out of range' error, it might help to include an additional column in your import file that uniquely identifies each product variant, such as the default_code (Internal Reference) or the barcode field, alongside the ID.

  4. Test with a minimal dataset. Try importing a single row of data (excluding the header) to isolate the issue. If this succeeds, gradually increase the dataset to identify the problematic entry.

  5. Use Odoo's import compatibility tools. Before importing, Odoo offers a test import feature. Use this to validate your data against common errors.

For personalized assistance:
https://www.pragtech.co.in/contact-us-mql.html

Can you please provide the details or sample sheet here?