Product Details
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
URLProduct TitleProduct DescriptionVendorTypeTagsPublishedOption1 NameOption1 ValueOption2 NameOption2 ValueOption3 NameOption3 ValueVariant SKUVariant GramsVariant Inventory TrackerVariant Inventory QtyVariant Inventory PolicyVariant Fulfillment ServiceVariant PriceVariant Compare At PriceVariant Requires ShippingVariant TaxableVariant BarcodeImage SrcImage Alt TextGift CardCategory
2
example-t-shirt
Example T-Shirt
AcmeShirts
mens, t-shirt, casual
TRUESizeLarge2001denymanual25TRUETRUE
http://cdn.shopify.com/s/images/shopify_shirt.png?e6948ca4d9028f9e734b8202cc472e3b89aae0f3
A black t-shirt with the shopify logo
FALSEShirts
3
example-t-shirtSizeSmallexample-shirt-s2001denymanual19.9924.99TRUETRUE
4
example-t-shirtSizeMedium
example-shirt-m
200shopify1denymanual19.9924.99TRUETRUE
5
6
7
8
9
REQUIRED

The URL is simply the part of the link that is unique to each page (i.e. NOT the www.your domain.com/products/ part, but whatever comes after that!) Every line in the spreadsheet starting with a different URL is treated as a new product.

If you want the product to have variants, you should have multiple lines with the same URL. If you have a preferred URL structure, please add here (without domain name prefix, as shown in example). Otherwise I can generate this based on product name.

REQUIRED

Product name as you would like it shown in your Shopify store
REQUIRED

Product description as you would like it shown in your Shopify store
REQUIRED

Naturally if you make all your own products, this will be your business name! We don't have to display this for customers if it doesn't make sense to do so, but it is required when creating products in Shopify backend.
REQUIRED

The type of product this is, for categorisation purposes.
OPTIONAL

Comma separated list of tags. These are used for further categorisation if required.
OPTIONAL

States whether or not a product is published on your storefront (i.e. so your customers can see this). Valid values are TRUE if the product is published on your storefront, or FALSE if the product is hidden from your storefront (i.e. so it's basically a draft for you to publish later). Leaving the field blank will publish the product.
OPTIONAL

If a product has an option, enter its name. For example, "Size".
OPTIONAL

If a product has an option, enter its value. For example, "Large" or "Medium".
OPTIONAL

The other option columns are only if you have multiple options within a single product. In the example shown, if your t-shirt came in different colors as well as different sizes, you would add "Color" in this column, and the relevant values in the next column.

Each combination of options will require its own separate row. I recommend setting up one variation in its entirety first, then copy-pasting and simply editing the values as needed, to ensure title, URL, etc. stays consistent and does not result in duplicate products.
OPTIONALREQUIRED*

The weight of the product or variant in grams. Do not add a unit of measurement, just the number in grams.

*Although required to set up products in backend, you only need to add accurate weights if you intend to offer weight based shipping rates or use a third-party carrier-calculated fulfillment service.
REQUIRED

Include your inventory tracking for this variant or product. Valid values include "shopify", "shipwire", "amazon_marketplace_web", or blank if inventory is not tracked (i.e. you plan on manually monitoring stock levels).
REQUIRED IF VARIANT TRACKER COLUMN IS NOT BLANK

The number of items you have in stock of this product or variant.
REQUIRED IF VARIANT TRACKER COLUMN IS NOT BLANK

How to handle orders when inventory level for this product or variant has reached zero. Valid values are "deny", or "continue". "deny" will stop selling when inventory reaches 0, and "continue" will allow sales to continue into negative inventory levels.
REQUIRED

The product or variant fulfillment service used. Valid values are: "manual", "shipwire", "webgistix", "amazon_marketplace_web”.
REQUIRED

The price of the product or variant. Don't place any currency symbol here. For example, 9.99.

If you are offering a product on sale / discounted, add the DISCOUNTED price here (not original price).
OPTIONAL

Leave blank unless you are offering a discount, in which case add the ORIGINAL product price here (yes, I know this is a little unintuitive, unfortunately that's how Shopify lays it out!)
REQUIRED

The option to require shipping. Valid values are "TRUE", "FALSE" (i.e. download / digital product / anything tha does not require shipping!), or blank (which equals FALSE).
REQUIRED

Apply taxes to this variant (if you are required to charge tax). Valid values are "TRUE", "FALSE", or blank (which equals FALSE).
OPTIONALLEAVE THIS COLUMN BLANK

(quicker to add images once products are in Shopify)
OPTIONAL

But recommended for both SEO and accessibility reasons (i.e. partially sighted customers who may need to use screen readers)
OPTIONAL

Please note! Gift cards are only available on Shopify Pro plan or higher.
OPTIONAL
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu