All templates
For retail store owners, inventory managers & Zakya POS users

See your Zoho POS best sellers and dead stock every week

Every Monday, WebRun opens Zoho POS, pulls units sold and revenue per product over the past 30 days, ranks the full catalog from best seller to idle stock, and writes a two part Google Sheets report so you can see what to restock and what to discount or clear.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 9:30 AM WebRun
1 Zoho POS pull 30 day sales by product
2 Google Sheets build the ranked report
Run a sample
In short

How do I see which Zoho POS products are best sellers versus dead stock?

WebRun opens Zoho POS every Monday, pulls units sold and revenue per product over the trailing 30 days, and ranks the full catalog from best seller to zero movement. It writes a Best Sellers and an Idle Stock tab to Google Sheets, with the cash value tied up in slow items, so restocking and clearance decisions are easy to make.

  • Best sellers and dead stock are both visible every Monday without a manual export
  • Cash tied up in idle inventory is quantified so clearance decisions are easy
  • Restocking focuses on proven movers instead of guesswork

Built for retail store owners · inventory managers · Zakya POS users · small chain retailers

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

  2. 1
    Zoho POS - pull 30 day sales by product
    zoho.com How to Automate Zoho POS
    WebRun in Zoho POS: pull 30 day sales by product
    WebRun opens Zoho POS to pull 30 day sales by product.
    • Open Zoho POS and pull units sold and revenue per product for the trailing 30 days
    • Capture current on hand quantity alongside each product's sales figures
    • Note products with zero units sold in the period

    Done when Every active product has 30 days of units sold and revenue captured.

  3. 2
    Google Sheets - build the ranked report
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: build the ranked report
    WebRun opens Google Sheets to build the ranked report.
    • Rank the full catalog by units sold, highest first, into a Best Sellers tab
    • List every product with zero or near zero sales into an Idle Stock tab with its on hand quantity and days since last sale
    • Highlight idle items tying up the most cash based on quantity times cost

    Done when The Best Sellers and Idle Stock tabs are both current and ranked.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.zoho.com/pos
ScheduleRuns automatically on this cadence
Every Monday at 9:30 AM
DeliveryHow each run's result reaches you
Sales and idle stock report · Google Sheets
OutputWhat each run produces - A Google Sheets report with products ranked by 30 day sales, plus an Idle Stock tab flagging items with little or no movement and the cash tied up in each.
Spreadsheet
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

How far back does the sales ranking look?

It uses a rolling 30 day window by default, so the ranking always reflects recent demand rather than a one time spike. The window is configurable at setup.

What counts as idle stock?

Any product with zero or near zero units sold across the 30 day window, still holding on hand quantity. It is flagged with the cash value tied up so you can prioritize which items to discount.

Will it discount or remove idle items for me?

No. It only reports which items are idle and what they are worth. Any price change, promotion, or clearance decision is yours to make in Zoho POS.

Put this on autopilot.

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