New Feature

TOT-2941 - Apply product volume discount pricing to all products based on total basket product quantity



We have created the ability for the price of all products added to a user's basket to change, based on each product's quantity breaks being applied against the total quantity of products in the user's basket.

This allows users to receive price discounts based on the total products in their basket, regardless of the quantity of individual products. This in effect allows users to be rewarded by adding more quantities of any product to their basket.

Within the Administration Centre, under the Inventory menu, in the Products settings interface a setting has been created labelled "Calculate Volume Discounts For All Products In Basket".

When set to Yes and a user adds a product to basket in either the Trade interface or through a content managed website, all the products will have their pricing recalculated based on any volume discounts applicable to the total quantity of products in the basket.

If a deal had already applied to product in the basket but a cheaper volume discount is applicable then the deal will be removed. It will be up to the user to re-apply the deal with a different quantity for it to come into effect again, which could occur if the user had a volume discount apply and then changed the quantity so that the volume discount no longer applies.



Functionality Affected: Product Add-To-Basket process, Product settings admin interface

Impact: Normal

 

Improvements

TOT-2948 - Style invalid order detail form elements in Order Checkout/Submission content managed web page areas



We have added an ability to style the order detail form elements so that they can be highlighted when a user enters incorrect information from a content managed web page.

On a content managed web page containing a Guest Order Checkout/Submission area, or Order Checkout/Submission area, if the user did not fill out a mandatory field or entered invalid data, then the css class labelled "order_validation_error" will be set against the field with the problem. Admin users can then style that class so that the form field element displays distinctly.

Additionally the field with the issue will become focused and the browser will scroll to the location of the field.



Functionality Affected: Guest Order Checkout/Submission, Order Checkout/Submission content managed web page areas

Impact: Normal





TOT-2947 - Branding of the Administration Centre to TOTECS theme



We have updated the Administration Centre to reflect the new TOTECS branded skin.

As a part of this update we have modified the information boxes in each of the interfaces to only show one line of text, with the ability for admins to press on a More link to view more information about the given interface.

The styling of interfaces has been simplified to allow admin users to focus more on using the interface rather then being overloaded with to many visual elements.

A new menu called Data has been created which contains links dedicated to transferring data into a TOTECS project, including the Data Imports interface that was previously located in the inventory menu.

Note: You may need to clear your browser of the old admin interface, this can be done by pressing the control key with the F5 key, or clearing your web browsers cache.



Functionality Affected: Administration Centre

Impact: Major





TOT-2946 - Allow the value of the "for" rule to accept any length of characters within the Order Surcharges admin interface



Within the Administration Centre, under the Store menu, within Order Surcharges, when adding a "for" rule node to the surcharges tree, we have modified the database to allow infinite amount of characters to be set in the Value field when setting a For rule node.

This allows complex surcharge rules to be defined when iterating through a set of data to determine a surcharge.



Functionality Affected: Order Surcharges calculation process.

Impact: Normal





TOT-2945 - Settings to customise order and address validation error messages



Within the Administration Centre, under the Store menu, in Checkout settings interface, two sections have been created "Order Validation Messages" and "Address Validation Messages" that allow administrators to specify the messages that display to users, when they are creating an order either through the Trade interface on ordering content managed web page areas.



Functionality Affected: Checkout store settings admin interface, order validation process

Impact: Normal





TOT-2943 - Settings for Categories connector data import to not update categories when assigned the web category trees



When importing categories from the Connector software, we have added settings to the Categories data import to limit the ability for existing categories to be updated, when those categories have the same codes and categories being imported from an accounting/ERP system.

Within the Administration Centre, within the Data menu, in Data Imports interface, within the Connector Data Imports tab, upon clicking the Modify Settings link in the Categories row, in the Category Import Settings window we have added the following settings:

 
• Update categories assigned to web category trees: If un-selected then categories assigned to web category trees will not be updated, even if a category being imported contains the same code.

 
• Update products assigned to categories in web category trees: If un-selected then categories assigned to web category trees will not have the products assigned to the category added or removed, even if the category contains products when being imported.

These options in effect allow a tree to be created in the TOTECS project, but have the products assigned to the categories be defined within an Accounting/ERP system that the connector is obtaining the mappings from.



Functionality Affected: Categories connector data import

Impact: Normal





TOT-2934 - Grouping of account product prices



We have modified the product pricing algorithm to now have the ability to group account prices where multiple customer accounts use the same pricing, for example with contracts. This looks to significantly reduce the amount of account pricing data that needs to be exported from the Connector software and be imported in a TOTECS project.

