Summary exports
An export with a summary block produces an aggregate report instead of an ordinary row for each product or order. A summary has one or more named metrics; the names become output column headers. columns can select and order those columns. Summary reports do not use the ordinary per-item mapping, actions, or templates.
Order summaries
An order summary uses type: "orders", action: "export", one file configuration, and an SFTP, SureDone SFTP, or email connection. Email requires an attachment. HTTP, triggers, and authentication sessions are not supported for this report. Use a separate automation for each report.
Use group_by: "channel" to group selected orders by channel, combining instances of the same channel. Omit group_by for one total row. Supported order metrics are a group column, count, and sum of total. Counts include each selected order once. The sum is the saved gross order total, not net sales or profit; it does not subtract refunds separately.
Choose the population explicitly. summary.filters accepts supported literal conditions on order ID, channel, instance, status, payment status, shipping status, dates, archive state, and currency. summary.filter_type defaults to AND and can be OR. Optional orders_start_date and orders_end_date are inclusive UTC bounds applied in addition to those filters. Supply an ISO date or datetime; an end date without a time means midnight at the start of that date.
To sum totals, set summary.currency to the expected three-letter uppercase currency. Every selected order must match it; the report does not convert currencies or automatically exclude other currencies. Add an explicit currency filter if that is your intent. Counts can span currencies. No order status, archive, date, or currency exclusion is implicit.
{
"name": "orders-summary.csv",
"summary": {
"group_by": "channel",
"currency": "USD",
"filters": [{"key": "currency", "opr": "=", "val": "USD"}],
"metrics": [
{"name": "channel", "source": "group"},
{"name": "orders", "type": "count"},
{"name": "total", "type": "sum", "field": "total"}
]
}
}
This is a file configuration excerpt, not a complete automation. Add the connection, schedule, and other required automation settings. For a grouped empty result, no file is sent unless export_empty_file is enabled, in which case the output contains headers only. An ungrouped empty result emits a zero total row.
Product summaries
Product summaries support grouping by a supported SureDone product field and metrics including count, sum, avg, min, max, and percent. A product summary can use a base search and supported per-metric filters. The fields accepted for aggregation and filter combinations have restrictions; validate the exact report before saving. A summary is a report, not a product update.
Verify the output and the receiving system before relying on the report for a business decision. A completed send does not by itself confirm that a recipient imported the file.