Inconsistency between 'sample CSV import Files' and the actual columns prestashop has

[miskey]

I found it is inconsistent between sample CSV import Files and the columns prestashop actually uses regarding "products_import.csv" when I was trying to import the products file.

 

In the sample product CSV file the columns are as following,

 

 

 

ID Active (0/1) Name * Categories (x,y,z...) Price tax excl. Tax rules ID Wholesale price On sale (0/1) Discount amount Discount percent Discount from (yyyy-mm-dd) Discount to (yyyy-mm-dd) Reference # Supplier reference # Supplier Manufacturer EAN13 UPC Ecotax Weight Quantity Short description Description Tags (x,y,z...) Meta-title Meta-keywords Meta-description URL rewritten Text when in stock Text when backorder allowed Available for order Product creation date Show price Image URLs (x,y,z...) Delete existing images (0 = No, 1 = Yes) Feature Available online only Condition

 

But in prestashop database it contains more columns which is as following

 

id Active (0/1) Name* Categories (x,y,z,...) Price tax excl. Or Price tax excl Tax rules id Wholesale price On sale (0/1) Discount amount Discount percent Discount from (yyy-mm-dd) Discount to (yyy-mm-dd) Reference # Supplier reference # Supplier Manufacturer EAN13 UPC Ecotax Weight Quantity Short description Description Tags (x,y,z,...) Meta-title Meta-keywords Meta-description URL rewritten Text when in-stock Text if back-order allowed Image URLs (x,y,z,...) Feature Only available online

 

 

The inconsistency cause may cause problems for newbies like me.

I tired to prepare my own products file using the sample file, and imported to prestashop.

It replied with several errors.

[MEG Venture]

Good catch!