Price Table

The SAWS Price Table (formerly known as SC::Prices) is a component in the PIM included in the SAWSConnector suite. It enables detailed price management for products which is implemented for fast processing and frequent updates. External updates such as Excel/CSV imports or REST API are supported and encouraged.

Activation

The price table can be enabled in the Centric PXM settings in “SAWS > General > Prices”. After enabling the price table for the first time, a data model update must be performed since it adds an additional table in the database.

Once the price table is installed, its rights must be enabled for the intended roles in “General > Advanced User Management > [Role] > SAWS > Base Connector”!

The settings are listed and explained in the following.

Manage Price in SAWSConnector

Enables the price table for your PIM.

Show current prices by default

Enables to show only the currently valid prices (according to their validity date) by default. The display can still be changed in the dialog.

Copy the contents of the price table with when product is duplicated

Controls whether the price table entries are copied with the copied product. The price table is a separate database table from the product attributes in order to support the frequent updates. This means the entries will be copied in this table.

Automatically create unknown entries for price type and currency

The price types and currencies are managed in the PIM value lists “SAWSConnectorPriceType” and “SAWSConnectorCurrencies” which are auto-installed into your system. These are encouraged to be altered and extended to your needs.

This setting controls whether to automatically create new price types or currencies for unknown ones in the Excel/CSV import.

Tax Rate Attribute

You can provide a PIM attribute for the tax rate here. This allows you to set a tax rate as a product attribute and export it alongside the price entries, just like any other price column value.

Extend Price Table with these Attributes as Columns

The price table can be extended with additional fields based on PIM attributes. Since this is a change in the data model and the price table already has an extensive list of fields that covers most use cases, we recommend to only use this feature if it is really necessary.

Index these fields

The price table already contains useful indices for quick database searches. This option allows indices to be added to the additional fields defined in “Extend Price Table with these Attributes as Columns”.

PIM Appearance

The list of all prices is located here in the PIM.

The prices of a product can also be displayed and edited by assigning the price table attribute to your according product classes. (One will be auto-installed but feel free to create one of your own if you wish to do so.)

Fields

Linked product

The product this price entry applies to. Enter the name/ID of the product from your PIM.

Price

The numerical value of the price for the linked product. Enter the amount without currency symbols (e.g., “99.99”).

Currency

The currency in which the price is listed (e.g., EUR, USD, GBP). Select the appropriate currency from the dropdown menu. The list of currencies can be extended in the value list “SAWSConnectorCurrencies”.

Valid from

The start date when this price becomes active. Select from a calendar picker.

Valid to

The end date when this price is no longer valid. Leave blank if the price has no expiration. Select from a calendar picker.

Price type

The category or nature of the price (e.g., standard, promotional, bulk, wholesale). Select the relevant type from the available options. The list of price types can be extended in the value list “SAWSConnectorPriceType”.

Price list

The specific price list or catalog this entry belongs to (e.g., “Retail Prices 2026,” “Wholesale Europe”).

Sales Channel

The platform or method through which this price is offered (e.g., online store, physical retail, B2B portal). Select the applicable channel(s). The list of sales channels can be extended in the value list “SAWSConnectorChannels” and is the same list used by the sales channel table.

Amount from

The minimum quantity required for this price to apply (e.g., “10” for bulk pricing starting at 10 units). Enter “1” for single-unit pricing.

Amount to

The maximum quantity for which this price is valid. Leave blank if there is no upper limit.

Items per unit

The number of individual items included in one unit (e.g., “12” for a pack of 12). Enter “1” if the product is sold individually.

Unit type

The unit of measurement for the product (e.g., piece, kilogram, liter, box).

Data Import

It is a very common use case to import data into the price table from external sources. This is covered in this article.

Was this article helpful?

1 0

How can we improve this article?

Please submit the reason for your vote so that we can improve the article.

Name

Email

Submit