Skip to main content
Question

Trouble with bundles and single items in QuickBooks Online Zapier automation

  • Nov 22, 2024 5:25 PM UTC
  • 2 replies
  • 135 views

We have been using the QBO zapier component on and off for our company. Since the introduction of bundles in QBO, we havent been able to use this automation. Luckily with the new update on the Create Invoice component, we can now send bundles.

I am now running into issues where our company will have both bundle items, and single service items on an invoice. Is there a way to either segregate the bundle from single items prior to the Create Invoice step to set those accordingly in the Create Invoice step, or is this still not currently possible?

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

2 replies

Badger
Forum|alt.badge.img+5
  • New
  • Nov 23, 2024 11:03 PM UTC

It will depend on how the data is coming in.

For me usually a code block can separate, sort, and manipulate the data as needed. I generally get issues with line items in shopify and I have used python code blocks to sort these out.

Without seeing how the data is coming it I can’t really offer anything more.  


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • Nov 25, 2024 4:25 AM UTC

Hi ​@patrick24,

 

Welcome to the Community.

 

Thank you ​, @Badger, for pointing our member in the right direction. Zapier's QuickBooks Online integration can't dynamically differentiate between bundle and single service items in invoices, as all line items are treated uniformly. A workaround involves preparing data with identifiers (for example, tags or naming conventions), using a Filter step to separate items, and employing a Path step to handle bundles and single items differently. While effective, this approach requires meticulous data organization and may not fully address complex scenarios, which could necessitate a more customizable tool or custom-coded solution.
​
Let us know if you have further questions.