Shopify Standard Taxonomy: How to Fix a Broken Product Catalogue
We found 1,373 products assigned to 'Address Signs' and 889 to 'Finials' on a UK furniture store. Here's how to audit and rebuild your Shopify taxonomy correctly.
Why Taxonomy Matters
Shopify introduced a standardised product taxonomy in 2023, with the goal of mapping your products to Google's product category system. For brands running Google Shopping, this taxonomy mapping feeds directly into your feed quality score, your eligibility for free listings, and your product type match rates in Performance Max campaigns.
The problem: most stores have never audited their taxonomy mapping. And when it goes wrong, it goes spectacularly wrong.
What We Found
On a recent client audit, we exported the full product catalogue and grouped products by their assigned Category Name. Here's a sample of what we found in a 6,337-product furniture and homeware store:
- ▸Address Signs: 1,373 products (should be sofas, beds, tables)
- ▸Finials: 889 products (should be curtain poles, accessories)
- ▸Earthquake Alarms: 721 products (should be miscellaneous homeware)
- ▸Backrest Pillows: Various (should be benches)
- ▸Bird Feeders: Various (should be photo frames, outdoor furniture)
This isn't a minor error. These products are being fed to Google Shopping under completely incorrect categories, suppressing impression share and causing policy violations.
Why It Happens
The taxonomy mapping happens at product import. If you're using a supplier feed or a migration tool, whatever category ID exists in the source data gets written as-is. Shopify's taxonomy uses a hierarchical ID system — and if a wrong ID gets applied to every row in a bulk import, you end up with 1,373 products in the wrong category overnight.
How to Fix It
Step 1 — Export via Matrixify
Export the Products sheet. You need three columns: Handle, Category: ID, Category: Name.
Step 2 — Identify the damage
Group by Category Name, count products per category. Any furniture store with products in "Address Signs" or "Earthquake Alarms" has a problem.
Step 3 — Build a mapping table
Create a lookup: your product type → correct Shopify taxonomy path and ID. Critical rule: only use taxonomy IDs verified from your own store's export, not constructed IDs.
Step 4 — Apply and import
Write the corrected Category: ID and Category: Name columns using Python or Excel VLOOKUP. Import via Matrixify with Command: MERGE.
Verification
After import, spot-check 10–15 products across different types in Shopify admin. In Google Merchant Center, check your product feed for category mismatch disapprovals — these should clear within 2–3 feed refresh cycles.
Getting your taxonomy right is a prerequisite for effective paid media campaigns — broken categories mean broken Shopping ads.
---
Need a taxonomy audit? Book a free session.