Within the Administration Centre, under the inventory menu, in the Data Imports interface, within the Accounting Connector tab, when a Product Account Pricing data import is run it now has the ability to import pricing groups, as well as assign accounts and products to the pricing groups.

The product search profiles have been modified to factor in pricing groups when calculating a products price. Because of this the search profiles will need to be regenerated for existing TOTECS projects to have this improvement come into effect.

Within the Administration Centre, under the inventory menu, in the Product Diagnostics it will now show product account prices that are associated with a pricing group that the specified customer account is assigned to. This will also occur within the User menu, in the Customer Accounts, when viewing the product account pricing associated with an account.

Within the Users menu, in User Account Contracts, when the contract regeneration button is pressed it will recalculate the contract pricing factoring group pricing.



Functionality Affected: Account Enquiry listings and records in the Trade interface, Admin Centre, Account Enquiry content managed web page areas.

Impact: Major





TOT-2932 - Setting to customise the formatting of dates in account enquiry records displayed in the Trade interface and on account enquiry content managed web page areas



For projects using the Account Enquiry feature, there is now the ability to customise how the dates are displayed in the record listings, and within the details of the records.

Within the Administration Centre, under the Stores menu, in the Accounting settings interface, in the Account Enquiry section we have added a setting labelled "Records Date Format".

This setting allows the admin user to specify how the dates are formatted for the account enquiry records. when setting the format the date it follows the formatting conventions of the Java programming language, as specified at http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html eg. yyyy/MM/dd will format the date to 2014/11/25

Please note that the "Records Date Format" setting will only effect the account enquiry records when the records are being obtained through the Connector application versions 0.22 or higher.



Functionality Affected: Account Enquiry listings and records in the Trade interface, Admin Centre, Account Enquiry content managed web page areas.

Impact: Normal





TOT-2931 - Hook to allow users to choose to display only outstanding invoices in the Customer Account Invoice Listing content managed web page area



On a content managed web page displaying a Customer Account Invoice Listing area, there is now a hook that allows users to choose to display all invoices, or only invoices that are unpaid and outstanding.

Within the Administration Centre, under the websites menu, in the Websites interface, navigating through the tree's Web Area Formats Libraries folder, Account Enquiry folder, Customer Account Invoice Listing folder, Customer Account Invoice Listing folder, when modifying a Customer Account Invoice Listing format there is now a hook labelled "invoices_show_outstanding_drop_down".

This hook can be added to the format and will display a drop down in the "Customer Account Invoice Listing" area that allows only outstanding invoice records that have not been paid to show, or all invoices that have been obtained from the accounting/ERP system for the user's customer account.



Functionality Affected: Customer Account Invoice Listing content managed web page area

Impact: Normal





TOT-2930 - Allow messages to display in styled web page HTML dialogs from the Order Checkout/Submission content managed web page area



On a content managed web page containing either a Order Checkout/Submission area or Guest Order Checkout.Submission area, there is the ability to display order validation error messages in a html dialog. This allows the dialog to be styled using CSS.

Within the Administration Centre, under the Websites menu, after clicking on a content managed web page, in the Web Page Editor when modifying either a Order Checkout/Submission area or Guest Order Checkout.Submission area, in the area editor window a new setting labelled "Show Messages In" has been added.

If it is set to Webpage HTML Dialog, then when a message displays to the user when using the area, the message will be displayed in a HTML dialog that is drawn on the web page and can be styled using CSS.

If the setting is set to Browser Dialog then the message will display in a browser alert dialog that cannot be styled and requires the user's input before being able to use the browser again.



Functionality Affected: Order Checkout/Submission, Guest Order Checkout.Submission content managed web page area

Impact: Normal





TOT-2929 - Hook to display product stock quantity limited to upper threshold in Product Search Record and Product Detail content managed web page area formats



On a content managed web page containing either a Product Detail area, in its Product Detail format two hooks can now be added to the format to limit the upper stock value that users can see, these hooks are:

 
• _P_StockLevel_threshold: Displays the quantity of the product available and in stock, capped at the upper threshold defined in product settings if the limit is turned on.

 
• _P_StockLevel_threshold_holder: Same as above except that if product combination drop downs are displayed in the area and a different product is selected, then this placeholder hook will update with the stock level of the chosen product.

For areas that use the Product Search Record format such as the Product Search Listing area, it also contains the _P_StockLevel_threshold hook to display the stock level quantity.

