AbleCommerce version 9.0.11 - build 9287
Date of Release: June 30, 2025.

** Subscription Release Date: May 8th, 2025 **
----------------------------------------------------------\

Upgrade from AbleCommerce 9.0.10 (build 8121) to 9.0.11 (build 9287)

- To view the change log: 
  https://help.ablecommerce.com/index.htm#t=upgrades%2FAC9_CMS%2Fchange_logs%2FChange_Log_from_AC_9.0.9_to_AC_9.0.10.htm

- For additional upgrade options, refer to the following help site link: 
  https://help.ablecommerce.com/index.htm#t=upgrades%2FAC9_CMS%2FUpgrade_to_AbleCommerce_9.0.10.htm 

- Access to the server running AbleCommerce will be required.

- This download will upgrade AbleCommerce 9.0.10.8121 only.

- A valid subscription license is required; ends on or after 05/08/2025

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

### Installation Instructions ###

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

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

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

3. Stop the website using IIS.

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

5. Restart the website using IIS.

6. Login to the Merchant Admin so that any database changes will be AUTOMATICALLY applied.
    
    Note: There are database changes in this release. (See below for details)

 
----------------------------------------------------------\
### Post-Upgrade Instructions ###

1. After logging in to the admin, go to Configure >  Store > Languages. 
   Go to Edit Resources page to add the following localization string. 

	- Use the ADD button to add the 1 new localization string below:

		NAME:
			retail.search.sortexpression.relevance

		TRANSLATION: 
		
			Relevance

** If the localization name already exists, search the name and edit the translation.**

2. A change to the \Website\Themes\{your theme name}\Content\skin.css
   Around line 200, find the following code -

   Change from: 
                .sidebar .field-validation-error span, .field-validation-error {
	        color: #cc5965;

   Change to:  
                .sidebar .field-validation-error span, .field-validation-error {
	         color: #cc5965 !important;
   

### Post-Upgrade Important Information ###

---------------------------------------------------------------------------
CAPTCHA ON PAYMENT FORMS:

   Retail Payment forms now have Captcha options. It is enabled by default. 
   To disable, Edit the "Payment Form" and the "Pay My Order" widgets. 
   Go to Website > Store Design > Widgets. Use the Edit button and change 
   the Enable Captcha setting to NO if you do not want this feature on.  

---------------------------------------------------------------------------
BOT PREVENTION ON CONTACT FORM:

   New settings for Contact Form to prevent bot attacks.
   Go to Configure > Security > General page to enable and review the settings.
   The setting is disabled for upgrade only.  
	
   Minimum Time for form submission (in seconds)
     This setting determines the minimum time it would usually take for 
     a human to fill out the contact form and submit. The default value 
     is 10 seconds. This can be increased or decreased as desired. 
   
   Maximum Number of email to send per hour.
     The default value is 10 emails maximum per hour. If you have a busy 
     site and expect to receive more contact requests, please increase 
     this amount as needed.  
   
   Honeypot is a hidden prevention measure that will trick the bot into 
   completing a form field that is not visible on the page. If the field 
   has a value, the form will not submit. 

---------------------------------------------------------------------------
AVATAX USERS:

   If you are using AvaTax, the Company Field is now required. 
   Update this by going to the Configure > Taxes > Providers menu. 
   Enter your AvaTax Company Code in the configuration field. 

---------------------------------------------------------------------------
BRAINTREE USERS: 

   Braintree payment transactions will now send the Order Number 
   instead of the Order ID. If you are using Braintree, please find  
   the last transaction details in Braintree Console. Make a note of 
   the last Order ID.  

   If the corresponding Order Number in AbleCommerce is LOWER, then 
   you must adjust the NEXT order number to prevent duplicate transaction 
   errors in future processing. 

   Go to the Configure > Store > General page. In the Order Settings 
   section, adjust the "Next Order Number" so it is HIGHER than the 
   last Transaction Order ID noted in Braintree. 

---------------------------------------------------------------------------
STRIPE USERS:

   Stripe payment gateway was upgraded to the new API version 45.1.0.0
   No changes should be needed, but after upgrading, confirm live payments 
   are still being processed. 

---------------------------------------------------------------------------
SHIPSTATION USERS: 

   Shipstation changes are included in this verion. A separate patch was 
   previously released. If you have already installed the patch, the databae 
   will not be updated.

---------------------------------------------------------------------------
FACEBOOK LIKE BUTTON: 

   Due to changes by Facebook, they now require meta tags and an application 
   ID for the "Like" button to function. We have modified the code to use a 
   "Share" button instead until such time a full integration with Facebook can be 
   developed.  

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

======== FOR REFERENCE ONLY - DATABASE UPDATES ============

ALTER TABLE ac_ordershipments ALTER COLUMN ShipStationId BIGINT;

IF (SELECT COUNT(*) FROM ac_StoreSettings WHERE FieldName = 'EnableBotDetection' AND StoreId = 1) = 0
BEGIN
	INSERT INTO ac_StoreSettings ([StoreId], [FieldName], [FieldValue])
		VALUES (1, 'EnableBotDetection', 'False' );
END

IF (SELECT COUNT(*) FROM ac_StoreSettings WHERE FieldName = 'BotCheckTimeOut' AND StoreId = 1) = 0
BEGIN
	INSERT INTO ac_StoreSettings ([StoreId], [FieldName], [FieldValue])
		VALUES (1, 'BotCheckTimeOut', '10' );
END

IF (SELECT COUNT(*) FROM ac_StoreSettings WHERE FieldName = 'AllowedEmailsPerHour' AND StoreId = 1) = 0
BEGIN
	INSERT INTO ac_StoreSettings ([StoreId], [FieldName], [FieldValue])
		VALUES (1, 'AllowedEmailsPerHour', '10' );
END