We use a webhook from Shopify to capture order data in Airtable. When the webhook comes in, we create a record in Airtable with pertinent order data. I want to parse out the line items in the order into another table for use in creating a packing slip.
Here is sample data: Airtable - MA Test
The Data table represents the data as it comes in from the webhook.
The Desired Output table represents the ideal output. This is where I need help, creating an automation/script to parse out that data into new rows.
Since I don’t know scripting, my personal methodology for this would be to use Make.com, which is a no-code/low-code automation platform.
You can either use a Make webhook or their native Shopify modules to receive your Shopify data, and you can loop through your Shopify line items to create the desired output in Airtable that you’re looking for.
This would take a few hours to setup in Make, so I wouldn’t be able to guide you through the entire process here. You can likely figure it out on your own. But if your company has a budget for your project and you’d like to hire an expert Airtable & Make consultant to help you with this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Thank you for spending time working on this! I apologize that it took me so long to get back to you. This is nearly perfect for our needs. As every order can vary in size, I'm trying to figure out a way to make the formula dynamic. Any ideas in that regard is appreciated but your efforts thus far are much appreciated.
No worries. It's built to handle up to 4 line items but should be able to handle dozens, the only limiting factor is the formula fields character limit
I've updated the base to handle 10 line items now and you should be able to recognize the pattern for which value you need to change, you'll just need to extend it to whatever upper bound you're comfortable with
I did expand the formula to accept more line items as well but then noticed a large order of over 100 line items. I am writing a script that will hopefully handle this situation at scale. I will post what I come up with. Thanks again for your help.