Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

All apps

How to import Product Variants if products are already in Odoo 14?

1 Ответить

7825 Представления

Hello,

We imported our product data already. But we have not imported the variants yet. How can we update the existintg products but creating variants?

What I did:

I created an attribute : "Attribute test: (I tried with variant creation mode = Dynamically or Instant) with 2 values: "Value 1" and "Value 2"

1/ Go to Export Variant > Export data (with internal ID, external ID, name)

2/ As the product does not have any variant, I created new lines in the CSV / Excel file with the following columns and values:

- Name = PRODUCTNAME

- product_template_attribute_value_ids = Attribute test: Value 2

3/ To import: Product variant > Favorites > Import > Upload file

--> But when I upload I get this error message:

No matching record found for name 'Attribute test: Value 2' in field 'Attribute Values' at row 2 ( PRODUCTNAME )

Can you please help? Thank you.

Лучший ответ

Hello,

First, you can export the product you needed. So you will get the External ID of the product.

id	name	attribute_line_ids/attribute_id	attribute_line_ids/value_ids
__export__.product_template_41565_b5dbe71f	1 Application Body Fluid Clean-Up Spill Kit Refill 717	Type	S2,S3

Like the above table, "id" is the External Id of the product.

"name" is the Product name

"attribute_line_ids/attribute_id" is the Variant Type.

"attribute_line_ids/value_ids" is the Variant Values. If you have multiple values, then give them separated by a comma.

You can do this on the the product.template

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Похожие посты	Ответы	Просмотры
import products with attributes values Odoo Решено import attributes v14	2 окт. 23	5070
Multiple Attributes in different columns but same row import variant attributes multiple_values	0 мая 16	5505
Remove Attribute (Variant List) variant attributes	1 нояб. 25	451
Import product with attributes from excel product import variant excel attributes	2 мая 24	6289
Many2many Fields import v14	1 июл. 23	2860