Uploading a Csv of Your Data Feed From Your Computer Will Allow You to Set an Automated Schedule.

Using CSV files to import and export products

This folio was printed on April 17, 2022. For the electric current version, visit https://help.shopify.com/en/manual/products/import-export/using-csv.

You use a CSV (comma-separated values) file to import products into your Shopify shop, and to export products from your store. By using a CSV file, you can import or export a large number of products and their details at one fourth dimension. This tin can be helpful if you want to substitution production data between Shopify and another system.

Acquire how to open and edit a CSV file.

Download a sample CSV file

Y'all can download and view a sample product CSV file to utilize as a template.

The sample file contains an example product and a couple of variants. Your import file probably contains many more products and variants. If you apply the sample file to create your own import file, and then brand sure that you lot remove all the example products.
The sample file includes the Variant Inventory Qty column, which is just used for stores that take a single location. If you use multiple locations and you want to import or export inventory quantities, then use the inventory CSV file.

Considerations for the product CSV file

Before yous use a product CSV file, review the following considerations.

Formatting the product CSV file

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

The first line of your product CSV file must exist the column headers as specified in the product CSV clarification table.
Each cavalcade must be separated by a comma.

Required columns in the product CSV file

These columns must be present under the following conditions:

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

Information dependencies

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

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

Before you lot remove or exclude columns from your CSV file, verify whether the data in whatever other columns depends on the data in the columns that you want to remove or exclude. If your information depends on a column that is missing, and so y'all receive an error when y'all endeavour to import your product CSV file.

Shopify Markets CSV columns

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

For instance, if you create a market place for each private continent, and i of your marketplace names is S America and so column heading Price / International becomes Price / South America, and column heading Compare at price / International becomes Compare at price / South America in the CSV consign file.

Columns in the product CSV file that must incorporate values

In addition to the Title column, another columns must have a value. When a column requires a value, only is bare, so a default value is created automatically in the post-obit cases:

The cavalcade is present, just the values in that cavalcade are blank.
The column is non present in the CSV file, only the values can't be blank.

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

Columns in the production CSV file that must have a value and the default values that are created automatically if no value is nowadays.
Column	Default value created when the column is blank
Handle	This value is created based on the value in the Championship column. For example, if the value in the Title cavalcade is `Black Sun Glasses`, and then the value in this cavalcade is `black-sunday-glasses`.
Vendor	The proper name of the store equally yous entered it when you created your Shopify account. For example, `John's Clothes` or `johns-apparel`. This is the aforementioned store name that you apply when you log in to Shopify.
Published	`True`, which ways 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 can't be purchased subsequently its inventory level reaches zero.
Variant Fulfillment Service	`manual`
Variant Price	`0.0`
Variant Requires Shipping	`TRUE` When the value is `True`, information technology indicates that the product is a physical product.
Variant Taxable	`TRUE`
Variant Grams	`0.0`
Variant Weight Unit of measurement	`kg`
Price / International	If y'all sell internationally, then this is the price of the product or variant. But include the price. Don't include any currency symbols. For example, `9.99`. This column heading name varies depending on the Shopify Markets that you have fix on your store. The default market place is `International`. If y'all alter the default market place or add together whatsoever new markets, so your column headers appear with those marketplace names. Refer to the considerations department for more information. Larn more most how overwriting existing products affects the information in this column.
Compare At Price / International	If you sell internationally, then this is the "Compare at Price" of the product or variant. Simply include the price. Don't include whatever currency symbols. For case, `nine.99`. This cavalcade heading name varies depending on the Shopify Markets that you have set up upward on your shop. The default market is `International`. If you change the default market or add any new markets, then your column headers appear with those market place names. Refer to the considerations section for more data. Acquire more about how overwriting existing products affects the data in this cavalcade.
Status	`active`

For more information most these and other columns, refer to the product CSV clarification table.

Overwriting product details using an import CSV file

When you import a CSV file, yous can select the option Overwrite any current products that have the same handle. Existing values will be used for whatever missing columns. If you select this option, 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 product list. If the overwrite option isn't selected, then the products that lucifer an existing handle volition be ignored during CSV import.

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

