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 Name Required Field Unique? Field Type Field Description Possible Values
Name Yes Yes string(255) Name of the commodity.
ID No No integer Unique identifier Coupa assigns when a new record is created. Cannot be modified, but can be used to update the record.
Active Yes No boolean Whether the commodity is active. true, false
Parent commodity No No Name of the Parent Commodity. Can also be left blank if this commodity is not a child.
Deductibility No No string(255) Deductibility fully_deductible, partially_deductible, not_deductible
Category No No string(255) Category goods, services
Subcategory No No string(255) Subcategory raw_materials, investment_goods, services_exceptions
Preferred No No string(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