All templates
For lumber dealers, building materials distributors & pricing managers

Roll out supplier price list changes in DMSi Agility without missing a SKU

When you upload a supplier price list, WebRun compares every SKU cost against the current DMSi Agility cost file, identifies increases and decreases, calculates the margin impact, logs the full change set in Google Sheets, and posts a review checklist to Slack so your pricing team can approve each change before it goes live in the ERP.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
On manual upload of a new supplier price file WebRun
1 DMSi Agility read current costs and pricing rules by SKU
2 Google Sheets log cost deltas and margin impact for review
3 Slack post pricing review checklist for team approval
Run a sample
In short

How do I automatically review and roll out supplier price list changes in DMSi Agility?

When you upload a supplier price file, WebRun compares every SKU cost against DMSi Agility, calculates the margin impact at each customer pricing tier, logs the full change set in Google Sheets with an approval column, and posts a review checklist to Slack. No cost updates go live until your pricing team approves each change.

  • Every supplier cost change is reviewed for margin impact before it goes live
  • High-impact SKUs are flagged automatically so pricing managers focus where it matters
  • Price list updates that used to take hours are reviewed and logged in minutes

Built for lumber dealers · building materials distributors · pricing managers · purchasing managers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.dmsi.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    DMSi Agility - read current costs and pricing rules by SKU
    dmsi.com How to Automate DMSi Agility
    WebRun in DMSi Agility: read current costs and pricing rules by SKU
    WebRun opens DMSi Agility to read current costs and pricing rules by SKU.
    • Open DMSi Agility and export the current cost file for the relevant supplier
    • Compare each SKU in the new price list against the current cost
    • Calculate the percentage change and the resulting margin impact at the current sell price
    • Flag SKUs with a cost increase above five percent for priority review

    Done when Every SKU with a cost change is identified with its delta and margin impact.

  3. 2
    Google Sheets - log cost deltas and margin impact for review
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log cost deltas and margin impact for review
    WebRun opens Google Sheets to log cost deltas and margin impact for review.
    • Log every changed SKU as a row with current cost, new cost, dollar delta, percentage change, and margin impact
    • Highlight rows where the cost increase would push the margin below the acceptable floor
    • Add a reviewer approval column so pricing team can sign off line by line

    Done when Full cost-change log is in Google Sheets with margin impact and approval column.

  4. 3
    Slack - post pricing review checklist for team approval
    slack.com How to Automate Slack
    WebRun in Slack: post pricing review checklist for team approval
    WebRun opens Slack to post pricing review checklist for team approval.
    • Post a summary to the pricing Slack channel: number of SKUs changed, total increase, and count of margin-risk items
    • Link directly to the Google Sheets review file
    • Tag the pricing manager to begin the review

    Done when Pricing team is alerted in Slack and has the review file link.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.dmsi.com
ScheduleRuns automatically on this cadence
On manual upload of a new supplier price file
DeliveryHow each run's result reaches you
Price review checklist · Slack
OutputWhat each run produces - A Google Sheets cost-change log with delta, margin impact, and approval column for every affected SKU, plus a Slack summary alert.
Spreadsheet
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it update costs in DMSi Agility automatically?

No. WebRun identifies and logs every cost change for your pricing team to review. Cost updates in DMSi Agility are made only after your team has approved each change in the Google Sheets checklist.

What if a supplier uses different SKU codes than DMSi Agility?

WebRun maps supplier part numbers to your internal DMSi Agility item codes using the vendor item cross-reference. Any SKUs that cannot be matched are listed separately for manual review.

Does it check the impact on customer sell prices?

Yes. It reads the current pricing rules in DMSi Agility, calculates the resulting margin at each customer price tier, and flags any SKU where the new cost would push the margin below your defined floor.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.