Merchant Product CSV Format
Learn how to create your own CSV file while importing products to the store.
*Unique Id : This id is unique for every product and it should be a numeric only. The variants for the
product will have the same unique id as the main product with different lines below the main
product. (This field is mandatory)
*Title : This is the title of the product. Example – Leather Bag. (This field is mandatory)
*Description : This is the HTML description of the product without formatting.
*Vendor Email : Email of the vendor for the product. Example – john@doe.com (This field is
mandatory)
*Type : Denotes the Product type and into what collection it belongs. Example – Clothing (This field is mandatory)
Tags : Tags are the keywords associated with your product, which helps them to be searched easily
from the store frontend
For adding multiple product tags, refer the listing given in Products Tags page- “tag1,tag2,tag3”
*Option Name1 : The name for the product option. Example – Size (This field is mandatory)
For products with no variants, this should be set to "Title"
*Option Value1 : The value for the product option. Example – Large (This field is mandatory)
For products with no variants, this should be set to "Default Title"
Option Name2 : This is the second option for the product and can be left blank. Example – Color
Option Value2 : This is the product value for the second option. Example – Blue
Option Name3 : This is the third option for the product.
Option Value3 : This is the product value for the third option.
Variant SKU : Product SKU or the variant SKU. This is used to track inventory
Variant Grams : This is the variant weight in grams. You need to write just the number, not the
measurement unit. Example : 10
Variant Inventory Tracking: This is the inventory tracking for this variant or product. Valid values
include “shopify” or blank if you don't want to track inventory.
Variant Qty : This is the variant or the product quantity in stock.
*Variant Price : This is the price of the variant or product. No need to specify the currency.
Example : 299.00
Variant Compare at Price : This is the “compare at price” of the variant
*Variant Requires Shipping : Use 'TRUE' for shipping requirement and 'FALSE' if shipping not
required (This field is mandatory)
Variant Barcode : Barcode, ISBN or UPC of the product.
*Charge Taxes : Use 'TRUE' for taxes requirement and 'FALSE' if taxes not required (This field is
mandatory)
*Image Url : This field contains link(s) of product images. Use comma as separator when product
contains multiple images.
Custom Fields : If custom field is required then do not leave corresponding cell empty and if custom
field is of drop down type then fill only the values which are in the options list of that custom field .
Handling Charges : This is the Handling Charges goes to seller.(This field is used when Sales Price
Configuration is Enabled)
Width : This is the width of the product. (This field is mandatory when product have either one of
shipping method USPS, CANADA POST, ECOM EXPRESS)
Height : This is the height of the product. (This field is mandatory when product have either one of
shipping method USPS, CANADA POST, ECOM EXPRESS)
Length : This is the length of the product. (This field is mandatory when product have either one of
shipping method USPS, CANADA POST, ECOM EXPRESS)
Girth : This is the girth of the product. (This field is mandatory when product have either one of
shipping method USPS, CANADA POST, ECOM EXPRESS)
Collection : This is the name of the collection in which you wan to add the product. One product
can be added to only one collection by this method. Smart collection cannot be added here.
Tax Type : This is the Tax Type e.g. GST, Federal Tax (This field is mandatory when INDIAN GST
feature is ENABLED)
Inventory Policy : This field allow sellers to sell their products when it's Out Of Stock.(Use
'continue' for continue selling when product in out of stock and 'deny' to restrict)
Note :
• If a product has variants, then enter all the fields (described above) for the product on the
first line. On the following lines, enter the unique id of the product. Then, skip the Title,
Description, Vendor Email, Type, Tags and Collection fields. And fill out the rest of the
fields for variants.
• If you have restriction on product types, collections or tags, then you must enter only values
that are allowed. Otherwise, it will give error.