/
/
Rank BigCommerce products by units sold and find slow movers
For merchandising and sales teams who want sellers and stale stock in one answer, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Old stock that never sold hides among new arrivals
Merchandisers sort a BigCommerce export by sold count and hunt for stale stock separately. Without a clear cut-off, old products that never sold mix with new arrivals, and a revenue guess from units sold can mislead.
Without PopdockAI
- Sort the product export by units sold
- Filter out hidden products by hand
- Work out which unsold products are old enough to worry about
- Estimate revenue without knowing which price was used
With PopdockAI
- The brand is resolved first, and it stops if several match
- Visible products with sales are ranked by units sold
- Visible products older than 90 days that never sold are listed
- Any revenue estimate shows the price used, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Rank products by units sold, showing the top `{top-n}` (default 10) and the slow movers, optionally for brand `{brand-name}`.
**Step 1: Resolve the brand (optional)**
If a brand name was given, call `bigcommerce-get-brand` with `name`; if it matches several, list them and stop. Use the brand's `id` as `brand-id` below.
**Step 2: Best sellers**
Call `bigcommerce-get-product` with `visible` set to true, `total-sold.min` of 1, and `brand-id` if resolved. Sort by `total-sold` yourself.
**Step 3: Slow movers**
Call `bigcommerce-get-product` with `visible` set to true, `date-created.to` set to 90 days ago, and `brand-id` if resolved. Keep those whose `total-sold` is 0.
**Step 4: Report**
Top table: name, sku, price, stock, total sold. Slow movers table: name, sku, price, stock, date created. Finish with two or three observations (for example high stock with no sales).
**Rules & Guidelines:**
* This is a read-only job. Never call any `bigcommerce-*-add`, `bigcommerce-*-update` or `bigcommerce-*-delete` tool. Do not suggest that you changed anything.
* Rank only on `total-sold`; do not estimate revenue from it unless you show the price used.
**Validation:**
* If a read returns no records, say so plainly and stop; do not invent figures.
* If a result hits the maximum records limit, say the figures may be incomplete and name the filter that would narrow it.Who it's for
One answer, three teams that use it
Merchandisers
Know your top sellers at a glance
A ranked table with price and stock shows which products to feature and keep in stock.
Rank the top 20 BigCommerce products by units sold with price and stock.
Inventory planners
Find stock that is not moving
Visible products over 90 days old with no sales are listed, so you can plan markdowns or delisting.
Which visible BigCommerce products older than 90 days have never sold?
Sales managers
Review a brand's performance
Filter to one brand to see its leaders and laggards before a supplier review.
Top 10 Contoso products in BigCommerce by units sold, and any Contoso slow movers.
How it works
What PopdockAI does when you ask
You choose how many products to rank and optionally a brand, and your AI assistant ranks BigCommerce sellers and finds slow movers. It only reads.
01
Ask
You give how many products to rank and optionally a brand.
02
Resolve
It matches the brand and stops if several match.
03
Rank
It ranks visible products with sales by units sold.
04
Report
You get slow movers older than 90 days plus observations.
What PopdockAI provides
The tools behind the answer
Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.
bigcommerce-get-brand
bigcommerce-get-product
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
What sells and what has stalled, in one answer
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
