I am exporting orders from Woocommerce using Zapier into Airtable.
The Order from the customer is received into two separate cells like this;
[Apple,Orange,Pear] and [1,3,5]
I need Airtable to recognise that order is for; 1 x Apple 3 x Orange 5 x Pear
I also need to know how many I require for a certain City. For example if I receive the data like this;
I need to know;
Apple x 1
Orange x 10
Pear x 8
Orange x 2
Banana x 5
Apple x 10
Orange x 3
Pear x 4
- Total -
Apple x 11
Orange x 15
Pear x 12
Banana x 5
Please note that I will not be able to input the list of Cities and it would be Difficult to list all of the fruit. I would need the application to read the Items (Fruit) and Cities only by selecting it to read the contents of a cell.
Here I have provided 5 records per day but there could be up to 300. I am currently processing this manually.
Any help would be much appreciated. I hope. I’ve made sense.
Step 1: Setup a Google Sheet with the 3 columns. Cities, Fruit, Qty
Step 2: Make a Zap with Woocommerce as trigger
Step 3: Add Formatter by Zapier - Line Itemizer (Create / Append / Prepend)
In the Line Itemizer, follow the screenshot below
Step 4: Add a Google Sheets action - Create new row(S), you will find it says that it supports Line Items
Now populate the Google Sheet you created in Step 1 with the data you have from the Line Items, each in its respective column
Step 5: Create a new Zap, with Google Sheets as the trigger
Step 6: Add an action Create new record in Airtable
Hope this helps, feel free to come back if you have any question.
If this answers your question, please mark this as a Solution so others can see it and benefit from it.