Commodity Import

Overview

The commodity import process reads files from the ./Incoming/Commodity/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/Commodity/ before being processed in alpha-numeric order.

Note: Name is the key.

Commodity

Field NameRequired FieldUnique?Field TypeField DescriptionPossible Values
NameYesYesstring(255)Name of the commodity.
IDNoNointegerUnique identifier Coupa assigns when a new record is created. Cannot be modified, but can be used to update the record.
DescriptionNoNotextDescription
ActiveYesNobooleanWhether the commodity is active.true, false
Parent commodityNoNoName of the Parent Commodity. Can also be left blank if this commodity is not a child.
DeductibilityNoNostring(255)Deductibilityfully_deductible, partially_deductible, not_deductible
CategoryNoNostring(255)Categorygoods, services
SubcategoryNoNostring(255)Subcategoryraw_materials, investment_goods, services_exceptions
PreferredNoNostring(255)Mark/unmark a commodity as preferred. Set to Automatic to allow the system to mark preferred. Automatic option is available only if Automatic Guided Experiences configuration is enabled on the Company Information page.Yes, No, Automatic, Always, Never
Use in SearchNoNobooleanWhen enabled, searches that match tags for this commodity will boost the visibility of preferred suppliers.
TagsNoNoCommodity Tags. Separate tags with spaces. For tags with more than one word, surround the tag in double quotations.