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

Wooocommerce Update Order same row

  • 24 March 2021
  • 4 replies
  • 59 views
F

Hi, I need to make a zap with Woocommerce and Google Sheets.

I need to update the order from "pending" to "completed" in the same row when performed in Woocommerce. I don't want the order to be duplicated. Does anyone know how to do it? 


I already have a Zap that creates the new orders. 

Thanks!

icon

Best answer by robschmidt 24 March 2021, 13:52

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.

4 replies

robschmidt
Userlevel 7
Badge +9

Hi @fedemirano,

Here is the process flows for your automation:

  • Trigger: Updated order in Woocommerce
  • Action: Google sheet: Search Row: Search the correct order in google sheet using WooCommerce order ID from trigger
  • Action 2: Gooogle sheet: Update row: Use the row number to update row (set column value from pending to completed) 

 

Outliant.com | Zapier Expert
F

Thank you robschmidt for your response. Should I use the same excel sheet or should I create a new one?

This would be...

If I have a sheet called ORDERS, should I do it with that one or should I make another one for example called ORDERS 2 and do what you told me?

F

I have this error: There was an error writing to your Google sheet.

 

william
Userlevel 3
Badge +6

Hey @fedemirano, I hope you’re doing well!

For the question regarding which sheet to use, you can use the original sheet since we want to update the information within that sheet.

As for the error writing to the Google Sheet, was there any additional information provided about the error?

If not, for issues relating to errors that don’t have a clear cause it will be best to check in with our support team. They can help dig into the error logs for the zap and track down the exact cause of the issue. 

You can get in touch with support by submitting a ticket on our Get Help page here: https://zapier.com/app/get-help

Terms & Conditions