Shopify and Stripe revenue side by side
Connect both and ask about each. Put the orders Shopify recorded next to the payments Stripe took, day by day, and see where they do not line up.
The question
“Do the days my store recorded sales match the days Stripe took payments?”
Ask it in your own words. You get the answer, with the steps that made it.
What in your data answers it
These are the fields the connector reads.
| Stream | Field | What it is |
|---|---|---|
| Shopify orders | created_at, total_price, financial_status | The sales your store recorded each day. |
| Stripe charges | date, amount, status, refunded | The payments Stripe took each day, and any that failed or were returned. |
Connect each source, then ask a question that names both. Each source is read on its own; we do not match one customer across the two.
A real sample report
This sample report runs anomaly detection on a public data set (card transaction data). It is not Shopify or Stripe data. The method looks for values that stand out, which is how a day that does not match would show up.
Other questions to ask
- “Which days did Shopify record sales that Stripe did not charge?”
- “How much was refunded each week?”
More free tools for this data:
Questions
Does it match one person across both?
No. Shopify and Stripe do not share a customer key, so this page compares totals by day, not people.
Why would they differ?
Refunds, failed payments, time zones and payouts that land on a later day can all make a day differ.
Does it change either account?
No. We only read.