ebay file exchange Please specify valid upload file name

Using CSV files to import and export products

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

Y'all 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, you tin can import or export a large number of products and their details at one time. This can be helpful if you desire to substitution product information betwixt Shopify and another system.

Acquire how to open and edit a CSV file.

Download a sample CSV file

You tin download and view a sample product CSV file to use every bit 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 yous apply the sample file to create your ain import file, and so make certain that yous remove all the example products.
The sample file includes the Variant Inventory Qty cavalcade, which is simply used for stores that have a single location. If you use multiple locations and you want to import or consign inventory quantities, then use the inventory CSV file.

Considerations for the product CSV file

Before yous apply a production CSV file, review the following considerations.

Formatting the product CSV file

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

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

Required columns in the product CSV file

These columns must be present under the following conditions:

When you lot 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 Championship .

Data dependencies

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

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

Before you remove or exclude columns from your CSV file, verify whether the data in any 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, then you receive an error when you lot try to import your production CSV file.

Shopify Markets CSV columns

If yous accept Shopify Markets set up on your shop, then your CSV consign reflects the unique markets that you created. By default your CSV has the Price / International and Compare At Toll / International columns. But if you supercede your international market with your own marketplace, and then in the header name, International changes to the name of the market.

For example, if you create a market for each private continent, and one of your market names is South America and so column heading Cost / International becomes Cost / South America, and cavalcade heading Compare at cost / International becomes Compare at cost / South America in the CSV consign file.

Columns in the product CSV file that must contain values

In addition to the Title column, some other columns must have a value. When a column requires a value, but is bare, and so a default value is created automatically in the following cases:

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

