Roll out vendor price file updates across your parts catalog
When a vendor price file is uploaded, WebRun compares every line to current buy prices in MAM Software Autopart, calculates the margin impact for each SKU, logs the changes to a Google Sheet, and posts a Slack summary to the purchasing manager so they can approve the update before anything is changed in the live catalog.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I review vendor price file updates and check margin impact before updating MAM Autopart?
When a vendor price file is uploaded, WebRun compares every SKU to current buy prices in MAM Software Autopart, calculates the margin impact, logs the changes to a Google Sheet with red flags for lines below your margin threshold, and posts the purchasing manager a Slack summary for approval before any live catalog prices are touched.
- Margin impact of every vendor price change is visible before a single price is updated
- SKUs that would drop below margin threshold are flagged automatically
- Unmatched part numbers are caught and listed so no new vendor line is missed
Built for auto parts distributors · purchasing managers · automotive jobbers · parts warehouse pricing 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 - pull current buy prices for comparison
mamsoftware.com How to Automate MAM Software Autopart
WebRun opens MAM Software Autopart to pull current buy prices for comparison. - Open Autopart and pull the current buy price and sell price for every SKU in the vendor's range
- Match each SKU in the new price file to its Autopart record by part number
- Calculate the percentage change in buy price and the resulting impact on current margin
- Flag SKUs where the margin drops below your minimum threshold
Done when Every affected SKU has a current price, new price, and margin impact calculated.
-
2
Google Sheets - log price changes and calculate margin impact
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log price changes and calculate margin impact. - Log every changed SKU to the price-update review sheet with old price, new price, and margin impact
- Highlight lines where margin drops below threshold in red
- Add a column for the purchasing manager to mark each line as 'Approve', 'Hold', or 'Query'
Done when The margin-impact review sheet is populated and ready for the purchasing manager to mark up.
-
3
Slack - alert purchasing manager with summary for approval
slack.com How to Automate Slack
WebRun opens Slack to alert purchasing manager with summary for approval. - Post a summary to the purchasing channel: total SKUs affected, lines with margin below threshold, and largest cost increases
- Include a link to the Google Sheet for the full review
- Tag the purchasing manager with a request to approve or hold the update before the next order run
Done when The purchasing manager is notified in Slack with the impact summary and a link to the review sheet.
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 update prices in MAM Autopart automatically?
No. WebRun only analyses the impact and prepares the review sheet. Your purchasing manager approves each change, and the price update in Autopart is done by your team so no live price changes without human sign-off.
What if a part number in the price file does not exist in Autopart?
WebRun logs unmatched part numbers to a separate tab in the Google Sheet and flags them in the Slack summary so your team can decide whether to add them as new SKUs or query the vendor.
How is the margin threshold set?
You set the minimum acceptable margin percentage once when configuring WebRun. It then uses that threshold every time a price file is uploaded, highlighting any SKU that would fall below it after the new buy price is applied.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.