← Back to templates

Shopify Sales by Product (with Transactions)

Each Product, with its Type and Tags is in a new row. For each item, a separate line contains the Transaction Date and Gateway kind. Since the Transaction Amount and Shopify Fee refers to the entire order, for the Order Items > Transactions Amount and Total Shopify Fee calculation, the transaction amount is equally divided by the price and quantity of items in the order.

Use report
Use Report
Import template to workspace
Copy template to clipboard (JSON)
Copied! Next, paste into your Mipler Reports
Get started free with Mipler Reports
Product Sales Transactions
  • Granular Product-Level Insights: Analyze each product’s sales performance along with associated transaction dates and payment methods
  • Fair Fee Allocation: Understand Shopify fees and payouts by distributing transaction amounts proportionally across items in the order
  • Enhanced Profitability Analysis: Connect products with financial transaction data to uncover true margins per item sold