CSV INVENTORY UPLOAD FILE
The first line of your product CSV has to include the field headers described below, in the same order, with each separated by a comma. Subsequent lines in the file should contain data for your product using those same fields in that exact same order. Here's a description of each field:
HandleHandles are unique names for each product. They can contain letters, dashes and numbers, but no spaces, no capital letters, and no other punctuation. A handle is used in the URL for each product. For example, the handle for a "Women's Snowboard" should be "womens-snowboard".
Every line in the CSV starting with a different handle is treated as a new product. If you want to add multiple images to a product, or want the product to have variants, you should have multiple lines with the same handle.
Title
The title of your product. Example: Women's Snowboard
Body (HTML)
The description of the product in HTML format. This can also be plain text without any formatting.
Vendor (min. 2 characters)
Your seller name. For example, John's Designs. This will be the same for every product.
Type
The Product type. For example, Mugs.
Tags
Leave blank
Published
Leave blank
Option1 Name
If a product has an option (for example the option to buy the same cushion but in different colours), enter its name. For example, "Colour".
For products with only a single option, this should be set to "Title".
Option1 Value
If a product has an option, enter its value (range of colours available). For example, "Black". For products with only a single option, this should be set to "Default Title".
Option2 Name (can be left blank)
If a product has a second option, enter its name. For example, Size.
Option2 Value (can be left blank)
If a product has a second option, enter its value. For example, Large.
Option3 Name (can be left blank)
If a product has a third option, enter its name.
Option3 Value (can be left blank)
If a product has a third option, enter the value of the option.
Variant SKU (can be left blank)
The Stock Keeping Unit (SKU) of the product or variant. This is used to track inventory with inventory tracking services.
Variant Grams
The weight of the product or variant in grams. Do not add a unit of measurement, just the number.
Note - Shopify will always import and export weight in grams, even if you specify a different unit. You must use accurate weights if you intend to offer carrier-calculated shipping or use a third-party fulfillment service.
Variant Inventory Tracker (can be left blank)
Include your inventory tracking for this variant or product. Valid values include "shopify", "shipwire", "amazon_marketplace_web", or blank if inventory is not tracked.
Variant Inventory Quantity
The number of items you have in stock of this product or variant.
Variant Inventory Policy
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.
Variant Fulfillment Service
Enter the name of your store as you are going to be fulfilling your own orders. For example, if "Mr. Fulfiller" is the name of your store, for your fulfillment service's name, enter "mr-fulfiller" in the CSV file.
Variant Price
The price of the product or variant. Don't place any currency symbol there. For example, 9.99. (This is the price you wish to sell your product at - commission will be deducted from this).
Variant Compare at Price
The "Compare at Price"" of the product or variant. Don't place any currency symbol there. For example, 9.99.
Variant Requires Shipping (blank = FALSE)
The option to require shipping. Valid values are "TRUE", "FALSE", or blank.
Variant Taxable (blank = FALSE)
Apply taxes to this variant. Valid values are "TRUE", "FALSE", or blank.
Variant Barcode (can be left blank)
The barcode, ISBN or UPC of the product.
Image Src
Put the URL for the product image. Shopify will download the images during the import and re-upload them into our store. These images are not variant specific. The variant image column is where you specify variant images.
Note - You won't be able to change your image filename after that image has been uploaded to your shop. Don't upload images that have _thumb
, _small
, or _medium
suffixes in their names.
Image Alt Text
The text that describes an image. Useful if an image cannot be displayed or a screenreader passes over an image—the text replaces this element - cannot be the same as product description e.g. Labrador bone china mug.
Gift Card
(False for all) States whether the product is a Gift Card or not. Valid values are "TRUE", or "FALSE". The addition of this column also allows you to edit other Gift Card details, such as the Body or Tags columns, and import these changes. A gift card can only be created and activated in the Shopify admin. You can't initially create a gift card through a product CSV import.
Metafields
SEO Title
leave blank
SEO Description
leave blank
Google Shopping / Google Product Category
Google has a proprietary set of product categories. The full list is quite large to allow merchants to be very specific towards their target audience. You can upload any value you want using the CSV file, however if your language format does not match Google's full product taxonomy, you might not be able to publish the products to Google.
Google Shopping / Gender
What gender does this product target? Valid values are Female
, Male
, or Unisex
Google Shopping / Age Group
What age group does this product target? Valid values are Adult
or Kids
only.
Google Shopping / MPN (if available)
The MPN, or Manufacturer Part Number, is a string of alphanumeric digits of various lengths (0-9, A-Z).
Google Shopping / Adwords Grouping (can be left blank)
This is used to group products in an arbitrary way. It can be used for Product Filters to limit a campaign to a group of products, or Product Targets to bid differently for a group of products. You can enter any "string" data (letters and numbers).
For more information visit https://support.google.com/merchants/answer/188494?hl=en.
Google Shopping / Adwords Labels (can be left blank)
Very similar to adwords_grouping, but it will only only work on Cost Per Click (CPC). It can hold multiple values, allowing a product to be tagged with multiple labels.
For more information visit https://support.google.com/merchants/answer/188494?hl=en.
Google Shopping / Condition
State what condition the product will be in at the time of sale (what quality?). Valid values are new
, used
, or refurbished
.
Google Shopping / Custom Product
False means that this product does not have an MPN or a unique product identifier (UPC, ISBN, EAN, JAN) set as a variant barcode. Valid values are TRUE
or FALSE
. Learn more here.
Google Shopping / Custom Label 0 (can be left blank)
You can have up to 5 custom labels for your product numbered 0 through 4. You can identify a specific definition for each label and specify a value. For example, Sale.
Google Shopping / Custom Label 1 (can be left blank)
You can have up to 5 custom labels for your product numbered 0 through 4. You can identify a specific definition for each label and specify a value. For example, ReleaseDate.
Google Shopping / Custom Label 2 (can be left blank)
You can have up to 5 custom labels for your product numbered 0 through 4. You can identify a specific definition for each label and specify a value. For example, Season.
Google Shopping / Custom Label 3 (can be left blank)
You can have up to 5 custom labels for your product numbered 0 through 4. You can identify a specific definition for each label and specify a value. For example, Clearance.
Google Shopping / Custom Label 4 (can be left blank)
You can have up to 5 custom labels for your product numbered 0 through 4. You can identify a specific definition for each label and specify a value. For example, SellingRate.
Variant image
Put the URL for your variant image. Shopify will download the images during the import and re-upload them into your store.
Variant Weight Unit (can be left blank)
Convert the variant grams field to a different unit of measure by entering kg
, g
, oz
, or lb
. If this field is left blank, the weight will be uploaded as grams and then converted to your store's default weight unit.
Variant Tax Code (can be left blank)
Enter a tax code that applies to a specific variant of the product. For example, TX123.
The Collection column exception
To organize your products into collections during the CSV upload, you can add a new column anywhere in your CSV file with the header name Collection
. This is the only column you can add to the CSV that will not break the format. Therefore:
Collection (must create a new column, can be left blank)
Enter the name of the collections as listed by IYDHG to add this product. You can only add a product to one collection using this method.