Columns available in the CSV file

In this article, you will find a detailed description of the columns that you can use when importing and updating products with the .csv file.

Available columns

URL – defines the address with which the product will be determined, in the case of:

  • URL address with special characters (e.g.! @ # $% etc.) – the system will consider it as incorrect and such products will not be imported,
  • Empty field; the URL is created based on the product name (title). Special characters such as ß, Ő, Ä are converted. For example, a product named “Unterwäsche!” will have the URL “unterwasche”.

During import, products are recognised by their URL. Remember to always map this column and don’t change the URLs in the CSV file.

If you want to change the URL, do it from the store dashboard. The next time you import, make sure the CSV file has the new URL. Otherwise, the product will be added again.

Title – product name, it is a required field both for the initial import of products and for updating.

Type – determines the type of product. The available values are:

  • physical 
  • digital
  • service

In case of an empty / incorrectly completed value in the file, the system will assign the product type physical by default.

Description – description of the product. May contain HTML tags.

Short description – short product description. May contain HTML tags.

Visibility – determines if the product is visible, the available values are:

  • 0 (hidden), 
  • 1 (visible),

in the case of an empty / incorrectly completed value in the file, the default value is 0.

Show when out of stock – determines whether the product should be visible/hidden if its stock level is 0, the available values are:

  • 0 (product is hidden),
  • 1 (product is visible),

in the case of an empty / incorrectly completed value in the file, the default value is 0.

Width – product width.

Height – the height of the product.

Depth – product depth.

Diameter – the diameter of the product.

SEO Title – the title of the page in the SEO section.

SEO Keywords – keywords in the SEO section.

SEO Description – page description in the SEO section.

Notes – note.

Categories – categories assigned to a product.

In the case of:

  • Providing an existing category, the product will be assigned to it.
  • If a non-existent category is entered, a new category will be created, and then the product will be assigned to it.

A product can be assigned to many categories at the same time, it is also possible to assign to subcategories:

  • To add a product to a subcategory, use the pattern: Main category > Subcategory, e.g., Clothing > T-shirts.
  • To add it to many categories at once, separate the categories with a semicolon “;”, the correct pattern: Category1; Category2, e.g., Clothing; Shoes

Collections – collections assigned to a product.

In the case of:

  • Providing an existing collection, the product will be assigned to it,
  • If a non-existent collection is entered, a new collection will be created, and then the product will be assigned to it.

A product can be assigned to many collections at the same time, to add it to many collections at once, separate collections with a semicolon “;”, correct pattern: Collection1; Collection2, e.g., Spring; Summer

Vendor – manufacturer, assigned to a product. Only one vendor can be assigned to a product at a time.

In the case of:

  • Providing an existing vendor, the product will be assigned to it,
  • If a non-existent vendor is entered, a new vendor will be created, and then the product will be assigned to it.

Tags – product tags. Multiple tags can be assigned to a product simultaneously. To add them all at once, separate the tags with a comma “,”, correct notation: tag1, tag2, e.g., Blouse, large.

Variant Image – URL address of the picture to be assigned to the first product variant.

Variant Image Alt Text – specifying an alt attribute for the variant image.

Image 1 – URL address of the picture to be assigned to the product. It is possible to import multiple images by inserting URLs in the following columns, i.e., Image1, Image2, Image3, etc.

In the case of:

  • Entering a URL address of a picture that does not exist at the given link / cannot be accessed (blockade on the side of the server that is hosting the photo) will not be added.
  • If you enter an incorrect URL, the importer will inform you about an error.

Important: When you choose the option to update the products, and in the product, we have picture A in the first place, and in the file, we import picture B as Image1, then picture A will be overwritten with picture B, i.e., picture A will be deleted.

Image 1 Alt Text  – alt attribute for the first picture. It is possible to provide alt attributes for many photos at once by adding them to the corresponding columns, i.e., Image 1 Alt Text, Image 2 Alt Text, Image 3 Alt Text, etc.

Variant UUID – this is the unique identifier of the variant. In the case of importing products without updating, there is no need to enter it because the system automatically generates an identifier for each variant. When updating products, this field is required.

Variant SKU –  the catalog number of the product and its variants. In the case of product updates, this field is required. If this value is not provided when importing products without updates, the SKU will be created automatically:

  • In the case of a multi-variant product: the first three letters of the product name and its parameters, e.g., the product “Shirt” with the size “Large” and the colour “Blue” – a “shi-large-blue” SKU will be generated,
  • In the case of a single-variant product: the first three letters of the product name, e.g., the product “Shirt Blue” – the SKU “shi” will be generated.

When the generated values are repeated, the system automatically adds a digit to the SKU, e.g., when importing two single-variant products, “Shirt blue” and “Shirt red” will be assigned the SKU “shi” and “shi-1”.

Same as products are identified by their URL, product variants are recognised by variant SKU. This means that you cannot update the SKU via import.

If you change the SKU, the current variant in the dashboard will be deleted, and a new one will be added.

Variant Barcode – barcode of the variant.

Variant Quantity – number of items (stock) of the variant. In the case of an empty/incorrect value, the value will be set to 0 by default. This does not apply to a situation where the option of tracking the stock of a given variant is selected.

Track Inventory – determines whether to track the stock of a variant. The available values are:

  • 0 (The variant’s stock is not tracked),
  • 1 (The variant’s stock is tracked).

In the case of an empty / incorrectly completed value in the file, the default value is 0, while if the column is not mapped at all, the value 1 will be set.

Variant Buy If Empty – determines whether it is possible to buy a variant if its stock level is 0. The available values are:

  • 0 (the purchase of a variant is not possible with 0 products in stock),
  • 1 (the purchase of a variant is possible with 0 products in stock).
In the case of an empty / incorrectly completed value in the file, the default value is 0.

Variant Regular Price – determines the price of the variant. If an empty / incorrectly completed value in the file, the default price is 0.00.

Variant Weight – determines the weight of the variant. The system treats the given value in grams (1000 = 1 kg). In the case of an empty / incorrectly completed value in the file, the default weight is 0.000 kg.

Tax – determines the tax assigned to the variant. The available values are:

  • 0.00 – 99.99 – tax as a percentage
  • not applicable –
  • exempted 

In the case of:

  • Entering an existing tax value, the indicated tax value will be assigned to the product,
  • Entering a tax value that is not in the dashboard, a new tax amount will be added in the system according to the value provided and then the tax will be assigned to the product,
  • An empty/incorrectly completed value in the file, the product is assigned the tax value that is set as default in the dashboard

Variant Property Name 1 – specifies the first parameter to be assigned to the product, e.g., Colour.

Variant Property Value 1 – specifies the value for the first parameter assigned to the product, e.g., Red.

Variant Property Name 2 – specifies the second parameter to be assigned to the product, e.g., Size.

Variant Property Value 2 specifies a value for the second parameter assigned to the product, e.g., XL.

Variant Property Name 3 – specifies the third parameter to be assigned to the product, e.g., Material.

Variant Property Value 3 specifies the value for the third parameter assigned to the product, e.g., Cotton.

Was this article helpful?

Was this article helpful?

Still can't find what you're looking for?

Contact