IndustriesNewsletterAbout

Track supplier price increases

Pull new prices from supplier notices and see which items to reprice.

Estimated time saved

Estimated: a few hours per price update cycle. (Estimate; results vary.)

Tools
  • ChatGPT (data analysis)
  • Microsoft Copilot in Excel
  • Claude

The problem

Steel and building material prices change often, and supplier price letters pile up before anyone updates the price list.

Step by step

  1. 1Save supplier price notices and price sheets as PDF or Excel.
  2. 2Ask AI to extract item, old price, new price and effective date into a table.
  3. 3Compare against your current sell prices in Excel and flag items below your target margin.
  4. 4Owner approves the new price list.

Copy-paste prompt

Prompt
From this supplier price notice, make a table of item, description, old price, new price, % change and effective date. Then compare it to my price list (attached) and list items where my margin drops below [X]%.

Review AI output before using it. Don’t paste confidential, customer or patient data into tools your company hasn’t approved.

Get this built for your business

Want “Track supplier price increases” set up and running in your company? Tell us a little about your business.