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
Use the Provider and Product Internal Code and make an 'External ID' for each product:
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:
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 9/8/16, 4:04 PM|
|Seen: 247 times|
|Last updated: 9/20/16, 11:04 AM|