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
The Mighty Moo! WordPress Theme Update
About 1 year ago, I built The Mighty Moo! WordPress theme. It is a fun theme that features an AJAX “accordion” navigation system built on MooTools and MooFx. Today, I spent much of the day updating the theme so that more novice users will be able to use it out-of-the-box. It isn’t quite ready for…
Testing Out Intense Debate
Today I spent some time installing Intense Debate (ID) on cryns.com. ID is a nice, little plugin for WordPress (fyi: ID was purchased by WordPress’ parent company in September 2008) that manages your comments. With WordPress 2.7’s threaded comments feature, ID’s feature set isn’t all that much of an improvement. But ID recently announced that…
Make WordPress Work for You: How to turn your self-hosted WordPress blog into a totally rocking Content Management System (CMS)
WordPress Presentation What we might cover How many people have a website or blog? Brainstorm ideas for websites. What do you want your website to do? WordPress as a CMS Examples: GBSSA.org, TeamUpMn.org, Letronica.com (http://www.letronica.com/content/), cryns.com Switching WordPress from a Blog to a CMS Photo Gallery: http://www.cryns.com/category/photos/ Post by email iPhone Application Cool Plugins: Podpress…