Multi-location Inventory JSON Example

A nested stock model that tracks the same SKU across multiple locations.

Real-world use case: Use this for warehouse systems, omnichannel fulfillment, and stock sync APIs.

2 "sku": "TSHIRT-BLK-M",

3 "updatedAt": "2026-03-12T08:00:00Z",

4 "locations": [

5 {

6 "warehouseId": "wh_north_1",

7 "onHand": 84,

8 "reserved": 6,

9 "available": 78

10 },

11 {

12 "warehouseId": "wh_west_2",

13 "onHand": 41,

Where this shape shows up in production

Warehouse sync

Omnichannel inventory

Planning tools

Use this for stock syncs, nightly exports, or warehouse dashboards.

Use this for product APIs, storefront cards, search indexes, and merchandising tools.

JSON in Databases — PostgreSQL JSONB, MongoDB & DynamoDB

Store, query, and index JSON in PostgreSQL (JSONB), MongoDB, MySQL JSON, DynamoDB, and SQLite. Includes schema design patterns and performance tips.

Large JSON Files — Performance, Streaming & JSON Lines

Handle multi-megabyte and gigabyte JSON: streaming parsers, JSON Lines (NDJSON), chunked processing, memory optimization, and benchmarks.

JSON Grid Viewer

Explore JSON as a sortable grid with nested cell inspection, dataset-path selection, and visible-state CSV or Excel export.

JSON Pretty Print & Viewer

Pretty-print, minify, and inspect JSON with strict-valid output, lenient repair modes, tree search, and local-only processing.

JSON to SQL Converter

Generate editable CREATE TABLE schemas and INSERT statements for PostgreSQL, MySQL, and SQLite with nested-data handling.