This article provides full details of each value in the sample product import spreadsheet. It's a reference guide for merchants who import products and need help understanding how to use each spreadsheet column.

Column Name: Key
Description: a unique identifier for each product (this field is required and should be the same for each variant of the same product)
Corresponding Field Name: N/A
Extension Required to Expose Field: N/A
Page Section: N/A

Column Name: Product Name
Description: the name of your product as it displays on your storefront
Corresponding Field Name: Name
Extension Required to Expose Field: N/A
Page Section: N/A

Column Name: Price
Description: the price you want to sell the product for that displays on the storefront
Corresponding Field Name: Price
Extension Required to Expose Field: N/A
Page Section: N/A

Column Name: Description
Description: a short description of your product that displays on the storefront
Corresponding Field Name: Description
Extension Required to Expose Field: N/A
Page Section: N/A

Column Name: Category
Description: the category of products that this product belongs to (you can specify more than one category by separating them with a comma, such as "clothing, shirts")
Corresponding Field Name: Categories
Extension Required to Expose Field: N/A
Page Section: N/A

Column Name: Hidden
Description: a "true" / "false" value that determines whether this product displays on your storefront
Corresponding Field Name: N/A
Extension Required to Expose Field: N/A
Page Section: three-dot more options menu: Hide Product / Show Product 

Column Name: SEO Friendly Name
Description: the text you want search engines like Google and Bing to display as the link to the product (for example, "www.yourstore.ocom/p/seo-friendly-name-value")
Corresponding Field Name: Friendly Name
Extension Required to Expose Field: SEO
Page Section: SEO 

Column Name: SEO Title
Description: the product name in search engines and the page title in web browsers
Corresponding Field Name: Title
Extension Required to Expose Field: SEO
Page Section: SEO 

Column Name: SEO Description
Description: detailed text that appears in search engine results pages (Google cuts this value off after 160 characters, and penalizes you for duplicate text)
Corresponding Field Name: Meta Description
Extension Required to Expose Field: SEO
Page Section: SEO 

Column Name: Advanced Description
Description: a detailed description of your product that displays on your storefront product page (this field supports basic HTML)
Corresponding Field Name: Advanced Description
Extension Required to Expose Field: Advanced Descriptions
Page Section: Advanced Description
Note: This value is for an obsolete extension that's no longer available. We include the column here for backwards compatibility.

Column Name: Image URL
Description: the URL of the current location of this product's image(s) (you can specify more than one image by separating the URLs with a comma, such as "http://www.location.com/image1.jpg,http://www.location.com/image2.jpg")
Corresponding Field Name: N/A
Extension Required to Expose Field: N/A
Page Section: image gallery drop zone 

Column Name: Images Alt Text
Description: a description of what each image you specified contains, which displays when users hover the mouse over the image (search engines also index this content)
Corresponding Field Name: Alt Text
Extension Required to Expose Field: N/A
Page Section: hover over image: Edit metadata (i icon) 

Column Name: Variation1 Title
Description: the name of the variant category you would like to create (for example, "color")
Corresponding Field Name: Variant Name
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation1 Value
Description: the type of variant in the category you specified above (for example, "red")
Corresponding Field Name: Variant Values
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation2 Title
Description: the name of the variant category you would like to create (for example, "color")
Corresponding Field Name: Variant Name
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation2 Value
Description: the type of variant in the category you specified above (for example, "red")
Corresponding Field Name: Variant Values
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation3 Title
Description: the name of the variant category you would like to create (for example, "color")
Corresponding Field Name: Variant Name
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation3 Value
Description: the type of variant in the category you specified above (for example, "red")
Corresponding Field Name: Variant Values
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation4 Title
Description: the name of the variant category you would like to create (for example, "color")
Corresponding Field Name: Variant Name
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation4 Value
Description: the type of variant in the category you specified above (for example, "red")
Corresponding Field Name: Variant Values
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation5 Title
Description: the name of the variant category you would like to create (for example, "color")
Corresponding Field Name: Variant Name
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variation5 Value
Description: the type of variant in the category you specified above (for example, "red")
Corresponding Field Name: Variant Values
Extension Required to Expose Field: Variants
Page Section: Variants 

Column Name: Variant Sku
Description: the unique identifier for this particular variant product
Corresponding Field Name: SKU
Extension Required to Expose Field: Variants
Page Section: Variants > Edit Products 

Column Name: Variant Price
Description: the price of this particular variant product
Corresponding Field Name: Price
Extension Required to Expose Field: Variants
Page Section: Variants > Edit Products 

Column Name: Variant Hidden
Description: a "true" / "false" value that determines whether this variant product displays on your storefront
Corresponding Field Name: eye icon
Extension Required to Expose Field: Variants
Page Section: Variants > Edit Products 

For instructions on how to import products, see "Products App: Importing".

For more information about products, see "The Products App".

Did this answer your question?