Suppliers have the ability to map their product categories to Unimarket UNSPSC codes. This means:
- Variances between UNSPSC code versions can be mapped and customers receive a consistent category value for reporting.
- Suppliers using another category system can maintain a mapping table. So their categories can be mapped back to the UNSPSC standard.
- The mapping applies to hosted and punch-out catalogs.
Suppliers can:
- Manually add mapping from within their eStore or
- Upload mapping via the supplied CSV template.
| Note: When mapping between UN versions, only the exceptions need to be mapped. For example, if a code in UN version 9 is the same as in UN version 16, no mapping is required. If the code is different, mapping set up is required. |
Manually Adding Mapping
To manually add or modify mapping, go to Profile on left panel > select Configure Store.
Once selected, the Configure Store screen will populate > click Categories tab.
If 'Calculator' in UNSPSC version 9 is 44101801 but it needs to be mapped to 'Pocket Calculator' in UNSPSC version 16 which is 44101809, click +Add Category Mapping.
The Add Category Mapping pop-up box will appear to enter information in all required fields marked with a red asterisk. Once completed, select Add or Add More to create additional mappings.
| Note: When setting the domain, ensure the value specified matches the value that will be returned from your roundtrip catalog. You can also choose to leave the domain blank and Unimarket will look for a matching mapping rule and ignore the domain. |
Upload mapping via CSV
To upload mapping using a CSV file, to add mapping information into the category template, click Download Category Mappings.
A Job Submitted pop-up box will appear > select the Here hyperlink. Once selected, the Background Jobs will appear to select Download when in Finished State.
Fields available within the category template are:
| Column | Name | Description | Mandatory |
| A | External Code | Category code that needs to be mapped back to Unimarket UNSPSC standards | Y |
| B | External Domain | What the external code is | N |
| C | Unimarket Code | Unimarket UNSPSC code | Y |
When ready to upload, select Browse in the Upload Category Mappings field > click Process > a pop-up box will appear to select OK to begin uploading.
Set Default Mapping
Suppliers have the ability to set a default UNSPSC category, when:
- A category value is not recognized (or is blank) and
- There is no mapping setup for the value.
Go to Profile on the left panel > click Configure Store > select Categories tab > key in default UNSPSC code in Default Category. If you are unsure which category to key in, select search icon in Default Category field to locate default UNSPSC category.
The Browse UNSPSC Categories pop-up box will appear, to locate desired categories > once located, click Select to set as default.
| Note: If no default is setup and a value is not recognized, the system will display 'NA' in the category. |