Product Data & Media

Read time19 min

Product Data

Full Information can be found here:

Product CSV file format

The first line of your product CSV needs to include the field headers described in the table, in the same order, each separated by a comma. Later lines in the file should contain data for your product using the same fields in that exact same order.

Handle

Handles are unique names for each product. They can contain letters, dashes, and numbers, but no spaces. A handle is used in the URL for each product. For example, the handle for a "Women's Snowboard" should be womens-snowboard, and the product's URL would be https://yourstore.myshopify.com/products/womens-snowboard.

Every line in the CSV that starts with a different handle is treated as a new product. To add multiple images to a product, you should add 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)

The name of the vendor for your product. For example, John's Apparel.

Type

The product type. For example, Snowboard.

Tags (can be left blank)

A comma-separated list of tags used to tag the product. Most spreadsheet applications automatically add quotes around the tags for you. If you are using a plain text editor, then you need to manually add the quotes. For example, "tag1, tag2, tag3".

Published

States whether a product is published on your online store. Valid values are TRUE if the product is published on your online store, or FALSE if the product is hidden from your online store. Leaving the field blank will publish the product.

Option1 Name

If a product has an option, then enter its name. For example, Color.

For products with only a single option, this should be set to Title.

Option1 Value

If a product has an option, then enter its value. 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, then enter its name. For example, Size.

Option2 Value (can be left blank)

If a product has a second option, then enter its value. For example, Large.

Option3 Name (can be left blank)

If a product has a third option, then enter its name.

Option3 Value (can be left blank)

If a product has a third option, then enter its value.

Variant SKU (can be left blank)

The SKU of the product or variant. This is used to track inventory with inventory tracking services.

This field can't be left blank if you're using a custom fulfillment service.

Variant Grams

The weight of the product or variant in grams. Do not specify a unit of measurement or use decimals. For example, for a weight of 5.125 kg, enter 5125.

Shopify always imports and exports the 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 Qty

The number of items you have in stock of this product or variant. This column is used only for stores that have a single location.

If your store manages inventory at multiple locations, then this column isn't included. If you want to import or export inventory quantities, then use the inventory CSV file.

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

The product or variant fulfillment service used. Valid values are: manual, shipwire, webgistix, amazon_marketplace_web. If you use a custom fulfillment service, you can add the name of the service in this column. For the custom name, use only lowercase letters. Spaces aren't allowed—replace them with a dash (-). Periods and other special characters are removed. For example, if "Mr. Fulfiller" is your fulfillment service's name, enter mr-fulfiller in the CSV file.

You must have a custom fulfillment service set up in your Shopify admin before you can add the name of the service in this column.

Variant Price

The price of the product or variant. Don't include any currency symbols. For example, 9.99.

Variant Compare at Price

The "Compare at Price" of the product or variant. Don't include any currency symbols. 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 (can be left blank)

Enter the URL for the product image. Shopify downloads the images during the import and re-uploads them into your store. These images are not variant-specific. The variant image column is where you specify variant images.

You can't change the image filename after that image has been uploaded to your store. Don't upload images that have _thumb, _small, or _medium suffixes in their names.

Image Position

Enter the number that represents the order in which you want the image to appear on the product's page. The images will appear in order from smallest to largest starting from an image position value of 1. For example, enter 1 if you want the image to appear first for that product.

Image Alt Text (can be left blank)

Alt (alternate) text describes an image and is an important part of a product description. If an image can't load for any reason, then alt text is shown instead. It's also used by assistive technology to describe an image to a customer who's visually impaired. Including alt text will boost your website's SEO. Keep your alt text brief and descriptive. The maximum length is 512 characters, but 125 or less is recommended.

Gift Card

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 be created and activated only in the Shopify admin. You can't initially create a gift card through a product CSV import.

SEO Title

The SEO Title is found on a product's details page under the Search engine listing preview header in the Page title field. The SEO Title has a character (letters and numbers) limit of 70. If you leave this field blank when importing a product, the field is automatically populated with the product title.

SEO Description

The SEO Description is also found on a product's details page under the Search engine listing preview header in the Meta description field. The SEO Description has a character (letters and numbers) limit of 320. If you leave this field blank when importing a product, the field is automatically populated with the product description.

Google Shopping metafields

The Google Shopping fields might be used by an app to sync products to the Google Merchant Center. However, Shopify's Google Shopping app doesn't use these metafields. You can ignore fields in the columns that include Google Shopping in their names unless an app tells you to use them.

Variant Image

The URL for images of variants.

Variant Weight Unit (can be left blank)

Valid values are g, kg, lb, and oz. If this field is left blank, then the Variant Weight Unit is kg.

Variant Tax Code SHOPIFY PLUS

The Avalara code to apply taxes to this product. This field applies only when you are importing to or exporting from a store that uses Shopify Plus's integration with Avalara AvaTax.

When you create a CSV file by exporting products from a store that uses Avalara, the Variant Tax Code field is populated. If you import this CSV file into a store that doesn't have Avalara set up, then your import will fail.

Cost per item

How much it costs you for the product or variant. Don't include any currency symbols. For example, 9.99.

Prepare your images

A CSV file can only contain text. So you need to make sure all product images are on an existing website. Those image URLs are only used during the CSV importing process (in other words, you can delete them when your import is done).

  • If the files are on your computer only, you must upload them to your Shopify store or another image hosting service to link to their URL.
  • If you are switching to Shopify from another platform, you can copy the current image URLs and use them in the CSV file.
  • If the product CSV file was produced by exporting your products from Shopify, then you don't need to do anything because your images are already on your website.

Caution

If you remove products or product images from your store after exporting and try to import those products without updating their image URLs, your import fails.

When you have URLs for each product image, you can start building your CSV file.

Recommended Sizing & Specs

  • Compressed JPG
  • Max Size: 2400px x 2400px
  • Naming Convention: {{product_title}}-{{variant_sku}}.jpg example: mens_metro_gtx_infinium_down_parka-38191200_SARGE_S.jpg









doc powered bycompany wiki & knowledge base