Can You Update A Single Field With The Amazon Product Template Upload

Using CSV files to import and export products

This page was printed on Apr 21, 2022. For the current version, visit https://assist.shopify.com/en/manual/products/import-export/using-csv.

You use a CSV (comma-separated values) file to import products into your Shopify store, and to export products from your store. By using a CSV file, y'all can import or export a large number of products and their details at ane fourth dimension. This tin be helpful if you want to exchange product information betwixt Shopify and some other system.

Acquire how to open up and edit a CSV file.

Download a sample CSV file

You tin download and view a sample product CSV file to use as a template.

The sample file contains an example product and a couple of variants. Your import file probably contains many more than products and variants. If yous use the sample file to create your own import file, then brand sure that y'all remove all the instance products.
The sample file includes the Variant Inventory Qty cavalcade, which is only used for stores that have a unmarried location. If you use multiple locations and you desire to import or export inventory quantities, then utilise the inventory CSV file.

Considerations for the product CSV file

Before y'all employ a production CSV file, review the following considerations.

Formatting the production CSV file

For your product CSV file to function correctly, verify the that information technology meets the post-obit criteria:

The showtime line of your product CSV file must exist the cavalcade headers every bit specified in the product CSV description table.
Each column must exist separated past a comma.

Required columns in the product CSV file

These columns must exist present under the following weather condition:

When you create a product CSV file to import new products, the only required column is Title .
When you update products using a CSV file, the just required columns are Handle and Title .

Information dependencies

Even though the Title and Handle columns are the only required columns when you update products using a CSV file, the information in some columns depends on the data in other columns.

For example, if you update a column that is related to variants, such every bit Variant SKU or Variant Grams , and then the data in those columns depends on the data near the corresponding variants. In this case, you lot must also include the Option1 Name and Option1 Value columns.

Before you remove or exclude columns from your CSV file, verify whether the data in whatsoever other columns depends on the data in the columns that yous want to remove or exclude. If your data depends on a column that is missing, then you receive an fault when you endeavour to import your product CSV file.

Shopify Markets CSV columns

If you have Shopify Markets ready on your store, then your CSV export reflects the unique markets that you created. Past default your CSV has the Price / International and Compare At Price / International columns. But if you supersede your international market with your ain market, then in the header name, International changes to the name of the market.

For example, if you create a market for each individual continent, and 1 of your market names is South America then column heading Price / International becomes Price / South America, and column heading Compare at price / International becomes Compare at price / Southward America in the CSV export file.

Columns in the product CSV file that must contain values

In addition to the Title column, another columns must accept a value. When a cavalcade requires a value, merely is blank, then a default value is created automatically in the post-obit cases:

The cavalcade is present, but the values in that column are blank.
The cavalcade is not present in the CSV file, but the values can't be blank.

The following table describes which columns must accept a value, and the default value that is created automatically if the column is blank.

Columns in the product CSV file that must take a value and the default values that are created automatically if no value is present.
Column	Default value created when the column is bare
Handle	This value is created based on the value in the Title column. For instance, if the value in the Championship cavalcade is `Black Lord's day Glasses`, then the value in this cavalcade is `blackness-sun-glasses`.
Vendor	The name of the store as you entered information technology when you created your Shopify account. For example, `John's Apparel` or `johns-apparel`. This is the aforementioned store proper name that you utilize when you log in to Shopify.
Published	`True`, which means that this production will be published and available in the online store sales channel.
Option1	`Title`
Option1 Value	`Default Title`
Variant Inventory Quantity	`0`
Variant Inventory Policy	`deny` When the value is `deny`, it indicates that the production tin can't be purchased afterward its inventory level reaches zero.
Variant Fulfillment Service	`manual`
Variant Price	`0.0`
Variant Requires Aircraft	`TRUE` When the value is `True`, it indicates that the product is a concrete production.
Variant Taxable	`Truthful`
Variant Grams	`0.0`
Variant Weight Unit	`kg`
Toll / International	If y'all sell internationally, then this is the toll of the product or variant. Only include the cost. Don't include any currency symbols. For example, `9.99`. This column heading name varies depending on the Shopify Markets that you take set upward on your shop. The default market is `International`. If you change the default market or add together whatever new markets, then your column headers appear with those market place names. Refer to the considerations department for more information. Acquire more about how overwriting existing products affects the data in this column.
Compare At Price / International	If y'all sell internationally, then this is the "Compare at Toll" of the product or variant. Only include the price. Don't include any currency symbols. For example, `9.99`. This column heading proper name varies depending on the Shopify Markets that yous accept set up on your shop. The default market is `International`. If you lot modify the default market or add together any new markets, then your cavalcade headers announced with those market names. Refer to the considerations section for more information. Learn more about how overwriting existing products affects the data in this column.
Status	`agile`

