Products Without Image_url Information Cant Be Uploaded

Using CSV files to import and export products

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

Yous utilise a CSV (comma-separated values) file to import products into your Shopify store, and to export products from your store. Past using a CSV file, yous can import or export a big number of products and their details at one time. This can be helpful if you desire to exchange production data between Shopify and some other system.

Learn how to open up and edit a CSV file.

Download a sample CSV file

Yous can download and view a sample product CSV file to apply 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 you lot use the sample file to create your ain import file, and so make sure that you lot remove all the example products.
The sample file includes the Variant Inventory Qty column, which is only used for stores that have a unmarried location. If yous use multiple locations and you want to import or export inventory quantities, so use the inventory CSV file.

Considerations for the production CSV file

Before you use a production CSV file, review the post-obit 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 as specified in the product CSV description table.
Each column must be separated by a comma.

Required columns in the production CSV file

These columns must be nowadays under the post-obit atmospheric condition:

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

Data dependencies

Fifty-fifty though the Title and Handle columns are the simply 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 yous update a column that is related to variants, such as Variant SKU or Variant Grams , then the information in those columns depends on the data almost the corresponding variants. In this example, yous must likewise include the Option1 Proper noun and Option1 Value columns.

Before yous remove or exclude columns from your CSV file, verify whether the data in whatever other columns depends on the data in the columns that y'all desire to remove or exclude. If your data depends on a column that is missing, then you receive an error when you try to import your product CSV file.

Shopify Markets CSV columns

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

For example, if yous create a market for each individual continent, and one of your marketplace names is South America then cavalcade heading Price / International becomes Price / South America, and column heading Compare at toll / 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 Championship column, some other columns must take a value. When a cavalcade requires a value, merely is bare, so a default value is created automatically in the following cases:

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

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

Columns in the production 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 column is blank
Handle	This value is created based on the value in the Championship column. For example, if the value in the Title column is `Blackness Sun Glasses`, then the value in this cavalcade is `blackness-sun-glasses`.
Vendor	The name of the store as you entered it when you created your Shopify account. For example, `John's Wearing apparel` or `johns-apparel`. This is the same store name that you lot use when you log in to Shopify.
Published	`TRUE`, which means that this product will be published and available in the online store sales aqueduct.
Option1	`Title`
Option1 Value	`Default Title`
Variant Inventory Quantity	`0`
Variant Inventory Policy	`deny` When the value is `deny`, it indicates that the product can't exist purchased later on its inventory level reaches zip.
Variant Fulfillment Service	`manual`
Variant Price	`0.0`
Variant Requires Shipping	`TRUE` When the value is `TRUE`, it indicates that the product is a concrete product.
Variant Taxable	`Truthful`
Variant Grams	`0.0`
Variant Weight Unit	`kg`
Price / International	If y'all sell internationally, then this is the toll of the production or variant. Only include the price. Don't include any currency symbols. For example, `nine.99`. This cavalcade heading proper noun varies depending on the Shopify Markets that y'all have set up on your store. The default marketplace is `International`. If you change the default market or add any new markets, then your column headers appear with those market names. Refer to the considerations section for more information. Acquire more than well-nigh how overwriting existing products affects the data in this column.
Compare At Price / International	If you sell internationally, then this is the "Compare at Price" of the product or variant. Only include the price. Don't include any currency symbols. For instance, `ix.99`. This cavalcade heading name varies depending on the Shopify Markets that you have gear up on your store. The default market is `International`. If y'all modify the default market or add any new markets, then your column headers appear with those market names. Refer to the considerations department for more data. Acquire more near how overwriting existing products affects the information in this column.
Condition	`active`

For more information nearly these and other columns, refer to the production CSV description table.

Overwriting product details using an import CSV file

When you import a CSV file, you tin can select the option Overwrite any electric 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 listing, the values in CSV file overwrite the values in the matching columns in the existing product list. If the overwrite selection isn't selected, then 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 production list is overwritten equally bare.

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

For example, if the Variant Prototype column is included in the existing product listing, only that cavalcade is not included in the import CSV file, and then the value in the product listing remains the same.

Clarification 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 production CSV files.

