Find Answers to Your Shopify Reporting Questions

Can you total Shopify POS cash drawer adjustments across a date range?

Merchants sometimes want to pull Shopify POS cash tracking session data and see the total cash drawer adjustments summed across a date range. Native Shopify doesn't show that as a single number, so a custom Cash Tracking report can be built instead, using a session ID column (since Shopify doesn't give sessions a name or number) and a column that breaks each adjustment out separately, so individual adjustments show on their own instead of only as one combined total.

Tag & Collection Reports

Can I see fulfilled quantity for every Shopify product under one tag since it was created?

A merchant wants total fulfilled quantity per product, filtered by one tag, measured from each product's creation date rather than order date. Shopify's tag filtering is limited to the Products and Inventory pages and doesn't reach Analytics reports, so natively this needs a manual CSV export and spreadsheet sum. The entry shows how to get tag, fulfilled quantity, and product creation date into a single report instead.

September 30, 2026

Can I split multiple values stored in one Shopify metafield into separate report columns?

When one metafield holds several values, such as ["Dry Skin","Sensitive Skin"], Shopify keeps them together as one stored value. It has no option to break them into numbered columns. Report Pundit can split each value into its own column, so Skin Concern 1 shows Dry Skin and Skin Concern 2 shows Sensitive Skin.

September 30, 2026

How can I see which other products were purchased alongside one specific product?

This entry addresses whether Shopify can surface which other products share an order with a single chosen product. Shopify's native reporting stops at per-product sales figures and doesn't cross-reference order contents against each other. Report Pundit answers this through a custom field that flags qualifying orders and surfaces the companion products found in them.

September 27, 2026

Can I run a Shopify sales report that shows product, quantity, and location while excluding free or 100% discounted items?

A merchant wants product-level sales quantity by booth (POS) location and date, with items given away free or discounted 100% excluded. Shopify's reports can group sales by product and location, but have no built-in filter to strip out free or fully-discounted line items. Natively this needs a manual CSV export and filtering the net sales column to zero by hand. The entry shows how to get product, quantity, location, and a net-sales exclusion filter into a single report instead.

September 27, 2026

Product and Variant Sku Reports

How many units of a specific SKU have I sold across multiple years?

Merchants often need total units sold for one SKU spanning more than a single year, e.g. checking an item across 2025–2026. Shopify's native Analytics > Reports > Total sales by product handles this on any plan, including Basic, by adding SKU as a dimension and setting a custom date range. Report Pundit's Sales by Variant report offers the same lookup as a reusable, schedulable report instead of a one-off dashboard query.

Do updated Shopify metafield values automatically show up in scheduled reports?

Shopify reflects updated metafield values immediately but has no way to schedule that data as a recurring report. Covers where Report Pundit fills that gap, its automatic six-hour sync cycle, refresh-on-schedule behavior, and the one-time setup needed for a metafield to carry through.

September 27, 2026

Payouts & Transactions

How do I retrieve the payout amount for a whole month of sales in bulk when payout timing differs per order?

Retrieving a full month of Shopify payouts is hard because orders settle on different dates. Native Payouts filtering gives the totals, but matching payouts to specific orders across gateways needs third-party reconciliation reporting.

How do I track Shopify orders where I still owe a refund?

A merchant's partial refund failed with no notification, and Shopify's order list gives no way to flag orders where refunds are still owed. They're asking how to track outstanding refund obligations.

September 24, 2026

Payouts & Transactions

Can I edit the Payment by Type report in Shopify?

A merchant asks how to track orders where a refund is still owed. Shopify only shows this inside each order, not in the orders list, and a failed partial refund gives no notification. Suggested workaround: filter a report by refund status "Partially Refunded" plus order status "Return."

September 14, 2026

How do I exclude test orders from Shopify reports if I can't delete them?

Explains why real-card test orders can't be deleted or auto-excluded in Shopify, and how store owners can tag and filter them out to keep financial reports clean.

September 14, 2026

Can you get a P&L, margins, and fee breakdown beyond Shopify's native reports?

P&L, margins, and fee breakdowns beyond native Shopify reports, pulling sales, cost of goods, payment fees, and custom expenses into one view that shows real profit.

September 14, 2026