5 Bulk Price Editor

The Bulk Price Editor is a Frontline Manager module that lets you quickly search, update, and manage menu item prices. With configurable adjustment rules, you can apply price changes to many records at once and still fine-tune individual records before committing the update.

The editor works only with price records that are:
  • Defined at the current hierarchy level
  • Overwritten at the current hierarchy level

By selecting the appropriate hierarchy, you make sure your changes stay within scope and never affect records outside your authority.

Figure 5-1 Bulk Price Editor Module


This figure shows the Bulk Price Editor module in Frontline Manager.

Search Criteria

When searching for menu item prices, you can filter using one or more of the following criteria:

  • Family Groups

    Locate prices linked to a specific family group.

  • Screen Lookups (SLUs)

    Locate price records associated to SLUs.

  • Menu Levels

    Search by the menu level(s) where the price is active.

  • Menu Item Types

    Filter by:

    • Regular menu items

    • Condiment menu items

    • Combo meal menu items

  • Effectivity Groups

    Search for prices linked to a specific effectivity group.

  • Price Sequence

    Locate by sequence number(s) of the price record.

  • Tags

    Search by associated menu item tag(s).

  • Search Item Name

    Directly search by menu item name.

  • Definition Sequence

    Search by the unique definition sequence number.

  • Data Extensions

    Search by lookup list, text list, and big text list data extension types.

  • Data Extension Values

    Filter by extended Menu Item Master data values:

    • Select an extra column name.

    • Search by the text value associated with the column.

    Text, Number, Lookup List, Text List, and Big Text List Data Extension Values are available in Bulk Price Editor. List type extension values that contain any of the following special characters—<, >, &, ', or "—will not be returned.

Note:

The Data Extension Value and Item Name fields support similarity-based searching. For example, searching for the Data Extension Value 8 will return records that have 8 as their Data Extension Value, and also those that contain the number 8 within their Data Extension Value. To refine your search results and make them more precise, include additional search parameters in conjunction with the Data Extension Value and Item Name search fields.

Price Adjustments

After retrieving and selecting the records, click Next in the top-right corner. You're directed to the next page, where you can adjust prices using one of the following five methods:

  1. Increase by Amount

    Raise prices by a fixed amount.

  2. Decrease by Amount

    Lower prices by a fixed amount.

  3. Increase by Percentage

    Raise prices by a fixed percentage.

  4. Decrease by Percentage

    Lower prices by a fixed percentage.

  5. Set Specific Value

    Set a new price directly.

Rounding

You can adjust rounding in three ways:

  • Auto

    Based on the values to be changed the application applies rounding.

  • Up

    Values are rounded up based on the selected rounding option.

  • Down

    Values are rounded down based on the selected rounding option.

Select one the following rounding options to determine price rounding:

  • None
  • .99
  • .50
  • .25
  • .05
  • Custom

Workflow Steps

The Bulk Price Editor follows a four-step process:

  1. Search

    Define your search criteria to locate the relevant price records.

  2. Adjust

    Apply bulk adjustments (increase, decrease, or set a specific price).

    Configure rounding if needed.

  3. Review

    Preview the adjusted prices.

    Manually edit individual price record values if required.

  4. Confirm

    Commit your changes.

    Optionally perform another bulk price change.