Connectors

/

BigCommerce

/

Check BigCommerce demand against PowerGP Online supply
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check BigCommerce demand against PowerGP Online supply
For company TWO, which of our top 10 BigCommerce sellers from the last 14 days are at risk of running out, and is any purchase order due in time?
3 of your top 10 sellers have under 14 days of cover and no purchase order due in time. - WIDGET-100: 220 units sold, 5 days of cover, nothing on order - CABLE-USB-2M: 180 units sold, 9 days of cover, next PO promised in 21 days - BAG-TOTE-BLK: 95 units sold, 11 days of cover, nothing on order - 1 SKU, GIFT-CARD-50, is not in PowerGP Online and is listed separately Want the full table of all 10 SKUs with daily rates?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order
bigcommerce-get-order-product
powergp-online-get-itemsitequantities
powergp-online-get-purchaseorders

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

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.

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

Your AI tool

02

Read

It reads recent BigCommerce orders and totals units sold per SKU, leaving out refunded lines.

bigcommerce-get-order
bigcommerce-get-order-product

03

Check

It looks up stock on hand, on order and open purchase orders for each top SKU in that company.

powergp-online-get-itemsitequantities
powergp-online-get-purchaseorders

04

Report

You get days of cover and next promised date, with risky SKUs and SKUs missing from GP flagged.

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-order

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

bigcommerce-get-order-product

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

powergp-online-get-itemsitequantities

Returns item site quantities from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

powergp-online-get-purchaseorders

Returns purchase orders from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
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

See which best sellers will run out before supply arrives

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