Back to All Datasets
Shopify Test Payload

Mock Shopify Order JSON with Line Items

A sample Shopify order JSON payload containing deeply nested line_items, tax_lines, and discount_applications. Use this payload to test JSON flattening, data loading pipelines, or database seeding.

Struggling to convert your own JSON?

Don't write another Python script. Use our free, 100% secure client-side tool to flatten any complex JSON export into a perfect Excel file in seconds.

Data never leaves your browser window.
Repair Your Export
payload.json
{
  "orders": [
    {
      "id": 450789469,
      "email": "customer@example.com",
      "created_at": "2024-02-15T10:00:00-04:00",
      "total_price": "135.00",
      "subtotal_price": "120.00",
      "total_tax": "15.00",
      "currency": "USD",
      "line_items": [
        {
          "id": 12345678,
          "title": "Minimalist Ceramic Mug",
          "quantity": 4,
          "price": "20.00",
          "sku": "MUG-CER-WHT",
          "properties": [
            {
              "name": "Color",
              "value": "White"
            },
            {
              "name": "Gift Wrap",
              "value": "No"
            }
          ]
        },
        {
          "id": 12345679,
          "title": "Artisan Coffee Beans",
          "quantity": 2,
          "price": "20.00",
          "sku": "COF-ART-500",
          "properties": []
        }
      ],
      "tax_lines": [
        {
          "title": "State Tax",
          "price": "10.00",
          "rate": 0.083
        },
        {
          "title": "County Tax",
          "price": "5.00",
          "rate": 0.042
        }
      ],
      "customer": {
        "id": 567890,
        "email": "customer@example.com",
        "first_name": "Alice",
        "last_name": "Baker",
        "orders_count": 3
      }
    }
  ]
}

Dataset Size

1308 Bytes

Format

JSON (Nested)

License

MIT (Free to use)