How to import products

The import file needs to be in the CSV format with a semicolon “;” as separator for the columns. In the first line there needs to be the name of the columns. HTML tags like <strong></strong> are not allowed. Instead you can use Markdown tags to format excerpt and description of the product.

Instructions

  1. Login to the admin and go to “Catalogue -> Products”.
  2. Choose the CSV and click Import

Example of the CSV

sku;name;excerpt;description;categories;related_products;slug;images;price;saleprice;weight;quantity;parent_sku;enabled
30000100007;T-Shirt. (max 128);Short introduction max. 255 words;"Long text.";en,dental;AR1234,AR4444;tshirt (max 128);img1.jpg,img2.jpg;178;0;0.7;5;;1

Description of the columns

1. sku

SKU is the article number and unique identifier of the product.

  • Maximum length: 30 characters
  • Cannot be blank
  • Examples: 000001, ANR0001, AT-8389

2. name

Name is the product name.

  • Maximum length: 128 characters
  • Examples: T-shirt, Samsung TV 20 inch

3. excerpt

Excerpt is a short description of the product.

  • Maximum length: 65535 characters
  • Accepts Markdown formatting

4. description

Description is the longer description of the product.

  • Maximum length: 65535 characters
  • Accepts Markdown formatting

5. categories

A comma separated list of category slugs the product should be assigned to.

  • The category must exist to be assigned to the product
  • You can find the slug (= URL identifier) of the category in the administration area

6. related_products

A comma separated list of product skus to show them as related products on the product detail page.

7. slug

The slug is to define the url of the product. It should be short, unique and not be changed afterwards according to the SEO best practices.

  • Maximum length: 128 characters
  • Cannot contain special characters
  • Is limited to: A-Z, a-z, numbers and “-“ (dashes)
  • Good slugs: t-shirt, samsung-tv-20, red-tomato
  • Bad slugs: t-shirt_with-a-long-and-pretty-v-neck, a_slug_with_underscore_separator

8. images

A comma separated list of image filenames. You can upload the images in a bulk upload and they will get linked automatically using the filename as identifier to the product.

  • Is limited to: A-Z, a-z, numbers and . (dots)
  • Must contain the file extension .jpg, .gif or .png
  • Examples: flower.jpg, lemon.jpg

9. price

The price for the product

  • Must be a number
  • Comma must be a dot
  • Example: 10.5, 8, 199.9

10. saleprice

The promotional price for the product

  • Must be a number
  • Comma must be a dot
  • Example: 10.5, 8, 199.9

11. weight

The weight of the product

  • Must be a number
  • Comma must be a dot
  • Example: 10.5, 8, 199.9

12. quantity

The stock quantity the product is available.

  • Must be a number

13. parent_sku

To build packages or variations of products the sku of the parent product must be inserted here.

  • Optionally, can be blank
  • The parent product must exist

14. enabled

Enabled defines if a product is visible in the shop and can be added to the cart.

  • Must be a number
  • Possible values: 1 = enabled, 0 = disabled