Hello,
I’m practicing product import for a Excel price list with more than 36.000 lines.
I’ve successfully imported three test products (with label, name, description & price).
Then I tried to update the same three products with new prices (like what will happen when I receive updated price list from supplier).
Now I have " Duplicate entry XXXXX for key ‘uk_product_ref’" error of course.
How do I update just product prices with product import?
Please, explain how do you import those three products.
If you used Dolibarr option to import products, you can try to import only prices, for products that already exists.
That option is just under “import products”, you probably used with those 3 products:
From horizontal Menu:
https://yourDolibarr/imports/import.php?leftmenu=import
Then, option import supplier prices:
https://yourDolibarr/imports/import.php?step=2&datatoimport=produit_supplierprices&excludefirstline=1&separator=%2C&enclosure=%22
I have created my own Excel file with my prices and I’ve upload it (only three test rows) via Tools -> New import -> products…
It worked great. Then I changed prices and tried to upload it again.
I could try to upload only prices but how would Dolibarr connect it with the right product?
If you test that option will see you can download first a blank template CSV, one of the columns must be the productId or product reference so price will be updated to that unique product.
Better you test, then ask if necessary, but you’ll see it.
Hi has this been resolved with later verisons? I am having the exact same problem with version 12.0.2.
