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

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
NameStringYes
Name of the product
StockCodeStringYesThis 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
ShortDescription
StringNoShort description of the product
LongDescription
String
No
Long description of the product
BrandName
String
No
Brand name of the product
ItemTypeInteger
Yes
This is product type that you are setting up. For example : simple product, gift card, bundle, etc.
Simple Product = 1,
Service = 2,
Virtual = 5,
Fixed Subscription = 8,
Variable Subscription = 9,
Addon = 10 
 
StockOnHandNumeric
No
This is the current stock on hand count in the warehouse. If you do not provide any value, system by default sets it to 0. 
SupplierCodeString
No
This is the default supplier code for this product. It is okay to leave it blank if you do not wish or have this info at this stage.
CostPrice
Numeric 
No
This the cost of the product. If you do not provide any value, system by default sets this value to 0. 
SellPrice
Numeric 
No
This is the price at which you sell it to the customer. This includes VAT. This the cost of the product. If you do not provide any value, system by default sets this value to 0. 
SellPriceExclusiveVat
Numeric 
No
This is the price at which you sell it to the customer. This excludes  VAT. This the cost of the product. If you do not provide any value, system by default sets this value to 0.
ListpriceNumeric
NoThis is the recommended retail price. This the cost of the product. If you do not provide any value, system by default sets this value to 0. 
StatusBoolean
No
This is the status of the product.
1=Draft
2=Active
3=Archived
4=Discontinued
If you do not provide any value, system by default picks 1 i.e. Draft. 
BarCodeString
NoThis is the barcode of the product. This can be provided at this stage or later generated from the system.
ImageString
NoThis takes the complete URL of the image.
CategoryString
No
This is the category of the image.
SizeString
NoThis takes the size attribute value.(If Applicable) 
ColorName
String
No This takes the color name of the product.(If Applicable) 
MaterialStringNoThis takes the material of the product.(If Applicable)
WeightDecimalNoThis takes the weight of the product.(If Applicable)
NoteString
NoYou can add a note for the product using this field.
CountryOfOriginStringNo
This field takes the country of origin of the product.
HSNCode
String
NoThis field takes the HSN code of the product. 
UOM
String
NoThis field is unit of measurement of the product. The supported values are: Bag,Bucket,Bundle,Bowl,Box,Centimeters,Card,Case,Carton,Dozen,Each,Foot,
Gallon,Gross,Inches,Kit,Liter,Lot,Meter,MilliLiter,Millimeter,Piece,Pack,Pack 100,Pack 50,Pair,Rack,Roll,Set of 3,Set of 4,Set of 5,Single,Sheet,Square ft, Tube, Yard
DimLengthDecimal
NoThis is length dimension of the product.
DimWidthDecimal
NoThis is width dimension of the product.
DimHeight
DecimalNoThis is height dimension of the product.
Stockable
Boolean
NoThis field defines if the product is stackable in the warehouse or not. If you do not provide any value, system by default picks 1 i.e. Yes. 
ProductCode
StringYesProduct Code is the common identifier of all the product variants within it. For example PS001 is the product code which can have 4 stock codes within it PS001-Red-Small,PS001-Red-Medium, PS001-Blue-Small,PS001-Blue-Medium,Stock Code is a unique value which can also be used to identify a product. This can stay same as stock code incase product doesn't have a variant.
ColorCode
String
NoThis field takes the color code of the product.(If Applicable)
Gender
String
NoThis field takes the gender of the product.(If Applicable)
FulfilmentChannelIdString
NoThis field is to set up the fulfilment channel. This can be left blank as it is not a mandatory field.
FulfilFromWarehouse
Boolean

NoThis value is needed in 1(True) or 0(False). If you fulfill this product's order from your warehouse, the value has to be 1 else 0. If you do not provide any value, system by default picks 1 i.e. True.
SellWithoutInventory

Boolean
NoThis again take 1 or 0. If a product has value 1 against this field, it means you can receive orders even you run out of stock. If you do not provide any value, system by default picks 0 i.e. False.
FulfilFromSupplier
BooleanNoThis field too takes 1 or 0. If 1 it means this is primarily a dropship product else supply 0 against this field. If you do not provide any value, system by default picks 0 i.e. False. 
IsPreorderEnabledBooleanNoThis field takes 1 or 0. if 1-it means the product is enabled for preorder.If you do not provide any value, system by default picks 0 i.e. False. 
PreOrderMaxStockIntegerNoYou can define the maximum preorders that you wish to take for this product if preorder is enabled in the previous field. Units of measure - by default, its set to pc (pieces).If you do not provide any value, system by default picks 0. 


Steps to bulk upload product file:

  1. Go to Products > Bulk Import 

  2. Select the type of data import you want to do. (Upload Product, Upload Product Relationship). In order to upload/establish the relationship(variants or bundles) you need to import the standard products first.

  3. Download the sample file from this screen.
  4. Prepare the file for import. Fields descriptions can be found above.

  5. Drag and drop or choose the file from your local computer to import and click on Next.
  6. Map the data fields of the system against the excel file columns and click on Next.
  7. Preview your data to verify. Once verified, click on Next.
  8. The import must start processing and completed successfully shortly. Now if you want to upload the relationship file or establish a relationship among the products you just imported follow the steps here.