Import Layout For CSV File

[peeps54]

Hi, I have spent the last hour trying to sort out the headers in the file and keep getting errors when I import

 

ID Category Name Description Weight Price JA001 Farmshop Jams Strawberry Xtra Jam with Marc de Champagne 227g £3.10

JA011 Farmshop Preserves Blackcurrant Preserve with Rum 227g £3.10

 

 

should be simple, but it is being a pain, a description of what header is what would help, all I could find was this example:

ID;Active (0/1);Name *;Parent category;Root category (0/1);Description;Meta-title;Meta-keywords;Meta-description;URLrewritten;Image URL;ID / Name of shop

 

surely the header Name does'nt need the * ???

 

any pointers or advise please

 

 

many thanks Paul

[peeps54]

blimey, did not think it was that difficult, oh well, back to manual entry at this rate

 

[Guest]

I can;t quite tell - are you using a category name? You have to use the ID number of the category, not it's name

 

Also, weight and cost should be number only, so 3.1 not £3.1

[peeps54]

ok,

 

so trying the basics here:

 

====================================

 

Category is Jams

 

Description is Strawberry Xtra Jam

 

Weight 227

 

price 3.1

 

=======================================

so the headers:

 

Categories

 

Description

 

Weight

 

Price tax incl.

 

=========================================

 

 

so what is Name *

 

and is my headers correct?

 

 

==========================================

 

 

regards Paul

Edited November 19, 2012 by peeps54 (see edit history)

[peeps54]

duplicated post

Edited November 19, 2012 by peeps54 (see edit history)

[Guest]

The names of your headers don;t matter - you simply match them agaisnt the import ones

 

Name * = means that you have to have that field

 

Headers look fine, but remember what I said. The category cannot be Jam, it has to be the ID of the category that is already there

[peeps54]

looks as if it has a bug, as it keeps showing old data from the csv I loaded earlier, also I still do not understand it, I have changed the info in name, see attached

 

/--- Paul

prestashop csv problem.doc

[Guest]

Are you being careful to match the field names in your file to the ones in prestashop (the system might guess which matches to what, but you do need to check they have got it right)

 

Have you remembered to tell it not to import the first line (ie. the titles)

 

have you remembered to check that the separator file matches between prestashop and CSV file?

 

Do the categories already exist?

 

if you w0uld like me to take a look, you could PM me the actau file and a back office log in

[Guest]

I think we got this sorted Paul if you want to edit the heading to [solved]

 

For others you need to make sure of two things

 

1) When you create your CSV file make sure you know the field delimiter (usually a comma , but can be anything. Prestashop likes it to be a semi colon; but it can be changed

2) The import products feature does not create categories, they have to be created first, then the import file needs the Category ID not the category name

3) When you upload make sure you changes the upload to "Products" and that the field delimeter matches what you saved the csv file as

[mehnihma]

What do you mean Category ID,

 

Can you give me example?

 

Thanks