• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Applications Questions
T

Thoro Constantinides

started a topic over 5 years ago
Answered

Shopify: Orders: Additional Fields

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
Aug 11, 2017, 5:30PM

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. 


image


Patricia Guevarra

said over 5 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:

image

T

Thoro Constantinides

said over 5 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

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

said over 5 years ago

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?

T

Thoro Constantinides

said over 5 years ago

Hello, Amanda


It looks like the "get transaction" action has a few more fields available, but it doesn't have the authorization key.


image


T

Thoro Constantinides

said over 5 years ago

Here are the fields available within the recipe:



Capture.PNG
Capture.PNG
(9.95 KB)

Amanda Wong

said over 5 years ago

Theodoros, is the "authorization" below what you're looking for?


image


T

Thoro Constantinides

said over 5 years ago

Yes, it is!  It's not available in the action, but it is in the data.

Answer

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. 


image


T

Thoro Constantinides

said over 5 years ago

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.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count