FYI: The quantity threshold settings can be modified within the Administration Centre under the Inventory menu, in Product settings, turn the "Limit Stock Quantity To An Upper Value" on and set the "Stock Quantity Upper Threshold" setting to value that will at most be displayed. If product stock quantity is over this limit then a plus sign will display after the amount in the hooks.



Functionality Affected: Product Detail content managed web page area, Product Search Results Listing content managed web page area

Impact: Normal





TOT-2927 - Product Combination content managed web page area to update all child product quantity prices after add-to-basket



Within the Administration Centre, within the Websites admin interface, when modifying a Product Combination area a content managed web page in the Web Page Editor, there is a new setting labelled "Refresh Pricing In Table After Product Add".

If this setting is set to Yes, then when the area is displayed on a content managed web page and the user adds a product to basket from within the area, any placeholder pricing hooks displayed in the Product Search Record format for each cell in the area's combination table will be updated with the product's prices.

The following hooks have been added to the Product Search Record content managed web page area format:

 
• price_holder: Placeholder containing the unit price of a product including or excluding tax dependent of project setting, that can be updated within the page.

 
• price_inc_holder: Placeholder containing the unit price of a product including tax, that can be updated within the page.

 
• price_ex_holder: Placeholder containing the unit price of a product including tax, that can be updated within the page.

 
• price_inc_currency_holder: Placeholder containing the unit price of a product including tax in the system currency, that can be updated within the page.

 
• price_ex_currency_holder: Placeholder containing the unit price of a product including tax in the system currency, that can be updated within the page.

 
• price_currency_holder: Placeholder containing the unit price of a product in the system currency including or excluding tax dependent of project setting, that can be updated within the page.

Use these hooks to allow the pricing in the combination table to be updated.

Note: Make sure that the Product Combination area's "Show Combination Options As" has been set to Table

Make sure that the Product Combination area's "Use Product Search Format In Table Cell" setting has been set to Yes so that these hooks become applicable when displaying the child products in the product search record format.



Functionality Affected: Product Combination content managed web page area

Impact: Normal





TOT-2926 - Product Combination content managed web page area to not show table rows and columns that are empty of child products



Within the Administration Centre, within the Websites admin interface, when modifying a Product Combination area a content managed web page in the Web Page Editor, there are no two new settings available in the area's editor, these are:

 
• Show Empty Table Rows: If set to No then when the Product Combinations area is display its child products in a table, if the table contains no product data in a row then the row will not display.

 
• Show Empty Table Columns: If set to No then when the Product Combinations area is display its child products in a table, if the table contains no product data in a column then the column will not display.

Functionality Affected: Product Combination content managed web page area

Impact: Normal





TOT-2925 - Regenerate product and user lists associated to product deals after connector data imports



When customer accounts or products are imported through the Connector software, there is now the ability to regenerate users and products associated with deals, thus allowing extra products and users to be automatically assigned to active deals, based on the deals rules.

Within the Administration Centre, under the Marketing menu, in the Marketing Settings interface a new setting labelled "Recalculate Deals After Customer Accounts And Product Data Imports" has been created.

When the setting is set to YES, then when a connector Products data import is run it will recalculate the products against all active deals.

When a Customer Accounts data import is run with this setting set to YES then it will recalculate the users associated with all active deals.

In the Deals and Vouchers admin interface a button has been added labelled "Recalculate Active Deals Users and Products" that will calculate both products and users associated with all active deals.

All of these settings are dependent on the Deals and Vouchers feature being turned on.



Functionality Affected: Products connector data import, Customer Accounts data import, Product Deals and Vouchers admin interface. Marketing settings admin interface

Impact: Normal





TOT-2714 - Settings to customise product add-to-basket validation error messages



Within the Administration Centre, under the Online Store menu, in Basket settings interface, a section labelled "Product Add-To-Basket Validation Messages" has been created that allow administrators to specify the messages that display to the users when they try to add a product to basket, either through the Trade interface or in content managed web page areas containing add-to-basket elements.



Functionality Affected: Basket store settings admin interface. Product Add-To-Basket process.

Impact: Normal

Bug Fixes

TOT-2952 - User's session not persisting on insecure content managed web pages after successfully logging in from a secure content managed web page



On a secure content managed web page that contains a User Login area, if a user successfully logged in then navigated to an insecure page, their session and its data would not persist on the unsecure content managed website domain.

We have modified the User Login process so that if a user is logging in from a secure content managed web page, and after a successful login is redirected to another secure page, then to ensure that the new session is saved to the user's browser against the unsecure content managed website domain.



Functionality Affected: User Login

Impact: Major





