Supplement Banding

Supplement banding empowers you to regulate the pricing of sales items when sold through a standard choice, offering enhanced flexibility and control.

Managing Banding

For each sales area within your organisation you must associate the sales area and subcategory to the relevant price band so that the correct prices are displayed for standard choices (non-multi select) if a price is to be used for some of the items within the choice all ordering channels.

By default sales area banding is always the first tab displayed however you can select supplement from the tabs at the before proceeding.

Step 1 of 2

Applying Organisation & Product Structure Filters

1. Select the required filters from the organisation and product structure filters

   As least one level must be selected from both filter sections to be able to load the supplement banding grid, if any previous filters had been selected for sales area banding and you navigate to the supplement banding tab the same filters will apply to this grid
   Click here for more information on filtering

   Site Filter Tips

   When filtering for parts of the organisation hierarchy you can:

   • Use the site, sales area or site reference to select 1 or more parts of the hierarchy

     • Click into a drop down and either type to search or scroll through the list of available items and select

     • Select filters from multiple sections, to provide more accurate results

     • Click the X on the selected item to remove

   • Apply a filter by selecting location tags

   Product Structure Filter Tips

   When filtering for parts of the product structure you can:

   • Use the product structure to select 1 or more parts of the hierarchy

     • Click into a drop down and either type to search or scroll through the list of available items and select

     • Select filters from multiple sections, to provide more accurate results

     • Click the X on the selected item to remove

2. Click Apply Filters | the supplement banding grid is now displayed based on the filter criteria selected

   By default 250 rows will be displayed in the grid, if there are more subcategories these will be displayed on further pages, alternatively the number of items displayed on a page can be increased to either 500 or 750

3. By default the following columns are displayed:

   • Site

   • Sales Area

   • Subcategory

   • Current Band

   • Date of Change

   • Future Band

   Additionally using the column button will allow the follow to be added to the grid (or default columns removed for that session):

   • Site Reference

   • Category

   • Last Sync

Step 2 of 2

Setting Supplement Banding - Single Subcategories

Follow these steps to allocate the supplement banding based on site, sales area and subcategory:

1. Select the required Start Date by clicking into the date cell

   The date must always be selected before choosing the price band, if a current band is displayed then the date selected will be used to swap that subcategory to the new price band

2. Select the required Price Band by clicking into the future band cell

   Each of the available price bands from the assigned price group (for that site location) will be displayed, to quickly navigate to the band letter you can enter the 1 or 2 character band letter

3. Click Save

   If an incorrect date or entry has been made (future date changes) click back into the date cell use the X to remove the set date
   If the banding grid has been loaded with multiple pages before changing the page any changes must be saved

Setting Supplement Banding - Multiple Subcategories

Follow these steps to allocate the banding based on multiple row selections of site, sales area and subcategory:

1. Select either the entire table or individual rows by clicking the check box

2. Click Assign

3. Select the future Start Date from the calendar

   The price group being used for the selections made will be displayed above the date after selection, if there is a single site selected and there is a price group future dated change the price group and bands displayed could be either for the current or future price group (depending on date selection)

4. Select the required Price Band

5. Click Apply Changes | the grid will be displayed with the updated selection

6. Click Save

   If the banding grid has been loaded with multiple pages before changing the page any changes must be saved

Managing Banding - Export & Import

Editing the Spread Sheet

1. Set the Date and Future Price Band within the sheet

   Dates should entered in the following format:

   Future price bands should be entered with band letters only

   Only the date and future price band fields can be edited all other cells are blocked from entry
   
   

2. Save the spread sheet

Importing

1. Select Banding

2. Click Import | or from an open Banding click the 3 dot menuselect Import Banding

3. Drag and Drop the file into the import area or click the link and locate the file to upload

   One file can only be uploaded at a time, the file will be validated and displayed that it uploaded correctly, if the wrong file was selected it can be deleted at this time and the process repeated to select the correct file

4. Click Import

   During the import process the file contents will be validated, if there are any date or band cells with incorrect formatting the file will automatically download and include an additional column stating the reason for the file failing to import

   When the file has imported the banding information will be updated with the new settings

Sync Status