MAM Autopart Automated Vendor Cost Change Digest
Every Monday, WebRun opens MAM Software Autopart, compares invoiced buy prices from the past week to the expected standard costs on each SKU, calculates the variance per line, logs a full cost-change digest to Google Sheets, and posts the purchasing manager a ranked Slack summary so margin creep is spotted and acted on immediately.
How do I automatically track vendor cost changes in MAM Autopart each week?
Every Monday, WebRun compares last week's vendor invoices in MAM Software Autopart to the standard buy prices on each SKU, calculates the variance per line, logs a colour-coded digest to Google Sheets grouped by vendor, and posts the purchasing manager a ranked Slack summary so cost increases are caught and queried before they erode margins.
- Cost increases are spotted the Monday after invoices arrive, not weeks later
- Purchasing manager sees the top offending vendors ranked by total variance
- Running vendor variance history in Google Sheets makes supplier negotiations data-driven
Built for auto parts distributors · purchasing managers · automotive jobbers · parts warehouse finance teams
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.mamsoftware.comin a real browser with your saved login - no setup, no API keys. -
1
MAM Software Autopart - compare invoiced costs to standard buy prices
mamsoftware.com
WebRun opens MAM Software Autopart to compare invoiced costs to standard buy prices. - Open Autopart and pull all vendor invoices received in the past 7 days
- For each invoice line, compare the invoiced unit cost to the standard buy price recorded for that SKU
- Calculate the variance in pounds and percentage for each line
- Group variances by vendor and sort by total variance value descending
Done when Every cost variance from the past week is captured with its SKU, vendor, and variance amount.
-
2
Google Sheets - log cost variances by SKU and vendor
google.com
WebRun opens Google Sheets to log cost variances by SKU and vendor. - Append this week's variances to the cost-change digest tracker with invoice date and vendor name
- Highlight lines where the variance exceeds 5% in amber and above 10% in red
- Update the vendor summary tab with a running total of variance by supplier
Done when The cost-change tracker is updated with this week's variances and colour-coded by severity.
-
3
Slack - post ranked digest to purchasing manager
slack.com
WebRun opens Slack to post ranked digest to purchasing manager. - Post a Monday morning digest to the purchasing channel with total variance, top offending vendors, and largest single-SKU cost increases
- Include the link to the Google Sheet for full detail
- Flag any vendor with a variance above 10% for the purchasing manager to query
Done when The purchasing manager has this week's cost-change digest in Slack with the most significant variances highlighted.
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 automatically update the buy prices in MAM Autopart to match vendor invoices?
No. WebRun only surfaces the discrepancy. Updating buy prices in Autopart is done by the purchasing manager after they have decided whether to accept the new cost or query it with the supplier.
How does it handle credit notes that reduce the effective buy price?
It reads invoices and credit notes posted in Autopart and nets them off by SKU for the period, so the variance figure reflects the true net cost change rather than gross invoice price alone.
Can it track cost changes across multiple vendors at once?
Yes. WebRun scans all vendor invoices received in the past week regardless of supplier and groups variances by vendor in the Google Sheet, so the purchasing manager can see which suppliers are moving prices the most.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.