/
/
Spot under-priced Shopify items against GP cost
For finance teams who want GP price lists and cost compared with Shopify prices by asking their AI assistant.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
Below-cost Shopify prices slip through item by item checks
Prices and costs are checked one item at a time, once in the Dynamics GP price lists and again in the Shopify admin. Under-priced and below-cost items slip through, and a unit of measure or currency mismatch makes the comparison misleading.
Without PopdockAI
- Open the GP price list and current cost for the item
- Look up the same variant in the Shopify admin
- Work out both margins by hand
- Compare across different units or currencies by mistake
With PopdockAI
- GP cost and price list row read for the item
- Shopify price, compare price and cost read for the variant
- Both margins, the gap and a plain verdict
- Same unit of measure only, currencies never converted
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For item `{sku}`, compare the Dynamics GP price list and cost with the Shopify variant price, using price level `{price-level}` (any level if empty).
**Step 1: GP side**
Call `powergp-online-get-items` (powergp-online-ai) with `item-number` = `{sku}` to get `current-cost` and `price-level-id`. Then call `powergp-online-get-itempricelists` (powergp-online-ai) with `item-number` = `{sku}` to get `price`, `price-level`, `currency-id`, `uof-m` and `from-quantity`.
**Step 2: Shopify side**
Call `shopify-get-product-variant` (shopify) with `sku` = `{sku}` and read `price` and `compare-price`. Call `shopify-get-inventory-item` (shopify) with `sku` = `{sku}` and read `cost`.
**Step 3: Report**
Show GP price (for `{price-level}` if given), GP current cost, Shopify price, Shopify compare price, Shopify cost, margin on each side, and the gap. State clearly whether prices match, Shopify is lower than GP, or Shopify is below GP cost.
**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.
* Compare only the price-list row with `from-quantity` 1 or lowest, and only in the same unit of measure.
**Validation:**
* If the SKU has no price list row, report cost only.
* If currencies differ, report both and do not convert.
* If the SKU is missing on one side, say so and stop.Who it's for
One answer, three teams that use it
Pricing analysts
Check web prices against GP in one answer
See GP price, Shopify price and the gap together, with a clear statement of which one is lower.
Compare GP price level WHOLESALE for item LAMP-220 with its Shopify price.
Finance managers
Catch items sold below cost online
Margins on both sides show whether Shopify is selling an item below its GP cost before it eats into profit.
Is our Shopify price for CHAIR-40 below the Dynamics GP cost?
E-commerce managers
Keep compare at prices honest
See the compare price and Shopify cost next to the GP price list before you run a promotion.
Show GP and Shopify prices, costs and margins for item DESK-300 before our sale.
How it works
What PopdockAI does when you ask
You give an item number and your AI assistant reads PowerGP Online and Shopify side by side. It compares like with like and changes nothing in either system.
01
Ask
You give an item number and optionally a price level.
02
GP
It reads the current cost and price list row.
03
Shopify
It reads the variant price, compare price and cost.
04
Report
You get both margins, the gap and a plain verdict.
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-items
powergp-online-get-itempricelists
shopify-get-product-variant
shopify-get-inventory-item
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
Under-priced items caught from one comparison
Related use cases
More ways to put this data to work
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
Compare PowerGP Online and Shopify stock by SKU
Ask your AI to compare stock by SKU between GP and Shopify. It ranks the differences and puts oversell risk first without changing anything.
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.