Two products with the same SKU throw off stock levels, integrations and every export file your store\nproduces. Two products with the same GTIN tell a shopping service they are the same item, so one of\nthem quietly disappears from search. A product with no identifier at all usually drops out of the\nfeed altogether.<\/p>\n\n
None of this breaks your store, which is why it goes unnoticed for years. Nothing in the WooCommerce\nadmin points at any of it.<\/p>\n\n
This plugin checks three things and nothing else:<\/p>\n\n
It never writes to your catalogue<\/strong>. There is no \"Fix it\" button, and there will not be one: a\nbulk change to product data is not something a report should do on your behalf. Every finding shows\nthe value that was read, so you can check the claim before you act on it.<\/p>\n\n It reads no order data, which makes the scan far cheaper than a full audit. The scan still runs\nin a single request, so on a very large catalogue it can run into your host's time limit \u2014 the\nscreen says so when that becomes likely, and the WP-CLI command has no such limit.<\/p>\n\n Every finding shows the field that was read and the value found, with a link straight to the product\nin your admin. A rule that could not run says so by name \u2014 on WooCommerce older than 9.2 the\nidentifier field does not exist at all, and the report says that rather than reporting every product\nas faulty.<\/p>\n\n The scanning engine is the one behind Merchlint, a full WooCommerce catalogue audit from the same\nauthor. This plugin carries its own copy with its own class names, so both can run side by side.<\/p>\n\n\n For large catalogues there is a WP-CLI command: Install this plugin, open Tools \u2192 Duplicate SKU and GTIN Finder<\/strong> and press Scan now<\/strong>. Every\nproduct that shares its SKU with another one is listed with the SKU that was read and an Edit link,\nand Download CSV<\/strong> gives you the same list as a file. It compares published products and their\nvariations; translations of one product are not counted as duplicates.<\/p>\n\n WooCommerce itself refuses a repeated SKU when you save a product, but it has no screen that lists\nthe pairs already in your catalogue. Those got in another way - for example through a tool that\nwrites to the database directly.<\/p><\/dd>\n WooCommerce shows this message when you save a product with an SKU that another product or\nvariation already has. A draft or a private product holds its SKU too; only a product in the Trash\ndoes not. In the classic product editor your other changes are saved, and the SKU keeps its\nprevious value.<\/p>\n\n To find the product that holds it, type the SKU into the search box under\nProducts \u2192 All Products<\/strong>. That search covers drafts, private products and the SKUs of variations,\nand for a variation it shows the product the variation belongs to. This plugin lists published\nproducts and their variations only, so a draft holding the SKU will not be on its list.<\/p>\n\n The identifier field has its own version of the message, \"Invalid or duplicated GTIN, UPC, EAN or\nISBN.\" (WooCommerce 9.2 and later), and it works the same way.<\/p>\n\n Since WooCommerce 11.2 the product CSV importer, with Update existing products<\/strong> ticked, also\nfinds products by their GTIN. A row whose GTIN two products share fails with this message, and\nneither product changes; the importer does not say which product holds the other copy. The list\nfrom this plugin shows which published products share it.<\/p><\/dd>\n Since WooCommerce 9.2 every product has a field for a GTIN, UPC, EAN or ISBN, but nothing in the\nadmin lists the products where it is empty. This plugin does: each one with an Edit link, and a\nvariable product once, with the number of its variations that have no code.<\/p><\/dd>\nEvidence, not adjectives<\/h4>\n\n
Where the audit engine comes from<\/h4>\n\n
\n
wp merchlint-duplicate-sku-finder scan<\/code>.<\/p>\n\n\n\n
How do I find duplicate SKUs in WooCommerce?<\/h3><\/dt>\n
What does \"Invalid or duplicated SKU\" mean?<\/h3><\/dt>\n
How do I find WooCommerce products without a GTIN?<\/h3><\/dt>\n
How do I check if a GTIN or EAN is valid?<\/h3><\/dt>\n