/
/
Know which web best sellers will run out before restock
For buyers and planners who want BigCommerce sales checked against PowerGP Online stock and open purchase orders by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Best sellers run dry before anyone raises a reorder
Buyers see what sells in BigCommerce but stock and open purchase orders in PowerGP Online, so spotting best sellers about to run out means adding up order lines and looking up each SKU. Refunded lines get counted by mistake.
Without PopdockAI
- Export recent orders and total units per SKU
- Remember to remove refunded lines
- Look up stock and purchase orders for each SKU in GP
- Work out days of cover in a spreadsheet
With PopdockAI
- Units sold per SKU are totalled without refunded lines
- Stock on hand, on order and open purchase orders are read for the chosen company
- Days of cover and next promised date are shown per SKU
- SKUs missing from GP are listed apart, 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:** For GP company `{company}`, take store orders created in the last `{lookback-days}` days (default 14), rank the SKUs by units sold, and check each of the top `{top-n}` (default 10) against GP supply.
**Step 1: Recent store orders (bigcommerce server)**
Call `bigcommerce-get-order` with `date-created.from` set to the start of the window. Keep each order `id`. Then call `bigcommerce-get-order-product` with `order-id` for each order (at most 50 orders; say so if capped). Add up `quantity` by `sku`, excluding lines where `refunded` is true.
**Step 2: GP supply (powergp-online-ai server)**
For each top SKU call `powergp-online-get-itemsitequantities` with `item-number` set to the SKU and `company` set to `{company}` (sum `quantity-on-hand` and `quantity-on-order`), and `powergp-online-get-purchaseorders` with `item-number` and `company` for open orders (`po-number`, `vendor-name`, `promised-date`, `quantity-ordered`).
**Step 3: Report**
Table: SKU, units sold, daily rate, GP on hand, days of cover, on order, next promised date. Flag SKUs with cover under 14 days and no order due in time.
**Rules & Guidelines:**
* `powergp-online-*` tools belong to the powergp-online-ai server (Dynamics GP). `bigcommerce-*` tools belong to the bigcommerce server (online store). Both servers and this prompt server must be connected.
* This prompt is read-only. Call only `get` tools. Never call any `bigcommerce-*-add`, `bigcommerce-*-update` or `bigcommerce-*-delete` tool.
* Query only the GP company given in `{company}`; never mix companies.
* Show at most 25 rows per table and say how many more there are.
**Validation:**
* SKU with no GP item: list it separately as not in GP.
* If the window has no orders, say so and stop.Who it's for
One answer, three teams that use it
Buyers
Reorder before best sellers run out
Low cover with no purchase order due is flagged, so you know what to order today.
In company TWO, which top 20 BigCommerce sellers from the last 30 days have under 14 days of cover?
Supply planners
Check open purchase orders arrive in time
Next promised dates beside days of cover show whether incoming stock lands before you sell out.
For our top BigCommerce SKUs, will open purchase orders in company TWO arrive before stock runs out?
Ecommerce managers
Protect sales on your top products
Know which web best sellers are at risk before you put money behind promoting them.
Which of our 10 best selling BigCommerce products are at risk of running out in company TWO?
How it works
What PopdockAI does when you ask
You name the GP company and your AI assistant checks recent BigCommerce demand against PowerGP Online supply. It states how many orders it read.
01
Ask
You name the GP company and, optionally, the look back window and how many top SKUs to check.
02
Read
It reads recent BigCommerce orders and totals units sold per SKU, leaving out refunded lines.
03
Check
It looks up stock on hand, on order and open purchase orders for each top SKU in that company.
04
Report
You get days of cover and next promised date, with risky SKUs and SKUs missing from GP flagged.
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-order
bigcommerce-get-order-product
powergp-online-get-itemsitequantities
powergp-online-get-purchaseorders
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
See which best sellers will run out before supply arrives
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)
