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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

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?

import external_id v11.0

1 Vastaa

5049 Näkymät

Community 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 Odoo doesn't assign an External ID, when the import runs, a DUPLICATE of this product will be created.

Example:

Between Week 2 and Week 3: Product with barcode 5678 is created by a user. External ID does not exist.

Week 3: Product with External ID "barcode.5678" is created - a DUPLICATE.

How can I setup Odoo so that when a user creates a Product, an External ID matching the format I am using is automatically created?

Ray Carnes

Paras vastaus

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, %s, %s, (now() at time zone 'UTC'), (now() at time zone 'UTC')) """, 
                  ("barcode", product_barcode, "product.template", record.id))

Note that this is the same way Odoo checks for and assigns External ID's during the import process:

\https://github.com/odoo/odoo/blob/11.0/odoo/addons/base/ir/ir_model.py#L257

XML ID UPDATE

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Correct import of related records to Odoo import vendor external_id	1 maalisk. 23	3670
import win32service as ws ImportError: DLL load failed: The specified module could not be found. import win32 v11.0	0 lokak. 21	8297
Cannot update product information through External ID import update external_id	5 huhtik. 18	9158
How to rename "External Id" with the "database id". import .id database_id external_id	2 maalisk. 15	13605
Issue with import and comma in Excel File (odoo 19) import	0 syysk. 25	234

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!