Skip to main content

Upload Contract Prices

1. Accessing Contract Pricing

Written by Jithesh B Acharya
  • Log in to your Quoteque account.

  • Locate the Contract Pricing option in the left-hand sidebar.

  • Click Contract Pricing Tab to navigate to the management view.

Access Contract Prices Section

2. Creating a Contract Price & Downloading the Import Template

  • In the Contract Pricing view, click the Add Contract Prices button located in the top-right corner.

Open Add Contract Prices Dialog
  • In the dialog that appears, click Download a Template.

  • A pre-formatted Excel file (.xlsx) will download to your local machine.

  • Populate the template with your negotiated pricing data following the column structure provided.

Open File Browser

3. Uploading a Contract Pricing List

  • Use Drag and drop or browse option to upload Contrcat price Excel file (.xlsx or .xls)

Open File Upload Options
  • Enter the List Name

    • Provide a descriptive name for the pricing list.

      Example: "Avnet Q2 2025 Negotiated Prices" or "Customer ABC - Special Pricing"

Enter Contract Price Name
  • Select the Price Sheet Type

    • Global - The pricing list applies to all quotes across all customers.

    • Customer-Specific - The pricing list applies only to quotes for a selected customer

Enable Contract Price Option
  • If Customer-Specific, select an existing customer from the dropdown or create a new customer record.

Select Customer Name Field
  • Set Validity Dates

    • Last Updated Date - Defaults to today's date.

      Valid Until Date - Defaults to one month from today. Set the appropriate expiry date for the agreement.

Access Next Step
  • Verify details and click on import

Import Contract Prices
  • Review the Import Summary

    • Number of rows successfully imported.

    • Number of rows that failed validation, along with the specific error reasons. Correct any errors in the source file and re-import if needed.

Close Import Dialog

4. Managing Uploaded Pricing Lists

  • After import, all pricing lists appear in the Contract Pricing view with the following information displayed per list:

    • Contract Price Name

    • Associated Customer Name (if customer-specific) Or Global

    • Last updated

    • Valid Until date

  • Select Preview from the Actions column to open a read-only grid showing the uploaded pricing data

Proceed to Next Action
  • Overwrite

    • Use Overwrite under the action button column to replace an existing pricing list with an updated version when supplier agreements are revised.

Access Additional Options

  • Overwire Price sheet - Upload the updated Excel file (.xlsx or .xls).

    • Optionally, update the Valid Until date to reflect the new agreement period.

    • Confirm the overwrite. The previous pricing data will be replaced in full.

Open File Upload Interface
  • Export

    • Select Export from the Actions column to download the current pricing list in the same Excel template format. Use this to make offline updates before re-importing via Overwrite.

Access Contract Price Options

Delete

  • Select Delete from the Actions column to permanently remove a pricing list. Deleted pricing lists will no longer be available as offers during sourcing. This action cannot be undone.

Proceed with Action

5. Contract Pricing in the Material View

  • Uploaded contract pricing is automatically available as a sourcing offer when building quotes.

  • Contract pricing and API-sourced offers are displayed using the same crown icon in the pricing column.

  • The tooltip indicates whether the price is sourced from an API or a contract pricing sheet.

    • Blue Crown - Active - the pricing list is within its valid date range.

    • Red Crown - Expired - the pricing list has passed its Valid Until date

Proceed to Next Step

Did this answer your question?