Column descriptions for CSV files

CSV title	Description
ID	This field holds a unique identifier for each product. It must be empty when you create new products, and it must contain the existing ID when you update an existing product.
Model	This column is for the product's own unique product number. It must be a unique product number for each product. The product number may contain both letters and numbers.
Title	This column contains the title of the product, and it must be plain text.
Description	This is the long description of a product, and it is written in HTML format.
Summary	This column contains a short summary of a product, and it must also be formatted in HTML.
Enabled	This column controls whether a product is active and should be shown on the website. A value of “Yes” means that the product is active and shown, and a value of “No” means that the product is not shown.
Weight	This column gives the exact weight of the product in kilos. For example, if a product weighs 100 grams, enter this as “0.1” (a decimal comma, “0,1”, works too).
Price	This column shows the current price of the product in the local currency, as customers will see it on the website. It is the price excluding VAT.
VAT	This column specifies the VAT class that applies to the product, with a typical value such as “Momspligtig 25%” (subject to 25% Danish VAT).
Local Stock	This column gives the exact quantity of the product in your local stock. The value must be a whole number.
Cost Price	This column shows the purchase price or cost price that the business itself has paid for the product.
Barcode	This column contains the product's unique barcode, usually in either GTIN or EAN format, which is used to identify the product in other systems.
Special Price	This column shows a sale price for the product, if any. This price can be given as a percentage discount (e.g. -33%) or as a specific amount before VAT. If it is a variant of a product, it can also be a relative change in per cent (e.g. +0, -10 or +10) compared with the price of the parent product.
Special Start	This column gives the date on which a specific sale price takes effect. If the column is empty, the special price takes effect as soon as the product is enabled.
Special End	This column gives the end date of the sale price. If the column is empty, the sale price applies indefinitely.
Special Enabled	This column shows whether the special sale price is active or not. “Yes” means that the special sale price is active. “No” means that the special sale price is not active. When you schedule a sale for a future date in the “Special start” field, “Special Enabled” must have the value “Yes”.
Brand	This column gives the name of the product's specific brand. For example, it could be “Apple” or “Samsung”.
Brand Model	This column gives the manufacturer's/brand's product number.
Supplier	Gives the name of the supplier.
Allow No Stock	This column controls whether sales without stock are allowed. “No” means that sales beyond the local stock are not allowed, while “Yes” means that sales are allowed even if the product is not in stock.
Shipable	This column shows whether the product has to be shipped physically. The value “Yes” means that the product has to be shipped physically, while the value “No” means that it is a digital product that does not need physical shipping.
Attributes	This column is used to give product variants such as size and colour. Different variants are separated with semicolons, and each value is given with an equals sign. For example, a variant with size XL and colour black is written as “Size = XL ; Colour = Black”. Each product variant must be on a separate row in the file with an identical product title.
Categories	This column gives the product categories a product is shown in. When a product is shown in several categories, they are separated by semicolons. To give the levels of a category, separate them with a greater-than sign, for example “Jewellery > Bracelets”.
Images	In this column you give the images for the product. It can be a file name or a full web address. If there are several images, they are separated with a semicolon.
Product ID	This column is used on import to add variants to an existing product. It can also be used to update the parent/shared fields, such as the brand, of a product that already has variants.
Max Price	This column is used if you have a maximum price for a product, and it is used for price management.
Keep Soldout	This column shows whether the product may be sold even if it is sold out. “Yes” means that the product may be sold when sold out (0 or less in your own stock), and “No” that it may not.