What a Shopify overwrite import changes in your existing products

Signs an overwrite import changed too much

• Descriptions, compare-at prices or metafields are empty.
• The vendor now shows your store name.
• Tags you added before are gone.
• A product is no longer in a collection it used to be in.
• Some variants show 0 in stock, or apps can't find them anymore.
• Shopify still said the import was successful.

How an overwrite import works

• An overwrite import is a product CSV import with “Overwrite products with matching handles” selected. It updates products that are already in your store.
• The URL handle is the product's unique name in its web address, such as linen-shirt. Shopify uses it to find the matching product.
• A variant is one version of a product, such as size M. Each variant has its own row in the CSV.
• For every matching product, each column in your file replaces the store's value. Shopify's documentation says a blank cell in a non-required column is written as blank.
• A column that isn't in your file at all leaves the store's value as it is.
• If you don't select overwrite, Shopify ignores products whose handle already exists and changes nothing.

Ce qui change, cas par cas

1. Columns you leave out stay the same

   Inchangé

   URL handle,Title,Description,Vendor
   linen-shirt,Linen shirt,Soft linen,Acme

   URL handle,Title,Vendor
   linen-shirt,Linen shirt,Acme Linen

   Après l’import : Only the vendor changes. The description stays, because the Description column isn't in the file. This is how Shopify's documentation describes it.

2. Blank cells clear the field

   Modifié

   URL handle,Title,Description
   linen-shirt,Linen shirt,Soft linen

   URL handle,Title,Description
   linen-shirt,Linen shirt,

   Après l’import : The description is cleared. In our tests on a Shopify development store in November 2026, blank Compare-at price and metafield cells were cleared too.

   Pour l’éviter : Fill the cell with the current value from your export, or remove the column.

   En savoir plus : Shopify overwrite import cleared product descriptions, compare-at prices or metafields

3. A blank vendor becomes your store name

   Modifié

   URL handle,Title,Vendor
   linen-shirt,Linen shirt,Acme

   URL handle,Title,Vendor
   linen-shirt,Linen shirt,

   Après l’import : In our tests, the vendor became the store name. Shopify's documentation says it's overwritten as blank. Either way, the old vendor is lost.

   Pour l’éviter : Copy the vendor from your export, or remove the Vendor column.

   En savoir plus : Shopify overwrite import cleared product descriptions, compare-at prices or metafields

4. Tags are replaced, not added

   Modifié

   URL handle,Title,Tags
   linen-shirt,Linen shirt,"summer, new"

   URL handle,Title,Tags
   linen-shirt,Linen shirt,sale

   Après l’import : The product's only tag is now “sale”. In our tests, Shopify replaced the whole list and didn't keep the old tags.

   Pour l’éviter : Put every tag you want in the cell, for example “summer, new, sale”.

5. Changing an option value recreates the variant

   Modifié

   URL handle,Title,Option1 name,Option1 value,SKU
   cotton-tee,Cotton tee,Size,M,TEE-M

   URL handle,Title,Option1 name,Option1 value,SKU
   cotton-tee,Cotton tee,Size,Medium,TEE-M

   Après l’import : Shopify deletes the M variant and creates a new one with a new ID, as its documentation warns. In our tests, the new variant had 0 in stock, even with the same SKU. Changing only capital letters, like m to M, did the same. A variant row missing from the file was deleted.

   Pour l’éviter : Copy option values exactly from your export, and keep every variant row. If you keep variant columns such as SKU or Price, keep Option1 name and Option1 value too.

   En savoir plus : Shopify variant IDs changed and inventory reset to 0 after a CSV import

6. A Collection column moves the product

   Modifié

   URL handle,Title,Collection
   linen-shirt,Linen shirt,Summer

   URL handle,Title,Collection
   linen-shirt,Linen shirt,Sale

   Après l’import : In our tests, the product was added to Sale and removed from the manual collection it was in before. Shopify's documentation says a CSV can add a product to only one collection. Product exports don't include this column, so the export can't show the old collection.

   Pour l’éviter : Leave the Collection column out unless you want to move products. Add products to collections in the admin instead.

