Skip to Content
This question has been flagged
1 Reply
2155 Views
Avatar
Darcy Martin

Hello all, 

I have had a few mass price changes in my business from my suppliers and lately every year it goes up. 

I have thousands of products in my inventory and i have been looking to upgrade my inventory management to odoo. 

I have been playing with the inventory to make sure it is right for me and this is what i have found. 

If i upload a csv of products and include the External ID for each then i can bulk import new CSV pricing which will change the products. 

This is fine but the issue comes around when i update stock levels. 


Lets say i have no stock of product TEST1 it has an external ID of TEST1 and barcode 111

Now if i import a new price list wih TEST1 as the external id and Barcode 111 then it will update cost and price no problem as many times as i want to change bulk pricing. 


If i have say 4 items of product TEST1 in stock with External TEST1 then all is well until i go to update pricing the same way i did before. 

Now it comes up with an error that the barcode is already in use so if i delete the barcode info and simply use the same external id as i did to update previously it just makes a new product with same name and external id but with no stock. 

Any idea how to work around this? 

Thanks, 
Darcy 

Avatar
Discard
Avatar
Josep Anton Belchi Riera
Best Answer

External Id must be unique. 

For some reason, Odoo does not recognize that the product in the new import file already exists in the DB. You can export both records (existing and new) and compare their IDs. They should be different. 

A good method to update data in a Odoo model is this:
- Export the external ID and the data to be changed (Example: External ID; price)
- Change the desired data, without touching the IDs.
- Import the file to Odoo. 

Hope this helps. 




Avatar
Discard