1. Help Center
  2. Get started
  3. Everything your need to get started

How to use Storeshop's Excel import template

This article explains how to use Storeshop's standard excel template.

If your data is imported to Storeshop through an Excel file, you have to use a standard excel template. This can be downloaded here: Click here to download

The template consist of:

  • Product id
  • Product title
  • Category
  • B2C price incl. VAT
  • B2B price ex. VAT
  • Description
  • Image URL
  • *Product group (Not relevant to everyone). 

Explanation of columns:

Product id: Product id of your product. 

Product title: Name of your product.
NB! If you are importing variants, product title should be the name of the product variant. E.g. if you are selling hoodies in different colors, the product title should be "Hoodie Green". 

Category: Name of the category the product belongs to. (Only one category is allowed.)

B2C price incl. VAT: B2C price incl. VAT

B2B price ex. VAT: B2B price ex. VAT

Description: Description of the product.

Image URL: Image URL of the product. To add several images, separate these with a semicolon.

Product group: If you are not using variants, leave this slot empty.
If you are using variants, this column should be the name of the group that the variant belongs to.

Example of product group
If your are selling Hoodies in extra small, small, medium, large and extra large, the main product should be named "Hoodie Blue" and the product group should be named "Hoodie Blue". The variants should be name Hoodie Blue XS, Hoodie Blue M and so on.

This is how the input with the product "Hoodie Blue" looks like:

If you import the file the outcome will look like this:

How to import custom fields
To import more information about your products you can use custom fields.You can import as many custom fields you want. It's important to not change the column names. The column names can be changed later on from the dashboard.

In this example we are going to import "Pakkestørrelse" to a variant. As you see in the column "Custom field 1" we have added 200 and 500. In the dashboard we define that "Custom field 1" should be displayed as "Pakkestørrelse". After the Excel file is uploaded the result should be like this:

What will be the outcome if I have already uploaded a file with custom fields and then upload a new file? 
If you already have uploaded a custom field to a product and upload a new excel file where you leave the field empty, then the product will keep the custom field which is already uploaded.

If you have any questions, please contact support@storeshop.no