Updating Dot Foods Items

During initial setup of entrée.DOT you will run the Update Catalog & Pricing utility to load the full Dot Foods catalog into the entrée.DOT database as described in the Importing Dot Foods Items Overview.

 

Once items from the Dot Foods catalog have been imported into entrée they must be kept up to date. This is done by running the Update Dot Catalog & Pricing utility in the Dot Foods Control Panel daily. Clicking this option will begin a query of the FTP site defined in System Preferences FTP settings for an updated catalog and pricing file. Should one of these files be found it will automatically be imported. No further action is required to complete the update process.  If there are no update files available a message will be displayed as seen in the image here.

 

IMPORTANT: This utility must be run once a day to keep the catalog and pricing data from Dot Foods current.

 

Access entrée.DOT to update prices for Dot Foods items

1.To access the entrée.DOT Control Panel option:

entrée V4 SQL Go to the Add-Ons ribbon menu > click the entrée.DOT drop down menu > select Update Dot Catalog and Pricing.

 

entrée V3 Use menu path: Inventory > entrée.DOT Control Panel > select Update items with new pricing from the Dot Foods Catalog.

2.If your files are current a message indicating that there are no new files to import will be displayed, other-wise an update to the Dot Foods database is performed.

 

8 Tier Pricing

The Dot Foods Pricing Catalog now supports 8 tiers of pricing. Most distributors typically use only tiers 1 through 4, low-volume pricing has been added in tiers 5 through 8. With tier 5 being the lowest volume/highest cost price and tier 8 one level below tier 1. This arrangement for the pricing information was used to avoid creating a conflict with the price information in the Catalog Pricing and Catalog Future Pricing data tables.

 

Price Breaks and 8 Tier Pricing

With 8 Tier Pricing came an update to the way tier pricing is applied when using Dot Catalog pricing. Previously, price breaks were being evaluated on a "per line-item" basis, meaning that the weight of a single line item would have to cross the weight threshold before a price break was applied to that one item.

 

Create/Change Purchase Order has been updated so that, if System Option #174 - "Use pricing from Dot Foods catalog when creating Purchase Orders" is enabled, then the "Unit Cost" and "Extended Amount" values for all items will immediately be reviewed and recalculated as necessary whenever the total weight of the entire order exceeds the threshold for receiving a price break.

 

Future Catalog Pricing Feature

When pricing information is being imported in entrée.DOT it will be placed into a "future price" file instead of going directly to the active Dot Price File. After all of the pricing data has been imported into entrée.DOT the data will be reviewed and any prices which are currently in effect will automatically be transferred to the active Dot Price File.