Get help with Shoplo products

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 product 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 recognized by their URL. Remember always to 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 first 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 case:

  • 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 case:

  • 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 case;

  • 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 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 case:

  • Entering a URL address of a picture that does not exist at the given link / cannot be accessed (blockade on the server’s side that 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 – it 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, while product updates, 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 while  importing products without updates, if this value is not provided, the SKU will be automatically created:

  • 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 color “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 SKU “shi” and “shi-1”.

Same as products are identified by their URL, product variants are recognized 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 0 by default. This does not apply to a situation where the product has the option of tracking the stock of a given variant 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 should be 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 case:

  • Entering an existing tax – the indicated tax will be assigned to the product,
  • Entering a tax that is not in the dashboard, a new tax 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 is assigned the tax, that is set as default in the dashboard

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

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?

Team