• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Deleting / Finalizing Orders in Woocommerce

Eugen

Member
Hello

I created a flow from woocommerce to Google Sheets. I made a payment in order to capture it in google sheet and I used a router to set everything right. I have two issues.

1) The router asked me to set the status of the purchase with was "processing". I did that but... SOME payments are automatically set to completed/finalized/processed. In that case... it seems that the router won't catch it? A payment that might show as "processing" is actually completed in my system, since I only sell digital products. I want ALL payments to be sent to my google sheets.

2) How can I work this process in reverse? Namely, if I cancel a payment in woocommerce, that row should get deleted from my google sheets or... be able to somehow make it clear in google sheet that that payment was canceled. Or, NOT delete it from google shet but set it to minus, so it wont count toward my total...

Thank you :)
 

Fagun Shah

Well-known member
For 1st issue setup router filter with 3 "OR" conditions, so it will go ahead if any one of them is TRUE.

1623513994539.png
 

Fagun Shah

Well-known member
Hello

I created a flow from woocommerce to Google Sheets. I made a payment in order to capture it in google sheet and I used a router to set everything right. I have two issues.

1) The router asked me to set the status of the purchase with was "processing". I did that but... SOME payments are automatically set to completed/finalized/processed. In that case... it seems that the router won't catch it? A payment that might show as "processing" is actually completed in my system, since I only sell digital products. I want ALL payments to be sent to my google sheets.

2) How can I work this process in reverse? Namely, if I cancel a payment in woocommerce, that row should get deleted from my google sheets or... be able to somehow make it clear in google sheet that that payment was canceled. Or, NOT delete it from google shet but set it to minus, so it wont count toward my total...

Thank you :)
For 2nd use case I think you can use "Order Updated" trigger of woocommerce in pabbly connect. That way when you change status of order to cancelled it will send that order data to pabbly connect and then lookup row in Gsheet using order id and delete the row or update the row as per your requirement.
 
Top