The following table describes which columns must have 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 nowadays.
Column	Default value created when the column is blank
Handle	This value is created based on the value in the Title column. For case, if the value in the Title column is `Blackness Sun Glasses`, then the value in this cavalcade is `black-sun-glasses`.
Vendor	The name of the store as you entered information technology when y'all created your Shopify account. For case, `John's Clothes` or `johns-clothes`. This is the same store name that you apply when yous log in to Shopify.
Published	`TRUE`, which ways that this product volition be published and available in the online store sales aqueduct.
Option1	`Championship`
Option1 Value	`Default Title`
Variant Inventory Quantity	`0`
Variant Inventory Policy	`deny` When the value is `deny`, it indicates that the product can't be purchased after its inventory level reaches zero.
Variant Fulfillment Service	`manual`
Variant Toll	`0.0`
Variant Requires Shipping	`True` When the value is `True`, it indicates that the product is a concrete production.
Variant Taxable	`TRUE`
Variant Grams	`0.0`
Variant Weight Unit	`kg`
Price / International	If you sell internationally, then this is the price of the product or variant. Only include the cost. Don't include whatsoever currency symbols. For instance, `9.99`. This column heading name varies depending on the Shopify Markets that y'all have set on your shop. The default marketplace is `International`. If you modify 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. Larn more about how overwriting existing products affects the data in this column.
Compare At Toll / International	If you lot sell internationally, then this is the "Compare at Price" of the product or variant. Only include the toll. Don't include any currency symbols. For example, `ix.99`. This column heading proper noun varies depending on the Shopify Markets that y'all have ready on your shop. The default market is `International`. If yous modify the default market or add together any new markets, and so your column headers announced with those market place names. Refer to the considerations section for more information. Larn more virtually how overwriting existing products affects the data in this column.
Status	`agile`

For more than information near these and other columns, refer to the production CSV description tabular array.

Overwriting product details using an import CSV file

When you lot import a CSV file, you can select the option Overwrite whatsoever electric current products that have the aforementioned handle. Existing values will be used for any missing columns. If yous select this selection, and so when the handle in the import CSV file matches an existing handle in your products listing, the values in CSV file overwrite the values in the matching columns in the existing production listing. If the overwrite selection isn't selected, so the products that match an existing handle will exist ignored during CSV import.

If a required column in the import CSV file is blank, and then the matching value in the product list is overwritten equally bare.

For example, the Standardized Product Type value in your existing product list is John's Apparel, merely the Standardized Product Type column is blank in the CSV file that you import, then the John'south Apparel is overwritten equally blank.
If a non-required column is non 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 Image column is included in the existing product list, but that cavalcade is not included in the import CSV file, and so the value in the product listing remains the same.

Description of the product CSV file

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

Description of the columns in the product CSV file.
Column	Clarification
Handle	Handles are unique names for each product. They can contain messages, dashes, and numbers, simply 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 product's 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 together multiple lines with the same handle.
Title	The title of your product. For example, `Women's Snowboard`.
Body (HTML)	The description of the product in HTML format. Learn more about how overwriting existing products affects the information in this column.
Vendor	The name of the vendor for your product. For example, `John's Clothes`. Values must be at to the lowest degree 2 characters long. Learn more about how overwriting existing products affects the data in this column.
Standardized product blazon	A label that describes the type of product. This label must be taken from the predefined standardized list of production types. You can input the standardized production type in either of the following means: using the full path from the Shopify Product Taxonomy, for example `Abode & Garden > Linens & Bedding > Bedding > Bed Sheets` using the numerical ID, for example `371` Learn more than about adding a standardized product type Learn more about how overwriting existing products affects the information in this column.
Custom production type	A custom label that describes the category of a product. This label doesn't need to conform to any predefined format. Learn more nearly calculation a custom product type Learn more than near how overwriting existing products affects the data in this cavalcade.
Tags	A comma-separated list of tags used to tag the product. Most spreadsheet applications automatically add quotes around the tags for you. If you use a plain text editor, then you need to manually add together the quotes. For instance, `"tag1, tag2, tag3"`. Learn more about how overwriting existing products affects the data in this column.
Published	Indicates whether a product is published on your online shop. Valid values are `True` if the product is published on your online shop, or `FALSE` if the product is not available on your online store.
Option1 Name	If a production has an option, then enter its name. For instance, `Color`. If a product has simply ane option, then this value should be `Championship`.
Option1 Value	Caution: Changing data in this cavalcade deletes existing variant IDs values, and creates new variant IDs. Whatever change to variant ID values can suspension third-political party dependencies on variant IDs. If a product has an selection, and then enter its value. For example, `Blackness`. If a production has merely 1 selection, and so this value should be `Default Title`.
Option2 Name	If a product has a 2d option, then enter its proper noun. For example, `Size`. Acquire more well-nigh how overwriting existing products affects the data in this column.
Option2 Value	Circumspection: Irresolute data in this column deletes existing variant IDs values, and creates new variant IDs. Whatever change to variant ID values tin can break 3rd-political party dependencies on variant IDs. If a production has a second option, then enter its value. For case, `Large`. Learn more about how overwriting existing products affects the information in this column.
Option3 Name	If a product has a 3rd pick, then enter its proper noun. Learn more virtually how overwriting existing products affects the data in this cavalcade.
Option3 Value	Caution: Irresolute information in this column deletes existing variant IDs values, and creates new variant IDs. Whatever change to variant ID values tin break third-party dependencies on variant IDs. If a production has a third option, then enter its value. Learn more about how overwriting existing products affects the data in this column.
Variant SKU	The SKU of the product or variant. This is used to track inventory with inventory tracking services. This field tin can't be left bare if you'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 or use decimals. For instance, for a weight of five.125 kg, enter `5125`. Shopify always imports and exports the weight in grams, fifty-fifty if you specify a different unit of measurement. You must use authentic weights if you intend to offer carrier-calculated aircraft or apply a 3rd-political 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, so inventory is no longer tracked. Learn more about how overwriting existing products affects the data in this column.
Variant Inventory Qty	The number of items yous have in stock of this product or variant. This column is only used for Shopify stores that take a unmarried location. Note: This column is but available for shop that have only 1 location. If your store manages inventory at multiple locations, then this column isn't included. If y'all want to import or export inventory quantities, then utilize the inventory CSV file. Learn more nigh 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 zip. Variants with a `deny` inventory policy tin't be purchased afterward their inventory level reaches naught. Variants with a `continue` inventory policy can be purchased after their inventory level reaches cypher, 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 you lot utilise a custom fulfillment service, and so you tin add the name of the service in this column. For the custom proper noun, use only 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's Fulfillment" is your fulfillment service's proper name, enter `joans-fulfillment` in the CSV file. You must have a custom fulfillment service gear up in your Shopify admin before y'all can add the name of the service in this column.
Variant Price	The price of the product or variant. Only include the price and don't include any currency symbols. For example, `9.99`.
Variant Compare at Toll	The "Compare at Price" of the production 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 data in this column.
Variant Requires Shipping	The option to require shipping. 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 near how overwriting existing products affects the data in this column.
Epitome Src	Enter the URL for the production image. Shopify downloads the images during the import and re-uploads them into your store. These images aren't variant-specific. The variant image column is where you lot specify variant images. You can't modify the image file name afterward that image has been uploaded to your shop. Don't upload images that have `_thumb`, `_small`, or `_medium` suffixes in their names. Learn more about how overwriting existing products affects the data in this column.
Epitome Position	Enter the number that represents the guild in which you want the image to appear on the product's page. The images appears in lodge from smallest to largest starting from an paradigm position value of `ane`. For example, if you want the image to announced start for that product, then enter `1`. Larn more nearly how overwriting existing products affects the data in this cavalcade.
Image Alt Text	Alt (alternate) text describes an paradigm and is an important part of a product description. If an image tin can't load for any reason, so alt text is shown instead. It's also used past assistive technology to describe an paradigm to a customer who'southward visually impaired. Including alt text volition boost your website'south SEO. Go along your alt text brief and descriptive. The maximum length is 512 characters, simply the optimal length is 125 characters or fewer. Learn more about how overwriting existing products affects the data in this column.
Gift Carte	Indicates whether the product is a gift card. Valid values are `TRUE` or `FALSE`. The addition of this column also allows yous to edit other gift card details, such every bit the Trunk or Tags columns, and so import these changes. A gift card can merely be created and activated in the Shopify admin. Y'all can't create a souvenir carte through a product CSV file import. Acquire more nigh how overwriting existing products affects the information in this column.
SEO Title	The SEO Championship is institute on a product's details page under the Search engine listing preview header in the Folio championship field. The SEO Championship is alphanumeric and tin include up to 70 characters. If yous leave this column bare when you import a product, so the value in the Title column is entered into the Page title field on the production's details folio. Learn more nigh how overwriting existing products affects the data in this column.
SEO Description	The SEO description is too found on a production's details page nether the Search engine list preview header in the Description. The SEO description is alphanumeric and can include up to 320 characters. If yous go out this cavalcade bare when yous import a product, then the value in the Trunk (HTML) cavalcade is entered into the Clarification field on the product's details page. Acquire more than about how overwriting existing products affects the data in this column.
Google Product Category	If you currently apply a Google product category, you can use information technology as your Shopify standardized production blazon. You tin can apply the standardized product type, the Google Product Category, or both. Provide the nigh specific category possible for each detail. The Google Production Category (GPC) (google_product_category) uses Google'due south product taxonomy. Y'all tin input the Google production category in either of the following ways: using the full taxonomy path, for instance `Apparel & Accessories > Clothing > Shirts & Tops` using the numerical ID, for case `212` Learn more about 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. However, Shopify's Google aqueduct doesn't utilize these metafields. You can ignore values in the columns that include Google Shopping in their names unless an app tells y'all to utilize them. Learn more almost how overwriting existing products affects the data in this column.
Variant Image	The URL for images of variants. If yous add an URL, then it must be a functioning image URL. Acquire more about how overwriting existing products affects the information in this column.
Variant Weight Unit	Valid values are `g`, `kg`, `lb`, and `oz`.
Variant Tax Code	Available to: Shopify Plus program The Avalara code to employ taxes to this product. This field merely applies when you lot import to or consign from a store that uses the Shopify Plus program's integration with Avalara AvaTax. When yous create a CSV file past exporting products from a store that uses Avalara, the Variant Tax Lawmaking column is filled. If yous import this CSV file into a store that doesn't accept Avalara set up, then your import fails. Learn more nearly how overwriting existing products affects the data in this cavalcade.
Cost per item	How much it costs you for the product or variant. Merely include the cost. Don't include whatsoever currency symbols. For case, `9.99`. Larn more than about how overwriting existing products affects the data in this column.
Status	Indicates whether a product is available to your customers. Valid values are: `active`: the product is active and ready to exist sold `draft`: the product is a draft and needs to be completed `archived`: the product is archived and no longer available to sell

