Import Bid Online Commodities

Each item that is tracked by Bid Online is 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 BQO_COMM_MSTR table of Bid Online.

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