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!
From Toby’s Blog
- How Digital Ocean Cost Us Thousands of Dollars in a Single DayHere’s the rub for me: My belief is that bad stuff happens, and you need to own it. Digital Ocean definitely did not own it in this case. I wonder how the original founders of Digital Ocean would have reacted had they been in charge… For example, wouldn’t it be nice if an actual human… […]
- Where uncertainty exists, don’t order specific.4 Idiot Case Studies with 2 simple age-old business lessons. The post Where uncertainty exists, don’t order specific. appeared first on Toby Cryns, WordPress Trainer in Minneapolis, MN.
- “Now THAT was a good meeting!”A single effective meeting can change the course of history for a company. Imagine if you could lead effective meetings EVERY DAY! You can, but it takes curiosity & practice. This article is a good place to start your journey to a more effective you. The post “Now THAT was a good meeting!” appeared first […]
More posts from themightymo.com
How to style FacetWP checkbox hierarchy results using jQuery
I recently invested many hours trying to target and style a FacetWP taxonomy facet that uses hierarchy for display. It should be noted that you can use straight up CSS for some styling (and should use css wherever possible), but sometimes you need javascript to target parent elements and such. I thought I’d document the…
How to fix SpinupWP ballooning disk space issue
A site we host on Digital Ocean recently went down. It took me a lot of troubleshooting and digging before realizing that the issue was that our disk space was maxed out on Digital Ocean. The site in question needs ~20gb of space, so our 50gb server should be plenty. But alas, there it was…
Google Removed Our Business Listing – How we restored our biz to the Map and got our reviews back.
I was about to send an email to a potential customer pointing them to our 5-star Google Reviews via our Google Business profile (e.g. the Google Map), hoping this added information about our customers’ past experiences might help me close a deal. But when I checked the Google Reviews link, it was down. And after…
From Toby’s Blog
- How Digital Ocean Cost Us Thousands of Dollars in a Single DayHere’s the rub for me: My belief is that bad stuff happens, and you need to own it. Digital Ocean definitely did not own it in this case. I wonder how the original founders of Digital Ocean would have reacted had they been in charge… For example, wouldn’t it be nice if an actual human… […]
- Where uncertainty exists, don’t order specific.4 Idiot Case Studies with 2 simple age-old business lessons. The post Where uncertainty exists, don’t order specific. appeared first on Toby Cryns, WordPress Trainer in Minneapolis, MN.
- “Now THAT was a good meeting!”A single effective meeting can change the course of history for a company. Imagine if you could lead effective meetings EVERY DAY! You can, but it takes curiosity & practice. This article is a good place to start your journey to a more effective you. The post “Now THAT was a good meeting!” appeared first […]