21. February 2013 11:24
For years I have worked to improve the transfer speed of my AbleCommerce Web Connector for Quickbooks. But there’s only so much you can do in code. The rest is up to the internet connection, the speed of the Quickbooks PC and Quickbooks itself.
A client of mine found a document that details how to increase the cache memory allocation of the Quickbooks database engine. So he passed it along to me to try.
Why increase the cache memory you ask? Because the default is a whopping 512mb of RAM. Even if your PC hosting the quickbooks company file has 8gb of RAM, the database engine will only ever use 512mb. Way to keep up with the times Intuit.
Read the attached document and follow the steps. It will require a change to the registry. So know what you are doing, or find someone who does.
The reward is worth it. My larger QB connector clients were taking 2.5 hours to transfer 300+ orders in a single transfer session. Now it takes 20 minutes. Yeah. You read that right. 20 minutes. Same internet. Same PC. 20 minutes instead of 2.5 hours. That’s how much of a difference this can make for your QB installation.
Here’s the PDF.
3. June 2009 09:19
Demo versions for my QuickBooks Web Connector for AbleCommerce 7 have been updated to the latest v1.5 of the product.
There are now two flavors of the demo. This was necessary to accomodate for the new OrderNumber field found in AC 7.0.2 and later. You can find the demos at http://www.AbleMods.com/Downloads.aspx
The only limitation in the demo is that all dollar amounts will transfer as .01 into QuickBooks. Otherwise the demo is identical to the full version.
3. June 2009 09:07
QuickBooks Web Connector v1.5 released June 1st, 2009. This release includes several more fixes to resolve problems with international ASCII characters causing certain orders to fail during transfer.
I've also spend a great deal of time rebranding the product. Originally, my module was designed under the name of "Solunar" because that's all I was. I never really meant to get into the programming business full time. It just sort of happened. So as business grew, I moved what programming I was selling over to a new site www.AbleMods.com. However I left some of my original products named "Solunar".
That has now changed and the AbleMods name sits proudly in front of every file. Ok, so maybe it's not that glamorous of a change but it does feel good to get that off my plate.
Documentation has been updated in v1.5 to include additional setup details and some useful troubleshooting tips.