Import Order Guides

Importing order guides allows you to automatically update vendor prices for order guide items on each item's Vendor Info tab (Restaurant Inventory Items) in Compeat.  This ensures that when orders or invoices are created in Compeat, the most up-to-date vendor prices are used.

 

Note:  Importing order guide pricing only updates the pricing used on orders and invoices.  It DOES NOT affect item valuation.

 

You can setup templates for importing order guides under Electronic Transmissions.

Access the screen under Inventory > Import Order Guides.

You can automate a price update process with a vendor that supports electronic ordering and order guides using this screen.

 

Toolbar

Toolbar buttons are available on the screen to perform the following actions:

Buttons

Note: You can highlight multiple items using Ctrl+Click and a range using Shift+Click.

 

Here is how the process works:

  1. Define an order guide template for the vendor on the Order Guides screen (Setup > Electronic Transmissions).

  2. Find your vendor on the Vendors screen (Setup > Accounts Payable > Vendors > Vendor Info tab), and specify the template in the "Order Guides" field, under Electronic Distributors.

  3. Select your vendor from the Vendor drop-down list in the Import Order Guide screen.

  4. Download the order guide from the vendor's website (click on the URL in the Compeat toolbar to access the vendor's website).  In the 'File Name' field, navigate to the file in the location you downloaded it to.  If the order guide is retrieved from an FTP site, skip this step, leaving the 'File Name' field blank.

  5. Click the Import button Items from the order guide file populate the screen, each having an indicated Status (see Status Column below).

 

image110.jpg


Compeat will attempt to match the items on the order guide to items in the restaurant inventory.  Based on your order guide template settings, Compeat will compare the item code, split case indicator, variable weight indicator, and/or pack size that are on the order guide, to the entries on the Par Levels/Vendor info tab of the restaurant inventory items.  If an exact match is found, ‘Exact Match’ is entered in the item’s  ‘Status’ column.  This means that the price can be accepted, and assigned to the item in Compeat when the items are processed.  For some items, Compeat may enter ‘Match’ in the item’s status column.  This can be for several possible reasons:

 

 

If a record exists more than once in an order guide file, and can be matched to an item in the restaurant inventory, ‘Multiple Match’ is entered in the status column. Multiple match items can be resolved by deleting one of the offending order guide records from the file and reprocessing.

 

If Compeat is unable to find any match for an item on the order guide in the restaurant inventory ‘New’ is entered in the status column.  This usually means that the vendor and item code aren’t assigned to any restaurant inventory item in Compeat, or the item itself isn’t defined in Compeat.

 

  1. (Optional) Resolve unmatched items If items remain marked New or Match and you would like to include these in your price update, they can be resolved as follows:

 

image61.gif

Double-click the entry that is an exact match for the entry on the order guide.  Compeat will accept this as an exact match, and the status will change to ‘Exact Match’.  If you wish to ensure that the match you selected is an Exact Match every time you import the order guide for the selected vendor, either remove the other matching entries from the inventory item(s), or check the ‘Order Guide Default’ box next to the entry on the item’s Par Levels/Vendor Info tab.

 


image62.gif

image63.gif

When ‘OK’ is clicked after the item and purchase units are selected, the item’s status will change to ‘Exact Match’, and the vendor information from the order guide will be added to the Par Levels/Vendor Info tab of the Restaurant Inventory Item when the items are processed.  If the item is not set up in Compeat as an inventory item, this will need to be done before you can assign order guide vendor info to it and update its pricing.

 

  1. Click the ‘Accept All Exact Matches’ button.  Doing so will change the status of all exact match items to ‘Accepted’, and the row color will change to green:

image64.gif

You can also highlight individual rows in the grid and click ‘Accept’ to accept individual items.

 

  1. Once all of the desired Exact Matches are accepted, click ‘Process Vendor Items’.  The pricing on the ‘Accepted’ items will be updated, and the items will be removed from the order guide screen.

 

Ignoring Order Guide Items

 

Many vendors list all items they have available for ordering in the order guide file.  Many of these items may be unused in your restaurant, but they will still be displayed when an order guide is imported.  If you wish to prevent these items from being displayed, highlight the row the item is on and click the ‘Ignore’ button.  The item’s status will change to ‘Ignored’, and when the items are processed it will be added to the ignored items list.  Any items on this list will no longer appear when the order guide is imported.  The ignored items list can be viewed at Inventory > Import Order Guides > Ignored Order Guide Entries:

 

image66.gif