Skip to main content

Contract Pricing - Quick Guide

S
Written by Shivprasad Vaidyanathan

1. Overview

  • When quoting wire harnesses, you often secure custom contract pricing with key manufacturers and distributors. Contract Prices allows you to upload these pricing sheets directly into Cableteque.

  • Once uploaded, the sourcing engine automatically applies your custom pricing contracts to your materials in real-time, matching your specific quantities to the correct price breaks.

2. Preparing & Uploading Your Pricing Sheets

Step 1: Download the Excel Template

  • Click Contract prices in the left sidebar menu.

  • Click Add Contract Prices in the top-right corner of the screen.

  • Inside the upload modal, click the purple Download a template button located in the drag-and-drop zone.

Step 2: Format Your Pricing Sheet

  • Fill out the downloaded template. The spreadsheet contains columns for part numbers, manufacturers, distributors, price breaks, lead times, stock, and expiration dates.

Part number

Manufacturer

Distributor

Price Break Qty

UOM

Unit price

Valid until

Example_Connector

TE

TTI

1

each

4.00

2026-12-31

Example_Terminal

Aptiv

Mouser

100

each

0.05

2027-06-30

  • Setting Up Price Breaks: To set up tiered pricing for the same part, simply add consecutive rows with the same part number and matching manufacturer/distributor details. Enter the different quantity tiers in the Price Break Qty column.

  • Managing Expiration Dates: You can enter specific expiration dates for individual parts directly into the Valid until column in the Excel file.

Step 3: Uploading to Cableteque

  • Open the Add Contract Prices modal.

  • Enter a unique List name (e.g., TTI Special Contract 2026).

  • Select your Price sheet type:

  • Global: Applies this pricing sheet across all customers.

  • Customer-Specific: Restricts this pricing sheet so it only applies when quoting for a specific customer.

  • Set the Valid until date. This acts as your default expiration date. If some rows in your Excel file do not have a date in the Valid until column, they will automatically use this default date.

  • Drag and drop your file into the drop zone (or click Browse), then click Import.

3. Managing & Filtering Your Contract Prices

Viewing Expiry Dates (The "Multiple" Tag)

  • If you upload an Excel sheet where parts have different expiration dates, Cableteque will display Multiple under the VALID UNTIL column on your dashboard.

  • Hovering over Multiple displays a tooltip revealing your earliest and latest expiration dates:

From: 2026-06-28

To: 2026-07-08

Filtering Your Workspace

  • You can search and filter your uploaded lists using the search bar or the quick buttons:

  • All sheets: Displays every active and expired contract pricing sheet in your system.

  • Valid: Displays only sheets that are currently active and in use.

  • Expired: Displays sheets that have passed their expiration date.

4. Monitoring Your Materials View

  • When you run a quote, Cableteque applies your contract pricing automatically. You can track these active contract matches directly within the Materials view of your quote.

Crown Icon Indicators

Under the Unit Price column of your materials grid, contract pricing is highlighted by a crown icon:

  • Blue Crown 👑: Active, valid contract price. Hover over the crown to view the contract name and its validity date.

  • Red Crown 👑: Expired contract price. This indicates that your contract has expired, letting you know it's time to negotiate a renewal.

  • Blue Filled Crown 👑: Represents a contracted price retrieved via live API connection.

The Expired Tab Segment

If your materials in your quote are using expired contract prices, an Expired tab segment with a red counter badge will appear in your quote header. Click this tab to instantly view all parts tied to expired contracts so you can address pricing adjustments.


5. Key Benefits

Integrating your negotiated agreements into Cableteque unlocks powerful quoting and procurement efficiencies:

🚀 Automated Contract Application: Instantly applies custom negotiated supplier agreements directly to your materials. This eliminates the need for estimators to manually cross-reference offline pricing sheets during the quoting cycle.

🔍 Price Break Tier Optimization: The sourcing engine automatically evaluates your active quote quantities against multi-tiered pricing matrices. By resolving the $MOQ \le \text{Required Qty}$ calculation, the system guarantees you secure the absolute best qualified contract rate for every assembly.

🛡️ Expiration Risk Mitigation: Real-time visual tracking automatically flags expired contracted items with a red crown and pools them into a dedicated tab segment. This prevents estimating teams from accidentally quoting clients using invalid, outdated supplier rates.

🔒 Secure Contract Segregation: Provides robust multi-tenant data isolation by letting you restrict custom-negotiated pricing sheets to specific customer accounts, while keeping standard, non-proprietary agreement sheets globally accessible.

Did this answer your question?