Importing Extra Variant Images in Odoo
Since product variants (configurated products) benefit from having their own additional images, and being able to add those in bulk is important. Here's a quick walkthrough of how to add extra variant image(s) to your product variants in Odoo eCommerce.
From the product template, click the Variants smart button
Select all variants and click Actions > Export
Check "I want to update data (import-compatible export). Then, export whichever field you need to identify each variant from each other. Since this example only has one attribute, I'm using "Variant Values".
You can export this as XLSX or CSV, depending on the software you're using to modify the data.
Export the data and import into your spreadsheet software. I'll be using Google Sheets.
This will give you the external ID (id) and the field you chose to identify each variant.
Add two columns with these headers:
- Extra Variant Images / Image
- Extra Variant Images / Name
Then, populate those new column fields with the URL of the image for the variant, and give that image a name. I just used the default filename generated by Google Drive for this example.
Export the sheet as an XLSX or CSV.
Next, go back to Odoo and navigate to Products > Product Variants. This is NOT the same view where you exported your variants.
Then click the Action > Import Records
Upload the file you just exported and make sure that the fields map as follows:
- id = External ID
- [the identifying field you chose] = None (do not import)
- Extra Variant Images / Image = Extra Variant Images / Image
- Extra Variant Images / Name = Extra Variant Images / Name
Click TEST to ensure there are no errors. You should see the Everything Seems Valid message.
Click IMPORT.
Once imported, go back to Products > Products and open the product template, then click the Variants smart button. You will not be able to see results from the current view.
You'll now see the new image under "Extra Variant Media"
On the front end, the image you added becomes the second image after the main product image.