Released Version: AbleCommerce Gold, Release 12, Build 9168
Release Date: 05/05/2016
Change Log from Gold R11 to Gold R12
Applies To: This upgrade can be applied to existing AbleCommerce Gold R11 (build 8643) or Gold R11 SR1 (build 8858) installations.
Download: After logging in to your account, you can visit the Downloads page to obtain the file(s) needed for upgrading.
Upgrading from older versions of Gold: If you are using AbleCommerce Gold R10 or lower, then you can apply incremental upgrades as needed, so that you will be using R11 before applying the upgrade to R12. If you are behind on upgrades, you can also install a full version of R12 and migrate any customizations, themes, and data to the new install. See the "Automatic Database Upgrade" section below for more information.
Upgrading from AbleCommerce 7.0.x: If you are upgrading from AbleCommerce 7, please go here first for instructions, and then you will still be able to upgrade to the latest version of AbleCommerce Gold.
Patches: You should apply
the Service Release for Gold R12
before applying any newer hot patches.
This upgrade includes a bug fix that may affect your standard product image sizes and how they are shown on the retail product pages. Please read this first before applying the upgrade.
Images can be uploaded and resized automatically through AbleCommerce. The auto-resizer creates images that use the size settings from the Configure > Store > Images page. The default size for a standard product image is 500px, although you can adjust this setting as needed.
Within the code that displays the size of a product image, we had a size constraint so that image was shown as 300px. This is a bug which has been fixed for Gold R12. However, you should be aware that after applying the fix, your standard product images may be larger and will now match their true size. This may be undesirable if you have customized your product pages to work with the smaller 300px images. Applying this change is optional.
If you do not want to show your product images as their true size of 500px, or you wish to show them with a different size, then follow the steps below.
1) Download Upgrade to temporary location
This upgrade is available to active subscription holders. To obtain the file, login to the ablecommerce.com website and go to the customer account area. From the Downloads tab, in the top section, you can see all files that are available to you by subscription. Be sure to download the files and keep an original for backup.
2) Confirm License
Do not install the upgrade unless your license subscription is valid through the "release date" of the build you are installing, or you have a license key for the latest version. The license key for Gold R12 is 7.0.92
There are two ways to see if you have a valid subscription for this upgrade:
to your AbleCommerce Merchant Menu and go to the Configure
> Security > Licensing page.
- OR -
Open the "commercebuilder.lic" file located in the \app_data\ folder with a txt program such as notepad.
If your license purchase included
a subscription, a line similar to the one above will be shown
in your key file.
3) Backup your Existing Production Files and Database
Always make a backup copy of the entire AbleCommerce folder and the database before beginning any upgrade..
4) Installation of New Files to Production Server
In this release, there is one configuration file that will be adjusted to fix a few minor issues.
5) Automatic Database Upgrade
When you login to the merchant administration for the first time, the database will be upgraded automatically. The database changes will be completed regardless of which AbleCommerce Gold version you are upgrading from.
For a complete list of database changes, see below.
6) Automatic Re-index
If you are using the Lucene search provider, we will re-index the database automatically after the upgrade. Re-indexing could get interrupted if the server is restarted. If this happens, simply access the Website > Indexes page to manually re-index the database.
7) Post-Upgrade Instructions and Information
IMPORTANT INFORMATION REGARDING NEW ENCRYPTION
After upgrading, you may experience a problem with the gateway (payment, tax, or shipping) configuration data disappearing. Please confirm the gateway settings have not been lost by logging into the Merchant Admin and viewing the configuration page for any gateway that you have enabled. If the fields containing connection data are blank, then this issue needs to be fixed by following the instructions in Machine Key and Encryption. Otherwise, your encryption is working fine.
- - -
There are no post-upgrade upgrade steps for this release. However, if you are upgrading from a version prior to Gold R11, then make sure you follow any post-upgrade instructions that may be included for earlier releases.
INFORMATIONAL ONLY - New Email Templates
In this release, there are two new email template files that will automatically be added to the installation.
~\App_Data\EmailTemplates\Default\Product Review Submitted.html - used when a new product review is submitted
~\App_Data\EmailTemplates\Default\Restock Notification.html - used with the new restock notification feature
Informational Only - Database Changes
The database changes will be automatic after upgrading. It is NOT necessary to make changes manually. This is provided for informational purposes only.
EnableRestockNotifications BIT DEFAULT 0 NOT NULL
Size and data type of three fields changed for c_Transactions table from CHAR(1) to VARCHAR(16)
AVSResultCode CHAR(16) NULL
CVVResultCode CHAR(16) NULL
CAVResultCode CHAR(16) NULL
New table ac_RestockNotify added
RestockNotifyId INT IDENTITY NOT NULL
ProductId INT NOT NULL
ProductVariantId INT NULL
Email NVARCHAR(255) NOT NULL
LastSentDate DATETIME NULL
If you need to merge any customizations,
we recommend that you use a file compare and merge utility such
as WinMerge. WinMerge is Open Source file compare and merge
utility which runs on all modern Windows versions. Latest
WinMerge version and other WinMerge information is available at
A division of Able Solutions Corporation - Vancouver, WA