• 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.

Updating woocommerce order status to google sheets with multiple items

Asim

Member
Hi everyone,

I created a workflow with Iterator to add woocommerce new order that has multiple items to google sheets and is working fine and adding multiple rows for orders that has more than one item.

Now, I need to create another workflow to update the order status once changed in woocommerce to the existing orders with multiple items in google sheets. I used "Lookup spreadsheet rows" which gives more than one row index and didn't know how to map them in next action.

Your help is extremely appreciated.

Thanks,
Asim
 

ArshilAhmad

Moderator
Staff member
Hi @Asim,

You can disable Simple Response, then click on 'Save & Send Test Request.' This will give you a response in the form of an array. Next, you can add an Iterator to your workflow and map the Iterator response in the 'Update Cell Value' action step. The Iterator will allow you to iterate through all the rows that contain the specific ID and update those cells.
1705868257089.png
 
Top