Skip to main content
Best answer

Update Inventory Levels In Quickbooks from Google Sheets


Hello, 

I am trying to have Google Sheets send information to QuickBooks regarding inventory levels, but i do not see any fields for updating existing products in Zapier, only to create new ones. Is this something that is not supported? Maybe a work around could be to delete the existing product and just create a new one with the new quantity that I have? Thanks in advance.

Kind regards,

Josh

Best answer by SamB

Hey @Joshua Mursic

I did some checking and you’re quite right, there currently isn’t an action to update existing products on the QuickBooks app. There isn’t a delete action either, but we don’t typically have delete-type actions as they could well end up deleting the wrong things if the Zap isn’t set up right. 

There is an existing feature request open for the ability to update existing products in QuickBooks though so I’ve added your vote for that.

Not an immediate solution I know but we’ll notify you by email as soon as it’s added. And we’ll be sure to pop back in here to post any updates on this feature request. 🙂  

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Joshua Mursic 

Good question.

You may have to use the QBO API: https://developer.intuit.com/app/developer/qbo/docs/develop

App APIs can be used in Zaps with the Webhooks app as an action step: https://zapier.com/apps/webhook/help

If you need help consider hiring a Zapier Expert: https://zapier.com/experts


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7814 replies
  • Answer
  • January 9, 2023

Hey @Joshua Mursic

I did some checking and you’re quite right, there currently isn’t an action to update existing products on the QuickBooks app. There isn’t a delete action either, but we don’t typically have delete-type actions as they could well end up deleting the wrong things if the Zap isn’t set up right. 

There is an existing feature request open for the ability to update existing products in QuickBooks though so I’ve added your vote for that.

Not an immediate solution I know but we’ll notify you by email as soon as it’s added. And we’ll be sure to pop back in here to post any updates on this feature request. 🙂  


  • New
  • 1 reply
  • January 11, 2023

How do I add my vote to this as well?

We have both an online store and storefront. We would like the inventory on the website (we use woo commerce with Zapier) to stay update to date if a sale is done in person through QuickBooks. As well as if we make a sale on the website, QuickBooks onlne inventory is updated.


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • January 14, 2023

Hey there, @MKC! It looks like your votes been added already! 🙂

We’ll be sure to email you if and when this gets implemented. Thanks for reaching out in community!