Product CSV column descriptions
Descriptions of the columns for the products CSV file.
To import products into Shopify using the Transporter app, you need a CSV file that contains only this record type.
CSV sample file
Download the sample product CSV file: products.csv.
You can use the Transporter command-line tool to generate this CSV file or you can follow the format described below to create it yourself.
The following table describes the column headers for the CSV file.
|The unique identifier for the product. Specify a human-friendly string with no spaces. Usually the handle is the product's title in lowercase with any spaces and special characters replaced by hyphens (-). For example,
|The name of the product. For example,
|Body||A description of the product. You can add HTML formatting tags in this description. For example,
|Vendor||The name of the product's vendor. The default value is the name of your store. For example,
|Type||You can use the product type as a condition for an automated collection, or to help you filter your products in the Shopify admin. A product can have only one product type.|
|Tags||A string of comma-separated tags that are used for filtering and search. Each comma-separated tag can have up to 255 characters. For example,
|Template Suffix||The suffix of the Liquid template that your online storefront will use to display the product and its variants. The default template is named
|Published||Whether the product is available to the online store. Valid values:
|Published At||The date and time (ISO 8601 format) when the product was made available to the online store. For example,
|Option1 Name||The custom product property name. For example,
|Option1 Value||The value of the custom product option. For example
|Option2 Name||The custom product property name such as Size, Color, and Material. Maximum length: 255 characters.|
|Option2 Value||The value of the custom product option.|
|Option3 Name||The custom product property name such as Size, Color, and Material. Maximum length: 255 characters.|
|Option3 Value||The value of the custom product option.|
|Variant SKU||A unique identifier for the product variant in your store. If your store uses a fulfillment service (that is,
|Metafields Global Title Tag||The name of the product (including its variants ) used for SEO purposes. If you do not provide a value, then by default the value in the
|Metafields Global Description Tag||The description of the product (including its variants ) used for SEO purposes. If you do not provide a value for this column, then by default the value from the Body column is used.
The Metafields Global Description Tag value is used in the meta description tag (
|Metafield Namespace||A container for a set of metafields.
To import metafields, you need to include values in the following 4 metafield columns:
|Metafield Key||The name of the metafield. This column is required when other metafield columns are included. Maximum length: 30 characters.|
|Metafield Value||The information to be stored as metadata. This column is required when other metafield columns are included.|
|Metafield Value Type||The metafield's information type. Valid values:
|Variant Grams||The amount that the product variant weighs in grams. If you leave this column empty, then by default its value is set to
|Variant Inventory Tracker||Describes how the inventory for the product variant is tracked. Valid values:
|Variant Inventory Qty||The amount (positive integer) of the product variant that is available for sale. For example,
|Variant Inventory Policy||Whether customers can place an order for the product variant when it's out of stock. Valid values:
|Variant Fulfillment Service||The fulfillment service that fulfills the product variant when it is ordered. Valid values:
|Variant Price||The price of the product variant.|
|Variant Compare At Price||A comparison or suggested price of the product variant.|
|Variant Inventory Cost||A record of the cost of the product variant.|
|Variant Requires Shipping||Whether the variant needs to be shipped. Valid values:
|Variant Taxable||Whether a tax is charged when the product variant is sold. Valid values:
|Variant Barcode||The barcode, UPC, or ISBN number for the product variant.|
|Image Attachment||A Base64 encoded image.|
The URL for the product image (for example, http://titan.plus/images/product-image.png). Non-HTTP URLs are not supported. The Transporter app will download the images during the import and upload them into your store. Images can be in .png, .gif or .jpg format. After the image is uploaded, its filename cannot be changed. If you have variant-specific images, then add them to the
To upload multiple images for a single product, create a new row for each image. In each row, enter the handle for the product in the
|Image Position||Enter the number that represents the order in which you want the image to appear on the product's page in your storefront. For example, enter 1 if you want the image to appear first for that product.|
|Image Alt Text||Alternative text that briefly describes the image. If an image can't load for any reason, then the alt text is shown in your storefront instead. Alt text is also used by search engines for SEO and by assistive technologies to describe an image to a customer who's visually impaired. Maximum: 512 characters.|
|Variant Image||The URL for image of the product variant. In one of the product variant's rows, enter the URL for the product variant image in this column. A product variant can only have one image.|
|Variant Weight||The amount that the product variant weighs. Do not use this column with the
|Variant Weight Unit||The unit of measurement that applies to the product variant's weight in the
|Variant Tax Code||The Avalara tax code for the product. This parameter applies only to stores that have installed the Avalara AvaTax app. For example, the physical good tax code is
The name of your CSV file needs to include the word
product (name of the object type that it contains). For example, myproducts.csv. The file needs to be in UTF-8 format.
Multiple product variants
If you have more than one product variant, then you need to create a row to describe each variant.
In the product row:
- Enter the option names in the option name columns (for example,
- Do not repeat the option names in the product variant rows.
In the product variant rows:
- Enter the product handle in the
- Enter the option values in the option value columns (for example,
To upload multiple images for a single product (that has no variants), create a row for each image. In each row, enter the handle for the product in the
Handle column and the URL for the image in the
Image Src column. To include any of the other information for that image (for example, its position), enter the information into the associated column (for example, into the
Image Position column).
To upload images for a product that has product variants, create a row for each product variant. In each product variant row, enter the handle for the product in the
Handle column and the URL for the product variant in the
Variant Image column. You can only import one image per product variant.