# Select "primary Key or Column" to import/Update product list

**URL:** <https://www.dolibarr.org/forum/t/select-primary-key-or-column-to-import-update-product-list/22572>\
**Category:** PM modules\
**Tags:** Supplier-Prices, Products, Prices, Barcodes, Imports\
**Created:** [July 29, 2022, 5:46pm UTC](https://www.dolibarr.org/forum/t/select-primary-key-or-column-to-import-update-product-list/22572 "2022-07-29T17:46:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohamettarik](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/48db29/32.png) [@mohamettarik](https://www.dolibarr.org/forum/u/mohamettarik)\
**Post date:** [July 29, 2022, 5:46pm UTC](https://www.dolibarr.org/forum/t/select-primary-key-or-column-to-import-update-product-list/22572/1 "2022-07-29T17:46:42Z")

</div>

Hello,

I am trying to import vendor price list to update current products, I would like to select different primary key/column than Ref or Barcode to avoid duplications and errors.

Simply because i have no barcode data and also no match between the imported list and current ref code of products.

However both my data base and imported list are matched in a different key/column. For example Local Authority Registration Code= DDC CODE which already added as parameter (Unique number like barcode)

I need to select the DDC CODE as primary key/column for updating to avoid errors and duplications.

 ![Screen Shot 2022-07-29 at 9.43.46 PM](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/6/6c84da382a411aa6dee505d86635e87ff0237cf5.jpeg)

Appreciating your reply with easy solution

Regards