Overview
Categories can be found in the Administration module > Settings > Management tab > Categories tab. Communities have the ability to map product categories to the Unimarket UNSPSC codes. This means that variances between UNSPSC code versions can be mapped and customers receive a consistent category value for reporting. It also means that communities using another category system can maintain a mapping table so that their categories can be mapped back to the UNSPSC standard.
Communities can choose to manually add mapping from within their community settings or to 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 14 then no mapping is required. If the code is different then the supplier needs to set up a mapping. |
Manual Mapping
- Navigate to the Categories management tab. From there you will be able to add or modify mapping.
- Click Add Product Mapping and a pop up box will appear.
- Enter the External Category and select a field for the UNSPSC category. The External Domain field is optional.
- Click Add to create the category mapping or Add More if you wish to create additional mappings.
Note: When setting the domain please ensure that it matches the external category source you are using. 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
You can upload mapping using a CSV file by adding mapping information into the category template, which can also be found by clicking Download Category Mappings.
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 |
Browse for your CSV file and click Upload.
Set default mapping
Communities have the ability to set a default UNSPSC category for when a category value that is not recognized (or is blank) is passed through and there is no mapping setup for that value.
- In the Categories tab, enter the UNSPSC category you would like to select as your default.
- If you are unsure which category to select, click Browse to bring up a UNSPSC category tree view where you can drill into the categories.
- Once you have found the correct category, click Select to set as default.
Note: If no default is setup and a value is not recognized then the system will display 'NA' in the category. |