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

Hello Guys,  I have this problem.

I have 3 providers who give me their information (products, stock, prices) using a csv, or xls. Then I must update the information every month.

Example 3 provider have an internal code Example. PRO1-HDD-XXX , PRO2-itemXXX , but both use the manufacturer part number. So i want use this manufacturer ID as my Internal ID. 

But if I add a product or some user add new product it will use an ID generated by Odoo... 

What is the best form for update a large amount of products every month? 

I want this..

I update. If product exist just update, if not  create new... 


I  hope u can understand my question. Thanks in advanced




 



อวตาร
ละทิ้ง
Ray Carnes

nd what is the best practice "in your opinion" to do this, we are a company, who buy and sell products, or install that products, we have a little stock but major cases use the dropship. But we want show that stock on web page.. 

Ray Carnes

Is this another question? I don't understand you fi it is - Sorry! My opinion is what I posted already.

อวตาร
Ray Carnes
คำตอบที่ดีที่สุด

Use the Provider and Product Internal Code and make an 'External ID' for each product:

ProviderA.PRO1-HDD-XXX

ProviderA.PRO2-itemXXX

ProviderB.PRO1-HDD-XXX


A file like that will check for an existing product with External ID matching.  If it finds the product, the import will UPDATE.  If it does not find it, the import will INSERT/ADD.


The first time you upload this way, Odoo will find no other products matching, so every product will be ADDED.

Then, if you supply this file:

ProviderA.PRO1-HDD-XXX

ProviderB.PRO2-itemXXX

ProviderB.PRO1-HDD-XXX


Odoo will find the first product, so will UPDATE.  It will not find the second product, so will ADD.  It will find the third product, so will UPDATE.


The only problem you will face is if a user adds products in between the imports.  Since Odoo will have the XML blank (only if you export it will you get a value) then it won't match.




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

And what is the best practice "in your opinion" to do this, we are a company, who buy and sell products, or install that products, we have a little stock but major cases use the dropship. But we want show that stock on web page.

Related Posts ตอบกลับ มุมมอง กิจกรรม
Trying to update product list by import from Excel sheet
update products
อวตาร
อวตาร
2
มิ.ย. 24
2309
How to update products master data in a custom app?
product update
อวตาร
อวตาร
1
ต.ค. 23
2535
Update data by import via .csv files? แก้ไขแล้ว
import csv update
อวตาร
อวตาร
อวตาร
อวตาร
อวตาร
4
พ.ย. 23
33193
error product import
product import csv
อวตาร
อวตาร
1
ก.ย. 19
3750
Error on importing products (Uncaught TypeError: Cannot read property '1' of undefined)
csv importing products
อวตาร
0
ส.ค. 16
7359