/
/
See which web best sellers need restocking in GP
For buyers who watch WooCommerce top sellers and manage stock and purchase orders in Dynamics GP, by asking their AI assistant.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
Web best sellers outrun the restock decision in GP
Buyers see best sellers in WooCommerce, but stock and purchase orders sit in Dynamics GP. Deciding what to reorder means looking up each SKU, adding stock by location and checking open orders, and by then demand has moved on.
Without PopdockAI
- Pull the top sellers from the web store
- Look up each SKU in Dynamics GP
- Add up stock across locations
- Check open purchase orders one item at a time
With PopdockAI
- The ten WooCommerce top sellers read with SKU and web stock
- GP on hand and on order read for each SKU
- Open purchase orders with vendor and promised date for low items
- Unmatched products listed, and nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Identify WooCommerce top sellers and show whether PowerGP stock and open purchase orders cover them, flagging anything with PowerGP on-hand below `{stock-threshold}` (default 10) in company `{company}`.
**Step 1: Top sellers**
Call `woocommerce-get-report-top-sellers` (woocommerce server) with `max-records` 10. Keep `title`, `quantity`, `product-id`. Then call `woocommerce-get-product` with `product-id` for each to get `sku` and `stock-quantity`.
**Step 2: PowerGP stock**
For each `sku`, call `powergp-online-get-itemsitequantities` (powergp-online-ai server) with `item-number` = the SKU and `company` = `{company}`. Sum `quantity-on-hand`; note `quantity-on-order`. The join is WooCommerce `sku` = PowerGP `item-number`.
**Step 3: Open purchase orders**
For items below the threshold, call `powergp-online-get-purchaseorders` with `item-number` and `company`. Report `po-number`, `vendor-name`, `quantity-ordered`, `promised-date`.
**Step 4: Report**
Table: product, units sold, WooCommerce stock, PowerGP on hand, on order, next promised PO date, and a status of Covered, Watch or Restock.
**Rules & Guidelines:**
* Tools starting powergp-online- are on the powergp-online-ai server; tools starting woocommerce- are on the woocommerce server. Both servers must be connected.
* This prompt is read-only. Never call any WooCommerce write tool (`woocommerce-update-product`, `woocommerce-update-product-variation`, `woocommerce-add-product`, `woocommerce-update-order`, `woocommerce-add-order`, `woocommerce-add-order-note`, `woocommerce-add-refund`, `woocommerce-add-coupon`, `woocommerce-update-coupon`, `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-send-order-details`).
* Report what the tools return. Do not guess values.
**Validation:**
* Products with no `sku` or no PowerGP item are listed as unmatched.
* If the top-sellers report is empty, say so and stop.Who it's for
One answer, three teams that use it
Buyers
Reorder what is actually selling
Units sold sit next to GP stock and open orders, so you reorder the right items.
Which of our WooCommerce top sellers need restocking in Dynamics GP?
E-commerce managers
Protect your best sellers from stock-outs
Each top seller gets a status, so you know which ones are at risk before a campaign.
Check the top 10 web sellers against GP stock and flag anything under 20 on hand.
Inventory planners
See what is already on order
Next promised dates for low items show whether a restock is already coming.
For our best selling products, what is on order in GP and when is it due?
How it works
What PopdockAI does when you ask
You set a stock threshold or accept the default and your AI assistant compares WooCommerce sales with PowerGP Online stock. Each item gets a Covered, Watch or Restock status.
01
Ask
You set a stock threshold and company, or accept the defaults.
02
Read
It reads the WooCommerce top sellers and their SKUs.
03
Check
It reads PowerGP Online stock and open purchase orders for each.
04
Report
You get a table with a Covered, Watch or Restock status.
What PopdockAI provides
The tools behind the answer
Ready made tools for PowerGP Online and one secure connection to your AI tool. No code, no exports.
woocommerce-get-report-top-sellers
woocommerce-get-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
Best sellers restocked before demand runs ahead
Related use cases
More ways to put this data to work
Check PowerGP Online inventory reorder risk
Ask your AI which items are at risk and it combines Dynamics GP stock levels, costs and open purchase orders into a ranked reorder list. It never creates orders.
Learn More
Audit a PowerGP Online payroll check run
Ask your AI to audit a payroll run and it reconciles PowerGP Online pre-check summaries with posted checks, drilling into exceptions. Read-only, with no personal data shown.
Learn More
Audit PowerGP Online vendor payables and 1099
Ask your AI to audit a vendor and it reads the balance, open payables, applied payments and 1099 totals from Dynamics GP, then flags real gaps. Read-only.
Learn More
Compare PowerGP Online companies key figures
Ask your AI to compare companies and it reads cash, payables and receivables from each Dynamics GP company you name, in one table. Currencies stay separate.
Learn More
Compare PowerGP Online dimension spend to budget
Ask your AI to compare a dimension group to budget and it ranks overspent codes from Dynamics GP and lists the largest postings behind the top five. Read-only.
Learn More
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.