Shopify Upload Does Option Name and Value Have to Be Popoluated?

abril 11, 2022 Enviar um comentário

Using CSV files to import and export products

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

Yous apply a CSV (comma-separated values) file to import products into your Shopify store, and to export products from your shop. Past using a CSV file, yous can import or export a large number of products and their details at one time. This tin exist helpful if you want to substitution production information betwixt Shopify and some other system.

Learn how to open up and edit a CSV file.

Download a sample CSV file

You can download and view a sample production 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 products and variants. If you utilize the sample file to create your own import file, then make sure that you remove all the case products.
The sample file includes the Variant Inventory Qty cavalcade, which is merely used for stores that have a unmarried location. If yous use multiple locations and you want to import or export inventory quantities, and so employ the inventory CSV file.

Considerations for the product CSV file

Earlier you lot use 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 offset line of your production CSV file must be the column headers as specified in the production CSV clarification tabular array.
Each column must exist separated by a comma.

Required columns in the product CSV file

These columns must exist nowadays under the following weather:

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

Data dependencies

Fifty-fifty though the Title and Handle columns are the only required columns when you 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 , then the data in those columns depends on the data about the corresponding variants. In this case, yous must likewise include the Option1 Name and Option1 Value columns.

Earlier you 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 data depends on a cavalcade that is missing, and so you receive an fault when you try to import your product CSV file.

Shopify Markets CSV columns

If y'all have Shopify Markets ready on your store, then your CSV export reflects the unique markets that y'all created. Past default your CSV has the Toll / International and Compare At Price / International columns. Only if you replace your international market with your own marketplace, then in the header name, International changes to the name of the market.

For case, if y'all create a market for each individual continent, and 1 of your marketplace names is South America then column heading Price / International becomes Cost / Southward America, and column heading Compare at price / International becomes Compare at cost / South America in the CSV export file.

Columns in the production CSV file that must contain values

In add-on to the Title column, some other columns must have a value. When a column requires a value, but is bare, so a default value is created automatically in the post-obit cases:

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

The post-obit 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 product CSV file that must have a value and the default values that are created automatically if no value is present.
Column	Default value created when the cavalcade is blank
Handle	This value is created based on the value in the Title cavalcade. For instance, if the value in the Title cavalcade is `Black Sun Glasses`, then the value in this column is `black-sun-spectacles`.
Vendor	The name of the store as you entered it when you lot created your Shopify business relationship. For example, `John's Wearing apparel` or `johns-dress`. This is the aforementioned store name that you use when you lot log in to Shopify.
Published	`TRUE`, which means that this product will exist published and available in the online shop 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 exist purchased subsequently its inventory level reaches zero.
Variant Fulfillment Service	`transmission`
Variant Price	`0.0`
Variant Requires Shipping	`TRUE` When the value is `Truthful`, it indicates that the product is a physical product.
Variant Taxable	`TRUE`
Variant Grams	`0.0`
Variant Weight Unit	`kg`
Toll / International	If you sell internationally, then this is the price of the production 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 you have set up on your store. The default marketplace is `International`. If y'all change the default market or add together any new markets, and then your column headers appear with those market names. Refer to the considerations section for more than information. Learn more well-nigh how overwriting existing products affects the data in this column.
Compare At Cost / International	If you lot sell internationally, so this is the "Compare at Price" of the product or variant. Merely 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 prepare up on your store. The default market is `International`. If you change the default marketplace or add together any new markets, so your column headers appear with those market names. Refer to the considerations section for more than information. Learn more about how overwriting existing products affects the data in this column.
Status	`agile`

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

Overwriting product details using an import CSV file

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

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

For example, the Standardized Production Type value in your existing product list is John's Apparel, but the Standardized Production Type column is blank in the CSV file that y'all import, then the John's Apparel is overwritten as bare.
If a non-required column is not included in the import CSV file, only is included in the existing product list, then the value in the production list remains the same.

For case, if the Variant Image column is included in the existing production list, but that column is not included in the import CSV file, then the value in the production list remains the aforementioned.

Description of the production CSV file

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

