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 Group

    Locate prices linked to a specific family group.

  • Screen Lookup (SLU)

    Locate price records associated to SLUs.

  • Menu Level

    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 Group

    Search for prices linked to a specific effectivity group.

  • Price Sequence Number

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

  • Menu Item Tag

    Search by associated tag(s).

  • Search Item Name

    Directly search by menu item name.

  • Definition Seek Number

    Search by the unique definition seek number.

  • Menu Item Master Data Extension

    Filter by extended data values:

    • Select an extra column name.

    • Search by the text value associated with the column.

Note:

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