Managing Product Data on Distributor end

Mapping Packaging Data

When a supplier uploads product data using Option 3 in 4 simple ways to upload product data in the SKU Onboarding Portal (SOP), and AI Mapping Finalization Choice is set to Distributor or Both in the template, the distributor must review the AI-suggested field mappings on the AI Mapping Finalization screen before confirming them.

NOTE: Ensure that the supplier has access to the submission template used to upload the product data.

For information on template configuration, refer to Manage Category Template.

Uploading the File

Follow the steps for Option 3 in 4 simple ways to upload product data to upload the file.

Mapping the Identified fields to Template fields

Mapping the Unique Identifier:

Before finalizing the mapping, map the source column containing the product identifier to the template field configured as a unique identifier.

Go to Suppliers and then select the supplier.
Under Submission in Overview tab, click Field mapping pending for custom upload file for corresponding uploaded file.
Locate the source column containing the unique identifier.
NOTE: To view the original file uploaded by the supplier in the Supplier Portal, click Download Sample File on the AI Mapping Finalization screen. Use this file to review the source data while mapping the fields. The file is downloaded to your computer.
Click + Select target data element in that row.
Under Select entity to map to, select Template Field.
Under Select a template field to map to, select the template field configured as the unique identifier, and then click Save.
Click OK in the confirmation pop-up.
The unique Identifier is mapped successfully.

NOTE: The system requires a unique identifier mapping before you can finalize the mapping. Complete the identifier mappings required by your template.

Mapping, Accepting/Rejecting Template fields:

Follow these steps to review suggestions and map fields to template fields:

For other fields with AI mapping suggestions, accept or reject the suggestions or map the fields manually.
For fields without AI suggestions, locate the unmapped fields in the Identified field in the uploaded file column.
Click + Select target data element in the corresponding row.
NOTE: Users can search for a target data element in the Will map to this target data element column by entering its name in the search box, as shown in the image below.
Under Select an entity to map to, select Template Field.
Under Select a template field to map to, select the field represented by the source column, such as BRAND_NAME or Photo.
In Locale, select the appropriate locale.
Review the selected template field, and then click Save.
Click OK in the confirmation pop-up.
The row displays Done under Mapping Status, Template Field under Mapped to Entity, and the selected field under Will map to this target data element.
Repeat these steps for the remaining columns.

NOTE: If Both or Supplier is selected in AI Mapping Finalization Choice, then refer to Managing Product Data on Supplier Side for further process.

Accepting AI suggestions in Bulk

Instead of accepting each AI suggestion individually, you can accept all suggestions that meet a minimum confidence level in a single action.

On the AI Mapping Finalization screen, click Bulk Accept Based on Confidence Level.
In Above __ % confidence level enter the minimum confidence level, for example 90.
Click Done.
All AI suggestions with a confidence level above the entered value are accepted.
Review the remaining fields and accept, reject or map them manually.

NOTE: AI suggestions below the entered confidence level remain in Pending status. Review and map these fields individually before finalizing.

Applying Bulk Actions to selected fields

To accept, reject, or delete mappings for specific fields at once, select the fields and apply a bulk action.

On the AI Mapping Finalization screen, select the checkbox next to each field you want to update. To select all fields, select the checkbox in the column header.
The number of selected fields appears next to Selected Fields, and Bulk Action becomes available.

Click Bulk Action, and then select one of the following options:

Option	Description
Accept AI Mapping Suggestions	Accepts the AI suggestions for the selected fields
Reject AI Mapping Suggestions	Rejects the AI suggestions for the selected fields
Delete Mappings	Deletes the existing mappings for the selected fields

For example, select Delete Mapping from the bulk action.
Click Delete on the Deletion pop-up.
Click Ok on the confirmation pop-up.
The mappings for the selected fields are deleted.
Review the updated fields and map any remaining fields manually.

Downloading the Field Mappings

