I need help with a task in Zapier where I’m transferring an invoice from QuickBooks Online to ShipStation. While most fields are correctly mapped, I’m facing an issue with the SKU field since it isn’t being sent by QBO. To resolve this, I utilized a lookup with a multi-step Zap and the Formatter Utility to align descriptions with a pre-defined table of SKUs. However, I found out that the Formatter Utility only processes the data once, without iterating through the array. I have been advised that the code utility in Zapier might help in this situation, but I’m uncertain about how to implement that. Can anyone provide guidance or examples?
hey alice! you might want to try using Zapier’s “looping by zapier” app. it’s perfect for iterating over arrays, and you can combine it with the code by zapier utility to run specific scripts for each item in the array. It’s a bit tricky at first but super worth it!