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'. 

1. 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