[Inventory][Odoo18] How can I import product variants in Odoo 18 (Version 18)?

Question

Prerequisite
Install sales and inventory application The demonstration is based in United States localization Create product attribute: Milk (creation: Never), some values Create product attribute: Syrups (creation: Never), some values This is the 'product template' 'import template'
This file has product attributes and variants included
https://docs.google.com/spreadsheets/d/1RSTntmPrbPUmSjrB-GA-Ps8dhsv63PMn/edit?gid=1797117805#gid=1797117805 [1]

[1] https://docs.google.com/spreadsheets/d/1RST

Pei Hua Tsai (pht) · Accepted Answer

Video

Create a product named 'Black coffee' Create attributes and values from the sales application
The following example is Milk with values
image [1]  After we have two attributes, Milk and Syrups, export with the columns below.  image [2]
3. We will get the Excel file as below. The red and blue boxes match the export technical field above.
image [3]
4. Prepare the Excel file with the product template name and
external ID, product attribute external ID, and values external ID.
Most importan

Dhrumi (Wan Buffer Services) · Answer

You can import product variants in Odoo 18 using the *Import* feature from the Product Variants menu.
📌 *Steps:*

Go to *Inventory* → *Products* → *Product Variants*.

Click on *“Import”* in the top right.

Download the *sample import template* to ensure correct formatting.

Your file must include:

Product Template (internal reference or name)

Attribute names and values (e.g., Color: Red, Size: M)

Internal Reference and Barcode (optional)

Upload and test the import using the *Test Import* b

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
Please refer to the following links:
1. https://www.odoo.com/documentation/18.0/applications/sales/sales/products_prices/products/import.html [1]
2. https://www.cybrosys.com/blog/how-to-import-product-attributes-and-product-variants-in-odoo-17 [2]

Hope it helps.

[1] https://www.odoo.com/documentation/18.0/applications/sales/sales/products_prices/products/import.html
[2] https://www.cybrosys.com/blog/how-to-import-product-attributes-and-product-variants-in-odoo-17

Related Posts	Replies	Views
[Accounting][Odoo 18] Loan Management Solved accounting SF-Experts Odoo 18	1 Nov 25	3067
How to import Product Variants images Solved import product.product SF-Experts	2 Oct 25	834
[Accounting] How do I recognize the vendor downpayment? Solved Accounting SF-Experts Odoo 18	1 Sep 25	1487
[Odoo 18][Accounting] Inter company transactions. Solved Accounting SF-Experts Odoo 18	1 Jun 25	3553
[Odoo 18][Accounting] GAAP Compliance: Customer down payment impacting ‘liability’ account Solved Accounting SF-Experts Odoo 18	1 Sep 25	1862

This question has been flagged

Enjoying the discussion? Don't just read, join in!