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

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


The standard template provides the following columns to be uploaded in excel / csv format


FieldTypeCompulsoryDescription
StockCode
Alpha-numericYes
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.
ProductCode (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. 
ProductName
StringYesName of the product
ShortDescription
String
No
Short description of the product
LongDescription
String
NoLong description of the product
ItemType
String
NoThis is product type that you are setting up example standard product, gift card, bundle, etc. 
ParentSKU
String
NoThis is the parent product code If there is any parent child relation between the product that you are setting up
Brand
String
YesBrand of the product.
Category
String
NoThis is the category of the product 
ParentCategory
String
No
Parent category of the product
ListPriceStringNoThis is the List price of the product, also commonly known as MRP (max retail price) or RRP (recommended retail price)
CostPrice
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.
SellPrice
Decimal
YesSell price is the product at which it is going to be sell to the user
CurrentStock
NumericNo
This is available stock value of the product which can be 0 or greater
Weight
String
NoWeight of the product
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.
ColorText
String
NoThis is the name of the color that is used for displaying on the PDP.
ColorHex
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 image5
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.