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 SKU
- Product title
- Category
- B2C price incl. VAT
- B2B price ex. VAT
- Description
- Image URL
- *Product group (Not relevant to everyone).
Explanation of columns:
Product SKU: Product SKU 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. If you want to import several categories, then seperate the category name by “,”. Example: “Category1,Category2,Category3”
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 colon “,”.
Status: Determines if the product should be active (visible) or inactive (hidden) in the webshop. Change the column name to status before import. Use Active to show the product, or Inactive to hide it.
Parent SKU: If you are not using variants, leave this slot empty.
If you are using variants, this column should be the name of the Parent SKU that the variant belongs to.
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:
How do I upload the file?
When you have finished preparing your product file, you can upload it to Storeshop by following these steps:
- Log in to your Storeshop account and go to the Dashboard.
- Navigate to Import and select Excel.
- Upload your product file by clicking Upload File and selecting the file you want to import.
- After the upload, you can click View Logs to see details from previous imports. Here you can check the import status, including how many products were successfully created, how many were updated, and how many failed.
This allows you to monitor and verify that your product import has been processed correctly.
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.
Troubleshooting Excel File Upload in Storeshop
Uploading product data through an Excel file can sometimes encounter challenges. This guide is designed to help you identify and resolve the most common issues.
Issue: You receive an error message when trying to upload the Excel file.
Solution: Check if you are using the correct format for the Excel file. Our standard template must be used to ensure the data is read correctly. Download and use the latest version of the template from our Help Center. The template is in the beginning of the article.
Issue: Images are not uploaded.
Solution:
1. Ensure all Product SKUs are correctly filled out.
2. Check if the separators in the Excel file are correct, especially for fields like “Image URL”, where multiple values should be separated by a comma.
3. “https://” has to be included in “Image URL”
Issue: Variants of products are not displayed correctly.
Solution:
Ensure the product group is correctly defined for the main product and all its variants.
Product titles for variants must be unique and correctly linked to the main product.
Symptom: Custom fields are not displayed as expected on the products.
Solution:
Double-check that the value in the Excel file matches what is defined in the dashboard.
Ensure the column names for custom fields have not been altered from the standard format. Adjustments can be made from the dashboard after upload.
If you have any questions, please contact support@storeshop.no.