Upgrade to AbleCommerce Gold R8

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.

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>06-05-14</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, June 5th, 2014, which is the release date for AbleCommerce Gold R8.  

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

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 upgrade release, there are 2 configuration files that will be adjusted.  

\web.config

\global.asax

Before copying the files 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.  For Gold release R8, the SLN file is upgraded to support Visual Studio 2012/2013.

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.  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

Upgrade your Theme -

Two simple style changes will be needed for this release.  The files are located in the \App_Themes\ folder, and then in the sub folder you are using for your own theme.

Change 1)  On or near line 790 of style.css, add the following:

.checkoutErrorMessage{font-weight: bold; color: #FF0000;}

in the section:

/* handle option sections on receipt page */

Change 2)  On or near line 295 of mobile.css, add the following:

div.editLink { padding: 10px 0 0 0;}

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.

* Three new field added to ac_WishlistItems

IsSubscription BIT DEFAULT 0 NOT NULL

Frequency SMALLINT DEFAULT 0 NOT NULL

FrequencyUnitId TINYINT DEFAULT 0 NOT NULL

Field's default value changed for ac_Subscriptions and ac_SubscriptionPlans tables

RecurringChargeModeId field's default value was 0 which is now changed to 2

Composite key removed and identity primary key field added to ac_UserPasswords

UserPasswordId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_UserGroups

UserGroupId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_UpsellProducts

UpsellProductId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_RelatedProducts

RelatedProductId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_ProductOptions

ProductOptionId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_ProductKitComponents

ProductKitComponentId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_OrderStatusActions

OrderStatusActionId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_OrderCoupons

OrderCouponId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_EmailTemplateTriggers

EmailTemplateTriggerId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_EmailListUsers

EmailListUserId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_CouponCombos

CouponComboId INT IDENTITY NOT NULL

Composite key removed and identity primary key field added to ac_BasketCoupons

BasketCouponId INT IDENTITY NOT 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