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
Page Section: N/A

Column Name: Product Name
Description: the name of your product as it displays on your storefront
Corresponding Field Name: Name
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
Page Section: N/A

Column Name: Description
Description: a short description of your product that displays on the storefront
Corresponding Field Name: Description
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
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
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.com/p/seo-friendly-name-value")
Corresponding Field Name: Friendly Name
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
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
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
Page Section: Advanced Description

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
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
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
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
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
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
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
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
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
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
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
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
Page Section: Variants 

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

Column Name: Variant Price
Description: the price of this particular variant product
Corresponding Field Name: Price
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
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?