Using Zapier, my BigCommerce orders are sent to Google Sheets, but each order with several items appears as one row. How can I create separate rows for each product?
hey bob, you can add a custom zap step to loop thru each product and create separate rows. i used a similar trick and it worked pretty wel. might need a bit of tweaking but worth a shot!
I faced a similar challenge and eventually moved away from complex coding by leveraging Zapier’s built-in Formatter. Instead of writing a custom loop in JavaScript, I used the Formatter to split the product list based on a delimiter. Once the items were separated, I added a subsequent step that iterated over this list to create individual rows in Google Sheets. This approach required minimal adjustments and was especially useful for those who aren’t as comfortable with code, while still maintaining a clean and efficient data flow.
hey bob, try using a code step in zapier to loop device the order items into single rows in your sheet. this workaround helped me manage multiple products per order without much hassle. give it a shot, might just do the trick.
In my experience, a good approach was to implement a custom scripting step within Zapier. I faced a similar situation where each order returned multiple items, and by adding a code step using JavaScript, I was able to iterate through the product items and create individual rows for each one in Google Sheets. This solution required a bit of tweaking for error checking and data validation but ultimately provided a flexible method to handle varying order complexities. It did take some trial and error, but the results made data management much more efficient.