ScraperCity logo

Ecommerce Store Database API API Documentation

Ecommerce Store Database API

Query the ecommerce store database via API. Access millions of stores with revenue, traffic, employee, and contact data. Requires $149/mo plan.

Included with $149/mo planGET /api/v1/database/ecommerce

Database APIs are included with the $149/mo plan.

Parameters

NameTypeRequiredDescription
pagenumberOptionalPage number (default: 1)Default: 1Example: 1
limitnumberOptionalResults per page (max: 100)Default: 50Example: 100
platformstring[]OptionalFilter by ecommerce platform (multiple allowed)Example: Shopify
countrystring[]OptionalFilter by country code (multiple allowed)Example: US
statestringOptionalFilter by state (partial match)Example: California
citystringOptionalFilter by city (partial match)Example: Los Angeles
categorystring[]OptionalFilter by store category (multiple allowed)Example: Apparel
merchantstringOptionalFilter by merchant name (partial match)Example: Nike
domainstringOptionalFilter by domain (partial match). Accepts multiple domains, comma or space separated.Example: nike.com, gymshark.com
technologiesstring[]OptionalStores that run ANY of these technologies (multiple allowed)Example: Klaviyo
technologiesAllstring[]OptionalStores that run ALL of these technologies (multiple allowed, repeat the parameter)Example: PayPal
notTechnologiesstring[]OptionalLeave out stores that run any of these technologies (multiple allowed, repeat the parameter)Example: Facebook Pixel
planExcludestring[]OptionalExclude stores on these plan tiers, e.g. Shopify Plus (multiple allowed, case-insensitive)Example: Shopify Plus
salesMinnumberOptionalMinimum monthly revenueExample: 100000
salesMaxnumberOptionalMaximum monthly revenueExample: 10000000
visitsMinnumberOptionalMinimum monthly visitsExample: 50000
visitsMaxnumberOptionalMaximum monthly visitsExample: 5000000
employeesMinnumberOptionalMinimum employee countExample: 10
employeesMaxnumberOptionalMaximum employee countExample: 500
hasEmailbooleanOptionalOnly return stores with email addressesDefault: falseExample: true
hasPhonebooleanOptionalOnly return stores with phone numbersDefault: falseExample: true
hasInstagrambooleanOptionalOnly return stores with InstagramDefault: falseExample: true
hasFacebookbooleanOptionalOnly return stores with FacebookDefault: falseExample: true
hasTiktokbooleanOptionalOnly return stores with TikTokDefault: falseExample: true
excludeDeliveredbooleanOptionalSkip stores you already have: anything this account got from this API before or unlocked in the dashboard. Use it for daily pulls so each run returns only new stores. With this on, request page=1 every time (or use after), because the stores you just received are skipped on the next call.Default: falseExample: true
afterstringOptionalCursor paging for large pulls: returns stores after this id, in id order. Send after=0 on the first call, then send the next_after value from each response until it comes back null. Faster than page numbers deep into a big search. pagination.total is still the whole search.Example: 0

Examples

Daily pull of only new stores (for n8n, Make, Zapier, or a cron job)

curl "https://app.scrapercity.com/api/v1/database/ecommerce?platform=Shopify&country=US&hasEmail=true&excludeDelivered=true&limit=100" \
  -H "Authorization: Bearer YOUR_API_KEY"

Page through a large search with a cursor

# First call: after=0. Then pass pagination.next_after from each response as after, until it is null.
curl "https://app.scrapercity.com/api/v1/database/ecommerce?platform=Shopify&country=US&hasEmail=true&after=0&limit=100" \
  -H "Authorization: Bearer YOUR_API_KEY"

Find Shopify stores with 500K+ monthly revenue

curl "https://app.scrapercity.com/api/v1/database/ecommerce?platform=Shopify&salesMin=500000&hasEmail=true&limit=100" \
  -H "Authorization: Bearer YOUR_API_KEY"

Search for stores using Klaviyo in the US

curl "https://app.scrapercity.com/api/v1/database/ecommerce?technologies=Klaviyo&country=US&limit=50" \
  -H "Authorization: Bearer YOUR_API_KEY"

Find high-traffic apparel stores

curl "https://app.scrapercity.com/api/v1/database/ecommerce?category=Apparel&visitsMin=100000&employeesMin=10&limit=100" \
  -H "Authorization: Bearer YOUR_API_KEY"

Use Cases

  • •Build targeted outreach lists for ecommerce brands
  • •Identify potential clients by technology stack
  • •Analyze competitor landscapes by category and revenue
  • •Feed ecommerce data into your CRM or analytics pipeline

Best Practices

  • •Use revenue and employee filters to target the right size stores
  • •Rate limit: 100 stores per request, 100,000 new stores per day. Stores you already have do not count again
  • •Every store the API returns is saved to your account, so excludeDelivered=true can skip it next time. It also shows in your unlocked stores in the dashboard
  • •For big pulls use after + next_after (cursor paging) instead of high page numbers
  • •Combine platform + category + location for precise targeting
  • •Use technologies filter to find stores using specific tools (Klaviyo, Shopify Plus, etc.)
  • •Combine technologies for exact targeting: technologiesAll=Klaviyo&technologiesAll=PayPal&notTechnologies=Facebook%20Pixel finds stores on Klaviyo and PayPal that do not run Facebook Pixel
  • •Requires $149/mo plan - upgrade at /dashboard/billing
  • •Daily limit resets at midnight UTC

Every scrape returns a runId. Poll GET /api/v1/scrape/status/{runId} until it completes, then download via GET /api/downloads/{runId}?format=csv.

Authenticate every request with Authorization: Bearer YOUR_API_KEY. See the full API reference for authentication, rate limits and error codes.