Blink Collection Live Count

Enter a store's Storefront API credentials once, then scan every collection in the store, count its live products, and flag any collection that falls below a minimum you set.

Open tool →

Before you start

This tool uses the Storefront API, not the Admin API. The Storefront API only ever returns products that are published to the Online Store sales channel and active — that's what this tool counts as "live". Draft and archived products are invisible to the Storefront API entirely, so this tool cannot report a true archived/draft count or a total product count per collection. It only reports the live count and flags collections that don't meet your threshold. If you need real Active/Draft/Archived status broken out, that requires the Admin API with an access token instead.

What it does

🔑

Saved credentials

Store a shop domain and Storefront API access token in your browser, and switch between multiple saved stores.

📦

Full collection scan

Pages through every collection in the store and counts its live products by paging through the collection's product list.

🚩

Configurable threshold

Set a minimum live-product count. Any collection with fewer live products than that is flagged.

📋

CSV export

Export the flagged collections (or the full scan) as a CSV for sharing or further work.

How to use

Add a store

Enter the shop domain (e.g. your-store.myshopify.com) and a Storefront API access token, then click Save store. You can save several stores and switch between them from the dropdown.

Set your live-product limit

Enter the minimum number of live products a collection should have (e.g. 5). Collections with fewer live products than this will be flagged.

Scan collections

Click Scan collections. The tool pages through every collection in the store, then pages through each collection's products to get an accurate live count. Larger stores with many collections will take longer — progress is shown as it runs.

Review flagged collections

By default only collections below your limit are shown. Tick Show all collections to see the full scan results, including collections that passed.

Getting a Storefront API token

In Shopify admin, go to Settings → Apps and sales channels → Develop apps, create (or open) a custom app, enable Storefront API access under API credentials, and copy the Storefront API access token. This token is safe for client-side use — it only ever exposes data already marked public/storefront-visible.

Troubleshooting

A collection shows 0 live products

Either the collection genuinely has no products published to the Online Store, or every product in it is in draft/archived status — both look identical to the Storefront API.

The scan is slow

The tool has to make a separate request per collection (and per 250 products within a large collection) because the Storefront API has no "just give me the count" field. Stores with hundreds of collections will take a while — leave the tab open until it finishes.

Request fails or is unauthorized

Double check the shop domain (must be the .myshopify.com domain) and that the token is a Storefront API token, not an Admin API token — they are not interchangeable.