Hello, We have connected multiple stores to our stripe account, and it's tough for us to identify each payment. We exported all payments, but we can't find the order number. How can we see the order number in our payments report? Shopify shows orders like this #1001, #1002, but stripe shows orders like this: c20504176790373.1
Tiia here from Better Reports support team.
I believe our app Better Reports can help with your Stripe reporting. Firstly, we can customize your Stripe reports to include the order number and we can consolidate data from multiple Stripe accounts!
Our app provides detailed reporting of all of your Stripe data including balance transactions, invoices, charges, customers, payout, and more.
Common use cases include:
I encourage you to install Better Reports and start your free 14-day trial, and I'll be happy to set this up for you.
What do you think?
I have the same issue the person who logged the issue regarding mismatched order identifiers in Shopify vs Stripe. I also have the same issue for Shopify order payments collected via Amazon Pay.
Can you show me what report I would use to reconcile order payments?
As Tiia mentioned, Better Reports has a connector with Stripe where we can retrieve order data. We can also do this directly in our app for Shopify!
Stripe passes along the Stripe order ID (format like c20504176790373.1) to Shopify contained within the payment gateway receipt. We can create a custom field to extract this data from the receipt so you can associate the Stripe order ID with the Shopify order name. If you provide example information available in Amazon, we can see if the same data is passed along to Shopify to correlate with orders.
In addition to custom reporting capabilities, Better Reports offers more than 60 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. Our reports can even be scheduled to send at a set frequency to your email or Google Drive!
I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.