Skip to main content
Question

How do I sync WooCommerce data and Woo Payments to QuickBooks Online and update invoices?


Hi I just started using QuickBooks Online and trying to automatically sync data from my WooCommerce store. I am using Woo Payments to process order payments. When a new order is placed I need a new invoice or sales receipt created in QBO with all relevant data including the WooCommerce order number. When the payments in Woo Payments are deposited (sent to my bank - once a day) I need the invoice or sales receipt that was previously created updated with the processing fees from Woo Payments and marked as paid. Thank you!

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 @Radar-Mirror 

Check out the available Zap triggers/actions for each app:

QBO: https://zapier.com/apps/quickbooks/integrations#triggers-and-actions

WooCommerce: https://zapier.com/apps/woocommerce/integrations#triggers-and-actions


  • Author
  • Beginner
  • 3 replies
  • January 9, 2024

Thank you for the information. Creating a new invoice in Quickbooks is not a problem, I haven’t been able to find any information that lets me know if the processing fees are included. 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6423 replies
  • January 10, 2024

Hi there @Radar-Mirror,

I’m jumping in to see if I can help.

Have you tried using the “New Order” trigger in WooCommerce? Based on what I’m seeing in the representative sample data it’s able to return some sort of “fee”:

69db6c96366b4a3b761cc9ee6c17d5fe.png
(view larger)

Have you tried setting up your Zap and checking if the “fee” data you’re looking for is being returned in the trigger step?


  • Author
  • Beginner
  • 3 replies
  • January 10, 2024

I haven’t done it yet, I was hoping someone could give me a firm yes and how to do it. I’m not used to having to map fields individually and most I’m not even sure what they are describing.