For more information well-nigh these and other columns, refer to the production CSV description tabular array.

Overwriting production details using an import CSV file

When you import a CSV file, you can select the option Overwrite whatever current products that have the same handle. Existing values will be used for any missing columns. If y'all select this pick, then when the handle in the import CSV file matches an existing handle in your products list, the values in CSV file overwrite the values in the matching columns in the existing production listing. If the overwrite option isn't selected, so the products that match an existing handle will be ignored during CSV import.

If a required cavalcade in the import CSV file is blank, then the matching value in the product list is overwritten as blank.

For example, the Standardized Product Type value in your existing production listing is John's Apparel, but the Standardized Product Blazon column is blank in the CSV file that y'all import, then the John's Apparel is overwritten every bit blank.
If a non-required column is not included in the import CSV file, but is included in the existing product list, and so the value in the product list remains the aforementioned.

For example, if the Variant Epitome column is included in the existing production listing, but that column is not included in the import CSV file, then the value in the product list remains the same.

Description of the product CSV file

For information nearly which columns are required, and which columns crave that values are entered, refer to the considerations for production CSV files.

Clarification of the columns in the product CSV file.
Column	Clarification
Handle	Handles are unique names for each product. They can incorporate letters, dashes, and numbers, but no spaces, accents, or other characters, including periods. Handles are used in the URL for each product. For example, the handle for a "Women'due south Snowboard" should be `womens-snowboard`, and the production's URL would exist `https://yourstore.myshopify.com/products/womens-snowboard`. Every line in the CSV file that starts with a different handle is treated as a new product. To add multiple images to a product, y'all must add together multiple lines with the same handle.
Championship	The title of your product. For example, `Women's Snowboard`.
Body (HTML)	The description of the product in HTML format. Acquire more about how overwriting existing products affects the information in this cavalcade.
Vendor	The name of the vendor for your production. For example, `John's Clothes`. Values must exist at least two characters long. Learn more about how overwriting existing products affects the information in this column.
Standardized production type	A characterization that describes the type of product. This label must be taken from the predefined standardized list of production types. Y'all can input the standardized product type in either of the post-obit ways: using the total path from the Shopify Product Taxonomy, for example `Dwelling house & Garden > Linens & Bedding > Bedding > Bed Sheets` using the numerical ID, for example `371` Learn more most adding a standardized product blazon Learn more than about how overwriting existing products affects the data in this column.
Custom product blazon	A custom label that describes the category of a product. This characterization doesn't demand to accommodate to any predefined format. Learn more most adding a custom product type Acquire more about how overwriting existing products affects the data in this column.
Tags	A comma-separated list of tags used to tag the production. Nearly spreadsheet applications automatically add quotes around the tags for you. If you employ a plain text editor, then yous need to manually add the quotes. For example, `"tag1, tag2, tag3"`. Acquire more than about how overwriting existing products affects the data in this column.
Published	Indicates whether a product is published on your online store. Valid values are `True` if the production is published on your online shop, or `FALSE` if the product is not available on your online store.
Option1 Name	If a product has an choice, then enter its proper noun. For example, `Colour`. If a product has just one pick, and so this value should be `Championship`.
Option1 Value	Caution: Changing data in this column deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values can break third-party dependencies on variant IDs. If a product has an selection, and then enter its value. For case, `Black`. If a product has only ane selection, then this value should exist `Default Title`.
Option2 Name	If a production has a second option, so enter its name. For case, `Size`. Acquire more almost how overwriting existing products affects the information in this column.
Option2 Value	Caution: Irresolute data in this column deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values tin pause third-party dependencies on variant IDs. If a product has a second option, and then enter its value. For example, `Big`. Learn more about how overwriting existing products affects the data in this column.
Option3 Name	If a product has a third option, then enter its name. Learn more about how overwriting existing products affects the data in this column.
Option3 Value	Caution: Changing data in this cavalcade deletes existing variant IDs values, and creates new variant IDs. Whatsoever modify to variant ID values tin pause 3rd-political party dependencies on variant IDs. If a product has a third selection, then enter its value. Learn more most how overwriting existing products affects the data in this cavalcade.
Variant SKU	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 . Larn more than about how overwriting existing products affects the data in this column.
Variant Grams	The weight of the product or variant in grams. Don't specify a unit of measurement or utilise decimals. For instance, 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 authentic weights if you intend to offer carrier-calculated shipping or use a third-party fulfillment service.
Variant Inventory Tracker	Include your inventory tracking for this variant or production. Valid values include `shopify`, `shipwire`, `amazon_marketplace_web`, or blank if inventory isn't tracked. If the existing inventory tracking options are removed, and then inventory is no longer tracked. Learn more about how overwriting existing products affects the data in this cavalcade.
Variant Inventory Qty	The number of items you have in stock of this production or variant. This cavalcade is only used for Shopify stores that have a single location. Note: This column is but available for store that have only one location. If your shop manages inventory at multiple locations, then this column isn't included. If yous want to import or export inventory quantities, then utilize the inventory CSV file. Learn more than almost how overwriting existing products affects the data in this column.
Variant Inventory Policy	How to handle orders when the inventory level for this product or variant has reached nix. Variants with a `deny` inventory policy can't be purchased subsequently their inventory level reaches zero. Variants with a `continue` inventory policy tin can exist purchased later their inventory level reaches zero, allowing for negative inventory levels.
Variant Fulfillment Service	The product or variant fulfillment service used. The following are the valid values for this column: `transmission` `shipwire` `webgistix` `amazon_marketplace_web` If y'all use a custom fulfillment service, and then you tin can add together the name of the service in this column. For the custom proper name, use just lowercase messages. Spaces aren't allowed and you must replace them with a dash (-). Periods and other special characters are removed. For example, if "Joan'south Fulfillment" is your fulfillment service'southward proper name, enter `joans-fulfillment` in the CSV file. You must have a custom fulfillment service gear up up in your Shopify admin before you can add the name of the service in this cavalcade.
Variant Price	The price of the product or variant. Only include the cost and don't include any currency symbols. For case, `ix.99`.
Variant Compare at Price	The "Compare at Price" of the product or variant. But include the price and don't include any currency symbols. For example, `9.99`. Larn more about how overwriting existing products affects the information in this cavalcade.
Variant Requires Shipping	The option to crave shipping. Valid values are `True` or `FALSE`.
Variant Taxable	Apply taxes to this variant. Valid values are `True` or `Fake`.
Variant Barcode	The barcode, ISBN, or UPC of the product. Acquire more virtually how overwriting existing products affects the data in this column.
Image Src	Enter the URL for the product image. Shopify downloads the images during the import and re-uploads them into your store. These images aren't variant-specific. The variant prototype column is where you specify variant images. Yous tin can't change the image file proper name subsequently that image has been uploaded to your shop. Don't upload images that have `_thumb`, `_small`, or `_medium` suffixes in their names. Acquire more almost how overwriting existing products affects the data in this column.
Image Position	Enter the number that represents the order in which you want the paradigm to appear on the product's page. The images appears in order from smallest to largest starting from an image position value of `1`. For case, if y'all want the image to appear first for that production, then enter `ane`. Learn more about how overwriting existing products affects the data in this column.
Image Alt Text	Alt (alternate) text describes an image and is an important part of a production description. If an epitome tin can't load for whatsoever reason, then alt text is shown instead. It's also used by assistive technology to describe an image to a customer who's visually dumb. Including alt text will boost your website's SEO. Keep your alt text brief and descriptive. The maximum length is 512 characters, but the optimal length is 125 characters or fewer. Learn more about how overwriting existing products affects the data in this column.
Souvenir Carte du jour	Indicates whether the production is a gift bill of fare. Valid values are `True` or `FALSE`. The addition of this column also allows y'all to edit other gift card details, such as the Body or Tags columns, and then import these changes. A gift menu can only exist created and activated in the Shopify admin. You tin can't create a souvenir carte through a product CSV file import. Learn more about how overwriting existing products affects the data in this column.
SEO Championship	The SEO Title is found on a production's details folio under the Search engine listing preview header in the Page championship field. The SEO Title is alphanumeric and tin include up to seventy characters. If yous leave this column blank when you import a product, then the value in the Title column is entered into the Page title field on the product'south details folio. Learn more nearly how overwriting existing products affects the information in this cavalcade.
SEO Description	The SEO clarification is also constitute on a product'south details page nether the Search engine listing preview header in the Description. The SEO clarification is alphanumeric and tin can include up to 320 characters. If you leave this column blank when y'all import a product, then the value in the Body (HTML) cavalcade is entered into the Description field on the product'southward details folio. Learn more virtually how overwriting existing products affects the data in this column.
Google Production Category	If you currently use a Google product category, you can employ information technology as your Shopify standardized product blazon. You can utilise the standardized production type, the Google Product Category, or both. Provide the most specific category possible for each item. The Google Product Category (GPC) (google_product_category) uses Google'due south product taxonomy. You can input the Google production category in either of the following ways: using the full taxonomy path, for case `Apparel & Accessories > Clothing > Shirts & Tops` using the numerical ID, for instance `212` Learn more about how overwriting existing products affects the information in this column.
Google Shopping metafields	The Google Shopping columns might be used by an app to synchronize products to the Google Merchant Center. However, Shopify's Google aqueduct doesn't employ these metafields. You lot can ignore values in the columns that include Google Shopping in their names unless an app tells you to employ them. Learn more about how overwriting existing products affects the data in this column.
Variant Epitome	The URL for images of variants. If y'all add an URL, then information technology must be a functioning paradigm URL. Learn more virtually how overwriting existing products affects the data in this column.
Variant Weight Unit	Valid values are `g`, `kg`, `lb`, and `oz`.
Variant Tax Code	Available to: Shopify Plus plan The Avalara code to apply taxes to this product. This field only applies when you lot import to or export from a store that uses the Shopify Plus plan's integration with Avalara AvaTax. When you create a CSV file past exporting products from a store that uses Avalara, the Variant Taxation Code cavalcade is filled. If you import this CSV file into a shop that doesn't have Avalara ready, then your import fails. Learn more virtually how overwriting existing products affects the data in this column.
Cost per item	How much it costs you lot for the product or variant. But include the price. Don't include any currency symbols. For example, `9.99`. Learn more well-nigh how overwriting existing products affects the data in this column.
Condition	Indicates whether a product is available to your customers. Valid values are: `active`: the product is active and ready to be sold `draft`: the production is a draft and needs to be completed `archived`: the product is archived and no longer available to sell

