If you have a lot of products to insert into your StoreHub account, you could use our CSV import template to add your products in one go (instead of adding them one-by-one). This article will guide you in how to CSV import your products into the BackOffice!
We've added support for scanning multiple barcodes of the same product.
Please note that these features are NOT SUPPORTED by inventory import:
- Multiple Choice Variants
- Composite Inventory
- Products that are not Tracking Stock Level cannot have variants specified
- Status of Track Inventory cannot be modified using inventory import. Please update directly in the BackOffice.
i) Setting Up
Before you begin the importing process, you will need to get some information ready:
Set up your products as one of these three types:
A. Standard Product
A product with no different types or versions.
B. Variant product
A product with different variations like size or colour. The main product is called the ‘parent product’ while the variations are ‘children products’.
C. Composite product
A product that tracks usage of other items at your store. The components of your items have to be linked manually from the BackOffice after the product has been imported.
The names of your products and their different variations like size or colour.
The tax-exclusive price of the products. If you charge GST at 6%, and your retail price is tax-inclusive, you can simply divide the tax-inclusive price by 1.06 to get the tax-exclusive price. Do keep all the decimal numbers.
ii) How to Import Your Products
First, you need to download the StoreHub import CSV template from your BackOffice. Go to Products > Manage Products > Import CSV.
Click ‘download a CSV template'.
Open the CSV file using Microsoft Excel or a free spreadsheet software such as Open Office or Google Docs.
Tip: We suggest using Google Docs to decrease any formatting issues that may be caused by Excel.
- Add your products into the CSV file. Refer to the ‘Adding your Products’ section below for more information.
- Import your products from the BackOffice: Go to BackOffice > Products > Manage Products > Import CSV > Select File > Select your CSV file > Import.
- After you’ve imported your completed CSV file, you will then be able to see the import status at Import Tasks.
iii) Frequently Asked Questions (FAQ)
Q: Can I update products by importing the CSV?
A: 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.
Q: What happens if the SKUs are new and are not currently assigned to any products in the BackOffice?
iv) Adding your Products
Below is a guide on each field in the CSV template:
The 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. Every product must have a unique SKU. Make sure it only has letters and numbers. You cannot have spaces or symbols in here.
Parent Product SKU
This is only used if you are creating a product with variance. You would specify the parent product SKU here if you are creating a child product.
The name of your product. You can have letters, numbers, and symbols in this field. Do not include #, $, or & symbols.
The category this product belongs to. For example 'Clothing' or 'Accessories' or 'Services'.
Fixed/Variable. 99% of the time, this will be 'Fixed'. If your product price is set at the point of sale itself, you would use 'Variable'. For example, consultation fees.
The price you sell your product for, excluding tax. Don't include a currency sign, just put the number.
The cost of your product, excluding tax. You don't need a currency sign - just put the number.
Lower-level categories this product belongs to. For example: 'Casual, Cotton, Summer Range, Mens'. You can have as many of these as you want. Separate each tag with a semicolon [ ; ] Track Stock Levels Required Set this to 1 if you want to keep track of your inventory levels. If you want to use barcoding, you need to track inventory.
Specify your barcode number here.
Variant Name 1
The first category/option for variant product. For example 'Size' or 'Colour' or 'Flavour'. Follow the same guide for the Variant options 2 and 3.
Variant Value 1
The value for the first variant category. For example 'Large' or 'Black' or 'Chocolate'. Follow the same guide for the Variant options 2 and 3.
The current quantity on hand/stock level of the product. If you have multiple stores, add more columns and change each header to 'store name_Quantity', store name being the name of the store specified at the BackOffice. Make sure the store name is identical to the store specified at the BackOffice settings, with spacing and capital letters. This column can be deleted if you don't want to overwrite your existing quantity data in the BackOffice.
Warning Stock Level
Set this to get notified when the quantity goes below warning stock level to make reordering easier. If you have multiple stores, add more columns and change each header to 'store name_Warning Stock Level', store name being the name of the store specified at the BackOffice. Make sure the store name is identical to the store specified at the BackOffice settings, with spacing and capital letters. This column can be deleted if you don't want to overwrite your existing quantity data in the BackOffice.
Ideal Stock Level
When reordering, the system will automatically calculate the amount to order based on what you set in ideal stock level. If you have multiple stores, add more columns and change each header to 'store name_Ideal Stock Level', store name being the name of the store specified at the BackOffice. Make sure the store name is identical to the store specified at the BackOffice settings, with spacing and capital letters. This column can be deleted if you don't want to overwrite your existing quantity data in the BackOffice.
Which supplier you order this product from.
This is the name of the tax rate you want to use for this product, e.g., SR and ZRL. Make sure that the tax name exactly matches the name of the tax you have set up in the BackOffice. Make sure to add your tax codes from Settings > Tax before importing the CSV file.
Example - Standard Product
Example - Variant Product
When you set up variant products, the child products will need to have different SKUs and Product Names from their parent products.
1. Ensure that the Field Names are not changed from the original template otherwise the import will fail.
2. Additionally, ensure there are no blank rows in the CSV as this too would cause an error.
3. Please download the CSV Template from your BackOffice > Products > Manage Products > Import CSV > Download a CSV Template.
Need further assistance?
Contact our Customer Care Team