7. Blank SEO title and image cells keep their values

   Inchangé

   URL handle,Title,SEO title,Product image URL
   linen-shirt,Linen shirt,Linen shirt for summer,https://cdn.shopify.com/s/files/linen.jpg

   URL handle,Title,SEO title,Product image URL
   linen-shirt,Linen shirt,,

   Après l’import : In our tests, the custom SEO title stayed and the product kept its images. A file without image columns also kept them. But removing one image row, while the product's other image rows were still in the file, deleted that image.

   Pour l’éviter : Keep every image row you want to keep.

   En savoir plus : Shopify overwrite import cleared product descriptions, compare-at prices or metafields

8. A blank inventory quantity: not confirmed

   Pas encore confirmé

   URL handle,Title,Option1 name,Option1 value,Inventory quantity
   cotton-tee,Cotton tee,Size,M,5

   URL handle,Title,Option1 name,Option1 value,Inventory quantity
   cotton-tee,Cotton tee,Size,M,

   Après l’import : We don't know yet. Shopify's column reference says a blank Inventory quantity defaults to 0. In our test store, the product CSV didn't change stock at all, so we couldn't confirm it. The column only applies to stores with one location.

   Pour l’éviter : Don't rely on the product CSV for stock. Check stock after importing, or use Shopify's inventory CSV.

How to import safely, step by step

1. In your Shopify admin, export all products and keep the file. This is your backup.
2. Make a copy of the export. Edit the copy, never the backup.
3. Delete the columns you don't want to change. Keep URL handle and Title, which Shopify needs to update products.
4. If you keep any variant column, such as SKU or Price, also keep Option1 name and Option1 value as exported.
5. Open Skuvera's catalog diff and add the export and your edited file. Both stay in your browser.
6. Read the list of changes, and fix anything you didn't mean to change.
7. Import the file in Shopify with “Overwrite products with matching handles” selected.
8. Open a few products in the admin and check their details, stock and collections.

If it already happened

• Shopify can't undo an import and keeps no import history. Your store's activity log shows recent changes made by an import.
• Put lost values back by importing them again from an export taken before the import.
• Re-enter stock for recreated variants, and re-sync apps that use variant IDs.
• Add products back to their collections in the admin.

Foire aux questions

What happens if I don't select overwrite?

Shopify ignores products whose handle already exists and doesn't change them. In our tests, the import still said it was successful and listed those rows as ignored.

Can an overwrite import delete products?

Shopify's documentation says CSV files can't be used to delete products in bulk. In our tests, products that weren't in the file stayed as they were. Variants missing from a product's rows were deleted, though.

Can a blank cell stop the import?

Yes. In our tests, a blank price on an existing product made Shopify reject that product. A Status column that was present but blank made Shopify reject the whole file.

Does the safe import file make an overwrite import fully safe?

No. It fills back cells that would be cleared, vendors that would become your store name and blank prices, and can merge tags. It can't protect variants that would be recreated or deleted, or products a Collection column would move; those are listed for you to check by hand. Blank inventory cells aren't filled back, because Shopify's behavior there isn't confirmed.

Sources

• Using CSV files to import and export productsCentre d'aide Shopify · Vérifié le 6 novembre 2026
• Importing products with a CSV fileCentre d'aide Shopify · Vérifié le 6 novembre 2026
• Exporting productsCentre d'aide Shopify · Vérifié le 6 novembre 2026

Autres problèmes de données

• How to compare your Shopify CSV with your store before you import
• How to back up Shopify products before a bulk update
• Shopify CSV barcodes turned into 4.00638E+12 after editing in Excel
• Shopify overwrite import cleared product descriptions, compare-at prices or metafields
• Shopify variant IDs changed and inventory reset to 0 after a CSV import
• Shopify says the CSV import was successful, but products didn't update
• Shopify product images missing or on the wrong product after sorting the CSV in Excel
• Problèmes de données CSV Shopify
• Erreurs d'import CSV Shopify