Sales Channel Table

The SAWS Sales Channel Table (formerly known as SC::Channels) is a component in the PIM included in the SAWSConnector suite. It enables detailed sales channel 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.

This video covers the basics of the sales channel management. It is in German and was created in 2018, so the user interface might not resemble yours, but the functionality is the same.

Activation

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

Once the sales channel 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 Sales Channel in SAWSConnector

Enables the sales channel table for your PIM.

Copy the contents of the sales channel table with when product is duplicated

Controls whether the sales channel table entries are copied with the copied product. The sales channel 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 the name and the status of the SC::Sales Channel

The sales channel names and states are managed in the PIM value lists “SAWSConnectorChannels” and “SAWSConnectorChannelStates” 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 sales channel names and states for unknown ones in the Excel/CSV import.

Extend Sales Channel Table with these Attributes as Columns

The sales channel table can be extended with additional fields based on PIM attributes. Since this is a change in the data model and the sales channel 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 sales channel table already contains useful indices for quick database searches. This option allows indices to be added to the additional fields defined in “Extend Sales Channel Table with these Attributes as Columns”.

PIM Appearance

The list of all sales channels is located here in the PIM.

The sales channels of a product can also be displayed and edited by assigning the sales channel 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

Is Template

Enable this option if this sales channel entry is a template. Templates can be used for the sales channel inheritance of this active job.

Sales Channel

The name or identifier of the sales channel (e.g., “Online Shop,” “Amazon DE,” “Retail Store Berlin”). Select the relevant channel from the dropdown menu. The list of channel names can be extended in the value list “SAWSConnectorChannels”.

Linked product

The specific product assigned to this sales channel. Select the product from your PIM that is available for sale through this channel.

Linked CS::Channels

The PIM channel this sales channel is connected to. Select the relevant channel from your PIM.

Channel State

The current status of the sales channel. Select the status from the dropdown menu. The list of channel states can be extended in the value list “SAWSConnectorChannelStates”.

Valid from

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

Valid to

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

First Delivery Date

The date when the sales channel first successfully delivered product data to the target system. This field is planned to be automatically populated and indicates the initial synchronization of product information.

This automatic population is not yet implemented but it can be set manually or by other implementations.

Last Delivery Date

The date when the sales channel last successfully delivered product data to the target system. This field is planned to be automatically updated and helps track the most recent synchronization.

This automatic update is not yet implemented but it can be set manually or by other implementations.

Data Import

It is a very common use case to import data into the sales channel 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