/
/
Compare a BigCommerce product with its Dynamics GP item
For operations teams who want a SKU's name, price, cost and stock compared between the store and Dynamics GP, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Checking one SKU means four screens in two systems
The name, price, cost and stock of one SKU are compared by hand between BigCommerce and Dynamics GP. That means looking at the product, then the GP item, its price level and its quantities, and differences go unnoticed.
Without PopdockAI
- Open the product in BigCommerce
- Find the GP item and its price level
- Sum quantities across locations by hand
- Subtract allocated stock and compare
With PopdockAI
- The product or variant and the GP item, price and quantities are read
- Available stock is on hand minus allocated, summed across locations
- The price level used is named when there are several
- Each attribute is a match or difference, with no winner picked
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare the BigCommerce product with SKU `{sku}` against the Dynamics GP item with the same item number and report every field where the two systems disagree.
**Step 1: Read the product in BigCommerce**
Call `bigcommerce-get-product` (bigcommerce server) with `sku` set to `{sku}`. If nothing matches, call `bigcommerce-get-product-variant` (bigcommerce server) with `sku` set to `{sku}` and use its `price`, `cost-price` and `inventory-level`. If still nothing, report the SKU as not in BigCommerce and stop. Keep `id`, `name`, `price`, `sale-price`, `cost-price` and `inventory-level`.
**Step 2: Read the item in Dynamics GP**
Call `dynamics-gp-get-iv-item` (dynamics-gp server) with `item-number` set to `{sku}`. If nothing comes back, report the SKU as present in BigCommerce and absent from Dynamics GP and stop. Keep `item-description`, `current-cost` and `standard-cost`. Then call `dynamics-gp-get-iv-item-price` (dynamics-gp server) with `item-number` set to `{sku}` and take `list-price` (if several price levels come back, use the first and say which level it was).
**Step 3: Read stock in Dynamics GP**
Call `dynamics-gp-get-iv-item-quantity` (dynamics-gp server) with `item-number` set to `{sku}`. Keep `quantity-on-hand` and `quantity-allocated`; available stock is on hand minus allocated.
**Step 4: Report**
A table with one row per attribute: `name` vs `item-description`, `price` vs GP `list-price`, `cost-price` vs `current-cost`, `inventory-level` vs available stock. Mark each row Match or Differs with the difference. Treat prices within 0.01 as equal and names as equal ignoring case and spacing.
**Rules & Guidelines:**
* `bigcommerce-*` tools run on the bigcommerce server and `dynamics-gp-*` tools on the dynamics-gp server. Both servers must be connected.
* Where a GP tool takes `company`, pass `{gp-company}` when it is given; if it is empty, omit `company`.
* This prompt is read-only. Never call any `bigcommerce-*-add`, `-update` or `-delete` tool, and never call any `dynamics-gp-*-add`, `-update` or `-note` tool.
**Validation:**
* If GP returns several quantity rows (one per location), sum them and say so.
* Do not say which system is right; report the difference only.
Who it's for
One answer, three teams that use it
Inventory managers
Confirm available stock
Available stock worked out the GP way sits next to the store figure.
Compare BigCommerce SKU CT-220 with the Dynamics GP item, including available stock.
Pricing analysts
Check price and cost agree
List price and cost are compared, with the price level named when there are several.
Does the BigCommerce price for SKU FB-918 match the Dynamics GP list price?
Catalog managers
Fix name differences
Name mismatches show where the catalog and item master describe a product differently.
Where do BigCommerce and Dynamics GP disagree for SKU NW-501?
How it works
What PopdockAI does when you ask
You give a SKU and your AI assistant compares it across BigCommerce and Dynamics GP. It stops when a record is missing and changes nothing.
01
Ask
You give the SKU and optionally the Dynamics GP company.
02
Read
It reads the BigCommerce product, then the GP item, price and quantities.
03
Compare
It compares name, price, cost and available stock, treating prices within 0.01 as equal.
04
Report
You get a table of matches and differences, with no winner picked.
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-product
bigcommerce-get-product-variant
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-price
microsoft-dynamics-gp-get-iv-item-quantity
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
Every disagreement for a SKU in one table
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)
