Reference
Data dictionary
Every field we deliver, across the four products, with types and meaning. Same names in every delivery target.
Price Monitoring
Competitor prices, discounts and stock, tracked daily.
| Field | Type | Description |
|---|---|---|
| sku | string | Store product identifier |
| title | string | Product name as shown on the page |
| price | decimal | Current selling price |
| list_price | decimal | Pre-discount price when shown |
| currency | string | ISO 4217 code |
| in_stock | boolean | Availability at scrape time |
| promo | string | Discount label or coupon text, empty if none |
| scraped_at | datetime | UTC timestamp of the observation |
Refresh options: Weekly (Monitor), Daily (Monitor + daily add-on), Hourly (Scale)
Catalog Data
Complete product catalogs from any store.
| Field | Type | Description |
|---|---|---|
| sku | string | Store product identifier |
| title | string | Product name |
| brand | string | Brand as listed |
| category_path | string | Breadcrumb path, '>' separated |
| description | text | Full product description |
| images | string[] | Image URLs |
| variants | object[] | Size, colour and per-variant price/stock |
| url | string | Canonical product URL |
Refresh options: One-off (One-off dataset), Weekly (Monitor), Daily (Monitor + daily add-on)
Review Intelligence
Every review, every store, one schema.
| Field | Type | Description |
|---|---|---|
| sku | string | Product the review belongs to |
| rating | integer | 1–5 stars |
| title | string | Review title when present |
| body | text | Review text |
| author | string | Display name as shown (no personal data beyond that) |
| verified | boolean | Verified-purchase flag when shown |
| date | date | Review date |
| store | string | Source store |
Refresh options: Weekly (Monitor), Daily (Monitor + daily add-on)
Assortment & Category
Who sells what, and what's new on the shelf.
| Field | Type | Description |
|---|---|---|
| category_path | string | Category breadcrumb |
| sku | string | Product identifier |
| title | string | Product name |
| brand | string | Brand |
| position | integer | Rank within the category listing |
| first_seen | date | First date the product appeared |
| last_seen | date | Most recent date it was listed |
Refresh options: Weekly (Monitor), Daily (Monitor + daily add-on)
Conventions
Field names
snake_case, consistent across every product and delivery target.
Timestamps
ISO-8601, UTC. A timestamp is always the time of observation, not of delivery.
Prices
Decimal values with a separate currency field (ISO 4217 code), never a formatted string.
Booleans
true or false, never a string like "yes" or "1".
Missing values
An empty string for missing text, null for missing numbers. We don't invent a placeholder.
Schema version
A schema_version column is present on every row, in every delivery.
Need a field we don't list?
Tell us what you need and we'll confirm whether it's available.