Managing Product Data on Supplier end

Mapping Product 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 Supplier or Both in the template, the supplier 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

When AI Mapping Finalization Choice is set to Supplier in the template, the supplier must review the mappings before confirming them.

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.

Open the submission and then click Field mapping Done. Please click here to ratify mapping or Field mapping pending for custom uploaded file to display details of mapping.
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.

NOTE: If AI Mapping Finalization Choice is set to Both, the unique identifier is already mapped by the distributor. The supplier must complete any remaining mappings that the distributor has not completed.

Mapping, Accepting or Rejecting Template fields:

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

For fields with AI mapping suggestions, accept or reject the suggestions, or map the fields manually.
Click OK in the confirmation pop-up.
For fields without AI suggestions or distributor mappings, locate the unmapped fields in the Identified field in the uploaded file column.
Click + Select target data element in the corresponding row.
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 Short Description.
In Locale, select the appropriate locale.
Review the selected template field, and then click Save.
Click OK on the confirmation message.
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.

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.

When AI Mapping Finalization Choice is set to Both or Supplier in the template, the supplier follows the steps below to map the packaging data.

To map the unique identifier, refer to Mapping the Unique Identifier.

Mapping Package Units and Attributes:

Follow these steps 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.
The submission status changes to Ready to import.
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.

Viewing and Editing Packaging Data in SOP

You can access the packaging data from the product grid or the individual item screen. The packaging icon is enabled when packaging data is available for the item.

From the Product Excel Grid

Open the submission and then click Edit Submission icon to display the Details of Submission.
On the Products tab, locate the required item.
In the Additional Data column, click the packaging icon.
The Packaging Constructs for Item ID panel opens and displays the package units and their attribute values.
Use the horizontal scrollbar to locate the required packaging attributes.
Click an editable value and enter the required change.
Click Done to complete the edit.

For example, if the file contains packaging values for Each and Case, the panel displays both package units with the imported values. Attribute cells without supplied values remain blank.

From the Book View Screen

In the product grid, click the Edit icon in the Actions column for the required item.
On the Edit Item in Submission screen, click the packaging icon.
The same Packaging Constructs for Item ID panel opens.
Review or edit the packaging values, and then click Done.

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 the Onboarded status before checking the result in the staging catalog.