[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

相关帖文	回复	查看
[Accounting] How do I recognize the vendor downpayment? Accounting SF-Experts Odoo 18	1 6月 25	606
[Odoo 18][Accounting] Inter company transactions. 已解决 Accounting SF-Experts Odoo 18	1 6月 25	1054
[Odoo 18][Accounting] GAAP Compliance: Customer down payment impacting ‘liability’ account Accounting SF-Experts Odoo 18	1 2月 25	1081
[PHT] Real costing using Lot/SN + Standard costing Accounting SF-Experts Odoo 18	2 3月 25	1023
[PHT] Real costing using Lot/SN + Average costing Accounting SF-Experts Odoo 18	1 3月 25	1070

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！