For example, the Standardized Product Blazon value in your existing production list is John's Dress, merely the Standardized Product Blazon cavalcade is blank in the CSV file that yous import, and then the John's Clothes is overwritten as blank.
If a non-required column is not included in the import CSV file, but is included in the existing production listing, then the value in the product list remains the same.

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

Description of the production CSV file

For data about which columns are required, and which columns require that values are entered, refer to the considerations for production CSV files.

Description of the columns in the product CSV file.
Cavalcade	Description
Handle	Handles are unique names for each product. They can comprise 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's Snowboard" should be `womens-snowboard`, and the production'southward URL would be `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, you must add multiple lines with the aforementioned handle.
Title	The title of your product. For example, `Women's Snowboard`.
Torso (HTML)	The description of the production in HTML format. Learn more about how overwriting existing products affects the data in this column.
Vendor	The name of the vendor for your production. For instance, `John's Dress`. Values must be at least 2 characters long. Learn more near how overwriting existing products affects the data in this column.
Standardized production type	A characterization that describes the blazon of product. This characterization must be taken from the predefined standardized listing of product types. Yous can input the standardized product type in either of the post-obit ways: using the total path from the Shopify Product Taxonomy, for case `Domicile & Garden > Linens & Bedding > Bedding > Bed Sheets` using the numerical ID, for case `371` Learn more about calculation a standardized product type Learn more about how overwriting existing products affects the data in this cavalcade.
Custom product type	A custom label that describes the category of a production. This label doesn't demand to accommodate to whatever predefined format. Learn more than nigh adding a custom production type Learn more than about how overwriting existing products affects the data in this column.
Tags	A comma-separated listing of tags used to tag the product. Most spreadsheet applications automatically add quotes around the tags for you. If yous use a apparently text editor, then you demand to manually add together the quotes. For instance, `"tag1, tag2, tag3"`. Learn more near 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 product is published on your online store, or `FALSE` if the product is non available on your online store.
Option1 Name	If a production has an option, and then enter its name. For example, `Colour`. If a product has simply 1 option, and then this value should exist `Title`.
Option1 Value	Caution: Irresolute data in this cavalcade deletes existing variant IDs values, and creates new variant IDs. Any modify to variant ID values tin break third-party dependencies on variant IDs. If a product has an selection, and then enter its value. For example, `Black`. If a product has but i selection, then this value should exist `Default Title`.
Option2 Proper name	If a product has a second choice, then enter its proper noun. For example, `Size`. Acquire more near how overwriting existing products affects the information in this column.
Option2 Value	Circumspection: Changing data in this cavalcade deletes existing variant IDs values, and creates new variant IDs. Any alter to variant ID values tin break third-party dependencies on variant IDs. If a product has a second option, and then enter its value. For example, `Large`. Learn more than virtually how overwriting existing products affects the data in this cavalcade.
Option3 Name	If a product has a tertiary option, so enter its proper noun. Acquire more than nearly how overwriting existing products affects the data in this column.
Option3 Value	Caution: Changing information in this column deletes existing variant IDs values, and creates new variant IDs. Any modify to variant ID values tin break third-political party dependencies on variant IDs. If a product has a 3rd selection, then enter its value. Learn more almost how overwriting existing products affects the information in this column.
Variant SKU	The SKU of the production or variant. This is used to rails inventory with inventory tracking services. This field can't be left blank if yous're using a custom fulfillment service . Learn more 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 of measurement or utilize decimals. For example, for a weight of 5.125 kg, enter `5125`. Shopify always imports and exports the weight in grams, fifty-fifty if y'all specify a unlike unit. You lot must use accurate weights if you intend to offer carrier-calculated aircraft or use a tertiary-party fulfillment service.
Variant Inventory Tracker	Include your inventory tracking for this variant or product. Valid values include `shopify`, `shipwire`, `amazon_marketplace_web`, or blank if inventory isn't tracked. If the existing inventory tracking options are removed, then inventory is no longer tracked. Learn more than near how overwriting existing products affects the data in this column.
Variant Inventory Qty	The number of items you have in stock of this product or variant. This column is only used for Shopify stores that have a single location. Annotation: This column is only bachelor for store that have only 1 location. If your shop manages inventory at multiple locations, and then this column isn't included. If you want to import or export inventory quantities, and then use the inventory CSV file. Acquire more most 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 zero. Variants with a `deny` inventory policy tin can't be purchased after their inventory level reaches zero. Variants with a `proceed` inventory policy tin be purchased after 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: `manual` `shipwire` `webgistix` `amazon_marketplace_web` If you employ a custom fulfillment service, then you can add together the proper noun of the service in this column. For the custom proper noun, use simply lowercase letters. Spaces aren't immune and you must supplant them with a dash (-). Periods and other special characters are removed. For example, if "Joan's Fulfillment" is your fulfillment service'south name, enter `joans-fulfillment` in the CSV file. You must have a custom fulfillment service set upwards in your Shopify admin before yous can add together the name of the service in this column.
Variant Toll	The toll of the product or variant. Only include the price and don't include any currency symbols. For example, `9.99`.
Variant Compare at Price	The "Compare at Cost" of the product or variant. But include the price and don't include whatever currency symbols. For example, `9.99`. Learn more than almost how overwriting existing products affects the information in this cavalcade.
Variant Requires Shipping	The choice to crave aircraft. Valid values are `TRUE` or `False`.
Variant Taxable	Apply taxes to this variant. Valid values are `True` or `FALSE`.
Variant Barcode	The barcode, ISBN, or UPC of the product. Learn more most how overwriting existing products affects the information 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 epitome cavalcade is where you specify variant images. You lot can't alter the image file name after that image has been uploaded to your store. Don't upload images that have `_thumb`, `_small`, or `_medium` suffixes in their names. Larn more about how overwriting existing products affects the information in this column.
Prototype Position	Enter the number that represents the order in which you desire the image to announced on the product's page. The images appears in order from smallest to largest starting from an image position value of `one`. For case, if you lot want the epitome to appear first for that product, and so enter `1`. Learn more about how overwriting existing products affects the information in this column.
Epitome Alt Text	Alt (alternating) text describes an prototype and is an important part of a production description. If an image tin't load for whatsoever reason, then alt text is shown instead. It's also used by assistive technology to describe an paradigm to a client who'due south visually impaired. Including alt text will boost your website's SEO. Keep your alt text cursory and descriptive. The maximum length is 512 characters, but the optimal length is 125 characters or fewer. Larn more about how overwriting existing products affects the data in this column.
Gift Carte du jour	Indicates whether the product is a souvenir card. Valid values are `TRUE` or `FALSE`. The addition of this column besides allows you to edit other gift carte du jour details, such as the Trunk or Tags columns, and then import these changes. A souvenir card can only exist created and activated in the Shopify admin. You lot can't create a gift card through a product CSV file import. Learn more than about how overwriting existing products affects the information in this column.
SEO Championship	The SEO Championship is found on a product's details page under the Search engine list preview header in the Page championship field. The SEO Championship is alphanumeric and tin include upwards to 70 characters. If you exit this column bare when you import a product, then the value in the Title column is entered into the Page title field on the product'south details page. Learn more than most how overwriting existing products affects the data in this cavalcade.
SEO Description	The SEO description is also found on a production's details page nether the Search engine listing preview header in the Clarification. The SEO description is alphanumeric and can include up to 320 characters. If you exit this column blank when y'all import a production, so the value in the Body (HTML) column is entered into the Clarification field on the production's details folio. Learn more most how overwriting existing products affects the information in this column.
Google Production Category	If you currently use a Google product category, you tin apply it as your Shopify standardized product type. You can employ the standardized product blazon, the Google Production Category, or both. Provide the near specific category possible for each item. The Google Production Category (GPC) (google_product_category) uses Google's product taxonomy. You can input the Google product category in either of the following ways: using the full taxonomy path, for example `Clothes & Accessories > Wear > Shirts & Tops` using the numerical ID, for case `212` Learn more nigh how overwriting existing products affects the data in this column.
Google Shopping metafields	The Google Shopping columns might be used past an app to synchronize products to the Google Merchant Center. Yet, Shopify's Google channel doesn't use these metafields. You can ignore values in the columns that include Google Shopping in their names unless an app tells you to use them. Acquire more about how overwriting existing products affects the information in this column.
Variant Image	The URL for images of variants. If you add an URL, then information technology must be a operation paradigm URL. Learn more about how overwriting existing products affects the information in this column.
Variant Weight Unit	Valid values are `thou`, `kg`, `lb`, and `oz`.
Variant Tax Code	Available to: Shopify Plus program The Avalara code to utilize taxes to this production. This field only applies when you import to or export from a store that uses the Shopify Plus plan's integration with Avalara AvaTax. When yous create a CSV file by exporting products from a store that uses Avalara, the Variant Taxation Code column is filled. If you import this CSV file into a store that doesn't have Avalara set upward, then your import fails. Learn more than nearly how overwriting existing products affects the data in this column.
Cost per item	How much information technology costs you for the production or variant. Just include the toll. Don't include whatsoever currency symbols. For example, `ix.99`. Larn more than about how overwriting existing products affects the information in this column.
Status	Indicates whether a product is available to your customers. Valid values are: `active`: the production is agile and ready to be sold `typhoon`: the product 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 can add a new column anywhere in your CSV file with the header proper noun Collection.

