How do I get order costs from Printify using their API?

Hi ​@tarka33 

What is the link to the mentioned post you found?

What is the link to the Printify API endpoint documentation you are trying to use to configure the Webhook step?

NOTE: A helpful resource is to use ChatGPT to help you configure the Webhook fields.

You can post screenshots of the Zap step configuration and ask ChatGPT questions to get guidance.

Hi ​@tarka33,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Hi ​@Troy Tessalone and ​@JammerS - thanks for your replies.

Troy, here are the links you asked for:
Shopify help post regarding how to set up a Zap to automate reporting COGS from Printify

Printify API Documentation

I did ask ChatGPT for help setting up the webhook in Zapier and did exactly as you suggested, sending screenshots, but it was telling me to fill in fields that weren’t available on the Zap despite this. Hence I ended up here hoping for help. Any further advice is most welcome! 
Thank you both!

​@tarka33 

Which specific Printify API endpoint are you trying to use?

Hi ​@Troy Tessalone - I’m not 100% sure if this is what you mean, but ChatGPT suggested I use https://api.printify.com/v1/shops.json to connect to my shop. Is that what you are asking for?

​@tarka33 

If you are trying to interact with Prinity Orders, then these are the available Printify API endpoints: https://developers.printify.com/#orders

You will need to set these fields:

• URL
  • Include your Printify Shop ID
  • Include the Printify Order ID
• Headers
  • Authorization: Bearer PAT
    • Reference the section in the documentation about personal access token (PAT
  • Content-Type: application/json;charset=utf-8
    • Search the API docs for “content type”

Hi ​@Troy Tessalone - thanks for this answer, and apologies I didn’t get back to look at this until now. I hadn’t understood what I was looking at until I read your response, but after you pointed me in the right direction, between the Printify API documentation and ChatGPT, I’ve managed to just about get there.

I’ve focused firstly on getting the information into Google Sheets, as then I can analyse it further. Getting it into Shopify as metadata as mentioned in my original post is a nice to have after I get this working. 

So, I’ve got the webhook to Printify working in Zapier, but it sends information through as comma separated values. I’ve put a loop and filter in to try to match the order numbers from Shopify and Printify, which seems to mostly work - I can get the total order cost, shipping cost, tax, order number, and date no problem. Here’s how my Zap is set up, for reference:
 

However, if an order has more than one line item, I can’t get the line item cost, shipping, or retail price. It appears to be nested within the comma separated values from Printify. Here’s a screenshot to show what I mean:
 

If you’ve got any suggestions, I’d be very grateful for the help. Also, if you need more info, please just let me know. Many thanks, again!

​@tarka33 

You are likely dealing with arrays within arrays.

Nested arrays get flattened.

So you need to handle each Shopify Line Item separately in order to get the nested metadata.

From the screenshots it’s unclear how Zap steps 3-4 are configured in EDIT mode with the field mappings visible.

Hi ​@Troy Tessalone, ok, I get that. I’m not sure how to go about handling each line item separately though; are you able to point me in the right direction, please?

If it’s of any use, here are some screenshots of the Configure sections of steps 3 and 4. I’ve added Line Item Cost back in on Step 4, but this is one of the fields that is nested so hasn’t been working. If there’s anything else you need to know, please just let me know - I’m very thankful for the help!