Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I want to add items from multiple sources to QuickBooks and send the invoice weekly. I’m able to create the first line-items in QuickBooks, but when I add the next items using update invoice trigger it deletes the items that were in the invoice before. I have a workaround planned but just wanted to know if this is really how it works.

 

 

 

 

Hi @Santeri 

Good question.

You’d first need to find the invoice to get the existing Invoice Line Items, then use logic to combine the new line items with the existing line items before updating so that all line items (old + new) are sent as part of the update.

 

QBO API - Full Update An Invoice

https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#full-update-an-invoice

Use this operation to update any of the writable fields of an existing invoice object. The request body must include all writable fields of the existing object as returned in a read response. Writable fields omitted from the request body are set to NULL. The ID of the object to update is specified in the request body.

Hi @Santeri 

Good question.

You’d first need to find the invoice to get the existing Invoice Line Items, then use logic to combine the new line items with the existing line items before updating so that all line items (old + new) are sent as part of the update.

 

QBO API - Full Update An Invoice

https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#full-update-an-invoice

Use this operation to update any of the writable fields of an existing invoice object. The request body must include all writable fields of the existing object as returned in a read response. Writable fields omitted from the request body are set to NULL. The ID of the object to update is specified in the request body.

Thanks Troy, this is a great approach.

So pleased to see Troy was able to help get you pointed in the right direction here, @Santeri! 😁

Have you got everything set up now? If you’re running into any issues on that at all please do let us know!

​@Troy Tessalone 

​@SamB , I don’t understand the solution to this. I only see one place to input line items. Do they have to be entered as comma separated values? I’m pretty aghast that this was built this way. What need would anyone have for overwriting all of their invoice data?? We’ve lost a lot of data due to this, I never would have thought to test for this because I never assumed that something that indicates having line item support would only be able to enter one line item while deleting everything else.

​Hi ​@jadecol 

The QBO Zap action is based on the QBO API: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice#full-update-an-invoice

You need to first get the existing invoice, then add logic to determine which line items to append/adjust/remove.

 

Reply


Terms & Conditions