Import Person Entity Commodities

Each item that is placed on a bid must be identified by a commodity code. Commodity codes must be consistent between BusinessPlus and Bid Online. 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 PE Product Information (PEUPPR) page. 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 page.

Each commodity type is expected in a certain file format. To load a file, launch the Import Person Entity Commodities in the Administrative Console (Database Admin > Line Item Purchasing). Enter the file path or use the adjacent Lookup button to locate the file. Select NIGP or UNSPSC file type. Click the "Load File" button to load the file contents into the console to compare the records with the database. Press the "Update DB" button to update the database.