The platform provides multiple ways of setting up / importing products in the platform.
- Create products manually within the platform
- Push the product data using REST API
- 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
| Field | Type | Compulsory | Description |
|---|---|---|---|
| Stock Code | String | Yes | 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) | String | Yes | This 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 | String | Yes | Name of the product |
| Short Description | String | No | Short description of the product |
| Long Description | String | No | Long description of the product |
| Item Type | Integer | No | This 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 | Yes | Brand of the product. |
| Brand Id | String | No | This 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 | No | This is sub brand or the sub manufacturer name of a product. |
| Category | String | No | This is the root category of the product |
| List Price | String | No | This is the List price of the product, also commonly known as MRP (max retail price) or RRP (recommended retail price) |
| Cost Price | Decimal | No | Cost 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 | Yes | Sell price is the price at which the product is going to be sold to the user |
| Current Stock | Numeric | No | This is available stock value of the product which can be 0 or greater |
| Size | String | No | If 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 | No | This is a custom attribute for the product. |
| Color Text | String | No | This is the name of the color that is used for displaying on the PDP. |
| Color Hex | String | No | This 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 | Numeric | No | Length of the product in mm, if applicable |
| Width | Numeric | No | Width of the product in mm, if applicable |
| Height | Numeric | No | Height of the product in mm, if applicable |
| Image1 | String | No | Name 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 | No | Name of the additional image 2 |
| Image3 | String | No | Name of the additional image 3 |
| Image4 | String | No | Name of the additional image 4 |
| Image5 | String | No | Name of the additional image 5 |
| Published | Boolean | Yes | Signifies if the product should be published on the website or not. By default, the product is not published. |
| Barcode | String | No | The barcode identifier for the product |
| UOM | String | No | Units of measure - by default, its set to pc (pieces) |
Steps to bulk upload product file:
- Go to Products > Bulk Import
- It opens the list view of all your historical imports
- Click on Bulk Import
- Select upload type Product
- Download the sample file (if needed), update the sheet with the data you want to import and click Next
- Select the file you want to upload and click Next
- 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
- Verify your data in the Preview and click on Next
You will see a confirmation screen confirming that the file has now been queued to be imported in the platform. - You can monitor the status of your upload in the list of imports.
- 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.