Error when importing product data, please kindly help.

[lioncity]

Hi all,

I am trying to import a sample product at in attachment file: products_010.csv

When I import it, Prestashop reports the error message as following:

Name * (ID ID) cannot be saved
test111 (ID 7703) cannot be saved

My questions:
1. May I know what is wrong with my product csv file?
2. In the first column: "ID", shall I just key in the one product ID?
3. In the "Categories" column, I put "243, 162" to represent two level category's ID, is this correct?

Please kindly advise, thank you.

Best regards,
lioncity

--Error when importing product data, please kindly help.

products_010.csv

[tigtig22]

I don't think you should include the first row (with the column names in). It is not needed.

Also, you can leave the ID field blank - Prestashop will simply give the product the next available ID number.

PT

[chaiwala]

I downloaded your sample file and found that it works if

1. you add some number to the "Quantity" field. Leaving it blank gives an error.
2. if you leave the "Reduction from" and "Reduction to" fields blank (perhaps its the date format which causes an error).

It does not seem to make a difference if you select the utf-8 or iso-8859-1 radio button on the import page (Back Office >> Tools >> Import).

As a field separator I used a semi-colon ; and as a multiple value separator I used a comma ,

I'm using:

Prestashop 1.2.4
Openoffice 2.0 (to manage import/export xls/ods/csv)

Hope this helps.

[lioncity]

Hello chaiwala, thanks a lot for your kind reply, I will test these and update again.

Best regards,
lioncity