Import Fields Definition For Csv Upload

[careware]

ID : ID in Prestashop base
Active : active ( 1 if product is active ).
Product name : product title.
Categories : all the product categories. The default category is the first of the list.
Price : Price tax excluded
Tax Rule ID : tax rule ID.
Wholesale price : product wholesale price
On sale : 1 if product is on sale, else 0.
Product Reference : product reference.
Supplier reference : supplier reference of the product
Supplier : Supplier ID
Manufacturer : Manufacturer ID
EAN13 : EAN13 of the product
UPC : UPC of the product
Ecotax : eco tax
Weight : product weight
Quantity : number in stock.
Short description : HTML short description
Description : HTML product description
Tags : product's tags
Meta title : product page meta title.
Keywords : meta keywords.
Meta description : meta description.
URL rewritten : Rewritten URL of the product
Text when In stock : text when in stock
Text if Back order : text if back order allowed
Available : if product is available
Date add : added date of the product
Show price : 1 if show price.
Images URLs : URLS of product's images. All images are exported, sort by positions order, first image
is the default one.
Features : Features values of the product. All features are exported, with a column for each one.
Only available online : 1 if product is available online, 0 else.
Condition : condition of the product

[Griffter]

Hi, I'm brand new at this and have my spreadsheet constructed but I think I have an error in that I get ID: No name on all lines of products. I would like the ID to be the unique SKU provided by the manufacturer and I have made that the first column but to no avail. I would be very grateful of any assistance and guidance. Many thanks...

[rocky]

Unless the manufacturer SKU is an integer, you can't use it as the product ID. You should put it in the "Reference" field or "Supplier reference" field instead and just use integers for the product ID.