sondahub / Store API / Products
Fake products API
2,000 products from the Store API, a fake e-commerce API. What the store sells. Prices are in USD.
Reads with filters, sorting, search and relations; writes that answer like a real server and stay in your session token. Same ids on every build. Free, no key, CORS open.
Connect
- List
- https://api.sondahub.com/v1/store/products
- One record
- https://api.sondahub.com/v1/store/products/{id}
- OpenAPI 3
- https://api.sondahub.com/v1/store/openapi.json
- GraphQL
- https://api.sondahub.com/v1/store/graphql
- JSON file
- https://api.sondahub.com/data/store/products.json
- MCP
- https://api.sondahub.com/mcp · list_records
curl "https://api.sondahub.com/v1/store/products?limit=3"
Sample records
Records 1 to 3 of 2,000, exactly as GET /v1/store/products/{id} answers them. The data file holds all of them.
[
{
"id": 1,
"created_at": "2026-05-30T03:43:29Z",
"updated_at": "2026-06-06T09:16:29Z",
"sku": "TOY-X7TDYW",
"name": "Tumble Building Board Game",
"slug": "tumble-building-board-game-toy-x7tdyw",
"description": "Tumble Building Board Game by Tumble. Setup took five minutes and it has worked every day since.",
"category_id": 7,
"brand": "Tumble",
"price": 83.6,
"compare_at_price": null,
"currency": "USD",
"color": "Graphite",
"weight_g": 11415,
"tags": [
"educational",
"ages-3+"
],
"in_stock": true,
"rating": 4,
"review_count": 1,
"status": "active"
},
{
"id": 2,
"created_at": "2026-04-02T04:01:58Z",
"updated_at": "2026-04-07T15:54:58Z",
"sku": "GAR-E99G7L",
"name": "Sunhouse Galvanized Planter Sand",
"slug": "sunhouse-galvanized-planter-gar-e99g7l",
"description": "Sunhouse Galvanized Planter by Sunhouse. Heavier than I expected, which is actually a good sign here.",
"category_id": 8,
"brand": "Sunhouse",
"price": 353.83,
"compare_at_price": null,
"currency": "USD",
"color": "Navy",
"weight_g": 9711,
"tags": [
"spring"
],
"in_stock": true,
"rating": 5,
"review_count": 4,
"status": "active"
},
{
"id": 3,
"created_at": "2025-09-08T07:09:37Z",
"updated_at": "2025-09-11T13:10:37Z",
"sku": "GAR-USFYL3",
"name": "Verdant Solar Hose Reel",
"slug": "verdant-solar-hose-reel-gar-usfyl3",
"description": "Verdant Solar Hose Reel by Verdant. The build quality is noticeably better than the last one I owned.",
"category_id": 8,
"brand": "Verdant",
"price": 370.18,
"compare_at_price": null,
"currency": "USD",
"color": "Olive",
"weight_g": 11170,
"tags": [
"patio",
"vegetables",
"spring"
],
"in_stock": true,
"rating": 4,
"review_count": 2,
"status": "active"
}
]
Fields
| Field | Type | Notes |
|---|---|---|
idread-only | int | Assigned by the server. Seed records keep their ids across restarts; records you create continue after the seed. |
created_atread-only | datetime | When the record was created (ISO 8601, UTC). |
updated_atread-only | datetime | When the record last changed. |
skurequired | string | Unique stock keeping unit. |
namerequired | string | |
slug | string | |
description | text | |
category_idrequired | int → categories | |
brand | string | |
pricerequired | float | min 0 |
compare_at_price | float | The struck-through price on sale, or null. |
currency | string | |
color | string | |
weight_g | int | min 0 |
tags | json string[] | |
in_stock | bool | |
ratingread-only | float | Average of the seed reviews, 1–5. |
review_countread-only | int | |
status | enum | active draft archived |
Relations: category → one category through category_id; reviews → the reviews whose product_id is this product; inventory → the inventory whose product_id is this product. Use ?expand=category,reviews,inventory to embed them, or the nested routes.
Endpoints
Try it
curl "https://api.sondahub.com/v1/store/products?status=draft&price_gte=10&expand=category&limit=3"
curl https://api.sondahub.com/v1/store/products/1?expand=category
curl "https://api.sondahub.com/v1/store/products/1/reviews?limit=5"
curl -i -X POST https://api.sondahub.com/v1/store/products \
-H "Content-Type: application/json" \
-d '{"sku":"AUD-4F7K2M","name":"Sonora Wireless Headphones","slug":"sonora-wireless-headphones","category_id":1,"brand":"Sonora","price":149.99,"currency":"USD","color":"Graphite","tags":["bluetooth","travel"],"status":"active"}'
curl "https://api.sondahub.com/v1/store/products?sort=-id&limit=3" \ -H "X-Sondahub-Session: THE_TOKEN_FROM_THE_CREATE"
curl -X PATCH https://api.sondahub.com/v1/store/products/1 \
-H "Content-Type: application/json" \
-d '{"status":"draft"}'
curl -X DELETE https://api.sondahub.com/v1/store/products/2001 \ -H "X-Sondahub-Session: THE_TOKEN_FROM_THE_CREATE"
Query recipes
Every list option works on products; these are ready to paste. All the options.
| What | Request |
|---|---|
| Page 2, 50 at a time (of 2,000) | /v1/store/products?page=2&limit=50 |
| Only status = active | /v1/store/products?status=active |
| Price between two values, largest first | /v1/store/products?price_gte=1&price_lte=500&sort=-price |
| Newest first by created at | /v1/store/products?sort=-created_at&limit=5 |
| Sku contains “toy” | /v1/store/products?sku_like=toy |
| Full-text search | /v1/store/products?q=toy |
| Only some fields | /v1/store/products?fields=id,sku&limit=5 |
| Embed the category | /v1/store/products/1?expand=category |
| Its reviews (nested route) | /v1/store/products/1/reviews?limit=5 |
| Just the count | /v1/store/products?limit=1&fields=id |
GraphQL
The same products as the products query on https://api.sondahub.com/v1/store/graphql, and one product as product(id: 1). Introspection is on. More on the GraphQL API.
{
products(limit: 3, sort: "-id", filter: { status: active }) {
total
data {
id sku name slug
category { name }
reviews(limit: 2) { id }
}
}
}
curl https://api.sondahub.com/v1/store/graphql -H "Content-Type: application/json" -d '{"query": "{ products(limit: 3, sort: \"-id\", filter: { status: active }) { total data { id sku name slug category { name } reviews(limit: 2) { id } } } }"}'
From an AI agent (MCP)
The MCP server reaches the same rows with list_records, get_record, create_record, update_record and delete_record, and as the resource sondahub://store/products.
curl https://api.sondahub.com/mcp \
-H "Content-Type: application/json" \
-H "Accept: application/json, text/event-stream" \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"list_records","arguments":{"api":"store","collection":"products","filters":{"status":"active"},"limit":3}}}'
More in the Store API
categories (8) · customers (800) · orders (3,000) · order items (6,219) · reviews (2,500) · warehouses (3) · inventory (6,000) · carts (200)
The live streams, and the whole API on one page: Store API. Other worlds: fake IoT API, fake banking API, fake social media API, fake helpdesk API, fake flight booking API, fake user directory API.