Consolidated Catalog

The Consolidation feature in the PCC portal helps streamline and unify product data from multiple sources providing an improved and unified experience for managing consolidated product data. When different suppliers or data pools provide information about the same product (SKU), their Attribute Values can vary. The Consolidation feature allows users to combine these varying inputs into a single, accurate, and consistent product record in a consolidated Catalog.

Users can configure consolidation rules that define which source’s data should take priority. This ensures that the most reliable or preferred data is used. These rules can be set globally or customized by product categories (Taxonomy).

The consolidated catalog acts as a shared target for multiple input channels. It keeps track of:

The original values from each source channel,
The transformed values per channel,
And the final consolidated value used in the catalog.

Steps to Create a Consolidated Catalog

To create a Consolidated catalog, follow the below steps:

Go to Catalog > All Catalogs > click +Create New Catalog.
On the Create New Catalog page, fill in all the details as you did for a normal catalog creation.
For information refer to Creating a New Catalog.
Under Onboarding Method using DataBridge select Consolidated as shown in the screenshot below:

Click Submit.
Once the catalog is created successfully, you’ll land on the catalog listing page.
On the catalog card you’ll see icon which indicates that it is a Consolidated catalog.
When you hover over this icon, it displays details such as the onboarding method used for the catalog and the list of channels contributing to it.
Since it’s a newly created catalog with no channels set up yet, the hover view will appear as shown in the screenshot below:

To setup the contributing channels for the consolidated catalog, refer to Consolidated Channels.

Catalog Card

On the catalog card there is a new icon which represents the catalog is still raw state with no channel set up yet. So, when you hover over this icon, a pop-up appears allowing you to choose whether you want to create a Regular or Consolidated catalog. Additionally, if a regular catalog was previously created, you could convert it to consolidated catalog directly from this pop-up as shown in the screenshot below:

Note: Once the catalog is selected as a Consolidated catalog it cannot be converted or used as a regular catalog.

On the consolidated target catalog card, when there is already a channel set up for the catalog then you’ll see icon. Now when you hover on this icon, details such as onboarding method used for the catalog and if there are channels already set up then all the channels contributing to the catalog is displayed.

For the configured channels when you click on the Launch Channel icon from the pop-up:

If it’s a CRUD Channel, you’ll be navigated Node Mapping page
If it’s an Enrich Channel, you’ll be navigated to Matching Logic page.

When you click on View Consolidation Configuration, you’ll land on the Consolidation Configuration page. For details refer to Consolidation Configuration section.

Consolidated Channels

Once you have successfully created a Consolidated catalog, the next step is to create channels.

Go to Channels > All Channels.
You’ll see a toggle for Non-Consolidated channels and Consolidated channels, as shown below:

Once a Consolidated channel is created, it will appear under the Consolidated Channels section.

If you're creating a Consolidated catalog for the first time, hovering over or clicking the Consolidated channel toggle will display the following message:

Click Create New Channel.
Enter the name of the channel.
Select the Source Catalog.
Note: To preserve the user from selecting the consolidated catalog from the source catalog drop-down, you’ll see the consolidated catalog is greyed out as shown below:

In the Target Catalog drop-down select the consolidated catalog which you have created.
Choose the Mapping Method as you do for any channel creation.
Click Submit.

On the channel listing page, select the toggle for Consolidated channels and you’ll see the channel created as shown in the screenshot below:

You can see all the channels listed which are mapped to the consolidated target catalog as highlighted in the screenshot below:

As you can see there are two options on the consolidated channel card:

Show Channel Details-> when you click on this option it expands and displays the channel card with details as in the channel listing page. If there are multiple channels linked, you can use the side arrows to navigate through the channel cards.

Click Hide Channel Details to collapse the channel card view.

Consolidation Ranking Configuration-> When you click on this option you land on the Consolidation Configuration for Catalog page. For more details refer to Consolidation Configurations.

Consolidation Configurations

When you click on the Consolidation Configurations, you’ll land on the following page with the default ranking.

There are three tabs on this page:

Entity Value Ranking
Node Map Ranking (COMING SOON!!!)
Matching Logic

Let’s look into each tab in detail:

Entity Value Ranking

This is the setup that the consolidation process uses to determine which channel’s output is to be used to populate the SKU-Attribute value basically which source’s attribute value should be used when multiple channels provide different data for the same SKU and attribute and assign ranks to each channel, indicating priority.

For example:

Supplier (A) -> Attribute= Color, Value= Red

Supplier (B)-> Attribute= Color, Value= Dark Red

In this case, the Attribute Value Ranking setup decides which "Color" value appears in the final consolidated SKU.

On the Attribute Value Ranking screen, you’ll see a list of any configured taxonomy nodes, along with the priority rankings of contributing channels for each node.

Setting Up Entity Value Ranking for a New Consolidated Catalog

Here’s how you configure ranking for a new consolidated catalog:

Adding Taxonomy Nodes:
1. Click on +Add Nodes and you’ll land on the Configured Nodes page.
2. Select the taxonomy nodes from your target catalog. Once selected, the nodes will appear under the Selected Nodes column.
3. Click Done to add them.

