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.

I have an Excel sheet where i create new rows based on new order line items.  these rows have a unique id that is the order number and the item number(1234-001). these line items are then pushed to Salesforce to create tasks for each line item of the order. after the task is completed in Salesforce, the excel sheet line item status is updated from processing to completed.

 

Question: Because the rows in the excel sheet are order line items and not just an order, how can i update the status in woo commerce when all the line items of an order are updated? I will need to look at the all the rows with the same order number, if all the rows have a status complete, then update woo commerce; but if only one of three line items have status of completed, don’t update the status in woo commerce.

 

I hope this makes sense

Hi @LeeU-Salesforce 

Good question.

There won’t be a “simple” solution for this.

I’d recommend using Airtable instead of GSheets.

Airtable is a relational database, where records can be linked across Tables.

You’d structure your Base with 2 Tables, for example:

  1. Orders
  2. Items
  • Items would be linked to Orders.
  • Orders would have a Status.
  • Items would have a Status.

There are fields that can be configured to to count and compare the matching Item status (e.g. Item Status is Completed) VS the # Order Items.

Airtable also has Views.

Views have Filters. (e.g. Items w/ Status as Completed = Total # Order Items)

Views can be used to trigger a Zap when a record moves into the View.

Airtable also has internal Automations.

Terms & Conditions