Skip to main content

hello all, I’m creating a zap from shopify on all open orders. I found the “new order” trigger under shopify, but that looks like it will only get new orders, not pull the existing open (unfulfilled) orders.

 

Is there a way to get all open orders from shopfiy so I can send them to a spreadsheet?

 

thanx

--kev

 

Hi ​@thekevmp 

If this is a one-time exercise, then you may be better served doing a manual export of Order data from Shopify, then importing or uploading to GSheets.

Help: https://help.shopify.com/en/manual/fulfillment/managing-orders/exporting-orders

 

Otherwise, you have to use the Shopify API: https://shopify.dev/docs/api/admin-graphql/2024-10/queries/orders

Resources for using app APIs in Zaps:

 


Hi ​@thekevmp 

If this is a one-time exercise, then you may be better served doing a manual export of Order data from Shopify, then importing or uploading to GSheets.

Help: https://help.shopify.com/en/manual/fulfillment/managing-orders/exporting-orders

 

Otherwise, you have to use the Shopify API: https://shopify.dev/docs/api/admin-graphql/2024-10/queries/orders

Resources for using app APIs in Zaps:

 

thank you, the manual export is where I was thinking, but I’m going to look into the other as well.


Hi ​@thekevmp,
 
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.


he did, I was able to manually perform an export from shopify and then set up zap to just keep appending to that sheet.

 

however, the instant trigger new fulfilled order did not get trigger today when I had an order fulfilled, so the entire zap was skipped. :(

 

any ideas why the trigger didn’t get activated?

 


Hi ​@thekevmp,

 

If your Zap didn’t trigger as expected, check the Zap History for error messages that may help diagnose the issue. Test your trigger in the Zap editor to ensure it's connected properly to Shopify and set to the correct event. Verify that the order in Shopify was marked as fulfilled, as the "New Fulfilled Order" trigger only activates for fulfilled orders. Finally, ensure your Zapier account is active and not paused or limited due to tasks or trial expiration.