Shopify order level reporting
When creating a report you have the option to choose which "level" to report on.
Results are not grouped
Results will be grouped by order, with each order on its own row. Fields that are repeated as part of an order (e.g. sales, products) will be collapsed into a single column under the order they are associated with.
When reporting at any level we can select the sales fields for an order:
Or we can select the fulfilment fields, but they cannot be combined:
Using the order level, both these sets of fields can be selected, and will be grouped into one row per order
This feature is currently only available in the Google Sheets addon
Report Level: Any Level
Results are not grouped
Report Level: Order
Results will be grouped by order, with each order on its own row. Fields that are repeated as part of an order (e.g. sales, products) will be collapsed into a single column under the order they are associated with.
Example
When reporting at any level we can select the sales fields for an order:
Or we can select the fulfilment fields, but they cannot be combined:
Using the order level, both these sets of fields can be selected, and will be grouped into one row per order
Limitations
This feature is currently only available in the Google Sheets addon
Updated on: 12/06/2024
Thank you!