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:
1. Using a CSV file for bulk uploads or
2. Import products directly from other platforms


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


Shopify Product Import
If you have an existing account with Shopify, simply port over your products to the Shopmatic platform by using the Shopify Products Import feature.

Please note that only these product details will be imported:
1. Title
2. Price
3. Compare at price
4. Description (Plain text format)
5. Product type
6. Variant names
7. Images

To import your products from Shopify:
1. Login to your Shopify account
2. Click on the “Apps” button located on the left panel
3. Scroll to the bottom of the screen and click on “Manage private apps”
4. Click on “Generate API credentials”
5. Type “Product import” under the Private app name
6. Scroll down to “Product Information” and switch the setting from “No access” to “Read access”
7. Scroll to the bottom of the page and click on “Save”
8. Scroll to “Example URL” and copy the entire text
9. Paste copied Example URL link to “Shopify Product Import” field
10. Click on “Save”

  • Your products will be imported to your Shopmatic account within minutes.
  • 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 your webstore.
  • To import your products again from the Shopify platform, simply click on the “Import Product” button, and then on “Save”.

Please note: If you import the same Shopify account multiple times, it will also create multiple listings of the same product on your Shopmatic webstore.

Was this article helpful?