Skip to main content
Question

How to update an individual Quickbooks line item when there are many?

  • July 10, 2025
  • 5 replies
  • 15 views

  • Beginner
  • 3 replies

I have a ZAP set up that a Quickbooks Online invoice is created. I then have a filter that looks for the line item descriptions. If one of the line item descriptions matches a value in a Zapier table, I need to update that specific line items product.

The problem I'm running into is on the update invoice action, I cannot figure out how to specify an individual line item.

I have followed guides on handling line items, look at videos, and other support articles and I just cannot figure out how to individually target a specific line item. Does anybody have an experience with this and can help me figure it out?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

MohSwellam
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+8
  • Zapier Orchestrator & Solution Partner
  • 902 replies
  • July 10, 2025

Hi ​@LPI 

 

To target a specific line item you need to isolate it of course. The line item is basically an Array, so there are several ways to isolate it:

  1. Use a code step by Zapier to get the line item you need then manipulate it
  2. Use a Loop by Zapier to loop through all the items individually, you can add a filter at the beginning of the loop so you can target the line items you want

Forum|alt.badge.img+2
  • Beginner
  • 58 replies
  • July 10, 2025

It looks like you're struggling to target specific line items in QuickBooks Online via Zapier. One thing you can try is capturing the line item IDs when the invoice is first created. This way, you can reference those IDs to update the correct line item later.

If that doesn’t work, you might need to recreate the invoice with the updated line items, as Zapier doesn’t always allow for granular updates like this.

Let me know if that helps or if you need more info!


  • Author
  • Beginner
  • 3 replies
  • July 10, 2025

I tried to use a filter inside of a loop. But I am never able to actually test it because the records that I'm testing against have it on the 2nd line item. And I'm only seeing an option to choose the first line item. Even though it I don't think it should matter because each one of them should be an iteration.

Looping through line items.
Line item 2 returns the QBO invoice description I am looking for.
Selecting the loop iteration fails in testing. I cannot ensure the line item I need is always going to be the second line item.

Is there something I am missing? 


  • Author
  • Beginner
  • 3 replies
  • July 10, 2025

@Adil Waqas How would I capture a specific ID? 


MohSwellam
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+8
  • Zapier Orchestrator & Solution Partner
  • 902 replies
  • July 10, 2025

In the testing it will only give you the first item, but when it's on it will actually loop.