Orders API - Payment Method & Order creation date (using Stitch)

macholas
Visitor
1 0 0

Hello guys,

 

I use the Stitch app (https://www.stitchdata.com/) to pull my store's info through an API and send them to a Data Warehouse. My main goal is to determine 2 KPIs which parameters I believe can be found in the Orders API (https://help.shopify.com/en/api/reference/orders/order😞

 

1) Boleto Conversion Rate. In Brazil, clients can pay using boleto (https://en.wikipedia.org/wiki/Boleto) or credit card. If they generate a 'boleto' they not necessarily pay it, and determining the percentage of 'boletos' paid will guide us in developing Client Support strategies.

Which parameter can I use to determine the payment method OR if the product was paid with credit card or 'boleto'?

 

2) Number of orders a day. I don't know the reason, but the created_at parameter is not being properly exported. It presents the information as if all orders were created at 12:00 AM.

Figure 1.png

 

It is also not considering Brazilian timezone, since order #5405 was generated in 11/18 (Monday) but the API reads it as 11 /19 (Tuesday). I've double checked in my Shopify store settings and the timezone is correctly set to Brazilian GMT.

 

Figure 2.png

 

I have no clue of why this is happening, maybe I am selecting the wrong parameter. Do you guys have any idea on how to help me?

 

Thanks in advance,

 

Macholas

 

Reply 1 (1)

SBD_
Shopify Staff
1829 270 412

Hey @macholas,

 

1) Try looking through transactions to see if there's anything to identify Boleto.

2) Is that screenshot from Stitch? You'll need to reach out to them.

 

Let me know if you have any questions.

Scott | Developer Advocate @ Shopify