Weekly imports update the pricing for all our SKU's. Sometimes users create new products before the Import runs. This creates duplicates! How can I manage this?

Question

My weekly imports use an External ID in the form "barcode.XXXX" where XXXX is the barcode of the product.
Example :
Week 1: Product with External ID "barcode.1234" is created with price $5
Week 2: Product with External ID "barcode.1234 is UPDATED to price $6

Note that the barcode field is also updated with "1234".
As long as a user doesn't create products, I am able to update and/or add new products each week.
If users notice that a new product isn't yet in Odoo, they will create it.  Since Odo

Ray Carnes · Accepted Answer

Assuming you are managing the contents of the barcode field (to prevent duplicates or null values for example) you can do something like this via an Automated Action that runs on create and update of the Product Template:
product_barcode = record.barcode
env.cr.execute("SELECT * FROM ir_model_data WHERE module=%s and name=%s",
("barcode", product_barcode))
if env.cr.rowcount == 0:
env.cr.execute(""" INSERT INTO ir_model_data (module, name, model, res_id, date_init, date_update)
VALUES (%s, %s, %

Powiązane posty	Odpowiedzi	Widoki
Correct import of related records to Odoo import vendor external_id	1 mar 23	3631
import win32service as ws ImportError: DLL load failed: The specified module could not be found. import win32 v11.0	0 paź 21	8258
Cannot update product information through External ID import update external_id	5 kwi 18	9134
How to rename "External Id" with the "database id". import .id database_id external_id	2 mar 15	13575
Issue with import and comma in Excel File (odoo 19) import	0 wrz 25	234

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!