# Error 23505 Mass import Update fails

**URL:** <https://www.dolibarr.org/forum/t/error-23505-mass-import-update-fails/21778>\
**Category:** PM modules\
**Created:** [February 1, 2022, 9:27am UTC](https://www.dolibarr.org/forum/t/error-23505-mass-import-update-fails/21778 "2022-02-01T09:27:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jazz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@Jazz](https://www.dolibarr.org/forum/u/Jazz)\
**Post date:** [February 1, 2022, 9:27am UTC](https://www.dolibarr.org/forum/t/error-23505-mass-import-update-fails/21778/1 "2022-02-01T09:27:54Z")

</div>

Hi all. I run Dolibarr version 14.0.5.  
I am able to Mass-import products and to mass import supplier prices. But I am not able to update these informations. If I select one (ore more) of the given options for selecting the column for update, it makes no difference:

> > FEHLER: 23505: doppelter Schlüsselwert verletzt Unique-Constraint »uk\_product\_fournisseur\_price\_ref« DETAIL: Schlüssel »(ref\_fourn, fk\_soc, quantity, entity)=(DETSERV-1, 21084, 1, 1)« existiert bereits. SCHEMA NAME: public TABLE NAME: llx\_product\_fournisseur\_price CONSTRAINT NAME: uk\_product\_fournisseur\_price\_ref LOCATION: \_bt\_check\_unique, nbtinsert.c:534

 ![image](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/e/e2821f923f72584a38db6a8aa9f9e7605c6b0f99.png)

Any suggestions?  
Thanks in advance  
Jazz

---

<div class="post-metadata">

**Author:** ![pcbleu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/pcbleu/32/3120_2.png) [@pcbleu](https://www.dolibarr.org/forum/u/pcbleu)\
**Post date:** [February 1, 2022, 9:48am UTC](https://www.dolibarr.org/forum/t/error-23505-mass-import-update-fails/21778/2 "2022-02-01T09:48:10Z")

</div>

Hey 🙂

I think that the only way you can use import functions, it is when related indexes are non existent  
in fact, you want to update prices, but with these functions you can **only insert new prices** …  
what you need to do before

Have a look at the table’s structure using phpmyadmin for example  
you can check indexes for llx\_product\_fournisseur\_price…

I made this several times for users who wanted to migrate to Dolibarr and the best way is to construct a sql script for this

Good continuation

---

<div class="post-metadata">

**Author:** ![Jazz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@Jazz](https://www.dolibarr.org/forum/u/Jazz)\
**Post date:** [February 2, 2022, 8:57am UTC](https://www.dolibarr.org/forum/t/error-23505-mass-import-update-fails/21778/3 "2022-02-02T08:57:02Z")

</div>

Hi,  
thank you for this very fast answer.  
I did now the update of prices direct via SQL, so a workaround is possible. But I wonder why the key for update (in my case [sorry for the german interface] “Produkt oder Leistung”) is just ignored.