[Solved] Field List for Creating Importable CSV File

[melriks]

Does anyone have a field list for creating an importable CSV file for both categories and products?

I see the import option under Tools, but the manual doesn't give much for specifics. There have been other posts with similar questions, but no answers.

Anybody done an import of products and categories without paying for one of the modules?

If I don't hear back, I'll post my results here for the next person with this problem.

[melriks]

Excellent Reference

 

Field found in Wiki

http://www.prestashop.com/wiki/Importing_Product_Data/

 

Since I can't figure out how to edit the Wiki. Additional import information for Prestashop 1.4 from the Import Wizard itself.

 

Available Import Fields

 

Separate multi-items (like image URLs) with commas

 

Categories

 

ID - give it the next available id

Active (0/1) - 0 = off; 1 = On

Name - required field

Parent category - id of parent category

Description - text description

Meta-title - text meta title

Meta-keywords - text meta title

Meta-description - text meta description

URL rewritten - text SEO url

Image URL - image for category

 

*********************************

 

Products

 

id - ID - give it the next available id

active - Active (0/1)

name - Name *

categories - Categories (x,y,z...)

priceNotax - Price tax excl.

taxRulesID - Tax rules id

wholesalePrice - Wholesale price

onSale - On sale (0/1)

discountAmount - Discount amount

discountPercent - Discount percent

discountFrom - Discount from (yyyy-mm-dd)

discountTo - Discount to (yyyy-mm-dd)

reference - Reference #

supplier# - Supplier reference #

supplier - Supplier

manufacturer_name - Manufacturer

ean13 - EAN13 - 0, ean13 or jan

upc - UPC

ecoTax - Ecotax

weight - Weight

quantity - Quantity

shortDescription - Short description

description - Description

tags - Tags (x,y,z...)

metaTitle - Meta-title

metaKeywords - Meta-keywords

metaDescription - Meta-description

urlRewritten - URL rewritten

instockText - Text when in-stock

backorderText - Text if back-order allowed

imageURLs - Image URLs (x,y,z...)

deleteOldimages - Delete existing images (0 = no, 1 = yes)

feature - Feature

onlyOnline - Only available online

condition - Condition

 

 

**************************************

 

Combinations

 

Product ID*

Options (Group:Value)*

Reference

Supplier reference

EAN13

UPC

Wholesale price

Price

Ecotax

Quantity

Weight

Default

 

***************************************

 

Customers

 

ID

Active (0/1)

Gender ID (Mr = 1, Ms = 2, else 9)

E-mail *

Password *

Birthday (yyyy-mm-dd)

Lastname *

Firstname *

Newsletter (0/1)

Opt in (0/1)

 

 

*************************************

 

Addresses

 

ID

Alias *

Active (0/1)

Customer e-mail

Manufacturer

Supplier

Company

Lastname *

Firstname *

Address 1 *

Address 2

Postcode*/ Zipcode*

City *

Country *

State

Other

Phone

Mobile Phone

VAT number

 

 

*******************************

 

Manufacturers

 

ID

Active (0/1)

Name *

Description

Short description

Meta-title

Meta-keywords

Meta-description

 

********************************

 

Suppliers

 

ID

Active (0/1)

Name *

Description

Short description

Meta-title

Meta-keywords

Meta-description

[kimble01]

Thanks for posting this! It will certainly come in handy, wish you had been about 2 months earlier...

[melriks]

wish you had been about 2 months earlier...

Ah, bummer. As I test through more import areas, I'll update the post above. Hopefully, we can get it added to the Wiki.

I've imported 6 categories successfully and up to 30 products (testing small batches) with photos. It's a very nice importer.

[melriks]

More Product Import Notes

 

Images

FTP your images into the img directory. Crazy simple. In your spreadsheet, the field format is ../img/nameofimage.png (or whatever extension your file needs jpg, gif, png)

 

Delimiter

Use a semi-colon. I couldn't figure out what to put to make Prestashop use a tab (\t didn't work)

 

Note for MS Excel users

If you use MS Excel to format your spreadsheet, you will need to "Save As" your Excel spreadsheet to a tab delimited file. Then you must open the tab delimited file in CSVed (free to download) and convert the tab into a semi-colon. Edit your preferences in CSVed to include "" around all fields. Save AS from CSVed into a next version file. Use the new file to upload into Prestashop.

 

Note on Columns

You don't need all the columns available in the import. If you include them in your spreadsheet but have no value for the column (i.e., discount date), when you map fields in Prestashop's Import, use the "Ignore this Column" option to skip those empty fields.

 

I imported 210 products with no problems except for stupid user errors.