Upgrade to AbleCommerce Gold R6

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 here 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>09-17-13</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, September 17th, 2013, which is the release date for AbleCommerce Gold R6.

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

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.

In this release, each registered user, that is not already part of a group, will be assigned to a system group named _Default_.  This includes any registered user who is part of a group assignment through a subscription.  The new group _Default_ will be automatically assigned through the upgrade process and during normal operations of the store, including checkout and manual user creation.

By having this automatic group assignment, we are able to utilize the new registered users-only storefront feature.

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

USPS Patch -

If you did NOT install the July 28th patch, then you will need to delete all USPS services/methods and re-configure them.

Informational Only - Database Changes

1. In ac_Products table new field EnableGroups is added

EnableGroups BIT DEFAULT 0 NOT NULL

2 (a). New table ac_ProductGroups added

CREATE TABLE ac_ProductGroups(
    ProductGroupId int IDENTITY(1,1) NOT NULL,
    ProductId int NOT NULL,
    GroupId int NOT NULL,
    PRIMARY KEY(ProductGroupId))

2 (b). Constraints for ac_ProdutGroups table added

ALTER TABLE ac_ProductGroups
ADD CONSTRAINT FK_ac_ProductGroups_ac_Products FOREIGN KEY (ProductId)
REFERENCES ac_Products (ProductId) ON UPDATE NO ACTION ON DELETE CASCADE

ALTER TABLE ac_ProductGroups
ADD CONSTRAINT FK_ac_ProductGroups_ac_Groups FOREIGN KEY (GroupId)
REFERENCES ac_Groups (GroupId) ON UPDATE NO ACTION ON DELETE CASCADE

2 (c). Index for ac_ProdutGroups table added

CREATE UNIQUE INDEX IX_ac_ProductGroups_Unique ON ac_ProductGroups (ProductId, GroupId)

3. New user role named 'Authorized User' added.

INSERT INTO [ac_Roles] ([RoleId], [Name], [LoweredName]) VALUES ( 8, 'Authorized User', 'authorized user' );

4. New group named '_Default_' added

INSERT INTO [ac_Groups] ([GroupId], [StoreId], [Name], [IsReadOnly]) VALUES ( 8, 1, '_Default_', 1 );

5. The new group created in 4 is assigned the new role created in 3

INSERT INTO [ac_GroupRoles] ([GroupId], [RoleId]) VALUES ( 8, 8 );

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