Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
exportimportproductsexternalid
1 ตอบกลับ
5969 มุมมอง
อวตาร
Parker D

Hi, I observed a curious thing: 

I exported all product variants to a csv file to update two numbers for the warehouse (length and width). I then imported that csv file, but not under "product variants" > "Import records", but under "products" > "import records".

The exported ID was " __export__.product_product_43772_0d0d8199". I used this to update the products variant by importing the new csv under Products > Import records. 

But instead of updating, Odoo imported a completely new product with a completely new ID. 

The curious thing was, that all of the product variants I tried to update had a new external ID afterwards. The before mentioned product has "__export__.product_product_43772_b62b7404" now. As you can see, only the random part after the last underscore has changed. Same thing with the other IDs.

Does anyone know why that is? I am quite new in the Odoo world, though...

PS: I finally got it and exported the external IDs again, imported the data under "Products Variants" > "Import records" and  voila, it worked.

อวตาร
ละทิ้ง
อวตาร
Ermin Trevisan
คำตอบที่ดีที่สุด

Product templates and product variants are separate entities and have their own External IDs.

Let's try to figure out what happened:

1. You did export product_product (variants). By exporting, Odoo creates External IDs if not already defined. These IDs contain the string product_product. It might be that 43772 is the database ID, but I'm not sure. You can check it in the database table directly.

2. You did import your product_products into the product template data model (product_template). As you are completely free to define your own External IDs, Odoo simply accepted your product_product-Export IDs. But it created new product-templates, because you did import into the wrong data model. If an External ID does not exist in a data model, then Odoo creates a new record instead of updating an existing record.

3. When creating a new product_template record, Odoo automatically creates one new product_product (variant) record. This record gets a new product_product External ID when you export it again.


อวตาร
ละทิ้ง
Parker D
ผู้เขียน

True, but this does not explain why the external ID of existing variants is changed after the import. I guess the number in "__export__.product_product_43772_0d0d8199" is the actual database ID... but what is the alphanumeric rest of it that does change?

Ermin Trevisan

The true database ID is an integer and is not related to an external ID.

Richard

Thanks so much, Ermin. Was trying to work out how a customer we had managed to change their "product_product_xxxx" external ids so they were now linked to "product.pricelist.item" model.

Then, of course, on next export, all their variants got new export ids. This explanation saved me a lot of investigation, and checking timestamps of the external identifiers (create date / modify date) and the newly created pricelist item record as the same timestamp as the modified external identifier modify date proved valuable, and allowed us to find the responsible user...

Good answer.

Related Posts ตอบกลับ มุมมอง กิจกรรม
Where are the import/export functions for products?
export import products
อวตาร
อวตาร
อวตาร
4
มี.ค. 15
11086
Price Update
export import
อวตาร
อวตาร
2
พ.ย. 24
2266
Export/Import Issue: "Root articles must have internal permission" แก้ไขแล้ว
export import
อวตาร
1
พ.ย. 24
3133
Import exported CSV on module load
export import
อวตาร
อวตาร
1
ต.ค. 23
3860
How to import and export with woocommerce? แก้ไขแล้ว
export import
อวตาร
อวตาร
อวตาร
อวตาร
3
ธ.ค. 23
21666