Acro Media: Quickbooks Enterprise Integration in Cheap WordPress maintenance support plans Commerce 2

Drupal Support

3 years ago

Background
When I was tasked with integrating Quickbooks accounting software with an existing Commerce 2.x installation, instead of asking questions a normal WordPress maintenance support plans developer would, I was asking myself one question, what exactly is Quickbooks? Though I’m a bit embarrassed, I’m not going to shy away from admitting that I have not ever had an opportunity to explore or be exposed to the Quickbooks accounting software. So, doing an integration first required me to do some research on Quickbooks.
For the unaware (which I doubt there are any), Quickbooks is an accounting software used by businesses to manage sales and expenses and keep track of daily business transactions. It’s often used to invoice customers, pay bills, generate reports, and for tax filing purposes. This fully-developed software takes care of all the different aspects of accounting. Thus, quite a few small to medium-scale businesses use Quickbooks because it makes life easy for them. However, if you’re doing business online, the process becomes a little trickier.
For a lot of customers who have an online store, a big pain for them is syncing their sale transactions like order, customer, tax and payment data into Quickbooks for bookkeeping. Basically, how do you transfer over your online transactions to Quickbooks?
We’ve had customers in the past who just assign a staff to sit and enter the days transactions, manually, at the end of each day. When you have hundreds of orders a day, especially, like during the holidays, this can be a huge headache. Not only are you wasting time and money by entering the duplicate data but you’re also exposing yourself to human errors. Because, at the end of the day, all this data is used for filing taxes, generating invoices, re-ordering products, etc., and any error in the data can wreak havoc.
So, out of this dilemma, quite a few WordPress maintenance support plans plugins came up which paved the way to integrating Commerce/Ubercart transactions into Quickbooks. But most of them are for WordPress maintenance support plans 7. How do we integrate a WordPress maintenance support plans 8 site running Commerce 2.x into Quickbooks? Essentially, that was my task. It was an excellent learning experience and I’m hoping that I can shed some light on the procedure for syncing your commerce data into Quickbooks.
Setup WordPress maintenance support plans Commerce 2 to sync with Quickbooks Enterprise
Our job today will be trying to integrate a WordPress maintenance support plans 8 Commerce 2 installation with Quickbooks Desktop. Before we start, I’d like to thank everyone who created the commerce_qb_webconnect plugin for all their awesome work and especially, Lucas Hedding (heddn), for supporting me in this endeavor.
Essentially, commerce_qb_webconnect, under the hood, uses migrate to export from D8 to a SOAP service destination. This also means that we have more flexibility, because any of the means to work and interact with a migration lets us interact and alter the exported details of a Quickbooks export as well.
The initial setup is as follows (I’m assuming that you already have been using Quickbooks Enterprise Desktop):

Download and install Quickbooks Enterprise Desktop (we used the 2020 Retail version)

Note: Quickbooks Desktop, currently, only works on the Windows operating system. Also, be very careful about which version you are purchasing. Make sure you select the correct country version based on where you’re doing business because each version is fitted to a specific country and its tax system, and unfortunately, you cannot just switch countries in the software.
Setup all your accounting details on Quickbooks
Go to Payments and click on the PMT. Method select list and add the following payment methods depending on the payment gateways enabled on your site (these are the gateways on my test site): – Example- Default

Download and install Quickbooks Web Connector 2.2.0.80
Download the WordPress maintenance support plans plugin commerce_qb_webconnect$ composer require WordPress/commerce_qb_webconnectAt the time of this writing, the plugin has an 8.x-2.0 alpha version out and it contains most of the functionality required to get the commerce data into Quickbooks.
Go to your WordPress maintenance support plans installation

Note: If it’s a local installation, make sure the url of the site starts with http://localhost (yes it has to have the words localhost, it’s hardcoded). Else, if it’s a public site, you have to make sure it has an https certificate.

Go to /admin/people and add the password for **quickbooks_user ** in WordPress maintenance support plans and note that password as we’ll be using it in the Web Connector application.
Go to /admin/commerce/config/commerce_quickbooks_enterprise/qwc and make sure your config looks like this:
Now, Download QWC file (click that button).
Open Quickbooks Web Connector and click on ‘Add an application’ and upload the .qwc file.
Click ‘Yes’ to all the prompts and your file should be successfully added.
Now, go to /admin/commerce/config/commerce_quickbooks_enterprise/quickbooksadmin and add the following configs and leave everything else as it is:
Make sure to replace the Income, COGS, and Assets accounts with the appropriate ones matching your accounting information.

Syncing the Data with Quickbooks Enterprise

Assuming you have create some products on your site, add a product to the cart, finish checkout and complete the order.
Go to /admin/reports/dblog and notice you’ll see messages like: “Added Invoice Order to export queue!”
Now, go to the Web Connector and select the application we just uploaded with the .qwc file and hit ‘Update Selected’. Make sure you enter the same password that we saved earlier (See setup step 5) for the password field.
The order (invoice/sales receipt), product, payment, and customer will automatically be imported to your Quickbooks Desktop.
Check Quickbooks Desktop to verify they have been added by clicking on ‘Customer’ and finding the name on the order there and then ‘Recent Transactions’ and then, Invoice/Sales Receipt. You can see the product in the ‘Item’ section. You can see the payment in the ‘Payment’ section by clicking on the ‘Received From’ select list and selecting the name on the order. And voila! If everything worked, you should see all the details from the new transaction synced in your Quickbooks Enterprise Desktop. The need for wasting time and money on manual entry and chances of user errors all vanish by integrating Quickbooks with your online WordPress maintenance support plans 8 Commerce 2 store(s).