Ok, so I created a zap that creates a new row in a Google Spreadsheet when a Woocommerce order is created in WooCommerce.
But the order status is (obviously) not updated. So many orders that are on status “completed” in Woocommerce are still on “pending” in the Google Spreadsheet.
So my questions are:
1.) Is it possible to create a zap that updates the order status of already imported orders?
2.) How can I do that?
Thank you for any help,
Andrea
Zap
Thank you for the super-fast help.
However, when trying to follow your steps, I am facing the following problems:
in Step 2: The filters don't seem to recognize any value such as “completed” or “pending” as transferred by the first ZAP to GSheets. See here:
and here:
What could be the issue there?
------------
In Step 3: GSheet Lockup Row does also seem to have an issue:
What am I doing wrong?
Thank you very much for your kind support.
Andrea
Have you pulled thru a sample order that matches the conditions of the Zap for which you are trying to test? (e.g. Status = Completed)
Probably need to remove the static “status” value.
Thank you. Yes, that was it!
However now step 4 does not seem to work.
Here’s the screenshot for the settings:
And here’s the error message when testing:
Thank you for your incredible patience! Really appreciated.
Andrea
Try rebuilding step 4.
There can be a lot of factors that cause errors for GSheets.
Articles: https://zapier.com/apps/google-sheets/help
Hi
Just checking in, did you manage to get this sorted?
No, unfortunately I have not found a way to update orders status properly via Zapier.
The error you’re seeing is because in the ‘Row’ dropdown you need to map the ‘Row ID” field from step 3, now the ‘Status’ field.
That dropdown is where you tell Zapier which exact row to update - in this case the one you got from the lookup in the previous step.
If you still have problems with this, feel free to reach out and I can try and help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.