AbleCommerce version 9.0.5 - build 6938
Date of Release: September 27th, 2021.
----------------------------------------------------------\

Upgrade from AbleCommerce 9.0.4 (build 6750) to 9.0.5 (build 6938)

- Access to the server running AbleCommerce will be required.

- This download will upgrade AbleCommerce 9.0.4.6750 only.

- A valid subscription license is required; ends on or after 9/27/2021

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

### 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.5'

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

    5709043e62824c1794a04c67dc451468 

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

1. After logging in to the admin, go to Configure >  Store > Languages. Two localization strings will need to be updated manually. 
   These are for the address validation feature within the checkout.

	- Use the ADD button to add the 2 new localization strings below:

		retail.addressvalidationmodal.action.continue
		  Continue

		retail.addressvalidationmodal.action.cancel
		  Cancel

2. Find the default "Sample" theme and locate the "default.css" file.
   The file is located at \Website\Themes\Sample\Content\default.css

   Copy this file to your custom store theme's \Content\ folder.
   You should not have merge any changes unless you've customized this file.

   The list of CSS style changes is given below as a reference.

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

======== FOR REFERENCE - CSS STYLE UPDATES ============

/* MOBILE VIEW SEARCH FEATURE */
#store-header-menubar #mobile-search-icon,
header.navbar #mobile-search-icon {
    margin-top: 4px;
}

#header-dark header.navbar #mobile-search-icon {
    color:white;
}

#mobile-search-field {
    position: fixed;
	top:45px;
    left:0;
    right:0;
	padding:15px 0 15px 0;
	z-index:999;
    display:none;
}

#mobile-search-field .form-control {
	font-size:25px;
	height:auto;
	border:0;
	font-weight:400;
	box-shadow: 0 1px 5px 0 rgba(0,0,0,0.15);
}

/* SUMMERNOTE ADD LINK POP UP */
.modal.link-dialog .checkbox input[type="checkbox"] {
    display: block;
}

.modal.link-dialog .checkbox > label::before {
	display: none;
}

.modal.link-dialog .modal-title {
    margin: 15px;
}

/* HELPER STANDARD STYLES */
@media (max-width: 1199px) {
  .r-m-t-lg {
        margin-top : 15px;
    }
}


======== FOR REFERENCE - DATABASE UPDATES ============
--
-- Create table [ac_PaymentMethodShipZones]
--
CREATE TABLE [ac_PaymentMethodShipZones]( 
	[PaymentMethodId] INT NOT NULL,
	[ShipZoneId] INT NOT NULL,
	PRIMARY KEY([PaymentMethodId], [ShipZoneId]))
ON [PRIMARY]
GO

--
-- Create foreign key [ac_PaymentMethods_ac_PaymentMethodShipZones_FK1] on table [ac_PaymentMethodShipZones]
--
ALTER TABLE [ac_PaymentMethodShipZones]
	ADD CONSTRAINT [ac_PaymentMethods_ac_PaymentMethodShipZones_FK1] FOREIGN KEY ([PaymentMethodId]) REFERENCES [ac_PaymentMethods] ([PaymentMethodId]) ON UPDATE NO ACTION ON DELETE CASCADE  
GO

--
-- Create foreign key [ac_ShipZones_ac_PaymentMethodShipZones_FK1] on table [ac_PaymentMethodShipZones]
--
ALTER TABLE [ac_PaymentMethodShipZones] 
	ADD CONSTRAINT [ac_ShipZones_ac_PaymentMethodShipZones_FK1] FOREIGN KEY ([ShipZoneId]) REFERENCES [ac_ShipZones] ([ShipZoneId]) ON UPDATE NO ACTION ON DELETE CASCADE 
GO