Bulk Import/Export using a CSV File
Bulk CSV upload lets you upload multiple products and variants at once. A CSV file (Comma Separated Values) is a plain text file with commas delimiting the fields. The first line of the CSV file is the header, and contains the name of the fields. A sample CSV is available from the Catalog>Bulk Import area of your store admin.
CSV import cannot be canceled or undone. All changes are irreversible.
A maximum of 1,000 products can be uploaded at one time (not including variants).
Import Products Options
1. Click Browse to select your CSV file for uploading
2. Select Ignore existing products OR Overwrite existing products
- a. Ignore existing products - If the handle already exists and this option is selected, the product will get skipped over and not be created
- b. Overwrite existing products - If the handle already exists and this option is selected, the product will overwrite the previous product and this cannot be undone
- c. Ignore image edits - If you select Overwrite existing products, the option to Ignore image edits will appear. If not selected, all images will be deleted and then reprocessed
3. When you're finished with your selections, click the import products button
4. Last Upload Status - This area will display the status of your most recent import
Fields for CSV file
The handle is the unique identifier for the product or variant row
The product title (100 characters maximum)
The product description. This field supports HTML tags. Please note Excel has a maximum cell size of 32,767 characters.
Comma separated list of categories
Specify if category cross promotion is enabled. Example value: "TRUE"
Specifies if the product is taxable. Example value: "TRUE"
Specifies if the product is active. Example value: "TRUE"
Specifies if the product is featured. Example value: "TRUE"
Determines the shipping method to be used for the product. Values: calculated, free, or flat
Domestic flat rate fee for product.
Domestic flat rate fee for additional purchases
Domestic flat rate handling fee for product
Domestic flat rate handling fee for additional purchases
International flat rate fee for product
International flat rate fee for additional purchases
International flat rate handling fee for product
International flat rate handling fee for additional purchases
Custom zones flat rate fee for product
Custom zones flat rate fee for additional purchases
Custom zones flat rate handling fee for product
Custom zones flat rate handling fee for additional purchases
optionname1 - 5
The option name for product/variant options. 50 characters maximum.
optionvalue1 - 5
The option value for product/variant options. 50 characters maximum.
The ID of the variant. This is not a required field when adding products but is required when editing.
The display name of the variant
The weight of the product. Unit weight is determined in store settings. Example Value "1.4"
The base price of the product or variant. Do not use currency identifier. Example Value "9.95"
The sale price offered on the product or variant. Do not use currency identifier. Example Value "8.95"
SKU for the product or variant. 50 characters maximum. Must be unique.
Choices are TRUE or FALSE
Choices are TRUE or FALSE. If set to TRUE, out of stock items can be purchased.
The number of items in stock. If trackinventory is set to FALSE, this column is ignored.
The product's SEO page title. 100 character limit.
The SEO keywords for the product. No HTML allowed. 1,000 character limit.
The SEO description for the product. No HMTL allowed. 1,000 character limit.
Comma separated list of image URLs.
Since product images can not be embedded in a CSV file, you can specify an external URL of the image to be downloaded and processed for new products.
Image URLs are included on exports.
It will not show on the csv export but you can add the column anywhere in the csv file.
You're able to use the headers "identifier" and "identifier_type" (type is MPN, ISBN, UPC, or EAN) and it will add or overwrite existing information.
Handle, Description, and Title (for products) are the only required fields.
Other fields will default if not entered. For example, if the shipping field is left blank, it will default to calculated. Shipping fees, if left blank, will default to 0.
ebay_listingprofilename – name of the shared listing profile
ebay_shippingprofilename - name of the shared shipping profile
ebay_paymentprofilename – name of the shared payment profile
ebay_returnsprofilename - name of the shared returns profile
ebay_title – the eBay title of the listing
ebay_ebay_siteid – the eBay site ID of the market: US = 0, Motors = 100, Canada = 2,
UK = 3, Australia = 15
ebay_currency – currency of the listing (example: USD)
ebay_ebay_username – the eBay account name
ebay_payment_salestaxstate – state to charge sales tax for (2 letter state ID)
ebay_payment_salestaxpercent – the rate of the sales tax in whole numbers (example: 6)
ebay_payment_shippingincludedintax - include sales tax on the shipping (TRUE/FALSE)
ebay_storecategory1 - the number of the primary eBay store category
ebay_storecategory2 - the number of the secondary eBay store category
ebay_listing_listingtype – the type of listing (values: Auction, FixedPriceItem,
ebay_listing_listingduration - the duration of the listing (values: Days_3, Days_5,
Days_7, Days_10, Days_30, GTC)
ebay_listing_primarycatid – the eBay category number
ebay_listing_condition – the item condition; values: 1000 (Brand New) 2750 (Like
ebay_listing_templatename – the name of the eBay listing template
ebay_listing_bestoffer – include Best Offer (TRUE/FALSE)
ebay_listing_bestoffer_autoaccept – include Best Offer auto accept (TRUE/FALSE)
ebay_listing_bestoffer_autoaccept_price – the auto accept price (do not include
the $ symbol)
ebay_listing_bestoffer_autodecline - include Best Offer auto decline (TRUE/
ebay_listing_bestoffer_autodecline_price – the auto decline price (do not include
the $ symbol)
ebay_itemspecifics_1_name - the name of the Item Specifics first field
ebay_itemspecifics_1_value - the value of the Item Specific first field
ebay_itemspecifics_1_keytype - not currently used
ebay_itemspecifics_2_name - the name of the Item Specifics second field
ebay_itemspecifics_2_value- the value of the Item Specific second field
ebay_itemspecifics_2_keytype - not currently used
The below columns are only used for eBay Motors only: