With Shopmatic’s Import Products tool, business owners can populate their shop catalog on the Shopmatic platform with a few simple clicks. This tool allows customers to easily add products by using a CSV file for a bulk product uploads.
CSV Bulk Import
To bulk upload products using CSV, download the Shopmatic sample CSV file first.
This feature can only be used for adding new products to your Shopmatic webstore, it does not affect the existing products
How to download the sample CSV file:
1. From the Shopmatic dashboard, click on the top left button to access the Products page.
2. On the Product Page, from the top left corner, click on “Import Product”
3. Click on the CSV icon
4. Click on “Download the CSV template to see the format required”
How to fill the sample CSV file:
Uploading products via a CSV file requires data to be uploaded in a fixed format. Please see the table below to know more about how to fill the CSV file.
Please note these points when filling in the CSV file:
1. Refrain from making any changes to the text from Row 1, from Column A to Column Z.
2. Column A and Column B are the only mandatory fields for each product, leave the other fields blank if they are not applicable.
| Column Names | Descriptions |
|
name
(Column A) |
The name of the product. |
| It is advisable to capitalise the first letter | |
|
price
(Column B) |
The selling price of the product. |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
list_price
(Column C) |
Will be shown with a strikethrough (Eg. 100), additionally, If the list price is greater than 5% of the price, the difference in percentage will be displayed.
|
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
description
(Column D) |
The product description. |
| Enter text in plain text format | |
|
stock_sum
(Column E) |
The total stock quantity of the product. |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
sku
(Column F) |
The SKU (Store Keeping Unit) of the product. |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
upc_code
(Column G) |
The UPC (Universal Product Code) of the product. |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
allow_oversell
(Column H) |
Please enter either value, True or False: |
| True: Allow customers to continue buying even when the stock reaches 0. | |
| False: Not allow customers to continue buying when stock reaches 0. | |
|
shipping_detail_product_type
(Column I) |
Please select only one product type from these available options: |
| Accessory (no-battery) | |
| Accessory (with battery) | |
| Audio Video | |
| Bags & Luggage | |
| Books & Collectibles | |
| Cameras | |
| Computers & Laptops | |
| Documents | |
| Dry Food & Supplements | |
| Fashion | |
| Gaming | |
| Health & Beauty | |
| Home Appliances | |
| Home Décor | |
| Jewelry | |
| Mobile Phones | |
| Pet Accessory | |
| Sport & Leisure | |
| Tablets | |
| Toys | |
| Watches | |
|
shipping_detail_length
(Column J) |
The length in cm of your product including the packaging. |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
shipping_detail_width
(Column K) |
The width in cm of your product including the packaging. |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
shipping_detail_height
(Column L) |
The height in cm of your product including the packaging. |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
shipping_detail_weight
(Column M) |
The weight in kg of your product including the package. |
| Enter only numeric value. (Eg. 0.1, 3, 15) | |
|
option_1
(Column N) |
The first option of your product. (Eg. Blue or XS or Size 6). |
|
If additional options are required, insert a new column into CSV file using the same format. (Eg. option_#)
|
|
|
option_2
(Column O) |
The second option of your product. (Eg. Green or S or Size 7). |
|
If additional options are required, insert a new column into CSV file using the same format. (Eg. option_#)
|
|
|
option_3
(Column P) |
The third option of your product. (Eg. Yellow or M or Size 8). |
|
If additional options are required, insert a new column into CSV file using the same format. (Eg. option_#)
|
|
|
option_4
(Column Q) |
The fourth option of your product. (Eg. Black or L or Size 9). |
|
If additional options are required, insert a new column into CSV file using the same format. (Eg. option_#)
|
|
|
option_5
(Column R) |
The fifth option of your product. (Eg. Red or XL or Size 10). |
|
If additional options are required, insert a new column into CSV file using the same format. (Eg. option_#)
|
|
|
option_6
(Column S) |
The sixth option of your product. (Eg. Orange or XXL or Size 11). |
|
If additional options are required, insert a new column into CSV file using the same format. (Eg. option_#)
|
|
|
option_1_price
(Column T) |
The selling price of the product variant |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_1_list_price
(Column U) |
Will be shown with a strikethrough (Eg. 100), additionally, If the list price is greater than 5% of price, the difference in percentage will be displayed.
|
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_2_price
(Column V) |
The selling price of the product variant |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_2_list_price
(Column W) |
Will be shown with a strikethrough (Eg. 100), additionally, If the list price is greater than 5% of price, the difference in percentage will be displayed.
|
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_3_price
(Column X) |
The selling price of the product variant |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_3_list_price
(Column Y) |
Will be shown with a strikethrough (Eg. 100), additionally, If the list price is greater than 5% of the price, the difference in percentage will be displayed.
|
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_4_price
(Column Z) |
The selling price of the product variant |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_4_list_price
(Column AA) |
Will be shown with a strikethrough (Eg. 100), additionally, If the list price is greater than 5% of the price, the difference in percentage will be displayed.
|
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_5_price
(Column AB) |
The selling price of the product variant |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_5_list_price
(Column AC) |
Will be shown with a strikethrough (Eg. 100), additionally, If the list price is greater than 5% of the price, the difference in percentage will be displayed.
|
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_6_price
(Column AD) |
The selling price of the product variant |
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
option_6_list_price
(Column AE) |
Will be shown with a strikethrough (Eg. 100), additionally, If the list price is greater than 5% of the price, the difference in percentage will be displayed.
|
| Enter only numeric value. (Eg. 1, 50, 100) | |
|
category_name_1
(Column AF) |
The first category of your product. (Eg. Shirt or Men or DryFit). |
|
If additional categories are required, kindly insert a new column into CSV file using the same format. (Eg. category_name_#)
|
|
|
category_name_2
(Column AG) |
The second category of your product. (Eg. Pants or Women or Cotton). |
|
If additional categories are required, kindly insert a new column into CSV file using the same format. (Eg. category_name_#)
|
|
|
image_1
(Column AH) |
The first image of your product (please ensure that your image is square-shaped) |
|
Enter the link to your image here (Eg.”https://cdn.myshopmatic.com/templates/OMP3E2/Z086DM/images/content/logo_black.png”)
|
|
|
alt_1
(Column AI) |
The Alt Text description of image_1 |
| Enter what is on the image (Eg. T-Shirt with print patent of superhero) | |
|
image_2
(Column AJ) |
The second image of your product (please ensure that your image is square-shaped) |
|
Enter the link to your image here (Eg.”https://cdn.myshopmatic.com/templates/OMP3E2/Z086DM/images/content/logo_black.png”)
|
|
|
alt_2
(Column AK) |
The Alt Text description of image_2 |
| Enter what is on the image (Eg. 5 inches galvanised steel monkey wrench) | |
|
image_3
(Column AL) |
The third image of your product (please ensure that your image is square-shaped) |
|
Enter the link to your image here (Eg.”https://cdn.myshopmatic.com/templates/OMP3E2/Z086DM/images/content/logo_black.png”)
|
|
|
alt_3
(Column AM) |
The Alt Text description of image_3 |
| Enter what is on the image (Eg. 1:16 scale model F-15 toy drone fighter plane) | |
|
image_4
(Column AN) |
The fourth image of your product (please ensure that your image is square-shaped) |
|
Enter the link to your image here (Eg.”https://cdn.myshopmatic.com/templates/OMP3E2/Z086DM/images/content/logo_black.png”)
|
|
|
alt_4
(Column AO) |
The Alt Text description of image_4 |
| Enter what is on the image (Eg. Fresh tropical fruits in a woven rattan basket) | |
|
visibility
(Column AP) |
Please enter either value, True or False: |
| True: The product will be immediately visible for customers to buy. | |
| False: The product will be hidden from customers. |
1. From the Shopmatic dashboard, click on the top left button to access the Products page
2. On the Product Page, from the top left corner, click on “Import Product” How to upload a completed CSV file:
3. Click on the CSV icon
4. Either drag and drop the CSV file into the pop-up window or manually upload the CSV file by selecting it from your folder.
- The average uploading time for 200 products is only one minute.
- Uploaded products will be placed in the All Products category. If products were tagged with a category, then they will automatically fall into their respective categories on the Shopmatic webstore.
- Imported products are set to “Hidden” so that they can be reviewed before going live on the webstore.
- To import more products, repeat steps 1 to 3 above, and choose “Upload CSV file again”.
How to Cancel an import:
- If an import product is taking too long, you can simply cancel the product import and try again, simply click on “Import Product” and you should see this window
- Next click on Cancel importing, and you will be asked to confirm your decision. Simply click on confirm, and the product import will stop.
Please note: If you have a duplicate listing on your CSV file, it will upload duplicate products. Likewise, if the same CSV file is uploaded twice, this will also create duplicate listings on your Shopmatic webstore.
