[Skip to main content](#vessel-content)

#   Product code

##

- **[jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")**
- [![jameswadsworth's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/556-jameswadsworth "View jameswadsworth's Profile") Topic Author
- [ Offline](/forum/user/556-jameswadsworth)

Less More

- Posts: 274
- Thank you received: 5
-
-
-
- [](http://www.deanimaconsulting.com)
-

15 years 4 months ago [\#19510](#19510) by [jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")  *[Product code](/forum/2-general-talk-about-hikashop/19510-product-code#19510 "Hi there,  in an ideal world the product code should be unique. However as we have discovered the real world is not so. We are testing uploading 16000 products from a supplier. The product code given is often repeated for the same type of product i.e. all chrome vanadium ring spanners of different sizes have the same product code. We have been considering the various options and I would appreciate your comemnts.  1) remove the unique index from the product&#95;code field in the product table 2) use the barcode supplied as this really is unique 3) if there is an quick way to assign variants doing a bulk upload I could use this method  Thanks")* was created by *[jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")*

Hi there,

in an ideal world the product code should be unique. However as we have discovered the real world is not so. We are testing uploading 16000 products from a supplier. The product code given is often repeated for the same type of product i.e. all chrome vanadium ring spanners of different sizes have the same product code. We have been considering the various options and I would appreciate your comemnts.

1) remove the unique index from the product_code field in the product table
2) use the barcode supplied as this really is unique
3) if there is an quick way to assign variants doing a bulk upload I could use this method

Thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE5NTEwLXByb2R1Y3QtY29kZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86322
- Thank you received: 14281
-
-

15 years 4 months ago [\#19514](#19514) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product code](/forum/2-general-talk-about-hikashop/19510-product-code#19514 "Hi there,  in an ideal world the product code should be unique. However as we have discovered the real world is not so. We are testing uploading 16000 products from a supplier. The product code given is often repeated for the same type of product i.e. all chrome vanadium ring spanners of different sizes have the same product code. We have been considering the various options and I would appreciate your comemnts.  1) remove the unique index from the product&#95;code field in the product table 2) use the barcode supplied as this really is unique 3) if there is an quick way to assign variants doing a bulk upload I could use this method  Thanks")*

Option 1 is not possible. The import and other parts of HikaShop are optimized using that unique key.

Option 2 would indeed be the easiest.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE5NTEwLXByb2R1Y3QtY29kZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.092 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
