# The 20 Million SKU Myth

> A Fictitious Shopify B2B Store With 20 Million SKUs, Run Against Shopify's Own Limits

*Source: [https://contentcucumber.com/research/20-million-sku-myth/](https://contentcucumber.com/research/20-million-sku-myth/)*

*By Brent Peterson, CEO, Content Cucumber. Issue 70. Published 2026-10-14*

---

[Read the full issue](https://www.linkedin.com/pulse/20-million-sku-myth-brent-w-peterson-hmlpc)

A Fictitious Shopify B2B Store With 20 Million SKUs, Run Against Shopify's Own Limits

## In this issue

- **The Store.** Our store is a fictitious Shopify B2B store with 20M SKUs.
- **Loading the Store.** Loading the store's 20 million SKUs into Shopify follows the path below, built from the documented limits, with the roadblock named at each step.
- **What the Store Looks Like Running.** Keep the catalog in step with the ERP through scheduled bulk operations, and run the day's update against the plan's budget.
- **Did we mention Search?** A single query cannot cost more than 1,000 points, arrays cap at 250 items, and you can't ask for 20 million records in one ordinary query, so reading the catalog means bulk queries that run outside the rate limit and must finish within 10 days.
- **Let's TEST!!** Test in stages at 500,000, 5 million, and 20 million variants.
- **Findings.** Standard and Advanced never load the catalog.
- **Boost targeting (saved 2026-10-14, before the campaign was created).** Goal: commerce platform leaders (Salesforce Commerce, Shopify, commercetools, Adobe, SAP and peers) read the article and inquire about what Brent does.
