Greetings, hoping someone at Shopify, or someone who has dealt with Shopify directly on the same issue can help advise on this
PROBLEM: On orders placed through Shopify and paid with a credit card via our Authorize.net integration, Shopify posts the "Checkout ID" (example: c.xxx48021.1) as the "Invoice Number" in Authorize.net. This is not useful when reconciling your payments. When you're browsing your payment history, you can't search by Order number in Authorize.net.
WHAT I'M HOPING TO ACHIEVE: I would rather Shopify post the Order# to the Authorize.net Data field [x_invoice_num] than the checkout number. When reconciling our payments it's much easier to go by invoice number.
If not, is there a way to post the Order ID in another field, say the PO Number?
I see in this thread, from back in 2006, when Active Merchant was in use, this was addressed. The only other area I see mention of this issue is in this thread. about the Checkout Id's and their significance.
Anyone else run in to this? How did you work around it?
Thanks in advance!
We got this working but perhaps not in the way you'd been trying to solve for it.
Ok, so it's an impossibility to modify or update Authorize.net records once they're created.
There seems to be an intractable and ongoing conflict between Shopify and Authorize.net in terms of getting order numbers passed with authorization requests, I think largely because order numbers in Shopify aren't created until AFTER transactions are authorized in Authorize.net.
That being said, the objective here is to get a reconciliation report, right?
Well, Shopify DOES store the Authorize.net Transaction ID number various other Authorize data in the transactions.json for every Shopify order. So, you can use this:
...with some custom functions their developers will write FOR you to achieve that reconciliation report. It can combine data from order.json and transactions.json for each order.
Also, it's automated so it can create send that report daily, weekly, monthly (or whenever) via email or even update a Google Sheet for you.
I'd been smacking my head into the desk trying to figure this out for our team, and remembered your post.
So, I thought you might have wanted to know how we solved it.