Import products

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 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 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_height
(Column K)
The height in cm of your product including the packaging.
Enter only numeric value. (Eg. 1, 50, 100)
shipping_detail_width
(Column L)
The width 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_#)
category_name_1
(Column T)
The first category of your product. (Eg. Shirt or Mens 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 U)
The second category of your product. (Eg. Pants or Womens 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 V)
The first image of your product
Enter the link to your image here (Eg.”https://cdn.myshopmatic.com/templates/OMP3E2/Z086DM/images/content/logo_black.png”)
image_2
(Column W)
The second image of your product
Enter the link to your image here (Eg.”https://cdn.myshopmatic.com/templates/OMP3E2/Z086DM/images/content/logo_black.png”)
image_3
(Column X)
The third image of your product
Enter the link to your image here (Eg.”https://cdn.myshopmatic.com/templates/OMP3E2/Z086DM/images/content/logo_black.png”)
image_4
(Column Y)
The fourth image of your product
Enter the link to your image here (Eg.”https://cdn.myshopmatic.com/templates/OMP3E2/Z086DM/images/content/logo_black.png”)
visibility
(Column Z)
Please enter either value, True or False:
“True” : Product will be immediately visible for customers to buy.
“False” : Product will be hidden from customers.

How to upload a completed 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. 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 it 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:

  1. 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
  2. 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.

 

Was this article helpful?