Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged

Hello,

Is there way to skip or reimport products when barcode field is already populated?

For example, I get daily .csv pricelist with number of products from supplier. Some of them are same, some of them have updated price, some are new on the list. When I try to import products from file I get error because barcode is already defined for products.


Is there anything I can do to update products list?



Avatar
Opusti
Avtor

Thank you. Your solution works. Any way to automate this inside Odoo maybe?

Best Answer

Odoo determines whether to update or newly create a Product via CSV based on the external_id field.

When this column in the CSV is empty, Odoo assumes it is a new Product, an therefore tries to create a new Product. 
When this column is set, Odoo attempts to find an existing record with that external_id and either updates the Product (if that external_id is found) or creates a new Product (with this exact external_id).

That being said, if you happen to be able to re-import your Products from scratch from CSV (i.e. by removing the barcodes from all currently existing Products and then archiving them) you could simply duplicate the barcode column in your CSV and use that duplicated column as your external_id. This way, when importing CSV files again in future, you can again use that same concept, ultimately representing the barcode, to match your Products.

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
1
nov. 23
1929
1
apr. 24
4211
4
jun. 20
4842
1
mar. 15
5461
0
nov. 23
2211