How to improve Quickbooks Web Connector Speed

by Joe Payne 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.

Tags: , , ,

AC7 Articles | General News | Personal | QuickBooks Connector | Tech Support

AbleCommerce IE10 and Windows 8 problems

by Joe Payne 27. November 2012 11:35

IMPORTANT UPDATE from AbleCommerce

Microsoft has confirmed that there are known issues when using the latest IE10 browser and certain code that might be in Asp.Net 2.0 or Asp.Net 4.0 sites. All AbleCommerce 7.0.x stores are affected by these issues, so you should carefully read the available options and take corrective action.

!. Javascript disabled in IE10 due to outdated browser definitions file

2. ImageButtons do not work in IE10 when using .net 4.0 and older

Microsoft has made an official patch available for one of the issues. It is unknown, at this time, if Microsoft plans to release another patch for the second issue. As such, AbleCommerce is providing a work-around that can be applied to your AbleCommerce store.

You should fix both issues by following the instructions found on the AbleCommerce help site.

Tags: , , ,

General News | Tech Support | AC7 Articles

Slick little GeoIP feature for the AbleCommerce Order Manager

by Joe Payne 28. August 2012 21:20

Came up with an awesome mod for the Order Manager screen tonight.  It highlights orders that are placed from non-US IP addresses.  This makes it incredibly easy to identify potential fraud orders in your storefront.

This mod works with a local GeoIP database too, so there’s no lookup limits or bandwidth spikes to worry about.

Geographic IP lookups are a dime a dozen on the internet.  But the vast majority of these lookup sites will throttle the number of requests.  This creates a slow and often frustrating limit on the usefulness in a production environment.

By leveraging a local database, it becomes far more efficient (and less costly) to implement GeoIP lookups in your AbleCommerce website.

Tags: , ,

General News | AC7 Articles

Automatic Abandoned Basket Reminders

by Joe Payne 22. June 2012 09:06

Put together a really nice automation routine for a client recently.

The client needed a way to fully automate abandoned basket reminders.  But the key is they only wanted to send the reminder X number of times. 

Thanks to some code from a few previous projects, I was able to put together a modification that changed only 1 existing AbleCommerce file.

Now their AC7 store will automatically scan for abandoned baskets at regular intervals.  Any baskets found are sent the designated email.  Once the email is sent, a marker is placed on the basket so the shopper isn’t spammed with reminders.  Even wrote a handy config page so the client can adjust the designated email template or the criteria without further program customization.

Tags: , ,

General News | Personal

AbleCommerce 3DS Implementation

by Joe Payne 22. June 2012 09:02

Did a great 3DS modification recently for a client.  Actually got it to work as a modal popup during checkout instead of requiring additional pages.  If the 3DS validation fails, the shopper returns to Checkout just like they should.

Took us a few weeks of live testing to work out the remaining kinks.  But those are gone now and the routines work rock-solid.

Tags: , ,

General News | Personal

Month List