/
/
Catch Shopify oversells by comparing stock to GP
For operations teams who want GP quantities compared with Shopify available stock by asking their AI assistant.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
Oversells surface only when an order cannot be filled
Stock counts are compared by hand between Dynamics GP and the Shopify admin. Oversells and stale quantities go unnoticed until a customer order cannot be filled, and the two systems rarely write a SKU the same way.
Without PopdockAI
- Look up on hand and on order in Dynamics GP
- Find the same SKU in the Shopify admin
- Work out the difference item by item
- Guess at SKUs written differently in each system
With PopdockAI
- GP on hand and on order read across locations
- Shopify available stock read for the same SKU
- A table sorted by difference, oversell risk first
- Exact SKU matching only, with unmatched formats listed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare stock for `{sku}` between Dynamics GP and Shopify, in GP company `{company}` (default company if empty), and report where the two disagree.
**Step 1: GP quantities**
Call `powergp-online-get-itemsitequantities` (powergp-online-ai) with `item-number` = `{sku}` and `company` = `{company}` if given. Sum `quantity-on-hand` across locations and note `quantity-on-order` and `location-id`. If `{sku}` is empty, call it with `max-records` 50 and `quantity-on-hand.min` 0 and use the item numbers returned.
**Step 2: Shopify quantities**
For each item number, call `shopify-get-inventory-level` (shopify) with `sku` = the GP `item-number`. Sum `available` across locations. If nothing returns, call `shopify-get-product-variant` (shopify) with `sku` to see whether the SKU exists at all.
**Step 3: Report**
A table: SKU, GP on hand, GP on order, Shopify available, difference, and a verdict (matches, Shopify higher, GP higher, missing in Shopify, missing in GP). Sort by largest absolute difference. Put any oversell risk (Shopify higher than GP on hand) first.
**Rules & Guidelines:**
* `powergp-online-*` tools belong to the powergp-online-ai server; `shopify-*` tools belong to the shopify server. Both servers must be connected; if a tool is missing, name the missing server and stop.
* This prompt is read-only. Never call any `shopify-add-*` or `shopify-update-*` tool, and do not change anything in either system.
* Match on exact SKU equal to item number, ignoring case and surrounding spaces.
**Validation:**
* If a SKU has no GP record, report it as Shopify only and continue.
* If Shopify does not track the item (`tracked` false), say so instead of reporting a difference.
* Do not guess a mapping when SKU and item number formats differ; list the unmatched ones.Who it's for
One answer, three teams that use it
E-commerce managers
Stop selling stock you do not have
SKUs where Shopify shows more than GP holds are listed first, so you can fix them before the next order.
Compare a sample of 50 SKUs between GP and Shopify and show me oversell risks first.
Inventory controllers
Find stale quantities in one table
See GP on hand, on order and Shopify available side by side, with the difference for each SKU.
How does stock for SKU BOTTLE-750 in GP compare with what Shopify shows available?
Operations managers
Check stock alignment before a busy week
A ranked list of the biggest differences tells you where the two systems disagree most.
Which SKUs have the largest stock difference between our Fabrikam GP company and Shopify?
How it works
What PopdockAI does when you ask
You give a SKU, or ask for a sample, and your AI assistant reads stock from PowerGP Online and Shopify. It matches on exact SKU and changes nothing.
01
Ask
You give a SKU, or leave it empty for a sample, and the GP company.
02
GP
It reads quantity on hand and on order across locations.
03
Shopify
It reads available stock for the same SKU.
04
Report
You get a ranked table with a verdict per SKU.
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.
powergp-online-get-itemsitequantities
shopify-get-inventory-level
shopify-get-product-variant
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
Oversell risk found before a customer finds it
Related use cases
More ways to put this data to work
Compare PowerGP Online and Shopify item prices
Ask your AI to compare an item's GP price and cost with its Shopify price. It shows margins on both sides and says whether Shopify is lower or below cost.
Learn More
Find PowerGP Online items missing from Shopify and the reverse
Ask your AI to find catalog gaps between GP and Shopify. It lists items missing on either side, flags look-alike SKUs and warns when the comparison is partial.
Learn More
Match a customer between PowerGP Online and Shopify
Ask your AI to match a customer between GP and Shopify. It compares balance, spend and location and states how confident the match is.
Learn More
Review customer exposure across PowerGP Online and Shopify
Ask your AI to review a customer's exposure. It combines GP overdue receivables with Shopify orders and refunds and keeps currencies apart.
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
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.