sondahub

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
The first three products
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

FieldTypeNotes
idread-onlyintAssigned by the server. Seed records keep their ids across restarts; records you create continue after the seed.
created_atread-onlydatetimeWhen the record was created (ISO 8601, UTC).
updated_atread-onlydatetimeWhen the record last changed.
skurequiredstringUnique stock keeping unit.
namerequiredstring
slugstring
descriptiontext
category_idrequiredint → categories
brandstring
pricerequiredfloatmin 0
compare_at_pricefloatThe struck-through price on sale, or null.
currencystring
colorstring
weight_gintmin 0
tagsjson string[]
in_stockbool
ratingread-onlyfloatAverage of the seed reviews, 1–5.
review_countread-onlyint
statusenumactive 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

GET/v1/store/productsA page, with every filter, sort, search, field and expand option.
POST/v1/store/productsCreate one: 201 with the record, its id, a Location header and the session token that keeps it; 422 names each field that is wrong.
GET/v1/store/products/{id}One record, with an ETag; If-None-Match earns a 304.
PATCH/v1/store/products/{id}Change the fields you send.
PUT/v1/store/products/{id}Replace the record; required fields must all be there.
DELETE/v1/store/products/{id}Answers 200 with what was removed (a real server’s 204 lives at /v1/utils/status/204); gone for the session.
GET/v1/store/products/{id}/categoryThe category this record points at.
GET/v1/store/products/{id}/reviewsIts reviews, as a page with all the list options.
GET/v1/store/products/{id}/inventoryIts inventory, as a page with all the list options.

Try it

List with a filter
curl "https://api.sondahub.com/v1/store/products?status=draft&price_gte=10&expand=category&limit=3"
One record
curl https://api.sondahub.com/v1/store/products/1?expand=category
Its reviews
curl "https://api.sondahub.com/v1/store/products/1/reviews?limit=5"
Create
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"}'
Read it back: newest first (send the session token)
curl "https://api.sondahub.com/v1/store/products?sort=-id&limit=3" \
  -H "X-Sondahub-Session: THE_TOKEN_FROM_THE_CREATE"
Change one field
curl -X PATCH https://api.sondahub.com/v1/store/products/1 \
  -H "Content-Type: application/json" \
  -d '{"status":"draft"}'
Delete the one you created
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.

WhatRequest
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 }
    }
  }
}
Run it
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.

tools/call
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.