进口ing products with a CSV file

进口ing products into your Shopify store using a comma-separated values (CSV) file is useful when you switch to Shopify from another platform or when you want to make many changes to your products or inventory.

When you import products, the data is converted from theCSV fileinto products and you can select whether you want to publish your new products to all sales channels or only to your online store.

Before you begin

Before you import products using a CSV file, make sure that you've read the following topics:

Testing imports using a development store

If you are a Shopify Partner and you are performing a large scale import for a merchant, then make sure that you test a small subset of changes first using adevelopment storebefore you perform the actual import job.

Considerations for overwriting your product details using an import CSV file

When you import a CSV file, you can select the optionOverwrite any current products that have the same handle. Existing values will be used for any 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 match an existing handle will be ignored during CSV import.

If a non-required column in the import CSV file is blank, then the matching value in the product list is overwritten as blank.
- For example, theVendorvalue in your existing product list isJohn's Apparel, but theVendorcolumn is blank in the CSV file that you import, then theJohn's Apparelis overwritten as blank.
If a non-required column is not included in the import CSV file, but is included in the existing product list, then the value in the product list remains the same.
- For example, if theVariant Imagecolumn is included in the existing product list, but that column is not included in the import CSV file, then the value in the product list remains the same.
If a non-required column is included in the import CSV file that relies on other column data not included in the file, then existing data is deleted or removed.
- For example, if theVariant SKU列包含在导入CSV文件,but not theOption1 ValueandOption1 Namecolumns, then the product variant option is deleted.

进口products from another store

If you have a CSV file that was exported from another store or came from another source, then verify that it matches theCSV file format. If the format doesn't match, or if there are any missing headers, then the import fails.

Your product CSV can't exceed 15 MB. If you get an error when trying to upload a new CSV file, then verify that it doesn't exceed the size limit.

Steps:

From your Shopify admin, go toProducts.
Click进口.
ClickAdd file, and then select the CSV file that you want to import.
Optional: If you want to publish new products only to your online store instead of to all of your sales channels, then deselectPublish new products to all sales channels.
Optional: To change the URLs byoverwriting the values for the existing handles, selectOverwrite any current products that have the same handle. Existing values will be used for any missing columns.
ClickUpload and continue.
Review the details about the import, and then click进口products.

When your CSV file is uploaded, you receive a confirmation email from Shopify at the email account that you used to set up your Shopify store. Read somesolutions to common problems.

进口products using a CSV file

If you want to make changes to your products using a CSV file, then you need toexport your productsfirst. You canmake changes to your CSV filein a spreadsheet program likeGoogle Sheets, then import your updated CSV into the Shopify admin.

Steps

From your Shopify admin, go toProducts.
Click进口.
ClickAdd file, and then select the CSV file that you want to import.
Optional: If you want to publish new products only to your online store instead of to all of your sales channels, then deselectPublish new products to all sales channels.
Optional: To change the URLs byoverwriting the values for the existing handles, selectOverwrite any current products that have the same handle. Existing values will be used for any missing columns.
ClickUpload and continue.
Review the details about the import, and then click进口products.

你的CSV文件上传后,你收到欺诈firmation email from Shopify at the email account used to set up your Shopify store. Read somesolutions to common problems.