WooCommerce to Quickbooks Online

Recently I had to connect a WooCommerce store to Quickbooks Online.

The solution was straightforward – use Zapier.  Here is a high-level overview:

  1. Create a WooCommerce trigger every time an order is placed.
  2. Use the Quickbooks Online action to search for the user and create a Quickbooks Online user if it doesn’t already exist.
  3. Create a Formatter action to get the order total minus taxes. (We do this because WooCommerce & Zapier are idiots when it comes to taxes.)
  4. Create a Formatter action to get the total taxes. (See note in #3.)
  5. Create a Quickbooks Online action to create the sales receipt.

That’s it!  See screengrabs & notes below.

NOTES:

  • This Quickbooks Online verbiage took me a while to understand… In Quickbooks Online, “Sales Receipts” are for automatic orders that are processed by your WooCommerce website.   “Invoices” refers to when you create the invoice manually in Quickbooks Online and click the “Send to Customer” button in Quickbooks Online.
  • As you see above, taxes doesn’t quick work properly.  My solution above is definitely a hack.  Please let me know if you figure this tax puzzle out!

 

Posted in

Toby Cryns

RSS From Toby’s Blog

More posts from themightymo.com

WordPress Support

The Ultimate Guide to WordPress Support: Why it’s Essential for Your Website’s Success

By The Mighty Mo! Design Co. | September 25, 2023

Whether you’re situated in Minneapolis, St. Paul, Illinois, New York, or any other corner of the globe, ensuring reliable WordPress Support is paramount for the continued success of your website. In this comprehensive guide, we will delve into the crucial role that WordPress support plays in your website’s journey to success.

sem rush log file analyzer

How to optimize your Google Crawl Budget using SEM Rush Log File Analyzer and Rank Math SEO

By The Mighty Mo! Design Co. | September 22, 2023

Today I ran the SEM Rush Log File Analyzer tool, and it showed some interesting things that are a complete waste of our Google Crawl Budget. Specifically, I learned that Google is wasting some of our crawl budget on the /wp-includes/ directory, certain plugin directories, and cache directories. I also noticed random files being crawled…

google analytics definitive guide

Where is the Google Analytics Measurement ID?

By Toby Cryns | August 16, 2023

In the vast, evolving world of web development and analytics, keeping up with terminologies and tools can sometimes feel like trying to chase a mischievous cat in a maze. You think you’ve got a grip, only for it to slip right through your fingers! Enter the mysterious “Measurement ID” from Google Analytics 4 (GA4), a…

RSS From Toby’s Blog