Connectors

/

BigCommerce

/

BigCommerce product sales ranking
Report

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.

Try PopdockAI free
Get a live demo
BigCommerce product sales ranking
Rank our BigCommerce products by units sold, show the top 10, and list slow movers for the Northwind Traders brand.
The top 10 Northwind Traders products sold 6,240 units, and 8 visible products older than 90 days have never sold. - Leader: NW-1042 Canvas tote, 1,420 sold, 212 in stock - Second: NW-1001 Linen apron, 980 sold - Slow mover: NW-2090 Brass planter, 150 in stock, created 2026-03-04 - Observation: 3 slow movers hold over 100 units each Want the full slow movers table?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-brand
bigcommerce-get-product

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

Connect BigCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Resolve

It matches the brand and stops if several match.

bigcommerce-get-brand

03

Rank

It ranks visible products with sales by units sold.

bigcommerce-get-product

04

Report

You get slow movers older than 90 days plus observations.

Your AI tool

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.

get-data

bigcommerce-get-brand

Returns brands from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

bigcommerce-get-product

Returns products from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
Read only.Nothing in BigCommerce Changes

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.

How Popdock AI secures your data

The outcome

What sells and what has stalled, in one answer

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation