Updating Prices and Other Information From the New File

Updating inventory items in EBMS from a vendor catalog is fast and simple once the correct parameters are set.

The updated inventory items are controlled by going to Inventory > Options > Vendor Catalogs > Properties button > General tab. The items that will be updated are the items that the Key Type Field matches the Key Expression in the vendor catalog as shown below:  The Inventory ID of the inventory item in EBMS needs to match the field in the vendor price catalog called ID in the example below:

The fields to be updated in the Inventory item are controlled by going to Inventory > Options > Vendor Catalogs > Properties button > Update tab as seen below (example below: The fields Base Price and Cost will be updated in the EBMS product catalog). When the Base Price is updated the Markup formula is set to (None), however when the Markup formula is Calculate cost from multiplier: ____, ___ Decimals,Round _ the Base Price is not changed.

After the new vendor price catalog is saved into the EBMS data directory and the correct parameters are set up, Select Inventory > Options > Vendor Catalogs and click on the Update button. The screen below will appear.

Select the Vendor Catalog that needs to be updated by putting a check mark in the Update field and select the OK button (example above: The EBMS inventory items that are linked to the Mega Vendor Catalog will be updated).

After the utility is finished, the following screen will appear with the number of items that have been changed (example below: Four EBMS inventory items were changed or updated from the new vendor price catalog).

Select Finish to exit the update utility.