JsonExport LogoJsonExport
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. Download this payload or convert it directly into Excel spreadsheets in 1 click.

Convert this Shopify JSON to Excel or CSV

Instantly flatten and preview these records in multi-column tables. Auto-unwinds nested objects without writing Python or Power Query.

100% Client-Side in Your Browser (Zero Data Upload)
Convert to Excel
shopify-line-items-json.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
      }
    }
  ]
}

Payload Size

1,308 Bytes

Format

JSON (Multi-level Nested)

Compatible Tools

Excel (XLSX), CSV, Pandas, Power BI

License

Public Domain / MIT (Free for Testing)