Configure Rankings for Each Node:
1. Once the taxonomy nodes are added, they appear in the table as shown below:
2. For each node, you can define the priority order of contributing channels by selecting them under Rank 1, Rank 2, and Rank 3.
  - Rank 1 = highest priority
  - Rank 2 = fallback if Rank 1 value is missing
  - Rank 3 = fallback if Rank 1 and 2 both are missing

Note: The Default row shown at the top is a global fallback used when a specific taxonomy node has no individual ranking.

Under the Actions column you can perform the following actions for each node:

Duplicate (Copy) -> Creates a duplicate of the existing ranking setup for that node. This helps to quickly copy the configuration to another node without manually reselecting ranks.

Paste -> Pastes the previously copied rank setup into the current node which results in saving time by applying the same priority logic across multiple taxonomy nodes without manual re-entry.

Reset (Undo) -> Reverts the ranking for that node back to its last saved state. This helps to discard unsaved changes made while editing ranks.

Delete -> Removes the node from the attribute ranking configuration. Once deleted, the system will use the Default ranking for that node unless reconfigured.

Entity Level Consolidation (Entity Overrides)

What is Entity Level Consolidation?

Entity-level consolidation provides more granular control compared to traditional node-level consolidation. Instead of applying channel rankings only at the node level, you can configure rankings at the attribute or SKU title level. This ensures:

Precise prioritization of critical attributes (e.g., Color, Size).
Flexibility to select the most reliable source channel for each attribute or title.
Cleaner, standardized product data across consolidated catalogs.

How to Add Entity Level Consolidation

Once you’ve added a node, you can override consolidation rules for individual attributes or SKU titles.

Click on +Add Entity Overrides.
You’ll get the following options:
Choose one of the following:
1. Add Attribute Ranking Override – Opens a list of available attributes.
  1. Select the attribute(s) you want to override (e.g., Color) and click Done.
  2. The attribute appears in the configuration table, where you can assign channel rankings by priority (Rank 1 = highest priority, followed by Rank 2 and 3).
2. Add SKU Title Ranking Override – Select SKU Title and assign the preferred channel ranking.
  This allows you to define precise control over which source channel provides critical attributes and titles, ensuring the most reliable data populates your consolidated catalog.
Note: Entity overrides apply only to the selected node. If no overrides are configured, the system falls back to the default node-level ranking.

Matching Logic

The Matching Logic tab allows users to define how SKUs from different source channels should be matched and consolidated into a single SKU entry in the target consolidated catalog.

When different channels provide data for the same SKU, this logic helps the system determine whether those SKUs represent the same SKU even if their unique IDs differ.

The configuration of matching logic ensures that the consolidation process can smartly group the right SKUs even without manual intervention.

How to Set Up Matching Logic (Step-by-Step)

Navigate to the Matching Logic tab under Consolidation Configuration for your target catalog.
To define Primary Matching Logic, click the toggle to choose:
1. ANY → Match if any of the listed attributes match.
  OR
2. ALL → Match only if all listed attributes match.
Click + Add Attribute and choose an Attribute (e.g., Batch ID, UPC).
Select the Matching Logic type (e.g., Exact as is value).
Enable or disable Case Sensitive Match as needed.

Then to define Fallback Matching Logic (Optional) which is if the initial attributes don't result in a match, use this section to define a secondary set of matching rules.
Click + Add Matching Logic.
You can again choose between ANY or ALL for combining fallback attributes.
Add one or more attributes and repeat the same steps (2 to 5) as defined previously in the primary logic.

Click Save Changes to apply the configuration.

For each matching logic rule or attribute, you have the following options:

To reorder a rule, click and drag the reorder icon.
To remove a rule, click the delete icon.

View Consolidation Details (Product 360)

Once you land on Product 360 page, click on View Consolidation Details and you’ll land on the Item Consolidation Details for SKU Item Id as shown below:

The Item Consolidation Details screen is designed to let you view all the source details for each attribute that eventually appears in the target consolidated catalog.

This screen:

Allows you to trace back which channel and source catalog contributed each consolidated attribute value.
Ensures transparency in the consolidation process.
Helps identify why a certain attribute value was chosen over others in case of conflicts.

It provides a breakdown of how attributes for a specific SKU have been consolidated from multiple source channels into the target consolidated catalog.

At the top, you’ll see the SKU Item ID for the product currently being reviewed. Below that, the screen displays attribute-level consolidation results in expandable sections.

Each attribute (e.g., MFG Part No, Batch ID, UPC) is displayed in its own section. Within each section, the following details are shown:

Rank → The priority rank of the channel that supplied the value, based on the configured Attribute Value Ranking.
Channel → The consolidated channel from which the attribute value was taken.
Source Catalog → The original catalog that contributed the attribute value.
Attribute Value → The actual attribute value chosen during the consolidation process.

A ✅ icon indicates that the value shown has been successfully consolidated into the target catalog.

As per the example in the screenshot above, for every attribute (like Size, Color, Warranty), you can see:

Which channel contributed the value.
Which source catalog it came from.
The final attribute value that was chosen based on the ranking rules.

If an attribute override has been configured, the following message is displayed:

Note: In the consolidation process, the contributing channel for the SKU Title will not be shown.