Note: File Import will Update products and Default price-books if any of the products which already exist in the database


Step 1. Click Products on Navigation bar and select Products from the dropdown.



Step 2. Click Drop down next to Add New Product .



Step 3. Click on Import Products.



Step 4.Choose the product file.


Create a .csv file in the below explained format. 

OR 

Download the sample file and edit the products and upload.



Column Required Type Description Example
name Yes string Item Name iPad 4 
short_name No string
Item Short Name/Code ipd4
sku No string
Item EAN / UPC (Barcode)

Note: Every item needs a unique item sku. If items have identical item numbers, they cannot be imported.
8590095789
description No
string
Description

Enter an item description
Apple iPad 4 64GB retina display.
section_name Yes
string
Section name
If you want the item to be listed within the category, you can provide the category name.
If section name is empty it will add to General section.

Note: If you provide New Section name which does not exist the system will automatically add the new Section.
Tablet-PC
brand_name No
string
Manufacturer or Brand name

Note: If you provide New Brand name which does not exist the system will automatically add the new Brand.
Apple
supplier_name No
string
Item Supplier

Note: If you provide New Supplier name which does not exist the system will automatically add the new Supplier.
Micro
modifier_set_name

No string Modifier Set name

If the product has any modifiers provide the modifier set name which you have already added.

 

Note: If you provide modifier set name which does not exist the system will skip it.

 
Color-Options
color No

Item Color
Note: You can use the hex codes available
      #49ab47      #e64946      #359fc8       #ffb237

      #785cb4      #b77334      #585858      #add852 

     
 #cf6e6e       #8e908f 

If color is empty it defaults to       #8e908f 
#585858
measure_type No
string Unit of measure.

You can define your unit like Nos, Kgs, Lbs etc...
Nos
is_unit No

Use any one of the option 0 or 1
If the product is of weight type please use 0 so it auto prompts for quantity when selling.

Note: If you leave it blank it defaults to 1.

1
selling_price Yes float
Selling base price ( Unit amount excluding tax, discount ).

Positive value (Price > 0)
Decimal places: 2
Decimal separator: point (not comma)
No currency symbol

Note: If 0.00 is submitted here, the import will break at that point.
399.00
discount_percentage No

Discount percentage

Positive value (Percentage > 0 and less than 99.00)
Decimal places: 2
Decimal separator: point (not comma)
No percentage symbol

Note: If discount is greater than 99 is submitted here, the import will break at that point.
6.00
tax_name Yes
string Tax name
Provide the tax name which you have already added.

Note: If you provide New Tax name which does not exist the system will automatically add the new Tax.
Vat
tax_percentage Yes

Tax percentage
Note: If you provide tax name which already exists percentage tax  entry not required.

Positive value (Price > 0)
Decimal places: 2
Decimal separator: point (not comma)
No percentage symbol

Note: If you provide new tax name in the above column percentage is mandatory else it will take 0.00 (Zero).
5.05
stock_tracking No

Stock Tracking
( Use any one of the options 0 or 1 or 2 )
Dont track stock level= 0
Track stock levels & Allow selling when stock is empty or negative = 1
Track stock levels & Deny selling when stock is empty or negative = 2

Note: If you leave it blank it defaults to 0.
1
reorder_point
No
float
Reorder Point
Enter the reorder level at which this product should be auto reordered
5
reorder_quantity No float Reorder Quantity
Enter the reorder quantity you wish to auto reorder.
10

enabled
Yes
string
Enabled 

yes = product is enabled
no   = product is disabled
Choose whether the Product should be enabled or not
yes


Step 5. Select the Stores to which these products to be added. Click Import from CSV.

(Note: File Import can be done only for Standard Products. Maximum file size allowed is 5Mb)