There are a number of fields that would be useful to have available from Shopify Orders. These are all around the information when Shopify uses an outside payment gateway (ex: paypal).
These would allow automations to look up related orders and expenses in Quickbooks to speed up reconciliations since the payment provider will reference their own ID's instead of the sales order ID from Shopify when they sync their expenses to Quickbooks.
Can you please add them? The most important is the authorization key.
Authorization key
Message
Success
Amount
$18.25
Gateway
PayPal Express Checkout
Status
success
Type
sale
Created
Best Answer
A
Amanda Wong
said
over 5 years ago
You should be able to see the output in Get transactions by Order ID step and also access the data pill for field mapping in subsequent actions.
Patricia Guevarra
said
almost 6 years ago
Hello Theodoros,
I just wanted to verify some information on behalf of our product team. Are the Amount, Gateway, and Status fields you are referring to separate from these:
T
Thoro Constantinides
said
almost 6 years ago
Here is an example from shopify. The interesting fields are;
Authorization Key - This is how the order can be related to the paypal payouts and fees
Amount - this is the amount within the payment. The order may have multiple payments (gift cards, paypal)
Status - this is the paypal payment status, not the order status
Thoro Constantinides
Shopify: Orders: Additional Fields
You should be able to see the output in Get transactions by Order ID step and also access the data pill for field mapping in subsequent actions.
Patricia Guevarra
Hello Theodoros,
I just wanted to verify some information on behalf of our product team. Are the Amount, Gateway, and Status fields you are referring to separate from these:
Thoro Constantinides
Here is an example from shopify. The interesting fields are;
Authorization Key - This is how the order can be related to the paypal payouts and fees
Amount - this is the amount within the payment. The order may have multiple payments (gift cards, paypal)
Status - this is the paypal payment status, not the order status
Gateway - allow us to identify the payment method
https://troopers.myshopify.com/admin/orders/46205698072
A $30.00 USD payment was processed on PayPal Express Checkout. 9:30pm
Order : 5686
Authorization key: 1NL642327B197900A
Message: Success
Amount: $30.00
Gateway: PayPal Express Checkout
Status: success
Type: sale
Created: Aug 22, 2017, 9:30PM
Amanda Wong
Hi Theodoros, can I check if you are able to retrieve these information from your shopify order using the Get transactions by order ID action?
Thoro Constantinides
Hello, Amanda
It looks like the "get transaction" action has a few more fields available, but it doesn't have the authorization key.
Thoro Constantinides
Here are the fields available within the recipe:
Amanda Wong
Theodoros, is the "authorization" below what you're looking for?
Thoro Constantinides
Yes, it is! It's not available in the action, but it is in the data.
Amanda Wong
You should be able to see the output in Get transactions by Order ID step and also access the data pill for field mapping in subsequent actions.
Thoro Constantinides
Thank you, Amanda
You are correct! I was able to access the authorization and use the pill through the Get Transactions by Order ID action.
In my recipe I have two choices and both work.
1 - From a new shopify order, execute the Get Transactions by Order ID for that order
2 - From a new QBO sales receipt (it gets created by the shopify sync), execute the Get Transactions by Order ID
It would be more efficient if the transaction data was available in the Shopify New Order action. But it does work now with the extra action.