Description of the columns in the production CSV file.
Column	Description
Handle	Handles are unique names for each product. They can incorporate messages, dashes, and numbers, but no spaces, accents, or other characters, including periods. Handles are used in the URL for each production. 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, y'all must add multiple lines with the same handle.
Title	The title of your product. For example, `Women's Snowboard`.
Body (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 product. For example, `John'south Apparel`. Values must be at to the lowest degree two characters long. Learn more about how overwriting existing products affects the information in this column.
Standardized production blazon	A label that describes the type of product. This label must be taken from the predefined standardized listing 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 case `Home & Garden > Linens & Bedding > Bedding > Bed Sheets` using the numerical ID, for case `371` Acquire more than about adding a standardized product blazon Learn more about how overwriting existing products affects the data in this column.
Custom product type	A custom label that describes the category of a production. This label doesn't need to conform to whatever predefined format. Learn more about adding a custom product blazon Learn more almost how overwriting existing products affects the data in this cavalcade.
Tags	A comma-separated listing of tags used to tag the production. About spreadsheet applications automatically add quotes around the tags for you lot. If y'all utilise a plainly text editor, then you demand to manually add the quotes. For example, `"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 `Truthful` if the product is published on your online store, or `FALSE` if the product is non available on your online store.
Option1 Proper noun	If a product has an pick, and then enter its proper name. For instance, `Color`. If a product has only one selection, and then this value should exist `Championship`.
Option1 Value	Caution: Changing information in this column deletes existing variant IDs values, and creates new variant IDs. Any modify to variant ID values tin can break third-party dependencies on variant IDs. If a product has an option, and then enter its value. For example, `Blackness`. If a product has but ane option, so this value should be `Default Title`.
Option2 Name	If a product has a second pick, then enter its proper name. For example, `Size`. Larn more than virtually how overwriting existing products affects the information in this column.
Option2 Value	Caution: Changing data in this cavalcade deletes existing variant IDs values, and creates new variant IDs. Any change to variant ID values tin can interruption third-party dependencies on variant IDs. If a product has a second selection, then enter its value. For example, `Big`. Learn more about how overwriting existing products affects the data in this column.
Option3 Name	If a production has a third option, then enter its name. Larn more than near how overwriting existing products affects the data in this column.
Option3 Value	Circumspection: Changing data in this cavalcade deletes existing variant IDs values, and creates new variant IDs. Any alter to variant ID values can pause third-political party dependencies on variant IDs. If a product has a third option, and 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 can't exist left blank if you're using a custom fulfillment service . Acquire more nigh how overwriting existing products affects the information in this column.
Variant Grams	The weight of the product or variant in grams. Don't specify a unit of measurement or utilize decimals. For example, for a weight of 5.125 kg, enter `5125`. Shopify ever imports and exports the weight in grams, even if yous specify a different unit. You must employ authentic weights if you intend to offering carrier-calculated shipping or use a third-political party fulfillment service.
Variant Inventory Tracker	Include your inventory tracking for this variant or production. Valid values include `shopify`, `shipwire`, `amazon_marketplace_web`, or bare if inventory isn't tracked. If the existing inventory tracking options are removed, so inventory is no longer tracked. Acquire more near how overwriting existing products affects the information in this column.
Variant Inventory Qty	The number of items you have in stock of this product or variant. This cavalcade is only used for Shopify stores that have a single location. Note: This column is only available for shop that take merely 1 location. If your store manages inventory at multiple locations, so this column isn't included. If you want to import or consign inventory quantities, then use the inventory CSV file. Learn more than about how overwriting existing products affects the data in this column.
Variant Inventory Policy	How to handle orders when the inventory level for this production or variant has reached goose egg. Variants with a `deny` inventory policy tin't exist purchased later on their inventory level reaches zero. Variants with a `continue` inventory policy can be purchased subsequently their inventory level reaches zero, 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, and so you can add together the name of the service in this column. For the custom name, use only lowercase letters. Spaces aren't allowed and y'all must supervene upon them with a dash (-). Periods and other special characters are removed. For example, if "Joan's Fulfillment" is your fulfillment service'due south name, enter `joans-fulfillment` in the CSV file. Y'all 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. Just include the cost and don't include whatsoever currency symbols. For case, `nine.99`.
Variant Compare at Price	The "Compare at Price" of the product or variant. Just include the toll and don't include whatever currency symbols. For instance, `nine.99`. Learn more nigh how overwriting existing products affects the data in this column.
Variant Requires Shipping	The pick to require shipping. Valid values are `True` or `Imitation`.
Variant Taxable	Apply taxes to this variant. Valid values are `Truthful` or `FALSE`.
Variant Barcode	The barcode, ISBN, or UPC of the product. Learn more than about how overwriting existing products affects the data in this cavalcade.
Image Src	Enter the URL for the product paradigm. Shopify downloads the images during the import and re-uploads them into your shop. These images aren't variant-specific. The variant image column is where yous specify variant images. You lot can't change the image file name subsequently that epitome has been uploaded to your shop. Don't upload images that have `_thumb`, `_small`, or `_medium` suffixes in their names. Learn more than nigh how overwriting existing products affects the data in this cavalcade.
Image Position	Enter the number that represents the order in which you want the image to appear on the product'south folio. The images appears in order from smallest to largest starting from an image position value of `1`. For case, if you lot desire the image to announced first for that product, then enter `one`. Learn more than about how overwriting existing products affects the information in this cavalcade.
Image Alt Text	Alt (alternate) text describes an prototype and is an important part of a product clarification. If an image can't load for whatsoever reason, and then alt text is shown instead. It's also used by assistive engineering to depict an image to a client who's visually dumb. Including alt text volition heave 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 information in this column.
Souvenir Card	Indicates whether the product is a gift card. Valid values are `TRUE` or `FALSE`. The addition of this column besides allows y'all to edit other gift bill of fare details, such as the Torso or Tags columns, and and so import these changes. A souvenir card can just be created and activated in the Shopify admin. You can't create a gift card through a product CSV file import. Larn more well-nigh how overwriting existing products affects the data in this cavalcade.
SEO Title	The SEO Title is found on a production's details folio under the Search engine list preview header in the Page title field. The SEO Title is alphanumeric and tin include up to 70 characters. If you leave this column blank when you import a production, then the value in the Title column is entered into the Page title field on the product's details page. Acquire more than almost how overwriting existing products affects the data in this cavalcade.
SEO Description	The SEO description is likewise found on a product's details page under the Search engine list preview header in the Description. The SEO description is alphanumeric and tin can include upwardly to 320 characters. If you lot get out this cavalcade blank when you lot import a product, then the value in the Body (HTML) column is entered into the Description field on the product'south details page. Learn more than about how overwriting existing products affects the data in this column.
Google Product Category	If you currently use a Google product category, you lot can use it as your Shopify standardized product type. You can utilize the standardized production type, the Google Product Category, or both. Provide the well-nigh specific category possible for each item. The Google Product Category (GPC) (google_product_category) uses Google's product taxonomy. You lot can input the Google product category in either of the post-obit ways: using the full taxonomy path, for example `Apparel & Accessories > Clothing > Shirts & Tops` using the numerical ID, for case `212` Learn more than nearly 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 channel doesn't use these metafields. You can ignore values in the columns that include Google Shopping in their names unless an app tells yous to use them. Learn more well-nigh how overwriting existing products affects the information in this cavalcade.
Variant Prototype	The URL for images of variants. If you add an URL, then it must be a functioning image URL. Learn more than nigh how overwriting existing products affects the information in this column.
Variant Weight Unit	Valid values are `yard`, `kg`, `lb`, and `oz`.
Variant Tax Code	Available to: Shopify Plus programme The Avalara code to use taxes to this product. This field only applies when you lot import to or export from a store that uses the Shopify Plus plan'due south integration with Avalara AvaTax. When yous 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 store that doesn't take Avalara gear up, then your import fails. Learn more most how overwriting existing products affects the data in this cavalcade.
Price per particular	How much it costs yous for the product or variant. Only include the cost. Don't include any currency symbols. For case, `9.99`. Larn more than about how overwriting existing products affects the data in this column.
Condition	Indicates whether a product is bachelor to your customers. Valid values are: `agile`: the production 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

Drove column exception

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

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

Description of the Collection cavalcade in the production CSV import file.
Column	Description
Collection	Enter the proper name of the collection that you want to add this product to. If it'south an existing automatic collection, then the product needs to meet the weather for the collection. If the collection doesn't already be, and then a manual collection is created. Yous can add together a product to but i collection. This value can exist blank. Learn more near how overwriting existing products affects the data in this column.

Create your product CSV file

For each production, you lot need to decide if it'due south a unproblematic product or i with variants.

Simple product: A unproblematic product doesn't include variants. If you upload a product that doesn't accept variants, and so enter all the fields for the product in the get-go row along with the URL for the showtime image. In the following rows, just enter the handle and the URL for each additional image.
Product with variants: If you upload a product that has variants, then enter all the fields for the product in the first row along with the URL for the showtime 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 image URL.

Later on y'all've added all your products and images, save your CSV file in UTF-8 format using LF-style linefeeds. If you're not familiar with encodings, then meet 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.

Gear up your images

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

If the files are just on your computer, then to link to their URL, you lot must upload them to your Shopify shop or to some other image hosting service.
If you're switching to Shopify from some other platform, then yous tin copy the electric current image URLs and use them in the CSV file.
If the product CSV file was produced by exporting your products from Shopify, so you don't demand to do anything because your images are already on your website.

When you have URLs for each product image, yous tin start building your CSV file.

Adding multiple production images in a CSV file

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

You 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 up to 250 images to a product.
Your product images must be uploaded to a publicly accessible URL. That is, they should be behind an https:// protocol with no password protection. To exercise this, you can upload images to the Files page of the Shopify admin. The URLs generate automatically. After y'all click Upload files, you lot tin select upwards to a couple hundred images to upload in bulk.

Add multiple production images to your CSV file

Insert new rows. You must use but 1 row per image.
Copy and paste the handle.
Re-create and paste the image URLs.

Insert a new row

Open your CSV file in your spreadsheet program, such as Google Sheets.
Locate the products that you desire to add together images to.
In the side by side row, click and drag the row numbers to select multiple rows. Select the same number of rows as the number of additional images you add.
While those rows are highlighted, right-click anywhere in the highlighted area, and then select Insert X rows to a higher place.

Re-create and Paste the Handle value

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

Copy and Paste the paradigm URLs

On the Files page, upload your images to Shopify.
Click the Copy link icon for one epitome URL at a time.
In the CSV file in your spreadsheet application, gyre sideways to the last columns of the CSV file.
In the Epitome Src column, paste the prototype URL into each line.
Repeat steps 2 to four for all the images for this product
Optional: To amend your SEO, enter values into all the Image Alt Text fields. Learn more than about Paradigm alt text.
Save the CSV file and import it to Shopify.

tatumdoorcall.blogspot.com

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