Category Import
Overview
Note:
You must haveCategory Planner to bulk import categories.
You can use the Category CSV loader to bulk import categories for use with Category Planner.
Unique Keys
-
Name
Validations
Stakeholders and owners must have the correct Category Planner permissions in Coupa to be added to categories. If they don't have the correct permissions, the Category bulk loader doesn't add them to the category. For more information, see Understand Category Planner Roles and Permissions.
The following values must already exist in Coupa:
-
Commodities List
-
Stakeholder Name:Stakeholder Department
-
Owner Name:Owner Department
-
Analytics Mapping Name
Note:
Commodities List, Stakeholder Name:Stakeholder Department, and Owner Name:Owner Department are semicolon (;) separated. The rest of the fields are comma (,) separated.
When you use the Category loader to add stakeholders and owners, it generates custom departments with the values you specify.
Category
|
Field Name |
Required Field |
Unique? |
Field Type |
Field Description |
Possible Values |
|
Name* |
Yes |
Yes |
string(100) |
Name. A category with the same name should not exist in Coupa |
|
|
Description |
No |
No |
Text |
Description |
|
|
Commodities List* |
Yes |
No |
Commodities List. Must exist in Coupa |
||
|
Stakeholder Name:Stakeholder Department |
No |
No |
Stakeholder Name:Stakeholder Department. Stakeholder name must exist in Coupa |
||
|
Owner Name:Owner Department* |
Yes |
No |
Owner Name:Owner Department. Owner name must exist in Coupa |
||
|
Analytics Mapping Name* |
Yes |
No |
Analytics Mapping Name. Must exist in Coupa |
||
|
Custom Field 1 |
No |
No |
Custom Field 1 |
||
|
Custom Field 2 |
No |
No |
Custom Field 2 |
||
|
Custom Field 3 |
No |
No |
Custom Field 3 |
||
|
Custom Field 4 |
No |
No |
Custom Field 4 |
||
|
Custom Field 5 |
No |
No |
Custom Field 5 |
||
|
Custom Field 6 |
No |
No |
Custom Field 6 |
||
|
Custom Field 7 |
No |
No |
Custom Field 7 |
||
|
Custom Field 8 |
No |
No |
Custom Field 8 |
||
|
Custom Field 9 |
No |
No |
Custom Field 9 |
||
|
Custom Field 10 |
No |
No |
Custom Field 10 |
||
|
Custom Field 11 |
No |
No |
Custom Field 11 |
||
|
Custom Field 12 |
No |
No |
Custom Field 12 |
||
|
Custom Field 13 |
No |
No |
Custom Field 13 |
||
|
Custom Field 14 |
No |
No |
Custom Field 14 |
||
|
Custom Field 15 |
No |
No |
Custom Field 15 |
||
|
Custom Field 16 |
No |
No |
Custom Field 16 |
||
|
Custom Field 17 |
No |
No |
Custom Field 17 |
||
|
Custom Field 18 |
No |
No |
Custom Field 18 |
||
|
Custom Field 19 |
No |
No |
Custom Field 19 |
||
|
Custom Field 20 |
No |
No |
Custom Field 20 |