DMSi Agility Automated Vendor Cost Change Digest
Every Monday, WebRun opens DMSi Agility and identifies every vendor cost change posted in the past seven days, calculates the resulting margin impact at current sell prices for each affected SKU, logs the changes in Google Sheets, and posts a digest to the pricing Slack channel so the team can act before margins are squeezed.
How do I automatically track vendor cost changes and their margin impact in DMSi Agility?
WebRun reviews DMSi Agility every Monday for vendor cost changes posted in the past seven days, calculates the margin impact at current sell prices for each affected SKU, logs the full change set in Google Sheets, and posts a prioritized digest to Slack so your pricing team can adjust sell prices before margins erode.
- Pricing team is alerted to margin-eroding cost changes every Monday morning
- The highest-impact SKUs are ranked so the team focuses where margins are most at risk
- A running history in Google Sheets shows cost trends across multiple weeks
Built for lumber dealers · building materials distributors · pricing managers · purchasing managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.dmsi.comin a real browser with your saved login - no setup, no API keys. -
1
DMSi Agility - identify vendor cost changes from the past seven days
dmsi.com
WebRun opens DMSi Agility to identify vendor cost changes from the past seven days. - Open DMSi Agility and pull the cost-change audit log for the past seven days
- Capture vendor name, SKU, previous cost, new cost, and the date the change was applied
- Calculate the margin delta at each item's current sell price and customer pricing tier
Done when All vendor cost changes from the past week are captured with margin impact.
-
2
Google Sheets - log cost changes with margin impact by SKU
google.com
WebRun opens Google Sheets to log cost changes with margin impact by SKU. - Log each changed SKU with vendor, previous cost, new cost, cost delta, and resulting margin at current sell price
- Flag rows where the new margin falls below the acceptable floor
- Retain history so pricing team can see trends over multiple weeks
Done when Weekly cost changes are logged in Google Sheets with margin impact and floor-breach flags.
-
3
Slack - post weekly cost-change digest to pricing team
slack.com
WebRun opens Slack to post weekly cost-change digest to pricing team. - Post a weekly digest to the pricing Slack channel summarizing total SKUs changed, largest cost increases, and count of margin-breach items
- List the top ten highest-impact SKUs with their cost delta and new margin
- Link to the full Google Sheets log for detailed review
Done when Pricing team has the weekly vendor cost digest and top-impact SKU list in Slack.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Will it change sell prices in DMSi Agility automatically?
No. WebRun only surfaces the cost changes and their margin impact. Your pricing team decides which sell prices to adjust and makes those changes in DMSi Agility manually after reviewing the digest.
What if the same SKU had its cost changed twice in one week?
It captures the full audit trail and shows both changes in the Google Sheets log. The digest highlights the net cost movement from the start of the week to the most recent update.
How are margin-breach items defined?
A SKU is flagged when its new vendor cost, combined with the current sell price, produces a gross margin below the threshold you set during setup. You can adjust the threshold at any time.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.