Besides manually creating products individually and sync products from sales channels, merchants can bulk import products to ShopHub. This feature will help upload products in large quantities effectively. In this article, we will introduce the procedure of importing products in bulk.
Step 1. Download template
On ShopHub admin panel, go to “Products” > “Products Library”, click “Import Products", and a popup window will appear.
Click "Importing example" and download the template file. It will be a folder containing different language version templates.
Step 2. Fill in the Product Import file
In the downloaded template folder, there will be all different versions of bulk upload product templates. Currently, ShopHub supports English, Simplified Chinese, Traditional Chinese, Malay, Thai, Vietnamese, and Bahasa Indonesian. Merchants can select the language version they need to fill in accordingly.
The file includes product name, variations, SPU & SKU information, and images URL. Please fill in the information for every product as completely as possible. ShopHub currently doesn’t support the bulk update feature for products already in ShopHub. After a product is created or imported to ShopHub, it is required to update the product information individually.
- Product name, Variations, and ShopHub SKU are required for all products.
- Variations and variation image URL are required for products with variations.
- ShopHub SKU and ShopHub SPU are important parameters in ShopHub system.
SKU is stock keeping unit that is used to distinguish individual products as well as individual variations of a product with multiple variations.
When a product has multiple variations, and each variation has their own SKU, we can use SPU, standardized product unit, to distinguish this product with other products.
For example, a product Tshirt has 3 variations of color: blue, red, and green. Merchant can use SPU Tshirt1 to distinguish this product with other products, and SKUs Tshirt1-Blue, Tshirt1-Red, Tshirt1-Green to distinguish individual variations.ShopHub system uses ShopHub SKU and ShopHub SPU to inventory and to connect the products on all integrated sales channels. So please pay attention to ShopHub SKU and ShopHub SPU when filling in the file.
- All images URL must start with http://, https:// or ftp://.
- In case a product has multiple product images, please fill in the image links in the Image URL columns, each link in each column.
Tips: How to get the URL of images
Merchants can upload their images to an online photo service supporting multiple uploading and public links like Imgur. After uploading, they can open the photo in a new tab, right-click and select “Copy Image URL” to copy the URL.
- There are 3 example products in the “Product Import Template” file, please remove the example products before importing to ShopHub.
- Please do NOT delete or change the column order of this file, otherwise, the file will not be imported successfully.
- The uploaded file must be saved as .xls or .xlxs format, and the file size cannot exceed 2MB.
Step 3. Upload the Product Import file
After filling out the information in the Product Import file and saving the file, go to ShopHub admin panel > “Products” > “Product Library”, click “Import Products” to upload the file.
Only files that are in the correct format can be imported successfully.
If there are errors in the content of the uploaded file, there will be an error notification, merchants can click "More Error Details" to check the details and edit the Product Import file accordingly.
If the Product Import file is imported successfully, the notification will be “Finished checking document, all data has been imported". Merchants can click “Close" to finish uploading.
After that, products that are successfully imported will appear in the "Product Library" list.
Now merchants can go to Inventory to set inventory levels for these products and proceed to manage the inventory.