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.
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.
Recommended Approach
For revenue reporting: include only aggregate orders. Filter to "Send to Many aggregate" tag. These represent the actual payment collected.
For fulfillment reporting: include only recipient orders. Exclude "Send to Many aggregate" tag. These represent actual shipments.
For isolating all STM activity: filter by the "Send to Many #" tag prefix, which appears on every order from a Send.
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.
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.