Leveraging the Gift Wrap feature for optional upcharges to a product

Just goes to show, you still can teach an old dog new tricks. A client needed a way to add an Engraving choice to the product page.   Normally this isn’t an issue, just use the product variant feature. But in this case, the engraving choice must be optional.   And it has to charge an amount.  And it needs to accept some text for the actual engraved words. So after a little digging, I settled on a little-used feature in AbleCommerce known as Gift Wrap.    Gift Wrap is a way to associate a secondary charge to any product.   The basket ...

Nov 25, 2019 READ MORE
TortoiseSVN missing icons in Windows 7

Been scratching me head for a while now as to why my Windows Explorer icons for TortoiseSVN were suddenly missing. After some digging, it appears that DropBox updated itself and added some more shell overlay extensions.   Since Windows 7 only supports 11 overlays, this pushed the Tortoise icon entries too low in the list. The solution was simple:  edit the registry hive: HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionExplorerShellIconOverlayIdentifiers and remove the unwanted registry entries so that the TortoiseSVN entries are in the first 11 found. &nbs...

Jan 13, 2015 READ MORE
SQL 2012 Management Studio hangs clicking Files menu during database restore

I’ve had this nagging issue for months now.   Every time I go to restore a database from a backup file, I cannot click the Files menu in the left sidebar.   This didn’t happen in SQL Server Management Studio 2008.    But it happens every time in SQL Server Management Studio 2012. I enjoy using SSMS, it works well for my needs.  So it got very frustrating that it would lock up when I needed it most. I finally took the time to research and thought maybe a newer version had been released since I downloaded it.  ...

Jul 25, 2014 READ MORE
AbleCommerce Gold How To Clean Up Anonymous Users

Even though Able Gold has a manual cleanup option in the Maintenance page, it doesn’t always work well.  The problem arises from how Able must delete each user individually.  Not such a big deal when you have 500 users to clear out.   It’s a very different story when you have 2,000,000 unwanted users.   A SQL query can delete all of the unwanted records in a single command. Below is the updated query to work with Able Gold schema.  Obviously change the dates to something more recent.  If the queries do not remove ...

Apr 14, 2014 READ MORE
SQL Studio Management Expand Databases Slow

So on my development PC, I’ve noticed that it takes 2-3 minutes for the Databases node to expand in my SQL Server Studio Management 11.0.2100.60 I don’t remember exactly when it started.   But it’s been several months I think.  It was just too easy to ignore since I could alt-tab and do something else while it worked through the delay. Today I decided to research it and determined it’s because some databases have auto_close turned on.   This causes the SQL server to have to start up the database before it can render it in the Databases node...

Apr 14, 2014 READ MORE