Skip to main content

Hello, community,

I was trying to create an invoice with multiple product items using a Zapier loop. This method works with the native NetSuite CSV import by adding multiple lines with the same invoice external ID but different product item IDs, which appends all product items to the same invoice. However, when I apply the same logic to the Zapier NetSuite Upsert action, it gives an error saying that this invoice already exists and does not update the invoice by appending a new product item.

What would be the best method to append multiple product items to a NetSuite invoice object?

Thank you so much for your help—I’m really excited to this NetSuite automation!

Best regards,
Serhii

Hi there ​@serhii_lexagri, welcome to the Community! 🎉

That’s very strange, with the Upsert action if it already exists then is should be updating it with the additional information. 🤔 

Can you share some screenshots of the setup of the Looping and Upsert actions in your Zap? I’d like to get a look at what’s been selected for those, as well as all the invoice object fields that are appearing in the Upsert action. It could be that it will accept line items for some of the fields (there will usually be a line to the left of the line item supported fields, as shown in the example here) in which case that looping action may not be needed. Make sure to blur or remove all personal information (names, emails, addresses etc.) from screenshots before sharing—you can use a tool like Zappy for that.

Looking forward to hearing from you!