Guide to the correct compilation of the CSV file. The columns of the CSV must be separated by ; (semicolon) and the text delimited by “ (double quote).
The columns of the CSV must be kept as position and order. It is not possible to omit the columns, otherwise the import malfunction, which can lead to unexpected results.
The import can be used to create new products or update existing products, the control value is the SKU code: if the SKU code is already entered in the system, the product will be updated, if the SKU code is not present in the catalog, a new product will be created. It is therefore not possible to change the SKU of a product via CSV.
If you want to update a product, only in some columns, you can insert the value "nochange" in the columns that allow it. By inserting the value "nochange" the value of the product referred to the column will not be modified. This system can be used for example if you want to make some changes directly from the back office and update only some information via CSV.
Below are the details of each column of the CSV. No columns can be removed from the CSV, even when the value is not required. Scroll / drag sideways to read all the contents of the table.
|
|
mandatory |
nochange |
note |
|
sku |
yes |
no |
the SKU code must be unique, if in the CSV there are two identical SKU codes the product will be overwritten with the data of the last corresponding row. |
|
name |
yes |
yes |
product title. |
|
description |
no |
yes |
Product description. |
|
price |
yes |
yes |
starting price of the product. It must be greater than or equal to zero. Enter only the numeric value, without currency. |
|
final_price |
yes |
yes |
selling price of the product. It must be greater than or equal to “price”. Enter only the numeric value, without currency. |
|
stockcount |
no |
yes |
quantity available. Enter 0 if the product is with variants or has an unlimited quantity. Enter numeric values only. |
|
unlimited |
no |
yes |
enter 1 if the product has unlimited availability |
|
usevariants |
no |
no |
enter 1 if the product has variants |
|
variants |
no |
yes |
Definition of variants. Color::red|blue|yellow#size::42|44 this string will generate for the product the combinations of variants for Color "Red", "Blue" and "Yellow" and Size "42" and "44". Warning! No special characters are allowed in the variant title (for example / -? _). If you wish to have a particular character appear in the variant title, you can insert it in the translations of the variants by going to the Tools >> Translations >> Variants section. As for the variant values, they cannot contain special characters including: - underscore (example: lilac_blu) - comma (example: 42.5) - slash (example: lilac/blue) The names of the variants and options must be entered in the CSV in lowercase and without spaces. You can configure the labels of the variants in the Tools > Translations > Variants section, where you can enter all the characters you want. |
|
variantsvalue |
no |
yes |
Definition of variant combinations: all possible combinations of product variants entered in the variants column must be listed. The # symbol separates the definition of each variant combination. Each combination consists of 11 elements, separated by | (pipe): superkey (1), quantity (2), surcharge (3), sku (4) ean (5) url image (6) mpn (7) weight (8) width (9) height (10) depth (11). The superkey is the combination of the options, separated by _ (underscore): red_42 is the superkey of the red color variant, size 42 of the product. If you only have one variant, such as size, the superkey will match the size entered in the variants column. |
|
categorytree |
no |
yes |
"categories to which the product is associated. Attention: the corresponding categories will be created, if not already present in the catalog, based on the names entered. Upper and lower case are to be considered different. It is not possible to remove categories via CSV. The structure of the categories is created with the separation #. An example: categoryA#subcategoryA. If the product is to be inserted into several categories, the structure of the categories must be separated by “|” . An example: categoryA#subcategoryA|categoryB#subcategoryB. |
|
socialcategoryid |
no |
yes |
Blomming marketplace category ID. The updated list of categories is available here. |
|
brand |
no |
yes |
Brand name: the brand is created if it is not already present in the catalog, uppercase and lowercase letters are to be considered different. It is not possible to remove brands via the CSV. |
|
weight |
no |
yes |
Product weight, in kg. Enter a numeric value, without unit of measure. |
|
w |
no |
yes |
Product width, in cm. Enter a numeric value, without unit of measure. |
|
h |
no |
yes |
Product height, in cm. Enter a numeric value, without unit of measure. |
|
x |
no |
yes |
Depth of the product, in cm. Enter a numeric value, without unit of measure. |
|
parameters |
no |
yes |
Filters applied to the product. Filters and options must first be created in catalog > filters. In the field enter filter key: option id separated by #, example color|1#discounted|0 will apply the navigation filters color and discounted. |
|
images |
no |
yes |
List of URLs (reachable from the internet, therefore http/https) to the product images. Separate urls with | (pipe). |
|
tags |
no |
yes |
Product Tags. Enter the tags in lowercase, without accented letters or special characters, use - (hyphen) in place of the space. Separate tags from each other with , (comma). |
|
facebookenable |
no |
no |
Product activation in the Facebook shop (deprecated field, usable for shops that have the old FB Shop). Not usable for those who use Facebook Ads Extension. |
|
seotitle |
no |
yes* |
SEO title |
|
seodescription |
no |
yes* |
SEO description |
|
seokeywords |
no |
yes* |
SEO keywords. Separate keywords with , (comma). |
|
ean13 |
no |
yes |
EAN product |
|
mpn |
no |
yes |
MPN product |
|
path |
no |
no |
This field is obtained only in export, it cannot be modified therefore any value entered here is irrelevant. |
|
visible |
yes |
yes |
Product status, 1 for active, 0 for deactivated product. |
|
minQuantity |
no |
yes |
Minimum purchase quantity, enter a value greater than or equal to 1 |
|
nextQuantity |
no |
yes |
Subsequent purchase quantity, after entering the minimum quantity in the cart. Enter a value greater than or equal to 1 |
|
maxQuantity |
no |
yes |
Maximum purchase quantity, enter a value greater than 0 to set a maximum purchase limit, 0 otherwise. |
*Attention: the SEO fields have a particular management of the nochange, to avoid errors pay close attention to the following:
- if the nochange is inserted in the seotitle column, no SEO fields will be updated without these having the value nochange. seotitle = nochange blocks updating all SEO fields.
- if the nochange is entered in seotitle and seodescription, then only the seokeywords field can be updated.
- the nochange cannot be entered independently on seodescription or seokeywords.
Here you can find the sample file: Click to download
Comments