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