The vendor price features to allow you to import prices for new vendors or existing vendors, and maintain prices for existing vendors.
Entering and maintaining vendor prices in this way allows you to create orders with correct pricing without having to change the price on each item. You will have a more accurate forecast of future expenses because you have created accurate orders. Maintaining accurate vendor pricing information is also important for several other functionalities of the software, such as Suggest Orders by Par Levels or Shopping Lists. The prices updated through these features will appear in the Par Levels/Vendor Info tab of Restaurant Inventory Items.
The Vendor Prices features, under Inventory > Vendor Prices, include:
Vendor Price Sheet to print out a worksheet of a vendor's item price history, with a column for making notes.
Vendor Price Maintenance to import bid sheets or manually enter price updates.
New Vendor Bid Sheet to create a bid spreadsheet with a list of items and blank spaces for prices.
Last Price Update to report on the current price of items and the dates they were last changed.
Below are simplified descriptions of common tasks performed with these features. See the help topic for specific screens for more detailed information.
You can import a spreadsheet of prices into Compeat, which will then update the various price fields throughout the system. These features should be used to submit and receive bid sheets, or for vendors who do not support electronic order guides. For vendors who offer electronic order guides, you may want to use the Import Order Guides feature.
Here is the general procedure for gathering bid prices:
Create a New Vendor Bid Sheet. The bid sheet provides a list of items with blank cells for vendors to enter their prices.
Email the bid sheet to your vendor.
Once the vendor has return the bid sheet with prices, go to Vendor Price Maintenance to import bid sheet.
Click Import Vendor Prices, and then select the spreadsheet to be imported. The data grid will fill with the imported data.
Click Apply Changes to save the imported information to the system.
You may occasionally need to update prices for a vendor without importing a spreadsheet. You can manually enter and update prices through the Vendor Price Maintenance screen.
Go to Vendor Price Maintenance.
Select the desired vendor from the Vendor drop-down list. All of the vendor's items will display in the data grid.
Enter the updated price in the New Price field of the grid.
Click Apply Changes to save the updated prices to the system.