Collection cavalcade 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 name Collection.

When yous consign a CSV file, the Collection column is not included.

Description of the Collection column in the product CSV import file.
Column	Description
Drove	Enter the name of the collection that you desire to add this product to. If it's an existing automated drove, then the product needs to meet the weather condition for the collection. If the drove doesn't already exist, then a manual collection is created. You tin add a production to only one collection. This value tin can be blank. Larn more about how overwriting existing products affects the information in this column.

Create your production CSV file

For each product, yous demand to decide if information technology'southward a simple product or one with variants.

Unproblematic product: A uncomplicated product doesn't include variants. If yous upload a production that doesn't have variants, so enter all the fields for the product in the first row along with the URL for the commencement image. In the following rows, only enter the handle and the URL for each additional image.
Product with variants: If yous upload a product that has variants, then enter all the fields for the product in the starting time row along with the URL for the first paradigm. In the post-obit rows, enter the handle. Then skip the Title, Body (HTML), Vendor, and Tags columns. Fill up out the balance of the variants' details and each image URL.

After y'all've added all your products and images, salvage your CSV file in UTF-8 format using LF-mode linefeeds. If yous're not familiar with encodings, and then see your spreadsheet or text editor program's documentation.

To view an example CSV file, download this sample product CSV file, and then open it in Google Sheets or another spreadsheet program.

Prepare your images

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

If the files are only on your calculator, and then to link to their URL, you must upload them to your Shopify shop or to another image hosting service.
If y'all're switching to Shopify from another platform, then yous can copy the current image URLs and utilise them in the CSV file.
If the product CSV file was produced by exporting your products from Shopify, then you don't need to exercise anything because your images are already on your website.

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

Adding multiple product images in a CSV file

Yous can add together more product images to your CSV file past uploading more images to your Shopify admin. If y'all're building your Shopify store with a CSV file, then the process is a little different. Review the post-obit considerations:

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

Add together multiple product images to your CSV file

Insert new rows. Yous must utilise only i row per image.
Copy and paste the handle.
Re-create and paste the image URLs.

Insert a new row

Open up your CSV file in your spreadsheet programme, 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 aforementioned number of rows as the number of additional images you add.
While those rows are highlighted, right-click anywhere in the highlighted area, and so select Insert X rows higher up.

Copy and Paste the Handle value

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

Copy and Paste the image URLs

On the Files page, upload your images to Shopify.
Click the Copy link icon for i image URL at a time.
In the CSV file in your spreadsheet awarding, scroll sideways to the final columns of the CSV file.
In the Image Src column, paste the image URL into each line.
Echo steps 2 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 almost Image alt text.
Save the CSV file and import it to Shopify.

hooverconesee1936.blogspot.com

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