Load Commodity Codes

Each item that is placed on a bid must be identified by a commodity code. The commodity codes must be consistent between BusinessPlus and Bid Online. Currently Bid Online supports two standard sets of commodities: 5-digit NIGP and UNSPSC.

Commodities are loaded into the PE_PROD_MSTR table of BusinessPlus, which is the data accessed by the PEUPPR screen. To prevent the standard commodity codes from overlapping any existing codes defined in PEUPPR, you may choose to use a prefix for the commodity code. This is configured on the BQUPON screen.

Each commodity type is expected in a certain file format.

Run the Administrative Console. Under Database Admin > Line Item Purchasing, open the Import Person Entity Commodities plugin.

To load a file, first enter the file path or click the adjacent button to browse. Choose either NIGP or UNSPSC file type. Click the "Load File" button to load the file contents into the console and compare the records with the database. Click the "Update DB" button to update the database.