Recently I had to connect a WooCommerce store to Quickbooks Online.
The solution was straightforward – use Zapier. Here is a high-level overview:
- Create a WooCommerce trigger every time an order is placed.
- Use the Quickbooks Online action to search for the user and create a Quickbooks Online user if it doesn’t already exist.
- Create a Formatter action to get the order total minus taxes. (We do this because WooCommerce & Zapier are idiots when it comes to taxes.)
- Create a Formatter action to get the total taxes. (See note in #3.)
- Create a Quickbooks Online action to create the sales receipt.
That’s it! See screengrabs & notes below.
- Zapier view of how to create a Quickbooks Online Sales Receipt every time a WooCommerce order is complete.
- WooCommerce + Quickbooks Online + Zapier Total Minus Tax
- WooCommerce + Quickbooks Online + Zapier Tax Total
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!
More posts from themightymo.com
How to merge multiple .csv files via command line
Today I downloaded 29 csv files with tax information. I could import those files 1 at a time into WooCommerce, but wouldn’t it be nice if I could merge them first and then only import a single file? The unix command is simple – just navigate to the folder with all the csv files and…
15 Best WordPress Support and Maintenance Services for 2023: Ensuring Your Website Stays in Top Shape
Small business owners and non-profit leaders know that keeping your website secure, fast, and fully-functional is critical to success. Here’s the unspoken truth: You can either learn how to do all that tech maintenance and development stuff yourself, or hire someone else to do it. But let’s face it, doing it yourself isn’t always the…
How to Whitelist SEM Rush IPs in Cloudflare
Alright, I’m going to show you how to whitelist a set of IPs on CloudFlare. In our case we use SEMrush and we want to make sure the SEMrush has full access to our sites.