Upgrade to AbleCommerce Gold R12

PRE-UPGRADE Information:

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. Find the Product Image control in {website}\ConLib\ProductImage.ascx.cs

2. Open the file and find this line of code on or near line 152 and also on line 188.  It will look similar to this:
   
   string ResizedImageUrl = string.Format("~/GetImage.ashx?maintainAspectRatio=true&maxHeight={0}&maxWidth={0}&Path={1}", 300, Server.UrlEncode(url));

3. The upgrade will include a bug fix which removes the 300 size constraint.  So, the new code will look similar to this instead:
   
   string ResizedImageUrl = string.Format("~/GetImage.ashx?maintainAspectRatio=true&Path={0}", Server.UrlEncode(url));

4. If you do NOT want to apply this bug fix, which will display your images at their true size, then do not apply the patched file noted in step 1.

5. If you do want to apply the bug fix, but use a different image size, then you may change the value in red text above to your desired new size.

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.

1. Determine the type of version you are using, WAP or WSP, and download the applicable file.

2. Extract the contents.  Only changed files are included in the upgrade set.

3. Compare the new upgrade files with your existing ones, and merge any custom changes.

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:

Login to your AbleCommerce Merchant Menu and go to the Configure > Security > Licensing page.
The "License Details" section will indicate whether a subscription is included with your license, and the subscription's expiration date will be shown.

- OR -

Open the "commercebuilder.lic" file located in the \app_data\ folder with a txt program such as notepad. 

e.g. <subscription>05-05-16</subscription>

If your license purchase included a subscription, a line similar to the one above will be shown in your key file.  
Make sure the date is on, or after, May 5th, 2016, which is the release date for AbleCommerce Gold R12.

NOTE:  A store in DEMO MODE is not valid for the upgrade.  Make sure you have a license key installed before continuing.  The key type can be Development or Live, but not DEMO. 

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.

\web.config

Before copying the file from the upgrade folder, check to make sure that you have not made changes that will be overwritten.  It is best to use a file comparison utility (e.g. WinMerge) to view any differences before replacing your customized configuration files

For WSP versions:

1. Stop the IIS web service, or application pool, to release a lock on the DLL files in the \bin\ folder.
   
   FAQ: How do I stop a website to upgrade?

2. Copy all files, from step 1c) above, to the corresponding folders on the production server.

3. Restart the IIS web service application.

For WAP versions:

1. Recompile the application.

2. Republish to the target server.

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.

New field added to ac_Products table

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 http://winmerge.org