All templates

Automated Marg ERP Expiry Stock Alerts

Every morning, WebRun opens Marg ERP, checks batch and expiry dates for stock expiring within your window, builds a clearance list in Google Sheets ranked by value at risk, and drafts WhatsApp offers to retailers who buy those lines, left unsent for your approval.

Runs on WebRun · Strict Lockdown policy
Every day at 8:00 AM WebRunorchestrates each step
1 Marg ERP find near-expiry batches
2 Google Sheets build the clearance list
3 WhatsApp draft clearance offers
In short

How do I clear near-expiry stock before it expires?

Every morning WebRun opens Marg ERP, reads batch and expiry data, and flags stock expiring within your window ranked by value at risk. It builds a clearance list in Google Sheets and drafts WhatsApp offers to the retailers who buy those lines, left unsent for your approval, so slow batches sell before they expire.

  • Near-expiry batches surface early, ranked by value at risk
  • Clearance offers are drafted for the right retailers
  • Fewer expiry write-offs and return claims

Built for pharma distributors · FMCG wholesalers · stockists · Marg ERP users

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.margcompusoft.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Marg ERP - find near-expiry batches
    margcompusoft.com
    WebRun in Marg ERP: find near-expiry batches
    WebRun opens Marg ERP to find near-expiry batches.
    • Open Marg ERP and read batch-wise stock with expiry dates
    • Flag every batch expiring within your chosen window, for example the next 90 days
    • Note the quantity, batch, expiry, and value at risk for each

    Done when Every near-expiry batch is listed with its expiry and value at risk.

  3. 2
    Google Sheets - build the clearance list
    google.com
    WebRun in Google Sheets: build the clearance list
    WebRun opens Google Sheets to build the clearance list.
    • Open the clearance sheet and add a dated section
    • List each near-expiry line ranked by value at risk
    • Suggest which retailers usually buy that product for a quick clearance

    Done when A ranked clearance list is saved in the sheet.

  4. 3
    WhatsApp - draft clearance offers
    whatsapp.com
    WebRun in WhatsApp: draft clearance offers
    WebRun opens WhatsApp to draft clearance offers.
    • Draft a short clearance offer for each suggested retailer naming the product and batch
    • Keep the tone friendly and on-brand
    • Leave every offer unsent in WhatsApp for you to review and send

    Done when A clearance offer is drafted, unsent, for each target retailer.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.margcompusoft.com
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Clearance list · Google Sheets
OutputWhat each run produces - A ranked clearance list of near-expiry batches by value at risk, with a drafted WhatsApp offer for each target retailer.
Text
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 send offers to retailers on its own?

No. WebRun drafts every WhatsApp clearance offer and leaves it unsent. You decide who to approach and send each message yourself, so no offer goes out without your approval.

How far ahead does it look for expiry?

As far as you set. By default WebRun flags batches expiring within the next 90 days in Marg ERP, and you can widen or narrow that window to match your return and shelf-life terms.

Does it help decide who to offer stock to?

Yes. WebRun looks at which retailers usually buy each near-expiry line in Marg ERP and suggests them first, so the clearance offers go to the buyers most likely to take the stock.

Put this on autopilot.

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