All templates

Lightspeed Automated Price Change Rollout

When you trigger a price-change run, WebRun reads your list of SKUs and new prices from Google Sheets, opens each product in Lightspeed and applies the updated price, then posts a completion checklist to Slack confirming every item updated and flagging any that failed or need review.

Runs on WebRun · Strict Lockdown policy
On demand WebRunorchestrates each step
1 Google Sheets read SKUs and new prices from the change list
2 Lightspeed apply each new price to the matching product
3 Slack post completion checklist with any failures flagged
In short

How do I automatically roll out price changes across Lightspeed from a spreadsheet?

WebRun reads your price-change list from Google Sheets, opens each SKU in Lightspeed and applies the new price, then posts a Slack checklist confirming every update and flagging any failures. Seasonal repricing or supplier cost pass-throughs that used to take hours now take minutes with a full audit trail.

  • Hundreds of price changes applied in minutes rather than hours
  • Every update confirmed in a Slack checklist with old and new prices
  • Failed or missing SKUs flagged immediately for manual follow-up

Built for retail store owners · retail buyers · pricing managers · multi-location retail operators

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

  2. 1
    Google Sheets - read SKUs and new prices from the change list
    google.com
    WebRun in Google Sheets: read SKUs and new prices from the change list
    WebRun opens Google Sheets to read SKUs and new prices from the change list.
    • Open the designated price-change Google Sheet
    • Read each row containing the SKU, product name, current price, and new price
    • Validate that each row has a complete set of required fields before proceeding

    Done when All SKUs and their new prices are read and validated from the Google Sheet.

  3. 2
    Lightspeed - apply each new price to the matching product
    lightspeedhq.com
    WebRun in Lightspeed: apply each new price to the matching product
    WebRun opens Lightspeed to apply each new price to the matching product.
    • Open Lightspeed Retail and search for each SKU by product code
    • Update the product price to the new value specified in the sheet
    • Confirm the change is saved and note any products that could not be found or updated

    Done when Every SKU from the list has been updated in Lightspeed or flagged as failed.

  4. 3
    Slack - post completion checklist with any failures flagged
    slack.com
    WebRun in Slack: post completion checklist with any failures flagged
    WebRun opens Slack to post completion checklist with any failures flagged.
    • Post a summary checklist to the management Slack channel
    • List successfully updated products, their old price, and new price
    • Highlight any SKUs that failed or could not be matched for manual follow-up

    Done when A completion checklist is posted in Slack with all updates confirmed and failures flagged.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
retail.lightspeedhq.com
ScheduleRuns automatically on this cadence
On demand
DeliveryHow each run's result reaches you
Price update checklist · Slack
OutputWhat each run produces - A Slack checklist confirming each price update in Lightspeed, with old and new prices, and a flag list for any items that could not be updated.
Report
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

Does it apply price changes across all Lightspeed locations at once?

Yes. When your Lightspeed account manages multiple locations, WebRun can apply the price change to all of them in a single run and confirm each location in the checklist.

What if a SKU in the sheet does not exist in Lightspeed?

WebRun logs the missing SKU as a failure in the Slack checklist so you can investigate the mismatch and update the product manually if needed.

Can I preview the changes before they are applied?

Yes. Run WebRun in review mode first and it will post a preview list to Slack showing exactly what will change, without writing anything to Lightspeed, so you can confirm before committing.

Put this on autopilot.

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