Category Mapping Template

Categories classify products and services in a way that makes sense for your organization. Using Category Mapping, Marketplace dynamically maps the supplier-provided category codes, to the categories that your organization uses. 

Download the template below to update your unique category mapping. Once saved to your device, select the 'Browse' icon shown below and upload your category mapping file. Categories will populate under 'Customize Categories'. 

mceclip0.png

    1. Row Number
        • Column Name: ROW_NUMBER
        • Required/Optional: Required
        • Example: 1, 2, 3, etc
    2. Supplier ID
        • Column Name: UNIQUE_SUPPLIER_ID
        • Required/Optional: Conditional
        • Description: A system assigned ID which uniquely identifies the supplier.
        • Example: 945037259
    3. Supplier Category
        • Column Name: SUPPLIER_CATEGORY
        • Required/Optional: Optional
        • Example: Hardware, Technology, etc
    4. Company Category ID
        • Column Name: COMPANY_CATEGORY_ID
        • Required/Optional: Optional
    5. Company Category Label
        • Column Name: COMPANY_CATEGORY_LABEL
        • Required/Optional: Optional
    6. Level 1
        • Column Name: LEVEL_1
        • Required/Optional: Optional
    7. Level 2
        • Column Name: LEVEL_2
        • Required/Optional: Optional
    8. Level 3
        • Column Name: LEVEL_3
        • Required/Optional: Optional
    9. System ID
        • Column Name: UNIQUE_SYSTEM_ID
        • Required/Optional: Optional
    10. Comments
        • Column Name: COMMENTS
        • Required/Optional: Optional
    11. Description
        • Column Name: DESCRIPTION
        • Required/Optional: Optional
    12. Product Tax Code
        • Column Name: PRODUCT_TAX_CODE
        • Required/Optional: Optional
    13. Product Tax Description
        • Column Name: PRODUCT_TAX_DESCRIPTION
        • Required/Optional: Optional
    14. Display
        • Column Name: DISPLAY
        • Required/Optional: Optional
    15. Content Views
        • Column Name: CONTENT_VIEWS
        • Required/Optional: Optional
    16. GL Account
        • Column Name: GL_ACCOUNTS
        • Required/Optional: Optional
    17. English
        • Column Name: ENGLISH (EN)
        • Required/Optional: Optional
    18. Description
        • Column Name: DESCRIPTION (EN)
        • Required/Optional: Optional
    19. Dutch
        • Column Name: DUTCH (NL)
        • Required/Optional: Optional
    20. Description
        • Column Name: DESCRIPTION (NL)
        • Required/Optional: Optional
    21. Spanish
        • Column Name: SPANISH (ES)
        • Required/Optional: Optional
    22. Description
        • Column Name: DESCRIPTION (ES)
        • Required/Optional: Optional
    23. French
        • Column Name: FRENCH (FR)
        • Required/Optional: Optional
    24. Description
        • Column Name: DESCRIPTION (FR)
        • Required/Optional: Optional
    25. German
        • Column Name: GERMAN (DE)
        • Required/Optional: Optional
    26. Description
        • Column Name: DESCRIPTION (DE)
        • Required/Optional: Optional
    27. Portuguese
        • Column Name: PORTUGUESE (PT)
        • Required/Optional: Optional
    28. Description
        • Column Name: DESCRIPTION (PT)
        • Required/Optional: Optional
    29. Italian
        • Column Name: ITALIAN (IT)
        • Required/Optional: Optional
    30. Description
        • Column Name: DESCRIPTION (IT)
        • Required/Optional: Optional
    31. Swedish
        • Column Name: SWEDISH (SV)
        • Required/Optional: Optional
    32. Description
        • Column Name: DESCRIPTION (SV)
        • Required/Optional: Optional
    33. Danish
        • Column Name: DANISH (DA)
        • Required/Optional: Optional
    34. Description
        • Column Name: DESCRIPTION (DA)
        • Required/Optional: Optional
    35. Japanese
        • Column Name: JAPANESE (JA)
        • Required/Optional: Optional
    36. Description
        • Column Name: DESCRIPTION (JA)
        • Required/Optional: Optional

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request