About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

New Magento Orders to Google Sheet

  • 13 February 2020
  • 6 replies
  • 218 views
M
Userlevel 2

Hi, I have a Zap which triggers every time there's a new order on Magento and then creates a new row on Google Sheets. While this is better than nothing, this is not the desired outcome.

The desired outcome would be that a new row on Google Sheets is created only if the status of the new order is "Paid". The problem is that when a new order is created the status is initially "Processing" and that's the status which Magento sends to Zapier. And later on, as the status of the order is updated to e.g. "Paid" or "Cancelled", the updated status won't be sent from Magento to Zapier since it's not a new order anymore.

Does anyone have a solution to this problem?



icon

Best answer by MageComp 30 April 2020, 15:26

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

AndrewJDavison_Luhhu
Userlevel 7
Badge +10

Hi @miika_4390

You're bet option would be to use a plugin like this: https://www.mageplaza.com/magento-2-webhook/

You should be able to set it up so that when order status is updated it fires a webhook.

You can then create a zap that triggers on a caught webhook and creates the row.


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
M
Userlevel 2

Hi @AndrewJDavison_Luhhu,

thank you for your answer. My apologies, I forgot to mention that we're still on Magento 1. The plugin you suggested works with Magento 2.

We're moving away from Magento 1 during next June. Until that, do you have any other suggestions?

Thank you.


AndrewJDavison_Luhhu
Userlevel 7
Badge +10

Are there any options for setting up webhooks in Magento 1?


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
jesse
Userlevel 7
Badge +9

@miika_4390 just wanted to follow up here to see if you had the ability to set up webhooks in Magento 1. Let us know!

jesse
Userlevel 7
Badge +9

@miika_4390 Just checking in once more to see if you were able to find a webhook workaround to trigger off of “Paid” order updates in Magento 1. 

Let us know!

M
Userlevel 1

if you follow this plugin, it will help to allows store owners to create unlimited order statuses to ease order processing and inform customers for status change. 

for more detail check  this: https://magecomp.com/magento-2-order-status.html

Terms & Conditions