Automated Lightspeed Price Margin Anomaly Flags
Every Monday, WebRun opens Lightspeed Retail, reads last week's transactions, identifies any item sold below cost or outside your accepted margin range, and appends a flagged anomaly list to Google Sheets so your manager can investigate pricing errors, unauthorized discounts, or system misconfiguration.
How do I automatically detect margin anomalies in Lightspeed Retail?
WebRun reads every Lightspeed Retail transaction from the past week every Monday, identifies any item sold below cost or outside your set margin threshold, and logs a flagged list to Google Sheets with the staff member, anomaly type, and implied margin. Your manager reviews and resolves each flag without manual report-pulling.
- Below-cost sales are caught weekly before they compound into significant losses
- Managers see the staff member and transaction details to investigate root cause
- Margin thresholds per category can be customized for each product department
Built for retail managers · store owners · retail finance teams · multi-location retailers
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
retail.lightspeedhq.comin a real browser with your saved login - no setup, no API keys. -
1
Lightspeed - scan transactions for price and margin anomalies
lightspeedhq.com
WebRun opens Lightspeed to scan transactions for price and margin anomalies. - Open Lightspeed Retail and navigate to Reports then Sales by Product
- Set the date range to the previous week
- Identify any item sold at a price below its set cost or below the minimum margin threshold you have configured
- Capture item name, SKU, cost, sale price, implied margin, and the staff member who processed the transaction
Done when Every transaction last week with a price or margin anomaly is listed with its details.
-
2
Google Sheets - log flagged anomalies for manager review
google.com
WebRun opens Google Sheets to log flagged anomalies for manager review. - Append the anomaly list to the running Price Anomaly sheet with a date stamp
- Add a column indicating the anomaly type: below cost, below minimum margin, or unusually high discount
- Highlight rows in red where items were sold below cost
- Leave a resolution column blank for your manager to record the outcome
Done when This week's margin anomalies are logged in Google Sheets with types, highlights, and a blank resolution column.
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 any prices or discounts in Lightspeed automatically?
No. WebRun only reads and flags. It never updates prices, modifies discounts, or reverses transactions. All corrective action is taken by your manager after reviewing the Google Sheets log.
How does it know what the minimum acceptable margin is?
You tell WebRun your floor margin, for example 30%, and it flags any transaction below that. You can also set different thresholds per category if your margins vary across departments.
Can it catch manual overrides where a staff member typed a lower price?
Yes. Lightspeed logs the final sale price and the cost for each line item, so WebRun can spot any transaction where the sale price dropped below your set thresholds, regardless of whether it was a system discount or a manual override.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.