Create Product Extension Table

In this tutorial you will learn how to create a new product extension table, setup its columns and preferences. The result can then look in the user interface like this

Let’s say you need to store data, which look like on the screenshot and plan to store them in a product extension table. In this sample, the number in column Average Cost keeps the cost of one product in Euros.

Create a new product extension table

In Pricefx user interface, navigate to Administration  Configuration  Master Data  Product Master Extension

On that page, click on the Add button to add new product extension table.

In the dialog, fill the Name, Label and Size of the table.

  • Name = ProductCost. The name is used in the calculation logic when you need to read data from this table

  • Label = Product Cost. Used only in the user interface to identify the product extension table.

  • Size = 3. The maximum number of Attribute# fields in a data row. This does not include the out-of-the-box fields, like sku, etc. In our example, we need only the Average Cost, so use the lowest value which is 3.

Click OK to save the setup

Select the new Product Extension by clicking on the name of the new Product Extension. Once selected, the right side of the screen displays the current fields of the master table.

Click on Edit action for Attribute1 field

  • Name = AverageCost

  • Label = Average Cost

  • Type = Real

  • Format type = Money (EUR) (note: this does not set up any currency conversions, only how the value displays on the screen)

Click OK to save the field definition. When the confirmation dialog appears, do confirm the change.

View the newly created Product Extension table

From the toolbar menu, navigate to Master Data  Product Extensions.

On the Product Extensions page, click on the Category dropdown box.

Review the result. There are no records yet, but you can see the configured fields.

Fetch the Product Extension fields metadata to your project

In case you already have your project set up in IntelliJ and also connection to partition set up, fetch the new fields' metadata to your project, so that you can store it to Git.