TOT-2951 - Users failing to login within a User Login area on a secure content managed web page is causing their guest session and basket to be destroyed



On a secure content managed web page that contains a User Login area, if a guest user tried to login with incorrect credentials, the failed login attempt would clear the users previous session and any data associated with it such as basket data.

In the Trade login page, or on a content managed web page containing a User Login area we have modified the login process to not destroy a user's guest session if their login attempt failed.

Additionally it will not try to recreate a new guest session if the login attempt fails to create a new basket either. This bugfix may make the login process quicker when failed attempts occur.



Functionality Affected: User Login

Impact: Normal





TOT-2928 - Left side advertisement banner not displaying with make/model search form in the trade interface



Within the Trade interface, on the left hand navigation panel, if advertising was set to display in the panel, but it was also loaded with a Make/Model search form then the advertising would not display.

Within the Trade interface we have modified the left hand navigation bar to correct show the advertising banner when the feature is turned on.



Functionality Affected: Left hand navigation panel of the Trade interface.

Impact: Normal





TOT-2923 - Billing address validation error appears on guest order submission content managed webpage area after incorrect reCaptcha entered



On a content managed web page containing a Guest Order Checkout/Submission area, if the user had entered not correctly entered all delivery address fields, then fixed the invalid fields, an error message would still display advising that billing address was still incorrect.

We have modified the order details format to have it not require the set_billing_with_delivery_address_checkbox format hook. When the hook is not set in the area then by default the server will set the delivery address as the billing address. This fix gets around the problem where if Internet Explorer or any other browser does not pass the hook's input value (due to it being hidden and becoming deselected) then the user can still checkout.

Additionally we have modified the order details form to reload a new Recaptcha image if the previous image was incorrectly answered by the user. For an unknown reason google would not longer accept answers for a reCaptcha after the first incorrect answer was given.



Functionality Affected: Guest Order Checkout/Submission content managed web page area

Impact: Normal





TOT-2922 - Customer Account Addresses connector data import failing when freight code field is being imported



When trying to run Customer Account Addresses connector data import from the Admin Center it could come up with the error message "An error occured whilst trying to set up the data import: Unknown column 'freightode' in 'field list'.

This issue would be caused if the Connector was configured to pass the freight code data with addresses.

We have modified the data export to ensure that it can correctly import freight code data when addresses are imported.



Functionality Affected: Customer Account Addresses conenctor data import

Impact: Normal





TOT-2918 - Importing incremental changes in Product Price Level Pricing connector data import is deleting all existing price-level pricing not updated



Within the Connector application, when an adaptor runs the Product Price-Level Pricing data export with the data transfer mode set to incremental, when TOTECS imports the data through the Product Pricng Connector data import, all existing product pricing data that was not updated was being deleted.

We have modified the Product Price-Level Pricing data import to ensure that it does not delete existing pricing if the data import is being run to apply only incremental changes.

Previously it was not looking at the data transfer mode and clearing all pricing data before import the changed pricing data that was pushed in the import.



Functionality Affected: Product Price-Level Pricing data import

Impact: Critical





TOT-2917 - Customer Account Detail content managed web page area unable to display on an insecure page after a user has logged in from a secure page



On a content managed web site, after a user has logged into a project from a secure web page, if they are then redirected to a insecure page containing a customer account detail area, the contents of the area is not drawing and an error message is displaying in the area.

For content managed web pages we have modified the Customer Account Detail content managed web page area to ensure that it renders after the user had logged in from a secure page. The bug was caused by the user's session data not being passed across to the unsecure domain after they were logged in.



Functionality Affected: Customer Account Detail content managed web apge area.

Impact: Normal





TOT-2916 - Customer Account Invoice Listing content managed area unable to display only outstanding invoices



On a content managed web page containing a Customer Account Invoice Listing area, if the area is configured to only show outstanding invoices (invoices that haven't been full paid for) the area is still showing invoices that have been paid for.

We have modified the Customer Account Invoice Listing content managed web page area to ensure that it only displays outstanding invoices if the "Show Only Outstanding Invoices" setting in the area's editor is set to YES.



Functionality Affected: Customer Account Invoice Listing content managed web apge area.

Impact: Normal





TOT-2915 - Flagged products not loading on the home page of the Trade interface



Within the Trade interface, on the Home page, it was possible that flagged products would not display on the page when they should have.

This bug could be caused if flagged products could not have their pricing calculated if the price is determined by pack pricing. This bug was directly caused by the bug fix of issue #TOT-2864.



Functionality Affected: Home page Trade interface

Impact: Major