The platform provides multiple ways of setting up / importing products in the platform. 

  1. Create products manually within the platform
  2. Push the product data using REST API
  3. Upload product data using excel

This document covers how to import products using excel/csv. The standard template provides the following columns to be uploaded in excel / csv format


FieldTypeCompulsoryDescription
Stock Code
StringYes
This is the unique identifier for the product / bundle. This could either be auto-generated by the system or can also be provided by you as well.
Product Code (SKU)StringYesThis is the product code which can be common for multiple products, mainly useful in the case of variant. Variants are grouped together based on the same product code. 
Product Name
StringYesName of the product
Short Description
String
No
Short description of the product
Long Description
String
NoLong description of the product
Item Type
Integer
NoThis is product type that you are setting up. For example : standard product, gift card, bundle, etc.
Simple Product = 1,
Service = 2,
Variant = 6,
Virtual = 5,
Bundle = 7,
Fixed Subscription = 8,
Variable Subscription = 9,
Addon = 10  
Brand Name
String
YesBrand of the product.
Brand Id
String
NoThis is the unique identifier for the brand.
Sub Brand Id
String
No
This is the unique identifier for the sub brand.
Sub Brand Name
String
NoThis is sub brand or the sub manufacturer name of a product.
Category
String
NoThis is the root category of the product 
List PriceStringNoThis is the List price of the product, also commonly known as MRP (max retail price) or RRP (recommended retail price)
Cost Price
DecimalNoCost price of the product at which it was purchased and this can be left blank or 0 while import. The cost price is used to calculate the Gross profit / gross margin for the sales. So, this should ideally be populated with the landing cost of the product.
Sell Price
Decimal
YesSell price is the price at which the product is going to be sold to the user
Current Stock
NumericNo
This is available stock value of the product which can be 0 or greater
Size
String
NoIf a product having multiple size then this info can be uploaded with pipe symbol example in fashion industry one product can have multiple size  M|S. Using this convention, the system will automatically create different variants for the products. 
Gender
String
NoThis is a custom attribute for the product.
Color Text
String
NoThis is the name of the color that is used for displaying on the PDP.
Color Hex
String
NoThis is the color hex code, eg #FFFFFF - white. This is used to display the color swatch on PDP / PLP and also used for color grouping.
Length
NumericNoLength of the product in mm, if applicable
Width
NumericNoWidth of the product in mm, if applicable
Height
NumericNoHeight of the product in mm, if applicable
Image1
String
NoName of the primary image. This image would be setup as the default image. All these images can be bulk uploaded within the media library and the platform will automatically map them to the product based on the names provided.
Image2
String
NoName of the additional image 2
Image3
String
NoName of the additional image 3
Image4
String
NoName of the additional image 4
Image5
String
NoName of the additional image 5
Published
BooleanYesSignifies if the product should be published on the website or not. By default, the product is not published. 
BarcodeStringNoThe barcode identifier for the product
UOMStringNoUnits of measure - by default, its set to pc (pieces)


Steps to bulk upload product file:

  1. Go to Products > Bulk Import 
  2. It opens the list view of all your historical imports
  3. Click on Bulk Import
  4. Select upload type Product
  5. Download the sample file (if needed), update the sheet with the data you want to import and click Next
  6. Select the file you want to upload and click Next
  7. The next window asks you to map the columns, from the uploaded spreadsheet to the column names in the system. Once the mapping is done, click Next

  8. Verify your data in the Preview and click on Next
  9. You will see a confirmation screen confirming that the file has now been queued to be imported in the platform. 
  10. You can monitor the status of your upload in the list of imports. 
  11. If there are any errors in any of the records, the platform will show the specific records for which the data was not correct. If the data is all correct, the file gets uploaded with a success message displayed next to it.