Managing vendor pricing and associations

Table of contents

• Setting up vendor prices

• Key data fields

• Bulk updates via export and import

If you purchase the same product from multiple suppliers, this module allows you to record the specific purchase prices for each vendor. This ensures that when you create a purchase order, the system automatically suggests the correct products and costs associated with that specific supplier.

Setting up vendor prices

To manage your supplier costs, navigate to the vendor prices module (found under the more arrow in the bottom-left menu).

• Add a price: Click the edit button at the top right, then use the plus (+) icon to add a new record.

• Modify a price: Click the edit button at the end of a specific row to adjust existing details.

• Remove a price: Use the minus (-) icon to delete a vendor-product association.

Key data fields

When creating or editing a record, pay attention to the following fields to ensure accurate purchasing:

• Vendor & product: Select the supplier and the specific item code for the association.

• Quantity: Use this field to create tiered pricing (price breaks). If left blank, the price applies to any quantity.

• Price & currency: Enter the purchase cost. It is best to enter prices for each currency you use; otherwise, the system will calculate the cost based on current exchange rates.

• Start date: This field is mandatory and cannot be set in the past.

• End date: This is optional. The system may automatically assign an end date if a newer price record is imported.

Bulk updates via export and import

Managing large lists of supplier prices is most efficient using Excel.

1. Export: Click the export button to download your current list. This file serves as the perfect template for changes.

2. Edit: You can copy prices between products or update rates in bulk. Do not change the column headers, as this will cause the import to fail.

3. Import: Upload your modified file. The system validates the data to ensure vendors and products already exist in Paragon.

Automatic price versioning: If you import a price with a new start date, Paragon automatically handles the history for you.
For example, if an item costs €10.00 from Jan 1st and you import a new price of €12.50 starting Nov 1st, the system will automatically set the end date of the old price to Oct 31st.