I’ve got my BigCommerce store connected to Google Sheets through Zapier, and it works great for getting new orders automatically transferred. The problem I’m running into is that when an order has multiple items, everything gets dumped into a single row with all the products crammed together in one cell.
What I really need is for each individual product to create its own separate row. So if a customer buys 4 different items, I want to see 4 distinct rows in my spreadsheet instead of one messy row with everything mixed together.
I noticed that BigCommerce’s built-in export feature can handle this properly and separates each item, but the Zapier integration doesn’t seem to tap into that same export functionality.
Has anyone figured out a workaround for this? Maybe there’s a way to modify the Zap or use some kind of formatter? Any suggestions would be awesome!
i get ur frustration! i had this prob too. if you use Code by Zapier, you can loop through the items and make distinct rows. it requires some coding, but it does work. also, the Line Items formatter could help, but it’s a bit complex.
Had this exact problem last year and found a workaround that’s way better. Skip the standard BigCommerce trigger entirely - it’s a pain for splitting items. Use webhooks with the BigCommerce API through Zapier’s webhook feature instead. Set up a webhook for new orders, then add a JavaScript code step to parse the order data and pull out each line item separately. You’ll need to loop through the products array and create individual payloads for each item before pushing to Google Sheets. Takes more setup upfront, but it handles variable quantities and product variations way more reliably. Plus you get cleaner data since you control exactly what goes into each column.
Use the Looping by Zapier step - it’s your best option without custom code. Add it after your BigCommerce trigger and set it to loop through each line item. Connect that to Google Sheets so it creates one row per item. I set this up for a client about six months ago and it worked great. Getting the field mappings right takes some trial and error, but once it’s dialed in, it handles multi-product orders perfectly. Just test it with different order sizes before you go live.