Knowledge Base - Your Online Tutorial.

How Can We Help?

< Back

How to Import / Export Products in CSV File

You can bulk add new products to your Unicart store if you have a wide variety of products. As importing products in CSV is fast and yet sensitive, it is recommended to bulk add basic data such as Product NameSKUQuantityPrice and etc. Product DescriptionWhats in the box and Highlight are recommended to update directly from Unicart as they require HTML code to align in CSV file. Product images are advised to upload directly from Unicart as well. You can also export products to bulk update existing products or for backup purpose.

Importing Products
Exporting Products

Importing Products

1. Navigate to Products page, click More icon and choose Import.

2. Click Sample CSV button download Unicart’s Products CSV format.

3. Open the downloaded sample Products CSV file via Open Office. Download Open Office.

4. Ensure the settings are correct especially Character SetSeparator Options and Text Delimeter. Click OK button.

csv3

5. Fill up the fields based on Unicart format in the CSV file.

Note: You may delete the columns which will not be updated except for the required (red) columns.  Avoid using (/) symbol in CSV as it will affect the importing process.

ColumnDescriptionSample Data
nameProduct name.Apple Cinema 30″
skuProduct identity code.A001
priceUnit price.2500.00
quantityStock quantity to sell.10
costCost price.2300.00
categoryCategory group. The category must be created in Unicart first.Desktop
category_2 …Additional Category group. The category must be created in Unicart first.Desktop > Monitor (subcategory)
brandBrand name. The brand must be created in Unicart first.Apple
statusCondition to publish a product.1 (Enable = 1, Disable = 0)
sortingDisplay in ascending order.1, 2, 3
date_availableDate to publish.2018-05-25 (YYYY-MM-DD)
descriptionProduct Specification. Require HTML code to align the content.

This is testing product for CSV used.

minimum_quantityMinimum quantity to be purchased.1
maximum_quantityMaximum quantity to be purchased.1
subtract_stock(Track Inventory) The availability to deduct stock automatically when order made.1 (Yes = 1, No = 0)
shippingThe need of parcel delivery to charge a shipping fee.1 (Yes = 1, No = 0)
length(Dimension) Length of a product. A mandatory field for Lazada sync.100
width(Dimension) Width of a product. A mandatory field for Lazada sync.50
height(Dimension) Height of a product. A mandatory field for Lazada sync.20
length_classDimension measurement.Centimeter / Inch / Millimeter
weightWeight of a product. A mandatory field for Lazada sync.1000
weight_classWeight measurement.Kilogram / Gram
meta_description(SEO) Meta tag description with limit of 250 characters. You may leave it blank as Google will capture the product description automatically.Apple Cinema 30″ is a …
page_title(SEO) Page title with limit of 70 characters. You may leave it blank as Unicart will take the product name for page title automatically.Unique Apple Cinema 30″
seo(SEO) SEO friendly URL with no spacing and special symbols except for dash (-). You may leave it blank as Unicart will take the product name for SEO URL automatically.apple-cinema-30-inches
highlightSelling points of a product. A mandatory field for Lazada sync. Require HTML code to align the content.
  • Highlight 1
  • Highlight 2
whatboxWhat’s in the Box. A mandatory field for Lazada sync. Require HTML code to align the content. 1 x Cable, 1 x Charger, 2 x Battery
tax_class_idProduct subject to tax. Please check with our support to get accurate tax class ID if you are tax registered company.14 (Default tax id is 14, no tax applied is -1)
tagHashtag to filter out products that have same tag.HD display
variant_1Product variant.
Format: Variant Name  || Variant Value || Variant SKU || Quantity || Subtract Stock || Price || + || Reward Point Required || + || Weight || + || Sorting
Color  || Blue || P1002-Blue || 10 || 1 || 0.0000 || + || 0 || + || 0.00000000 || + || 0
variant_2 …Additional product variants
Format: Variant Name  || Variant Value || Variant SKU || Quantity || Subtract Stock || Price || + || Reward Point Required || + || Weight || + || Sorting
Color  || Red || P1002-Red || 10 || 1 || 0.0000 || + || 0 || + || 0.00000000 || + || 0
variation_typeDisplay variants in Radio button or Drop Down List. radio / select
imageImage link to upload as product thumbnail for new product only. Image must be uploaded to Image Manager first to store in our server and generate image path link. https://www… (path from image manager only)
image_1 …Additional images link to upload as product thumbnail up to image_20, for new product only. Image must be uploaded to Image Manager first to store in our server and generate image path link. https://www… (path from image manager only)

6. Click Save icon and choose Keep Current Format option.

7. On the Product CSV page, click Choose File button to upload the modified products.csv. Click Next button.

8. Preview the data and click Proceed button.

Congratulations! You have successfully imported the Products CSV file on your Unicart store.

If you tried to import data with an incorrect format, Unicart will return 2 results.

1. Columns with error will be skipped, which means the particular customer will not be added nor updated.

2. Columns with warning can be still imported with the default value according to the rules.

Ensure that you have entered with right format of data, click Reupload CSV button to try import again.

Exporting Products

1. Navigate to Products page, you may filter or select products first before exporting.

2. On the Products page, Click More icon and choose Export.

3. Tick Export option and proceed with Export button.

4. Products’ data will be downloaded in CSV file.

Learn more about how to create new products.

Previous How to Sell Digital Products
Next How to Create Product Filters