Products - Bulk Importing and Editing with CSV

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 productsOROverwrite 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

variantid The ID of the variant. This is not a required field when adding products but is required when editing.

variant_name The display name of the variant

weight The weight of the product. Unit weight is determined in store settings. Example Value "1.4"

price The base price of the product or variant. Do not use currency identifier. Example Value "9.95"

saleprice The sale price offered on the product or variant. Do not use currency identifier. Example Value "8.95"

sku SKU for the product or variant. 50 characters maximum. Must be unique.

trackinventory Choices are TRUE or FALSE

allowpurchase Choices are TRUE or FALSE. If set to TRUE, out of stock items can be purchased.

stocklevel The number of items in stock. If trackinventory is set to FALSE, this column is ignored.

seo_pagetitle The product's SEO page title. 100 character limit.

seo_keywords The SEO keywords for the product. No HTML allowed. 1,000 character limit.

seo_description The SEO description for the product. No HMTL allowed. 1,000 character limit.

images 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.

product identifier

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.