What You Will Learn in This Guide

A guide for you to input your products by using StoreHub's CSV import template.

Manage and update existing SKUs and product groups in bulk using CSV templates for advanced functionalities.

Important Notes

Scanning for multiple barcodes of the same product is now supported.

The following features are not supported by inventory import:
- Composite Inventory.
- Single & Multiple Choice Modifier.
- Products that are not Tracking Stock Level; unspecified variants.

Price in CSV will follow your Display Price setting in the Settings; General tab. Refer to this article for more information.

Please do not delete or hide any columns in the CSV file, as this may affect the upload process.

When updating existing SKUs or variants in bulk, ensure the SKU column contains valid and unique entries to prevent overwriting errors.ss.

Setting Up

Before you begin the importing process, you will need to get some information ready:

Information 1:

Set up your products as one of these three types; Standard, Variant, or Composite.

Types of Products	Clarifications
Standard	A standalone product sold individually or without variants.
Variant	A product with multiple options, such as size or color, defined by attributes like Variant Name 1, Variant Value 1.
Composite	A product bundle that combines multiple products into one (e.g., a gift set).

Information 2:

The names of your products and their different variations like size or colour.

Information 3:

Check that the prices in your CSV matches your Display Price setting. It is either tax-exclusive or tax-inclusive. Read more about Display Price setting in this article.

Notes:

Do keep all the decimal numbers.

How to Import Your Products

1. Download the StoreHub import CSV template from your BackOffice by going to Products, and clicking on Import CSV.

2. Click Download template.

3. Open the CSV file using Microsoft Excel or any spreadsheet software such as Open Office or Google Docs.

Note: We suggest using Google Docs to decrease any formatting issues that may be caused by Excel.

4. Add your products to the CSV file and save the file.

Note: Refer to Adding your Products section for more information.

5. Once you've completed your CSV file, upload it to your BackOffice. On Products, click on Manage Products and click on Import CSV. Select File and choose the file you saved and click Import.

Notes:

Untick Update inventory" & "Update description" options if you do not want to update product inventory & description.
You will be able to see the import status at "Import Tasks" after importing your CSV files.

Adding your Products

Bulk Updates for SKUs and Variants

Updating SKUs in Bulk

1. Export Products to CSV:

Download the CSV file from BackOffice under Products → Export.

2. Edit and Modify:

Update SKUs in the respective columns without altering essential fields like Product ID to prevent errors.

3. Save and Import:

Save the changes and upload the modified file using the Import CSV option in BackOffice.

Managing Multiple Product Variants

Follow the steps to create organized product variants in bulk:

1. Modify Variant Columns:

Use Variant Name 1 and Variant Value 1 columns in the template to define attributes like color or size.

2. Fill Additional Fields:

Add SKUs, pricing, and other required details.

3. Import to BackOffice:

Upload the completed template and sync data to apply changes.

Below is a guide on each field in the CSV template:

Field	Necessity	Description
SKU	Required	Stock keeping unit for your product. You use the existing barcode number for your product here if you have one. Otherwise, it's a good idea to start counting at 10000. Ensure it only has letters and numbers; it cannot contain spaces or symbols. Every product must have a unique SKU.
Parent Product SKU	Optional	Only use if there is a variance in your product.
Product Name	Required	You may include letters, numbers and symbols; except these symbols #, $, &.
Category	Optional	The group of your product; accessories, clothing.
Price Type	Required	Either fixed or variable.
Unit	Required	Required if the price type is Unit. Leave this field empty if the price Type is either Fixed or Variable.
Tax-Exclusive/Inclusive Price	Optional	Optional; 0 by default Ensure that you have set up on your settings page if you want your products to display price inclusive or exclusive. Refer to this article for more information. Don't include currency sign.
Min Price and Max Price	Optional	Applicable if your pricing type is variable. Price should follow your Display Price settings (Tax inlcusive/exclusive)
Price	Required	The selling price of your product excludes tax. Don't put a currency sign.
Cost	Optional	The cost of your product excludes tax. Don't put a currency sign.
Product Tags	Optional	Lower-level categories your products belong to; casual; men. Separate each tag with a semicolon [;]. Track Stock Level requires you to set as one if you wish to keep track of the levels. Usage of barcodes requires you to track inventory.
Barcode	Optional	Specify your product's barcode number.
Variant Name	Optional	The option for the variant products; such as size, colour, and flavour.
Variant Value	Optional	The value of the variant option; such as large, orange and vanilla.
Quantity	Optional	Current quantity of your products. For multiple stores, add more columns and change each header to "store name_Quantity" Store name is the name inserted on your BackOffice; must be identical.
Warning Stock Level	Optional	Set this to be notified if the quantity of your products reaches below stock level. For multiple stores, add more columns and change each header to "store name_Warning Stock Level" Store name is the name inserted on your BackOffice; must be identical.
Ideal Stock Level	Optional	When reordering, the system will auto-calculate the amount to order based on this setting. For multiple stores, add more columns and change each header to "store name_Ideal Stock Level" Store name is the name inserted on your BackOffice; must be identical.
Supplier	Optional	The vendor of the product.
Tax Name	Optional	The tax name rate you would want to use for your product; such as SR and ZRL. Ensure that the tax name matches your BackOffice. "Settings" > "Tax"
Kitchen Printer	Optional	To enable kitchen printer: Leave blank for Default Kitchen Printer Enter Printer name To disable kitchen printer: Enter 'Do Not Print Kitchen Docket' to not print kitchen docket
Classification Code	Required	Enter the classification code for the product. This is mandatory if e-Invoicing is enabled. Ensure the code follows the standard format (3-digit code). Invalid codes will cause an import error and prevent the product from being updated.

Note: Classification Code is only required when e-Invoicing has been enabled. To do so, please refer to this article.

Frequently Asked Questions (FAQ)

1. Can I update products by importing the CSV?

Yes, you can! If you've uploaded a CSV with SKUs that match the SKUs that are already in the system, the existing SKUs in your BackOffice will be overwritten with the new ones that you uploaded.

If you have varying quantities of stock throughout your outlets and don't want to overwrite them, you are able to delete the entire Quantity column in the CSV template; doing so will keep your current quantity levels intact.

2. What happens if the SKUs are new and are not currently assigned to any products in the BackOffice?

Uploading new SKUs will create new products. If you don't want to add new products, ensure the SKUs you upload to match the SKUs that are in the BackOffice.

3. If my existing product has multiple-choice variants and pictures when exporting the product CSV file to amend the price, will my multiple-choice variants and picture be erased?

No. Your multiple-choice variant and pictures will still remain. Only the data from the CSV file will overwrite the existing data. (EG. Price, Single-Choice variants, etc.)

4. How do I set my product price to be tax-inclusive or tax-exclusive?

Its simple! Go to your Settings in the BackOffice. On the General tab, scroll down to Display Price and select tax inclusive/exclusive.

5. How do I organize products with extensive variants (e.g., prescription details)?

Use the CSV template, specifying a Parent SKU and individual SKUs for variants with fields like Variant Name 1 and Variant Value 1.

(Back to Top)