Privacy Policy

Any data captured by CarolinaPOS forms, applications or other tools is used internally only for sales purposes or day to day business purposes only for the use of CarolinaPOS or Morton South Insurance. Data is not shared with any third party ever without your explicit permission.

Integrating QuickBooks or QuickBooks POS to 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 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.

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.

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 to QBPOS and QB.

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-353-2000 or email sales@carolinapos.com.

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

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.