AbleCommerce version 9.0.6 - build 7222
Date of Release: March 31st, 2022.
----------------------------------------------------------\

Upgrade from AbleCommerce 9.0.5 (build 6938) to 9.0.6 (build 7222)

- Access to the server running AbleCommerce will be required.

- This download will upgrade AbleCommerce 9.0.5.6938 only.

- A valid subscription license is required; ends on or after 3/31/2022

----------------------------------------------------------\

### Installation Instructions ###

TO VERIFY THE DOWNLOAD (optional):
**********************************************************\

1.  Go to WinMD5.com or any other utility that can provide checksum validation.

2.  Download the .zip file, and run the MD5 utility.

3.  Select the downloaded for 'AbleCommerce Upgrade to 9.0.6'

4.  In the field provided, copy the MD5 hash provided below, or displayed on the Upgrade page.

    d0e707a47480a7af65f3fb18b3006a3a 

5.  Click Verify and confirm the number is a match.

6.  If the validation fails, do NOT install the patch.  Instead, open a support ticket at our website.

TO INSTALL THE UPGRADE:
**********************************************************\

7. Extract contents to a temporary location on the server.

   \Lib\      --> files in this location are provided to developers; do not install these to the server.
 
   \Website\  --> files and folders located here are installed to the website.

8. Backup the website and database to a separate location.

9. Stop the website using IIS.

10. Copy everything from \Website\ to the actual website root folder, matching folders and file locations.

11. Restart the website using IIS.

12. Login to the Merchant Admin so that any database changes will be AUTOMATICALLY applied.
    
    Note: There are database schema updates for this release.
          For reference, these are noted at the bottom of this document.
 

----------------------------------------------------------\

### Post-Upgrade Instructions ###

These steps are required to utilize a new feature in 9.0.6 that allows you to select different SKINS for a Theme.

1. After upgrading to 9.0.6, make a copy of the Sample Theme.
   a) From the admin, go to Website > Store Design > Themes page.
   b) Click the COPY button for the theme named "Sample".
   c) Enter a new Theme name and click COPY button to complete this step.

2. From the server, copy and/or merge all other customized files from your current (in-use) theme folder into the new (copy of sample) theme folder created in step 1.
   Customized files include: custom.css, images, scripts, skin.css

3. From the admin, return to Website > Store Design > Themes page
   a) From the first column, select your new theme.
   b) Click the Set Default Theme button.
   c) Test your changes by viewing the storefront.

* If you have multiple themes in use, then you will need to repeat steps 1. and 2. above for each theme.

----------------------------------------------------------\
END OF UPGRADE INSTRUCTIONS
----------------------------------------------------------\



======== FOR REFERENCE - DATABASE UPDATES ============
--
-- Alter [ac_Redirects] Alter column [SourceUrl]
--
IF (SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ac_Redirects' AND COLUMN_NAME = 'SourceUrl') < 300
BEGIN
	ALTER TABLE [ac_Redirects] ALTER COLUMN SourceUrl NVARCHAR (300)
END

GO

--
-- Alter [ac_Redirects] Alter column [LoweredSourceUrl]
--
IF (SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ac_Redirects' AND COLUMN_NAME = 'LoweredSourceUrl') < 300
BEGIN
	ALTER TABLE [ac_Redirects] ALTER COLUMN LoweredSourceUrl NVARCHAR (300)
END

GO

--
-- Alter [ac_Redirects] Alter column [TargetUrl]
--
IF (SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ac_Redirects' AND COLUMN_NAME = 'TargetUrl') < 300
BEGIN
	ALTER TABLE [ac_Redirects] ALTER COLUMN TargetUrl NVARCHAR (300)
END