Point of Sale, eCommerce and QuickBooks Online Integration Made Easy!

Oh yeah, who hasn’t pulled their hair out when trying to synchronize all the working pieces of their accounting software, point of sale software, shopping cart and middle-ware? If you can’t see me, I’m in the back office pulling out my hair. Ouch.

But there is a better way! MBC (that’s us at Morton Business Consulting) can make all the pieces work.

We offer two very distinct but very workable solutions:

QuickBooks Online with WooCommerce Shopping Cart and WooCommerce POS

This is the ultimate online solution. Use QuickBooks Online to manage your accounting and inventory control. Use WooCommerce to sell online via its shopping cart. Use WooCommerce POS to sell to your brick and mortar customers. All integrated!

QuickBooks desktop (Pro, Premier, Enterprise) with WooCommerce Shopping Cart and QuickBooks Point of Sale

This is a traditional way of doing things. Use QuickBooks desktop perform your accounting, use WooCommerce to sell online and use QuickBooks Point of Sale to manage your inventory and sell to your brick and mortar clients.

MBC can get all of this set up for you. Call us at 843-936-0632 or fill out the form and we will reach out to you.

QuickBooks POS – Invalid Product Number: Error 176109

Solution 1: Delete the contents of the entitlement client folder

  1. Using Windows Explorer, navigate to: C:\Program Data\Intuit\Entitlement Client\v8.
  2. Press the CTRL+A on your keyboard to select all the files in the folder, then press Delete.
  3. Select Yes to confirm the action.
  4. Relaunch QuickBooks Desktop Point of Sale and re-register the application.

Solution 2: Rename the WSActivity file

  1. Using Windows Explorer, navigate to: C:\Program Data\Intuit\QuickBooks Point of Sale XX\Ini
  2. Right-click WSActivity and select Rename.
  3. Enter OLDWSActivity and click anywhere to save.
  4. Close the window then delete the entitlement again.
  5. Relaunch QuickBooks Desktop Point of Sale.

QuickBooks POS Firewall Settings

Configure Windows firewall

  1. On your keyboard, press Windows+R to open the run command.
  2. Type in control, then click OK to open the Control Panel.
  3. Set the “view by” to Small Icons, then select Windows Firewall.
  4. Select Advanced Settings, then choose Inbound.
  5. Click New Rule.
  6. Select Port, then click Next.
  7. Enter the port numbers, then click Next (See Point of Sale Firewall Ports section).
  8. Select Allow Connection, then choose Next.
  9. Name your firewall rule (e.g. POS), then click Finish
  10. Follow steps 5-9 to create a new Outbound Rule.

Point of Sale Firewall Ports

PORTPORT NUMBERS
TCP
(Incoming)
8040, 8443, 8036, 8035, 8025, 8024, 46228, 46225, 46216-46220, 46203, 2638, 443
UDP
(Outgoing)
8036, 8035, 8024, 2638

Integrating QuickBooks or QuickBooks POS with a Shopping Cart

Generally, there are just a handful of good ways to connect QuickBooks Point of Sale to an online shopping cart, same for QuickBooks desktop (QuickBooks Online will be covered later). You have to use middleware. Middleware is the software that translates the data between QuickBooks and your shopping cart.

Preferably you are going down this path with the horse in front of the cart. Meaning, do some research before building a website and then wanting to retroactively connect to QuickBooks as you’ll find that not all shopping carts will connect to QuickBooks without spending a lot of consulting dollars to make it work.

To make all this work, you need QuickBooks POS or QB desktop (Pro, Premier or Enterprise) or QB Online; a shopping cart and website and middleware. My personal favorite is QuickBooks POS with a connection to QB desktop, my own website hosted on my domain name using WordPress as a content manager and WooCommerce as my shopping cart.

I am going to focus on the middleware for this conversation. Both QuickBooks POS and QuickBooks financial software are similar in how they connect. Of course there are some differences that I’ll mention as needed.

A lot of the middleware out there provides similar functionality. They all offer comparable functionality in levels such as basic, pro, multistore, etc… And they are all priced as an ongoing subscription service.

This is not an all-inclusive list of middleware providers nor are they rated in order.

Webgility eCC: Webgility offers eCC for desktop versions of QBO and QB, and eCC Cloud for QBO. Offered as a subscription service with levels based on features and order volume. Sync with QBPOS for inventory quantity starts on the first level of Premium (a step above Lite). A bit pricey in my book but offers a boatload of integrated features. Webgility is also a well-established company with top-notch support. I think it fits well with a medium to large scale company with lots of sales volume in ecommerce.

A while back, a very inexpensive WooCommerce connector called 61Extensions came out and was a hit but they had bad business management and went under. Some of its customers got together and bought the website and now point to a connector called MyWorksSync. A moderately priced subscription service connecting WooCommerce, Shopify and Magento (and others) to QBPOS and QB.
6/17/2020 – so far so good on using a new connector between QBPOS v18 and WooCommerce. It has a wordpress interface that talks to Intuit’s Web Connector that then transfers data to and from QBPOS. Their pricing is very reasonable and they actually answer their phones, respond to email, and provide a Slack account access.

Atandra T-Hub: Atandra offers an online version for QBO and a desktop version for QBPOS and QB. Offered as a subscription service with various levels – note that you connect to QBPOS with the Pro version, you can’t sync inventory quantities until the Advanced level. You pay for features – not volume. Pricing is reasonable to me for the Advanced feature set. Atandra has been around for a long time and support is reasonable in its turnaround.
6/17/2020 update – It is disappointing to say this but Atandra’s support has slipped a lot. It has taken a lot of brow-beating to get them to respond, if they respond at all. T-Hub does not sync categories from QBPOS to WooCommerce – what a major fail! Just based on this lack of support – I can no longer recommend Atandra T-Hub.

Connex for QuickBooks: Connex is a subscription service with various levels – note that you can’t sync inventory quantities or attach to QBPOS until the Pro level. You pay for features and for order volume. For QBPOS, it uses a proprietary web connection to send data between QBPOS and your shopping cart. For QB, it uses Intuit’s Web Connector.

If you want an assist on getting this up and running for your business, give us a call at 843-936-0632 or email sales@mortonbusinessconsulting.com