# Shopify to Google product category mapping study

George Kelly · Observed November 14, 2026

[Canonical study](https://www.iamgeorgekelly.com/field-guide/shopify-google-category-mapping-study)

## Source files

Save the source downloads in one directory with these local filenames. The replay uses the compressed Shopify bytes and the original Google text bytes.

| Local filename | Download | SHA-256 |
| --- | --- | --- |
| `shopify-2026-08.json.gz` | [Shopify v2026-08 English mappings](https://github.com/Shopify/product-taxonomy/releases/download/v2026-08/integrations.all_mappings.en.json.gz) | `6673b1c7197780b4535e3fac21d5df670597a8fac3d3973ac527cb7273efe651` |
| `shopify-2026-10.json.gz` | [Shopify v2026-10 English mappings](https://github.com/Shopify/product-taxonomy/releases/download/v2026-10/integrations.all_mappings.en.json.gz) | `bd878991595cbc056fafd3826535702c3efe7405f2db52e1923c2a6b760f6b41` |
| `shopify-2026-11.json.gz` | [Shopify v2026-11 English mappings](https://github.com/Shopify/product-taxonomy/releases/download/v2026-11/integrations.all_mappings.en.json.gz) | `0a68b05fa7b0056c1ce4b8472802b47aa7e8f56a9c7f5f7aa8bc2b6933873a3c` |
| `google-taxonomy.en-US.txt` | [Google category IDs and paths](https://www.google.com/basepages/producttype/taxonomy-with-ids.en-US.txt) | `30039729880ec5ac4851de088ad228a6898aa253f0de5d5ebea5bb1437478fce` |

Google’s text download can change. Keep the original file for exact replay and record a new capture date if repeating the comparison with newer inputs.

## Comparison rules

1. Select the Shopify-to-Google route with the matching Shopify release and `google/2021-09-21` as its destination. Include all Shopify category depths in that route.
2. Count each Shopify source ID once. Group source IDs by their mapped Google ID. A shared group contains two or more source IDs.
3. Join consecutive releases by Shopify ID. Count added and removed source IDs, different Google destinations for shared IDs, and changed Shopify full paths for shared IDs.
4. Compare every Google ID and path used in the November route with the captured Google file. Retain IDs missing from Google and differences in full paths as distinct results.

The study measures public category rules. It does not observe product counts, merchant adoption, feed submissions, automatic category assignment, or Merchant Center processing.

## Reproduce

Download the [replay script](https://www.iamgeorgekelly.com/downloads/reproduce-shopify-google-category-study.mjs). From the directory containing the script, run:

```sh
node reproduce-shopify-google-category-study.mjs ./inputs > results.json
```

Compare `results.json` with the [recorded results](https://www.iamgeorgekelly.com/downloads/shopify-google-category-study-results.json). To rebuild the department lookup data, pass an output directory as the second argument. The runner reads local files and verifies all four digests.

The [lookup data index](https://www.iamgeorgekelly.com/downloads/shopify-google-taxonomy-2026-11/index.json) lists department names and IDs. Each `<department-id>.json` has `rows` as `[Shopify short ID, Shopify full English path, Google ID]`. Its `destinations` object maps a Google ID to `[Google full English path as published by Shopify, count of mapped Shopify IDs across all departments, whether the ID and path match the captured Google file]`. Add `gid://shopify/TaxonomyCategory/` to a Shopify short ID to reconstruct the GID. The bundle includes the [Shopify taxonomy license](https://www.iamgeorgekelly.com/downloads/shopify-google-taxonomy-2026-11/LICENSE.txt).
