Shopify Store Database
Real-time discoverable Shopify stores with rich enrichment data. Sourced from Certificate Transparency, refreshed continuously.
Record Schema
Each row represents one Shopify store discovered via CT stream — DNS-fingerprinted from the Let's Encrypt cert Shopify provisions for every custom domain. Scraped from the public storefront.
| Field | Type | Sellability | Notes |
|---|---|---|---|
shop_domain |
string | Sellable | The *.myshopify.com handle — the store's unique identifier |
store_name |
string (nullable) | Sellable | Store name set by the merchant |
primary_domain |
string (nullable) | Legal-gated | Real custom domain. Legally sensitive; may be withheld pending compliance review |
description |
string (nullable) | Sellable | Store's meta description from the storefront |
country |
string (nullable) | Sellable | Normalized to ISO 3166-1 alpha-2. Unmappable values are null |
currency |
string (nullable) | Sellable | ISO 4217 three-letter currency code |
product_types |
string[] | Sellable | Product-level category labels (raw from Shopify, not curated) |
product_tags |
string[] | Sellable | Product-level free-form tags |
vendors |
string[] | Sellable | Brands/manufacturers the store carries |
contact_email |
string (nullable) | Legal-gated | Email extracted from mailto: links in the homepage. Legally sensitive |
social_links |
string[] | Legal-gated | Public social profile URLs (Instagram, Facebook, TikTok, etc.) |
theme_name |
string (nullable) | Sellable | Shopify theme detected from storefront markup |
price_min |
decimal (nullable) | Sellable | Minimum product price (floored at 0) |
price_max |
decimal (nullable) | Sellable | Maximum product price (floored at 0) |
price_median |
decimal (nullable) | Sellable | Median product price (floored at 0) |
product_count |
integer (nullable) | Sellable | Number of visible products in the catalog |
age_band |
string (derived) | Sellable | Derived from earliest_product_at. See band definitions below |
size_band |
string (derived) | Sellable | Derived from product_count. See band definitions below |
growth |
string (derived) | Sellable | Derived from snapshot history. See definitions below |
installed_apps |
string[] | Sellable | Detected Shopify app markers (script hosts) |
payment_methods |
string[] | Sellable | Detected payment providers (Shop Pay, PayPal, Stripe, etc.) |
tech_markers |
string[] | Sellable | Analytics/tracking markers (GA, Meta Pixel, TikTok, etc.) |
scraped_at |
timestamp | Sellable | When this record was last refreshed from the storefront |
Derived bands
Age, size, and growth are computed from raw fields and snapshot history rather than sold as raw timestamps.
| Dimension | Bands |
|---|---|
| Age band from earliest_product_at |
|
| Size band from product_count |
|
| Growth from snapshot history |
|
Segment & Filter Taxonomy
Buyers can filter the dataset by any combination of these dimensions. "Useful only" is on by default — it excludes locked, empty, and dead stores so you only see real businesses.
Quality SLA
Published KPIs — transparent targets backed by real-time telemetry. These are observed commitments, not contractual SLAs, and will tighten as the dataset matures.
Data Freshness
Each store is rescanned automatically on a schedule that reflects its activity:
- Active stores (open, with products) — rescanned monthly
- Locked / empty stores — rechecked every 2 days until they open or prove dead
- Rate-limited stores — rescheduled in 5 days (429 backoff)
- Dead stores (10 failed attempts, never opened) — abandoned
New stores are discovered continuously from the Certificate Transparency stream. At steady state, the pipeline adds thousands of new shops per day.
Sample Dataset
A deterministic sample of ~100 useful shops can be produced on demand. Contact us to request a sample CSV matching this schema.
Normalization Rules
| Field | Rule |
|---|---|
| Country | Mapped to ISO 3166-1 alpha-2 at scrape time. Unmappable → null |
| Prices | Floored at 0 on export. Never negative |
| Contact email | Lowercased at scrape time |
| Social links | Deduplicated, sorted, capped at 10 |
| Product attributes | Lowercased at scrape time (types, tags, keywords) |