Drove column exception

To organize your products into collections during the CSV file upload, you tin can add a new column anywhere in your CSV file with the header name Collection.

When you lot consign a CSV file, the Collection cavalcade is non included.

Description of the Drove column in the product CSV import file.
Cavalcade	Description
Collection	Enter the proper noun of the collection that you want to add this product to. If information technology's an existing automatic collection, then the product needs to meet the conditions for the drove. If the collection doesn't already be, then a manual collection is created. Yous can add a product to only one collection. This value can be blank. Learn more well-nigh how overwriting existing products affects the data in this column.

Create your product CSV file

For each product, you need to decide if it's a simple product or one with variants.

Simple product: A simple product doesn't include variants. If y'all upload a product that doesn't have variants, then enter all the fields for the product in the kickoff row along with the URL for the first image. In the post-obit rows, simply enter the handle and the URL for each additional image.
Production with variants: If you upload a production that has variants, so enter all the fields for the product in the first row along with the URL for the first image. In the following rows, enter the handle. And so skip the Title, Body (HTML), Vendor, and Tags columns. Fill out the rest of the variants' details and each prototype URL.

Later you've added all your products and images, save your CSV file in UTF-8 format using LF-fashion linefeeds. If you're not familiar with encodings, and then see your spreadsheet or text editor plan'south documentation.

