The product ID can only be an integer (number). So no letters or other characters

[Mishu]

There is no chance that the product ID can be letters or other characters?
In many cases the products have an ID that is more complicated ...

[corruptedmonk]

If you mean the 'Reference' section in product (catalog/product) then i have no problem with letters.

[Martin Velikov]

The product ID itself can only be a number. It generally reflects the order in which products were entered in the database and defines each product with unique identification number.

This is not something that your customers see anyway so should not be a problem.

[Mishu]

I now that the ID defines each product with unique identification number , a combination of characthers and number can make an unique identification. I 'd have some product data in CSV from the Suppliers, where they have the ID and i have also the pcitures.
Ex:

ID | Name | filename
E-10479-CGN | Hard disk | o_click_cod_10476c.jpg

You see my problem?

[SystemOAD]

I to had a simular problem but you will just have to remove or replace the letters and - to just numbers, thats what I did

[Mishu]

Or try with another CMS

[Martin Velikov]

Here is what you can try to do:

1. Change the ID in your CSV to Reference - This way the unique ID from your supplier will be inserted in the reference table
2. Create new ID for your CSV file
3. Enter dummy numbers for the product IDs - for example starting from 10000 and above (or whatever wont be duplicate for your store)

Hope that helps.

[Mishu]

Thanks Martin

I tried to put that ID to Reference, but with the pictures that i have ... i have to rename all the pictures to have the name of the ID product.
And also i have to update and to add.. the products every week and the products are more than 3000 ...
It would have been nice if the field "Reference" was unique, because then you can import products without repeating the products because of the reference

[princemaxa]

Sorry if I open an old post but I couldn't find any solution yet, so i was wondering if someone could make it work.
My problem is very simple: I have 2 CSV files to import: first one has unique item reference for each product + descriptions, images, prices and all the rest, but NOT product ID as number; second one is inventory with just 1 attribute (size), quantities and the same item reference as in products CSV.
Now when I import 1st CSV I correctly populate my database with products but it generates product id by itself: so when I import the 2nd file it just add new items instead of giving the right attributes to existing items, because I cannot link reference to 1st file but just ID (numeric) that is not present in my CSV.
This would be easily accomplished if I could use as "common key" the reference number that is unfortunately alphanumeric.
I am speaking about 30000 items so any "manual" suggestion is not acceptable.
I see 2 ways:
1) an algorithm that transform and alphanumeric key (with variable lenght) into an integer
2) modification of Prestashop import module so it can use reference key instead of product ID as unique identifier for items

Sorry for language mistakes but I'm Italian and our English schools just suck

Thanks.

(I appreciate also suggestions for different CMS suitable for an online shoes shop)