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