EasyStore Support Center

Contact Us

Import products (in bulk)


In this article

a. About import products tool 

b. Import products in bulk



About import products tool

Import products tool allows you to import your products in bulk by using the file (template_import_product_xls.xls) we provided.




Import products in bulk



1. EasyStore Control Panel > Products > Import product













2. Download the sample of Excel template for Excel user OR CSV template for Opensource user









3. Insert your product data according to the sample listed



Must know:
- If one product has few options (e.x. size, colors), make sure the handle is the same.
- One product can upload up to 2 images by using import products tool.
- Do not add or delete the original columns (e.x. add or delete Collection).



Must know for product with variants (e.x. S, M, L, black, white):

- Fill in Variant as below





Field name
Maximum length
Required / Optional
Handle - Product URL, can contain letters, dashes and numbers, but not space.
(e.x. www.testingshop.com/choco-brownie)
255
alphanumeric
Required
Title - Product name
255
alphanumeric
Required
Name - Product name
255
alphanumeric
Required
Taxable - Product taxable or not
-
Required - Fill in TRUE(Yes) OR FALSE(No)
Track_Inventory - Track inventory or not
-
Required - Fill in TRUE(Yes) OR FALSE(No)
Keywords - Keywords that help in SEO
255
alphanumeric
Optional
Description - Meta description that helps in SEO
4,294,967,295
alphanumeric
Optional
Image_Src1 , Image_Src2 
- Product image URL
4,294,967,295
alphanumeric
Optional
Collection 1, Collection 2
- Product's collection name
45
alphanumeric
Optional
Body_Html - Product description
4,294,967,295
alphanumeric
Optional - You can insert the description in HTML format
Store _Name - Store name
45
alphanumeric
Required
Published_At - The product's publish date & time
-
Optional
- Will use current date if leave blank
- If need specific date, use format DD/MM/YYYY
Variant_Type1, Variant_Type2, Variant_Type3
- Product's option name (e.x. Size)


255
alphanumeric
Not necessary to fill in if your product does not have variants
Variant_Option1,  Variant_Option2, Variant_Option3
- Product's option (e.x. S, M, L)


255
alphanumeric
Not necessary to fill in if your product does not have variants
Variant_ID -  Product's variant ID
20
numeric
Not necessary to fill in
- Can only be obtained if you exported the products.
- For next update use
SKU - Product' stock keeping unit, product's code for your own tracking (e.x.ES100001)
45
alphanumeric
Optional
Barcode - Product's  barcode
45
alphanumeric
Optional
Weight - Product's weight
11 numeric, 2 decimal point
Optional
Weight_Unit - Product's weight unit (maximum 2 units, e.x. g, kg, oz, lb)
2 alphabet
Optional
Grams - Product's weight in gram
11 numeric, 2 decimal point
Optional
Price - Product's price
11 numeric, 2 decimal point
Required, if not price will be in $0
Inventory_Quantity - Product's inventory quantity
11 numeric
Necessary to fill in if your Track_Inventory is TRUE
Not necessary to fill in if your Track_Inventory is FALSE
Compare_At_Price - Compare the price with another price (e.x.market price)
11 numeric, 2 decimal point
Optional
Variant_Taxable - Product variant are taxable or not
-
Required, if your Taxable is TRUE
Not necessary to fill in if your Taxable is FALSE
Is_Enabled - Show the product in store front or not
-
Required - Fill in TRUE(Yes) OR FALSE(No)
Variant_Image_Src - Image URL for the particular variant
4,294,967,295
alphanumeric
Optional





4.  EasyStore Control Panel > Products > Import product > Choose file > Upload > Cross the page > Refresh 






Powered by HelpSite