All templates

Automated DistributionPlus PVF Backorder Alerts

Every morning, WebRun opens CP Tech DistributionPlus, finds every backordered pipe, valve, and fitting line, links each to the order or job it belongs to, logs the full list to Google Sheets, and posts your purchasing team a ranked Slack alert with the lines that have no ETA or a late ETA at the top.

Runs on WebRun · Strict Lockdown policy
Every day at 7:00 AM WebRunorchestrates each step
1 CP Tech DistributionPlus find backordered PVF lines
2 Google Sheets log the backorder tracker
3 Slack alert purchasing on urgent lines
In short

How do I get an early warning before a PVF backorder stalls a job?

Every morning, WebRun opens CP Tech DistributionPlus, finds every backordered pipe, valve, and fitting line, and links each to its order or job. It logs the list to Google Sheets and posts purchasing a ranked Slack alert, lines with no ETA or a late ETA first, so no job stalls waiting on parts.

  • Backordered PVF lines with no ETA are flagged before a contractor's job stalls
  • Purchasing opens Slack to a ranked backorder list every morning instead of running reports by hand
  • Lines that receive stock overnight drop off the tracker automatically

Built for PHCP wholesale distributors · plumbing supply purchasing teams · inside sales reps · branch 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 cptechinc.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    CP Tech DistributionPlus - find backordered PVF lines
    cptechinc.com
    WebRun in CP Tech DistributionPlus: find backordered PVF lines
    WebRun opens CP Tech DistributionPlus to find backordered PVF lines.
    • Open DistributionPlus and filter the backorder report to pipe, valve, and fitting categories
    • Capture the SKU, description, quantity short, vendor ETA, and the linked sales order or job for each line
    • Flag any line with no ETA or an ETA later than the linked job's need by date

    Done when Every backordered PVF line is captured with its ETA and linked order.

  3. 2
    Google Sheets - log the backorder tracker
    google.com
    WebRun in Google Sheets: log the backorder tracker
    WebRun opens Google Sheets to log the backorder tracker.
    • Append today's backordered lines to the PVF backorder tracker with the run date
    • Remove lines that received stock or shipped since the last run
    • Add a column showing days backordered for each line

    Done when The backorder tracker reflects today's list with ETA and days backordered for every line.

  4. 3
    Slack - alert purchasing on urgent lines
    slack.com
    WebRun in Slack: alert purchasing on urgent lines
    WebRun opens Slack to alert purchasing on urgent lines.
    • Post the purchasing channel a ranked list led by lines with no ETA or a late ETA
    • Include the SKU, quantity short, linked job, and days backordered for each line
    • Link to the full Google Sheets tracker for the complete list

    Done when Purchasing has today's ranked PVF backorder alert in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
cptechinc.com
ScheduleRuns automatically on this cadence
Every day at 7:00 AM
DeliveryHow each run's result reaches you
Backorder tracker · Slack
OutputWhat each run produces - A PVF backorder tracker in Google Sheets plus a ranked Slack alert flagging lines with no ETA or a late ETA against their linked job.
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 reorder or expedite a backordered line automatically?

No. WebRun only surfaces the ranked list. Your purchasing team decides whether to expedite, substitute, or wait, and places any order themselves.

How does it decide which backorders are most urgent?

It ranks lines by whether they have no ETA at all or an ETA later than the need by date on their linked job, so the ones most likely to stall a contractor sit at the top.

What happens once a backordered line ships?

WebRun reads the live backorder status in DistributionPlus each morning, so any line that received stock or shipped since the last run drops off the tracker automatically.

Put this on autopilot.

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