Clarification 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, 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 product'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 production. 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'due south Snowboard`.
Body (HTML)	The description of the product in HTML format. Acquire more virtually how overwriting existing products affects the data in this column.
Vendor	The name of the vendor for your product. For example, `John's Apparel`. Values must be at least 2 characters long. Acquire more about how overwriting existing products affects the information in this column.
Standardized product type	A characterization that describes the type of production. This characterization must exist taken from the predefined standardized list of product types. You can input the standardized product type in either of the following ways: using the full path from the Shopify Product Taxonomy, for example `Home & Garden > Linens & Bedding > Bedding > Bed Sheets` using the numerical ID, for example `371` Acquire more about adding a standardized product type Learn more most how overwriting existing products affects the data in this cavalcade.
Custom product type	A custom label that describes the category of a product. This characterization doesn't need to conform to any predefined format. Larn more about adding a custom product blazon Acquire more than about how overwriting existing products affects the data in this column.
Tags	A comma-separated list of tags used to tag the production. Almost spreadsheet applications automatically add quotes around the tags for you. If you utilize a manifestly text editor, so you demand to manually add the quotes. For case, `"tag1, tag2, tag3"`. Learn more about how overwriting existing products affects the data in this cavalcade.
Published	Indicates whether a product is published on your online shop. Valid values are `TRUE` if the product is published on your online store, or `FALSE` if the product is not bachelor on your online store.
Option1 Name	If a product has an option, then enter its name. For example, `Color`. If a production has only one option, then this value should be `Title`.
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 production has an choice, and then enter its value. For example, `Black`. If a product has just one option, and then this value should be `Default Title`.
Option2 Name	If a product has a 2nd option, then enter its name. For case, `Size`. Learn more about how overwriting existing products affects the data in this column.
Option2 Value	Caution: Irresolute data in this cavalcade 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 production has a second pick, then enter its value. For example, `Big`. Larn more most how overwriting existing products affects the information in this cavalcade.
Option3 Proper noun	If a product has a third option, so enter its name. Learn more than most 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. Whatever change to variant ID values can suspension third-political party dependencies on variant IDs. If a product has a tertiary selection, and so enter its value. Learn more than nearly how overwriting existing products affects the data in this column.
Variant SKU	The SKU of the product or variant. This is used to rail inventory with inventory tracking services. This field can't exist left bare if you're using a custom fulfillment service . Learn more nearly how overwriting existing products affects the information in this cavalcade.
Variant Grams	The weight of the product or variant in grams. Don't 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 unlike unit. You must utilise accurate weights if yous intend to offer carrier-calculated shipping or use a tertiary-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, then inventory is no longer tracked. Learn more than near how overwriting existing products affects the data in this cavalcade.
Variant Inventory Qty	The number of items yous have in stock of this product or variant. This cavalcade is merely used for Shopify stores that have a unmarried location. Note: This cavalcade is only available for shop that take just one 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, and so use the inventory CSV file. Larn more than near how overwriting existing products affects the information in this cavalcade.
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 can't exist purchased after their inventory level reaches nix. Variants with a `continue` inventory policy can be purchased subsequently their inventory level reaches goose egg, allowing for negative inventory levels.
Variant Fulfillment Service	The production or variant fulfillment service used. The following are the valid values for this column: `manual` `shipwire` `webgistix` `amazon_marketplace_web` If you use a custom fulfillment service, then you can add together the name of the service in this cavalcade. For the custom name, use just lowercase letters. Spaces aren't immune and yous must supercede them with a dash (-). Periods and other special characters are removed. For example, if "Joan'due south Fulfillment" is your fulfillment service'south proper noun, enter `joans-fulfillment` in the CSV file. You must have a custom fulfillment service fix in your Shopify admin before you can add the name of the service in this column.
Variant Price	The cost of the product or variant. Simply include the cost and don't include whatever currency symbols. For case, `9.99`.
Variant Compare at Price	The "Compare at Price" of the product or variant. Simply include the price and don't include any currency symbols. For example, `nine.99`. Learn more nearly how overwriting existing products affects the data in this cavalcade.
Variant Requires Shipping	The option to require shipping. Valid values are `TRUE` or `FALSE`.
Variant Taxable	Apply taxes to this variant. Valid values are `Truthful` or `False`.
Variant Barcode	The barcode, ISBN, or UPC of the product. Larn more nearly how overwriting existing products affects the information in this column.
Image Src	Enter the URL for the production paradigm. Shopify downloads the images during the import and re-uploads them into your store. These images aren't variant-specific. The variant epitome column is where y'all specify variant images. You lot tin't change the paradigm file name later on that image has been uploaded to your store. Don't upload images that have `_thumb`, `_small`, or `_medium` suffixes in their names. Learn more nearly how overwriting existing products affects the information in this column.
Image Position	Enter the number that represents the order in which you desire the epitome to appear on the product's page. The images appears in guild from smallest to largest starting from an epitome position value of `1`. For example, if you want the paradigm to appear start for that product, and then enter `1`. Learn more nigh how overwriting existing products affects the data in this column.
Image Alt Text	Alt (alternating) text describes an epitome and is an important part of a product description. If an image tin't load for any reason, then alt text is shown instead. Information technology's as well used by assistive technology to describe an image to a customer who's visually impaired. Including alt text will heave your website'south SEO. Keep your alt text brief and descriptive. The maximum length is 512 characters, only the optimal length is 125 characters or fewer. Larn more than about how overwriting existing products affects the data in this column.
Souvenir Menu	Indicates whether the production is a gift card. Valid values are `TRUE` or `Faux`. The addition of this column also allows you to edit other souvenir card details, such as the Body or Tags columns, and and so import these changes. A souvenir card can only exist created and activated in the Shopify admin. You tin't create a gift menu through a production CSV file import. Learn more most how overwriting existing products affects the data in this column.
SEO Championship	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 is alphanumeric and tin can include upwardly to 70 characters. If you leave this column blank when you import a product, then the value in the Title cavalcade is entered into the Page title field on the product's details folio. Learn more well-nigh how overwriting existing products affects the data in this column.
SEO Description	The SEO description is also found on a production'due south details page under the Search engine listing preview header in the Description. The SEO description is alphanumeric and can include upwards to 320 characters. If yous leave this column blank when you import a product, and so the value in the Body (HTML) column is entered into the Description field on the product's details page. Larn more than about how overwriting existing products affects the data in this column.
Google Product Category	If yous currently apply a Google product category, you can use it every bit your Shopify standardized product type. You can apply the standardized product type, the Google Product Category, or both. Provide the nigh specific category possible for each item. The Google Production Category (GPC) (google_product_category) uses Google'southward product taxonomy. You tin can input the Google product category in either of the following ways: using the full taxonomy path, for example `Wearing apparel & Accessories > Wearable > Shirts & Tops` using the numerical ID, for example `212` Larn more about how overwriting existing products affects the information in this column.
Google Shopping metafields	The Google Shopping columns might exist used past an app to synchronize products to the Google Merchant Center. However, 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 y'all to utilize them. Larn more than almost how overwriting existing products affects the data in this column.
Variant Image	The URL for images of variants. If you add an URL, then it must be a functioning paradigm URL. Learn more most how overwriting existing products affects the data in this column.
Variant Weight Unit	Valid values are `chiliad`, `kg`, `lb`, and `oz`.
Variant Tax Lawmaking	Available to: Shopify Plus program The Avalara lawmaking to apply taxes to this product. This field only applies when you import to or consign from a store that uses the Shopify Plus plan's integration with Avalara AvaTax. When you create a CSV file by exporting products from a store that uses Avalara, the Variant Tax Code column is filled. If you import this CSV file into a shop that doesn't take Avalara ready up, then your import fails. Larn more about how overwriting existing products affects the data in this column.
Price per item	How much it costs you for the product or variant. Only include the toll. Don't include any currency symbols. For case, `9.99`. Learn more about how overwriting existing products affects the data in this column.
Status	Indicates whether a production 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

