Seller Master Extensions

In this section you can set up new Seller Extensions and their structure.

  1. Click the Add button to add a new extension.

  2. Enter a Name – You will use this name later in the calculation logic to identify, in which table you want to search data.

  3. Set a Label – This is what users will see in the Master Data > Seller Extensions > Category drop-down menu.

  4. Select the Size, which is the number of attribute columns (3, 6, 8, 10, 20, 30 or 50) available in the table. Make your selection wisely to optimize the database size – i.e., do not create a table with 30 columns, if you only plan to use 2.

  5. In the Allow Search column, set whether this extension's attributes should be available in the advanced Seller filter (on the Sellers page).

  6. Allow Analytics Search – If enabled, you can make this extension's attributes available in the Seller input filter when the datamartSellerGroupEntry() method is called. The returned Seller group object can be used in a Datamart query as soon as you create corresponding Data Sources and propagate the Seller Extension's attributes as fields into a Datamart -- use the Template that is created automatically when you create a Seller Extension. This feature is intended above all for Agreements & Promotions and Rebates.

  7. Set view/edit permissions determining which groups of people can see/edit this table.

  8. Click OK and select the new extension from the list.

  9. On the right-hand side panel, choose which column(s) is used as the Business Key. The system checks if the combination of business key values is unique and avoids duplicates. If duplicated rows are loaded, the system will update the existing records with whatever comes last.
    This uniqueness restriction is applied only when the user enters data manually in the user interface, and also for data modified via calculation logics. It is not forced, however, during integration.

    • You should always set up the Business Key, so that it is clear, which combination of columns forms the unique key.

    • Seller ID can also be selected as the Business Key. It is recommended to use the first attributes (attribute1, attribute2, attribute3, ...) as the Business Key to achieve better performance. If needed, a single database index (attribute1, attribute2, attribute3, ...) can then be created for all product extensions (this requires discussion with the Support team).

    • If Last Update Date column is selected as the Business Key, this column is not included in the file when the Seller Extension is exported. This means that this file cannot be used for data update as it will fail on header validation.

    • Attribute extensions cannot be selected as Business Keys.

  10. (Optional) You can add attribute extension columns if you need to exceed the limit of attribute columns and/or the maximum limit of characters in a column.

When an extension is selected, the structure is visible in the right-hand side panel as a grid without data (even if the extension contains some).

If you need to rename the Seller ID field, you need to do that in the Seller master. This way the change is propagated to all Seller Extensions and the data is kept consistent.

  • After changing Seller Master Extensions, you need to log off and log in again to see the changes reflected in other parts of the application. Changing the name or type of an existing Seller Master Extension that is used in a calculation logic will require a change there too. Changing the name also means that you loose all data and column configurations. Note that the configuration is cached and it can take up to five minutes for a change to take effect.

  • When changing the number of attributes, make sure that no calculation uses that Seller Extension during the data migration. Consider stopping the adapters and calculation flows and do not allow the end users to trigger any calculation. For larger amounts of data, consider temporarily dropping the unnecessary database indexes for the source and target Seller Extension table and recreate them after the migration.

  • The maximum possible length of all the Business Keys combined must fit into the database limit of 3,072 bytes. The total length is calculated in the following way: number of keys * 255 (chars) * 3 (bytes for each char), i.e., the maximum number of Business Keys is 4. See also Loaddata and Business Key Length.

Found an issue in documentation? Write to us.

 
Pricefx version 13.1