How to Create a Price List

Before you start creating a Price List, make sure that you have the following components ready:

  • Products
  • (Optional) Company Parameters
  • (Optional) Product Extensions
  • (Optional) Analytics – Data in Datamart

To create a new Price List, take the following steps:

  1. Create a Calculation Logic determining prices for the products in the Price List.
  2. (Optional) Create a Workflow logic if you want to set up an approval process for the Price List.
  3. Create the Price List (using the new Calculation Logic).

When you have all the prerequisites ready and you have set up a calculation logic, you can create a new Price List in three steps:

  1. Define Price List.
    1. Go to Price Setting > Price Lists.
    2. Click the New Price List button. If there are Price Setting Types defined, select one from the list.
    3. In the Select Products step, select individual products or add all products in the (filtered) view. You can use simple or advanced filters.
      (info) You can define a custom filter for the Product picker using a logic with Nature set to Product Input Filter.
      Alternatively, enter a list of products (one item per line) in the Text entry tab.
      (tick) Product images can be displayed in-line in the Label column. Upload the images in the Product Detail View and make sure the showProductImagesInPriceBuilder feature flag is enabled.
    4. Click Continue to Parameters.
  2. In the Set Parameters step, there are the following options:
    • Price List Name – Identifies the Price List.
    • Header Type – Optionally select a Price List Type with a header logic associated with it.
    • Copy preferences from – Allows you to select an existing Price List whose view preferences will be copied to the new Price List.
    • Allow distributed calculation – For large Price Lists it will improve the calculation performance as the Price List calculation is done simultaneously. Detailed settings can be made in the pricefx-config.xml file.
      (warning) References and dependencies within a Price List need to be considered in the calculation logic in the right way. See also Multi-pass Calculation of a Price list or LPG.

    • Target Date – Validity date which will be taken into account when looking up Company Parameters. To ensure that all items use the same target date, this value cannot be changed later. But if you need more flexibility, you can enable editing the target date even after the Price List has been calculated.
    • When calculation fails – In case of an error you can either abort the whole calculation or skip just the item and continue.

    • Notify me by – If Email is selected, a notification that the Price List calculation has been completed is sent to the user's email address. 
    • Default pricing logic – Select the logic that will be used for products which have no pricing logic defined (the product's default pricing logic can be found at Products > Pricing logic column). If a default logic for Price Lists is defined, it will be preselected here. If no selection is made, the application-wide default generic logic will be used.
      (warning) Only Active pricing logics and logics with no additional Nature value will show in this drop-down.

    • Result Price – Determines your final List Price which can be manually overridden. The drop-down shows all pricing elements from the selected Default pricing logic. If Default pricing logic is empty, the drop-down here will show all pricing elements from all pricing logics.
      (info) The result price is rounded to 5 decimal places. If you want to have rounding/trimming of values under control, you need to do that before returning the value from logic.

    • Matrix logic – Optionally define a matrix Price List. The matrix Price List is another type of Price List. Through the addition of a second key dimension, prices can be calculated, displayed and maintained (multiple times) per combination of the SKU (product) and any other dimension, such as country, quantity, customer etc. With the selection of a matrix logic (a generic logic of the Matrix nature), a secondary key for a Price List can be defined.

    • Matrix logic element – Defines the secondary key field.

    • Dynamic UOM – Allows you to specify a logic result field whose UOM will override the product's default UOM. If left empty, the default from the product master is kept.
    • Dynamic currency – Allows you to specify a logic result field whose currency will override the product's default currency. If left empty, the default from the product master is kept.
    • Define all other parameters defined by the selected logic. (If a parameter is left blank, it will be set to zero.)

    • Output Elements on the right – Define the output element's visibility using the check-boxes:
      • Check-box in the first column – If checked, the result of the given element is displayed as a column in the Price List.
      • Displayed in Quoting (read only) – Informs how the visibility of the element is set up in the logic (in Display Mode).
      • Hide in item list – If checked, the given element is not displayed but still available for mapping to an attributeXX field (for the purpose e.g., integration or filtering from API). However, it is still possible to see the values in the remote procedure call requests data (as it is still part of the data).
        (tick) If you want to use specific view settings as a template and apply it to other Price Lists, you can do so in Defaults for List Calculations in Configuration.
  3. Create Price List.
    Click the Create Price List button. The new Price List gets the status Pending and starts to calculate the prices. If needed, you can cancel the calculation by clicking the Cancel calculation button. The status is not updated automatically but only when you click the Refresh icon.

Found an issue in documentation? Write to us.

 
Pricefx version 13.1