Collection column exception

To organize your products into collections during the CSV file upload, you lot tin add a new cavalcade anywhere in your CSV file with the header proper noun Collection.

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

Description of the Drove column in the product CSV import file.
Column	Description
Collection	Enter the name of the collection that you want to add this product to. If it's an existing automatic drove, and then the product needs to meet the weather for the collection. If the collection doesn't already exist, then a manual collection is created. You can add together a product to only one collection. This value can be blank. Acquire more nigh how overwriting existing products affects the data in this column.

Create your product CSV file

For each production, yous demand to decide if it's a simple product or one with variants.

Simple product: A unproblematic product doesn't include variants. If you upload a product that doesn't have variants, and then enter all the fields for the product in the first row along with the URL for the commencement prototype. In the following rows, only enter the handle and the URL for each additional paradigm.
Product with variants: If you upload a product that has variants, then enter all the fields for the product in the kickoff row along with the URL for the first image. In the following rows, enter the handle. Then skip the Title, Body (HTML), Vendor, and Tags columns. Fill out the residual of the variants' details and each paradigm URL.

After you've added all your products and images, salve your CSV file in UTF-viii format using LF-style linefeeds. If you're non familiar with encodings, then encounter your spreadsheet or text editor program'southward documentation.

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

Set up your images

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

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

When you lot have URLs for each production paradigm, you tin can get-go building your CSV file.

Calculation multiple product images in a CSV file

You can add more product images to your CSV file by uploading more images to your Shopify admin. If you're building your Shopify shop with a CSV file, then the process is a lilliputian dissimilar. Review the following considerations:

You demand to exist able to edit a CSV file. Shopify recommends using Google Sheets to view a formatted version of your CSV files.
You can 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, yous can upload images to the Files page of the Shopify admin. The URLs generate automatically. After you click Upload files, you tin select upwards to a couple hundred images to upload in bulk.

Add multiple product images to your CSV file

Insert new rows. You must employ only one row per prototype.
Copy and paste the handle.
Copy and paste the epitome URLs.

Insert a new row

Open your CSV file in your spreadsheet programme, such as Google Sheets.
Locate the products that y'all desire 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 together.
While those rows are highlighted, right-click anywhere in the highlighted 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 cavalcade 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 one paradigm URL at a time.
In the CSV file in your spreadsheet awarding, ringlet sideways to the last columns of the CSV file.
In the Image Src column, paste the image URL into each line.
Echo steps 2 to four for all the images for this production
Optional: To improve your SEO, enter values into all the Paradigm Alt Text fields. Learn more most Prototype alt text.
Save the CSV file and import it to Shopify.