Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

  • March 24, 2021
  • 4 replies
  • 83 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!

Best answer by robschmidt

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) 

 

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
Forum|alt.badge.img+9
  • robschmidtZapier Solution Partner
  • Zapier Solution Partner
  • Answer
  • March 24, 2021

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
  • fedemirano
  • Author
  • March 24, 2021

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
  • fedemirano
  • Author
  • March 25, 2021

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

 

william
Forum|alt.badge.img+6
  • williamZapier Staff
  • Zapier Staff
  • May 25, 2021

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 & ConditionsAccessibility statement