Price groups and category price rules

Pricing

Price groups are used to create and manage different prices and discounts for your products. They are used as a way for the user to identify the different price options you want to configure against the same Product. Price groups provide the link between the different prices, discounts and the Stores. Category price rules can be applied when creating Trade Agreement or reviewing pricing in Price Review Journals.

  1. From the Dashboard, go to Merchandising > Set up > Price and Discount Setup, then click Price groups.

  2. In the Price Groups dialog, click New and create the following three Price Groups:
    • A price group for each store that is used for local store products.
    • One or more price groups for pricing managed products, essentially a price group for each different level of pricing you need. For example. Competitive, Non- Competitive or you may use location type pricing Metro, Country, Remote.
    • (Optional) You may also create a price group(s) to manage pricing for private dispensing.

      • For example:

      • Vic-Metro and Vic-Regional are the head office managed Price groups for retail pricing.
      • All is an optional price group we can use to set private pricing for dispense to apply to all stores.
      • <STORE NAME> is the store specific price group for this store.
  3. Close the window to save your changes.
  1. From the Dashboard, go to Organisations > Retail Stores.

  2. Select a store, then under the Store tab, click Price groups.

  3. In the Retail channel price group window, click New, then attach the applicable Price Groups to this store.

    A store can have multiple price groups attached.

  4. Close the Retail channel price group window to save your changes.
  1. From the Dashboard, go to Merchandising > Set up > Price and discount Setup and click Category price rules.

  2. In the Category price rules screen, click New.

  3. Set the following:
    ColumnValue
    Account code
    • All: all stores and customers.
    • Group: a specific Price Group which is set in the Account Selection field.
    • Table: a specific customer which is set in the Account Selection field.
    CategorySelect the relevant category you wish to set this rule for.
  4. Set all remaining field (if applicable).
  5. Click Generate trade agreements to start the Trade Agreements wizard.
  6. In Product selection, select All Items, then click Next.
  7. In Trade agreement options, set the From and To date (to delay the Trade Agreement's effective date).
  8. Recommended: Select Find next to ensure the best price is located.

    Expire previous trade agreements can be ignored as it is included in the default processing logic.

  9. In Price summary, confirm your setting and optionally select Run as batch job (if this is a large batch).

  10. Click Finish to create the price/discount agreement journal.
  11. Review the line items, then click Post to apply the new prices to your products.
  1. Navigate to FredNXT Head Office > Merchandising > Setup > Price and Discount Setup and click Price groups.

  2. In the Price groups window, select the relevant price group, then from the Trade Agreements dropdown, select View sales prices.

  3. In Price (sales) screen, filter the To date column (CTRL + G) to check current prices.

  4. Copy this data into a spreadsheet for easy editing.

Related Links