fulfillment_items_report.json

{
  "id": "57c5047e-0e3b-40ba-96b6-629a9fc58774",
  "title": "Orders Detail (Customized)",
  "group": "My Reports",
  "description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.",
  "tags": [
    "Orders",
    "Detailed"
  ],
  "hiddenFields": [],
  "fieldLabels": {},
  "displayMode": "table",
  "visualizationType": "pie",
  "toolbar": {
    "dimensions": [],
    "filters": [
      "orders.processed_at"
    ]
  },
  "visualization": {
    "graphFields": [],
    "pieFields": [
      "orders.source_name",
      "orders.total_sales_amount"
    ],
    "scalarFields": [],
    "cumulative": false,
    "frozenFields": [],
    "columnWidths": {}
  },
  "query": {
    "model": "shopify",
    "explore": "fulfillments",
    "fields": [
      "orders.name",
      "fulfillments.name",
      "orders.processed_at",
      "fulfillments.created_at",
      "orders.hours_to_fulfillment",
      "fulfillment_items.sku",
      "fulfillment_items.product_name",
      "fulfillment_items.variant_name",
      "fulfillment_items.total_price",
      "fulfillment_items.total_quantity"
    ],
    "pivotFields": [],
    "sorts": [
      {
        "field": "orders.processed_at",
        "direction": "desc"
      }
    ],
    "filter": {
      "condition": "and",
      "groups": [
        {
          "condition": "and",
          "groups": [],
          "filters": [
            {
              "field": "fulfillments.created_at",
              "condition": "nempty",
              "value": "<nil>",
              "group": "",
              "disabled": false
            }
          ]
        }
      ],
      "filters": [
        {
          "field": "orders.processed_at",
          "condition": "named",
          "value": "last30Days",
          "group": "",
          "disabled": false
        }
      ]
    },
    "parameters": [],
    "limit": 50,
    "offset": 0,
    "crossFilters": []
  },
  "meta": {
    "userDefined": true
  },
  "isShared": false
}