CatalogHop

WooCommerce import error: "A product with this ID already exists."

What it means: The ID column holds product IDs from the store the file was exported from. On a new-products import, WooCommerce skips a row whose ID it has already imported in the same file, which happens when the same ID appears on two rows (007 and 7 count as the same ID).

Find the rows in your file

WooCommerce product import

The product CSV you are about to import into WooCommerce (Products, Import), or the one that just failed.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the tool keeps working offline once the page has loaded.

Loading the converter...

How to fix it

  1. If the file came from another store, clear the ID column, or delete it, before importing. SKUs are a safer way to match products.
  2. If you are re-importing to change products, tick "Update existing products" instead.
  3. Make sure no ID appears on two rows.

Example

A file with this problem

ID,Type,SKU,Name,Published,Visibility in catalog,Tax status,In stock?,Stock,Regular price,Images,Parent,Attribute 1 name,Attribute 1 valu...
10,simple,MUG-1,Mug,1,visible,taxable,1,5,12.00,,,,,
10,simple,MUG-2,Large Mug,1,visible,taxable,1,5,15.00,,,,,

What the checker says about it

  • Line 3: ID 10 is also on line 2. On a new-products import only the first is imported and this row is skipped with "A product with this ID already exists."; with "Update existing products" ticked, this row overwrites the same product instead, or both are skipped with "No matching product exists to update." if the ID is not in your store.

Once the listed rows are fixed, check the file again; the checker also looks for the other problems in WooCommerce's import code, so you do not trade one error for the next.

Other WooCommerce import errors

Sources

Based on WooCommerce 11.2.2's import code and documentation. Not tested on a live store.