Merchlint
Available now
Next, in this order
  • FrançaisFR
  • ItalianoIT
  • PortuguêsPT
  • NederlandsNL
  • SvenskaSV
  • TürkçeTR

A language shows up here once its pages are actually written. Nothing on this site is machine-translated, except a few German and Spanish pages that no native speaker has reviewed yet.

Install free Install

Duplicate SKU and GTIN Finder for WooCommerce

A free WordPress plugin that finds products sharing an SKU, and products sharing or missing a GTIN. It reads your catalog and changes nothing in it.

Two products with the same SKU throw off stock levels, integrations and every export file your store produces. Two products with the same GTIN tell a shopping service they are the same item, so it may show only one of them. And Google can limit or disapprove a product whose GTIN is missing.

None of this breaks the store, which is why it goes unnoticed for years. Nothing in the WooCommerce admin points at any of it.

Video, 1:22 — Invalid or duplicated SKU in WooCommerce: find every duplicate

Three checks, and nothing else

CheckWhat counts as a findingHow it works, and how to do it by hand
Two products share the same SKUthe same code on two different productsduplicate SKU
Product with no GTIN, UPC, EAN or ISBNthe identifier field is emptyno GTIN
Two products share the same identifierthe same GTIN on two different productsduplicate GTIN

Three details decide whether a report like this is useful or just long:

  • Translations are not duplicates. A multilingual store gives every translation of a product the same SKU on purpose. The plugin reads the translation groups of Polylang and WPML and treats one group as one product, so a two-language store does not get a false alarm for every item.
  • A store without identifiers gets one sentence, not a list. If not one product has the GTIN field filled, the check stays quiet and says why. Handmade goods, services and your own production carry no manufacturer’s barcode and need none.
  • A check that could not run says so by name. The identifier field was added in WooCommerce 9.2. On anything older the report says the field does not exist, instead of calling every product faulty—or calling the catalog clean.

What the result looks like

The Duplicate SKU and GTIN Finder screen under Products: a summary with one tile per check, then three checks, each with the products it found, the value that was read and an Edit link

The plugin adds one screen under Products → Duplicate SKU and GTIN Finder; the Find duplicates link next to the plugin on the Plugins screen opens it too. Before version 0.1.4 the screen was under Tools, as in the video above; the old address still opens it. Each finding shows the field that was read and the value found — duplicated SKU: SB-60, not “problem detected”—with a link straight to the product in your admin. You can check every claim before acting on it.

Download CSV gives you the same list as a file, evidence and edit links included, so it can go to whoever maintains the catalog. Cells are protected against spreadsheet formula injection.

What it does not do

  • It never writes to your catalog. There is no “Fix it” button, and there will not be one—the reasoning is here. It stores the last result, so that reloading the page does not need another scan, and notes in your user profile, so that a notice you have dealt with does not come back. Uninstalling removes all of it.
  • It reads no order data. That keeps the scan cheap: on a test catalog of 10,000 products and variations it took about 2.5 seconds.
  • No paid version, no banners around your admin. After activation, one notice on the Plugins screen says where the plugin is; it goes away for good once you dismiss it or open the screen. On its own screen, below the results, the plugin asks once for a review and suggests Merchlint for the rest of the catalog. You can dismiss both.

Large catalogs

The screen runs the scan in a single request, and on a very large store that can hit your host’s time limit—on a 50,000-item test catalog the scan took 22 seconds. Above 5,000 products and variations the screen tells you so in advance. The WP-CLI command has no such limit:

wp merchlint-duplicate-sku-finder scan
wp merchlint-duplicate-sku-finder scan --format=csv

It prints how many findings each check produced and saves the result, so the full list with evidence is waiting on the screen afterwards.

Requirements

WordPress6.5 or newer
WooCommerce9.0 or newer; the two GTIN checks need 9.2, where the field was added
PHP7.4 or newer
MultilingualPolylang and WPML translation groups are recognized
LicenseGPL-2.0-or-later, free

Questions

How do I find duplicate SKUs in WooCommerce?

Install the plugin, open Products → Duplicate SKU and GTIN Finder and click Scan now. Every product that shares its SKU with another one is listed with the SKU that was read and an Edit link, and Download CSV gives you the same list as a file. The plugin compares published products and their variations; translations of one product are not counted as duplicates. A code that only variations share, of one product or of different products, is not on the list when no product carries that code itself.

WooCommerce itself refuses a repeated SKU when you save a product, but it has no screen that lists the pairs already in your catalog. Those got in another way—for example through a tool that writes to the database directly. How to look for them by hand: duplicate SKU.

What does “Invalid or duplicated SKU” mean?

WooCommerce shows this message when you save a product with an SKU that another product or variation already has. A draft or a private product holds its SKU too; only a product in the Trash does not. In the classic product editor your other changes are saved, and the SKU keeps its previous value.

The plugin adds one line under that message with the product that holds the code and an Edit link:

Saving a product with an SKU that is already taken: under the WooCommerce message "Invalid or duplicated SKU.", a line names the product that holds the code, here a draft, with an Edit link

For codes from elsewhere, for example the product import log, open Products → Duplicate SKU and GTIN Finder and paste them under Who has this code?. It also finds what the product search does not show: a variation whose product no longer exists, a placeholder left by an import that did not finish, and an out-of-date row in the WooCommerce product lookup table. The line does not appear in quick edit, where WooCommerce drops a taken SKU without any message, or in the block product editor.

Without the plugin, type the SKU into the search box under Products → All Products. That search covers drafts, private products and the SKUs of variations, and for a variation it shows the product the variation belongs to.

The identifier field has its own version of the message, “Invalid or duplicated GTIN, UPC, EAN or ISBN.” (WooCommerce 9.2 and later), and it works the same way.

Since WooCommerce 11.2 the product CSV importer, with Update existing products checked, also finds products by their GTIN. A row whose GTIN two products share fails with this message, and neither product changes; the importer does not say which product holds the other copy. Who has this code? shows both.

How do I find WooCommerce products without a GTIN?

Since WooCommerce 9.2 every product has a field for a GTIN, UPC, EAN or ISBN. Since 10.4 the product list also has a column for it, hidden by default: switch it on in Screen Options and sort by it, and products with no number come first. Variations are not in that list, so a variable product whose variations have no number looks fine there. The plugin lists them all: each product with an Edit link, and a variable product once, with the number of its variations that have no code. Why an empty field costs you: no GTIN.

How do I check if a GTIN or EAN is valid?

The plugin does not check the number itself. It finds products with no GTIN and GTINs used by more than one product. To check the check digit, the length and the format of a whole list of codes, use the free GTIN validator: paste a column of codes or pick a product export file (CSV, TXT or XLSX). It runs in your browser, and the file is not sent anywhere.

A well-formed number is not yet proof that it belongs to the product. Only the GS1 registry shows whether the manufacturer registered it.

Where to get it

The plugin is in the WordPress.org plugin directory as Merchlint – Duplicate SKU and GTIN Finder for WooCommerce and installs from Plugins → Add Plugin like any other. Questions and problems go to its support forum on WordPress.org, or to contact.

The name leads with our own, because the reviewers asked for a distinctive first term instead of a generic phrase—a fair request: “Duplicate SKU Finder” describes a category, not a product. The checks, the screen and the CSV file are the same ones this page describes.

Where the engine comes from

The scanning engine is the one behind Merchlint, a full WooCommerce catalog audit from the same author, Baltano. This plugin carries its own copy under its own class names, so the two can run side by side on one store without conflict. If you want the rest of the catalog checked too—prices, stock, images, categories—that is what Merchlint is for.