Jump to content

In which field I should store my product identifiers (SKUs)?


user2076

Recommended Posts

In the PrestaShop back-office I can see a number of places where I possibly could store a product identifier (also known as SKU).

As an example, in PrestaShop version 1.7 inside a product page, there are the following fields:

    "Reference Code"

    "EAN-13 or JAN barcode"

    "UPC barcode"
    "ISBN"

 

...I am a bit lost, is there a standard place where I should store the product identifier? What is a most common approach? and why? 

Thanks for the help in advance.

Edited by user2076 (see edit history)
Link to comment
Share on other sites

Use Reference Code.

 

Unfortunately prestashop doesn't require this field to be set, or to be unique. But you should always strive for uniqueness, it will ease your integration with third party services.

 

Some people send product ids as a SKU, but that's a big mistake - id's can change, for example if you delete and reimport your products from csv. Also that makes transferring to other platforms quite hard.

Link to comment
Share on other sites

As DataKick pointed out, and I agree, that it is not reliable to use product ids (that are generated automatically by PrestaShop for every new item in the product catalogue) as SKUs. 

Our store randomly generates unique alphanumeric identifiers with variants for colour & size. 

The question still remains, in which of the following fields we should save the ids? 

  • Reference code
  • EAN-13 or JAN barcode
  • UPC barcode

What is the most common place? (E.g. which field 3rd party plugins takes when they need to extract the product SKU.)

 

I've attached a screenshot to illustrate it better:

product_identifiers.png

Edited by user2076 (see edit history)
Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...