Skip to main content

How to Filter Shopify Reports to Avoid Double-Counting Bulk Orders

Filter Shopify analytics and reports to separate aggregate and recipient orders. Avoid double-counting revenue from Send To Many orders using tags and gateways.

When you use calculated values for order revenue handling, both the aggregate invoice and individual recipient orders reflect revenue in Shopify. Without filtering, your reports will double-count Send To Many revenue.

Why Double-Counting Happens​

With calculated values, recipient orders show product prices, tax, and shipping. The aggregate order shows the total collected from the gifter. Shopify's built-in reports see both, so revenue gets counted twice.

For revenue, product sales, fulfillment, and sales tax reporting: filter out the aggregate orders. In Shopify reports, exclude orders tagged "Send to Many aggregate". The recipient orders contain the itemized product, shipping, and tax detail that these reports need.

For payout reconciliation: the aggregate (parent) orders contain the actual transactions that Shopify pays out on. You can reconcile individual recipient orders back to their Sends using the data in Analytics > Send Details within Send To Many.

For sales tax reconciliation or third-party tax reporting: all the detail you need is available in Analytics > Sales Tax within Send To Many, broken out by tax rate per recipient order per Send.

For isolating all Send To Many activity: filter by the "Send to Many #" tag prefix, which appears on every order from a Send.

How to Filter​

You can identify Send To Many orders using two key attributes:

  • Order tags: Every order from a Send is tagged "Send to Many #[Send ID]". Aggregate orders also get the "Send to Many aggregate" tag. Tags are the most reliable way to filter.
  • Payment gateway: Recipient orders show "Send to Many" as the gateway. Aggregate orders go through Shopify's standard gateway (since they're created from draft orders), so the gateway alone won't catch everything.

To exclude aggregate orders from a Shopify report:

  1. Open or create a report in Shopify > Analytics.
  2. Click Filters at the bottom of the report.
  3. Set the filter to Order tags > does not contain > Send to Many aggr.

This removes all aggregate orders from the report, leaving only the recipient orders with their itemized detail.

Shopify analytics report filtered by order tags to exclude Send To Many aggregate orders

tip

The "Send to Many aggregate" tag is added automatically to every aggregate order. You don't need to configure anything in Send To Many for this tag to appear.

If Using Zero-Dollar Recipient Orders​

No double-counting risk since recipient orders are $0. Revenue only on aggregate. You may still want to filter to separate STM orders from regular catalog orders.

tip

Work with your accounting team to set up standard filters before going live with large Sends. This ensures consistent reporting across your business.

See Dashboard and Exports for export options and Sales Tax Calculation for tax considerations.

Last updated on