You can download the field mappings on the AI Mapping Finalization screen to review.

On the AI Mapping Finalization screen, click Download Mapping.
Under Download as, select the required format (XLSX, CSV, JSON, HTML, IMAGE or PDF).
The file is downloaded and the message AI mapping suggestions downloaded successfully appears.
The file is downloaded to your computer.

The downloaded file includes the following columns:

Column	Description
Mapping Status	Current status of the field, such as Pending or Done.
Field Position	Column position of the field in the uploaded file.
Identified field in the uploaded file	Column name in the supplier's file.
Mapped to Entity	Entity the field is mapped to, such as Template Field or Package.
Will map to this target data element	Target field suggested by AI or selected manually.
Confidence Level	AI confidence percentage. Displays No Match found if AI could not suggest a field.
Download Date/Time	Date and time of the download, in your local time.

Mapping the fields to Packaging data

When a supplier uploads packaging information along with product data using Option 3, the status changes from Product import in progress to Waiting for portal manager to map after the product import is complete.

For information on configuring package units and attributes, refer to Package Units and Package Attributes.

To map the Unique Identifier, refer Mapping the Unique Identifier

The distributor follows the steps below to map the packaging data:

Mapping Package Units and Attributes:

Follow the steps below for each packaging column:

Locate the packaging column under Identified field in the uploaded file.
Click + Select target data element in that row.
Under Select an entity to map to, select Package.
In Package Unit, select the unit represented by the source column, such as Each or Case.
Under Package Attribute, click Click to select a Package Attribute.
Search and select the appropriate package attribute, and then click Done.
Review the selected package unit and attribute, and then click Save.
Click OK in the confirmation pop-up.
The row displays Done under Mapping Status, Package under Mapped to Entity, and the selected attribute and package unit under Will map to this target data element.
Repeat these steps for the remaining packaging columns.

NOTE: If a required package attribute is unavailable, have the distributor create it in the staging catalog and associate it with the appropriate package unit in PCC. Return to the mapping screen and select the attribute.

Finalizing the Mapping

Review the mappings for the product identifier and template fields.
Click Finalize.
Click OK in the confirmation pop-up.
If AI Mapping Finalization Choice is set to Both, the supplier must complete the subsequent review and finalization.
Wait for the import to complete before reviewing the product data in the submission.

NOTE: Only mapped fields are imported. Unmapped columns and AI suggestions that have not been accepted are excluded. Mapping only the unique identifier allows finalization.

Publishing and Onboarding the Products

After import, the products follow the publishing, approval, acceptance, and onboarding settings configured for the supplier in the category template.

If Auto Publish SKUs, Auto Approve SKUs, Auto Accept SKUs, and Auto Onboard SKUs are enabled, the corresponding stages run automatically as the products become eligible. If a stage is not automated, complete the required action through the existing submission workflow.

When publishing manually, review the product data and resolve any validation issues before publishing the items that are ready. For instructions, refer to Managing Open Submission.

Note: Finalizing the mapping does not mean that onboarding is complete. Wait for the product to reach Onboarded status before checking the result in the staging catalog.

Viewing Packaging Data in PCC

On the SKU Journey Screen

After the supplier publishes the product, the distributor can view its packaging data during the onboarding workflow.

Open the SKU Journey screen for the required supplier and submission.
Locate the product in its current workflow stage.
In the Additional Data column, click the packaging icon.
Review the package units and attribute values in the Packaging Constructs for Item ID panel.

Note: Packaging data is read-only on the SKU Journey screen.

For information on the workflow stages, refer to View SKU Journey.

In Product 360

After onboarding is complete, follow these steps to view the packaging data in the staging catalog:

Open View My Products in PCC.
Select the staging catalog associated with the submission template.
Locate the onboarded product and open it in Product 360.
Click the Packages tab.
Select a package unit from List of Packages to view its details and attribute values.

For information on managing package units in Product 360, refer to Using Package Units in Product 360.