When you export a CSV file, the Collection column is not included.

Description of the Collection column in the product CSV import file.
Column	Clarification
Collection	Enter the proper noun of the drove that you desire to add this production to. If it's an existing automatic collection, then the production needs to come across the weather condition for the collection. If the drove doesn't already exist, and then a manual collection is created. Yous tin add a production to simply i drove. This value tin can be blank. Larn more about how overwriting existing products affects the data in this column.

Create your product CSV file

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

Simple product: A simple production doesn't include variants. If you lot upload a product that doesn't have variants, then enter all the fields for the product in the first row along with the URL for the first epitome. In the following rows, only enter the handle and the URL for each additional epitome.
Product with variants: If you upload a product that has variants, then enter all the fields for the production in the get-go row forth with the URL for the outset prototype. In the following rows, enter the handle. And so skip the Title, Body (HTML), Vendor, and Tags columns. Make full out the residual of the variants' details and each image URL.

After y'all've added all your products and images, save your CSV file in UTF-8 format using LF-style linefeeds. If you're non familiar with encodings, and then meet your spreadsheet or text editor program's documentation.

To view an example CSV file, download this sample production CSV file, and then open it in Google Sheets or some other spreadsheet programme.

Prepare your images

A CSV file tin only contain text, therefore, you need to brand certain that all product images are on an existing website. Those epitome URLs are merely used during the CSV file importing process. You tin delete the URLs later on your import is complete.

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

When y'all have URLs for each product image, y'all tin start building your CSV file.

Adding multiple product images in a CSV file

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

You lot need 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 attainable URL. That is, they should be behind an https:// protocol with no password protection. To do this, you can upload images to the Files page of the Shopify admin. The URLs generate automatically. Subsequently you lot click Upload files, you can select up to a couple hundred images to upload in bulk.

Add multiple product images to your CSV file

Insert new rows. You must apply only i row per image.
Copy and paste the handle.
Copy and paste the prototype URLs.

Insert a new row

Open your CSV file in your spreadsheet plan, such equally 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 aforementioned number of rows as the number of additional images yous add.
While those rows are highlighted, correct-click anywhere in the highlighted surface area, and then select Insert X rows above.

Copy and Paste the Handle value

Re-create and paste the Handle value of the required product into column A for your new rows.

Re-create and Paste the epitome URLs

On the Files folio, upload your images to Shopify.
Click the Copy link icon for ane image 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 two to 4 for all the images for this production
Optional: To improve your SEO, enter values into all the Image Alt Text fields. Acquire more about Image alt text.
Save the CSV file and import it to Shopify.

scottbrequir.blogspot.com

Source: https://help.shopify.com/en/manual/products/import-export/using-csv