IMPORT (update) new stock of existing products does not work 12.0.2 Help needed please

linzbeech · December 23, 2020, 3:15am

Hi all,
Enjoying Dolibarr version 12.0.2. I have just tried to import a CSV file of existing products to update quantities in a warehouse. When I first did the import using the stocks import pictured below and ran the import simulation there were no errors. I then checked the stocks which should have been updated and no quantities have changed at all. I tried again but when I ran the import simulation every line item had the following error message:-

Line 1

Duplicate entry ‘153147-1’ for key ‘uk_product_stock’

I see this has been mentioned in older versions of Dolibarr but which version has this been fixed up on or is it still not fixed? I have added a picture of the csv used to upload as well.

Can anyone assist please?

chiche · March 6, 2024, 2:28pm

I have same problem in 18.0.3

vincentb · July 26, 2024, 10:32am

Do anyone Fixs this ?

Edit:

To big to see it !
The dropdown + choose the right/good fields

I already post

in french for detaills

MAJ des lieux de stockage (entrepôts) dans les produits - Maintenir mon Dolibarr - Forum Dolibarr france
↳ MAJ des lieux de stockage (entrepôts) dans les produits - #11 par vincentb - Maintenir mon Dolibarr - Forum Dolibarr france

And reopen :

Error: Duplicate entry ‘17-1’ for key ‘uk_product_stock’ inventory import - Maintaining my Dolibarr - Dolibarr international forum
↳ Error: Duplicate entry '17-1' for key 'uk_product_stock' inventory import - #5 by vincentb

Cant find a fix
and I dont want to TRUNCATE my database
Thanks
V.