To view an example CSV file, download this sample production CSV file, and so open information technology in Google Sheets or another spreadsheet program.

Prepare your images

A CSV file can merely comprise text, therefore, yous demand to make sure that all product images are on an existing website. Those image URLs are just used during the CSV file importing process. Y'all tin delete the URLs after your import is complete.

If the files are only on your reckoner, then to link to their URL, you must upload them to your Shopify store or to some other image hosting service.
If yous're switching to Shopify from another platform, then you lot tin can copy the current prototype 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 demand to practise anything because your images are already on your website.

When you lot have URLs for each product paradigm, you tin can start edifice your CSV file.

Adding multiple product images in a CSV file

You lot can add more product images to your CSV file by uploading more than images to your Shopify admin. If you're building your Shopify store with a CSV file, then the procedure is a little different. Review the post-obit considerations:

You demand to be able to edit a CSV file. Shopify recommends using Google Sheets to view a formatted version of your CSV files.
Yous tin add up to 250 images to a product.
Your product images must be uploaded to a publicly accessible URL. That is, they should exist behind an https:// protocol with no password protection. To practice this, you lot can upload images to the Files page of the Shopify admin. The URLs generate automatically. After you click Upload files, you can select up to a couple hundred images to upload in majority.

Add multiple product images to your CSV file

Insert new rows. Y'all must apply only ane row per image.
Re-create and paste the handle.
Copy and paste the paradigm URLs.

Insert a new row

Open your CSV file in your spreadsheet program, such as Google Sheets.
Locate the products that you want to add images to.
In the next row, click and drag the row numbers to select multiple rows. Select the same number of rows as the number of additional images y'all add.
While those rows are highlighted, right-click anywhere in the highlighted expanse, and and so select Insert Ten rows higher up.

Re-create and Paste the Handle value

Copy and paste the Handle value of the required production into column A for your new rows.

Re-create and Paste the paradigm URLs

On the Files page, upload your images to Shopify.
Click the Re-create link icon for one epitome URL at a time.
In the CSV file in your spreadsheet application, scroll sideways to the last columns of the CSV file.
In the Image Src column, paste the epitome URL into each line.
Repeat steps ii to 4 for all the images for this production
Optional: To better your SEO, enter values into all the Image Alt Text fields. Learn more about Paradigm alt text.
Salvage the CSV file and import information technology to Shopify.