/
/
Reconcile your BigCommerce catalog to PowerGP Online items
For operations teams who want web products matched to the Dynamics GP item master by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
The web catalog and the GP item master drift apart
The BigCommerce catalog and the PowerGP Online item master drift apart, and comparing them means exporting both and matching SKUs by eye. Products go live with no GP item, and web prices fall below GP cost unnoticed.
Without PopdockAI
- Export products from BigCommerce
- Export items from GP
- Match SKUs in a spreadsheet
- Check cost against web price row by row
With PopdockAI
- Products and items are read for the chosen company
- SKU is matched to item number ignoring case and spaces, retrying once
- Missing items on each side and below-cost prices are listed with counts
- Capped reads are labelled samples, 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.
**Objective:** For GP company `{company}`, compare BigCommerce products with GP items, matching the BigCommerce SKU to the GP item number, and report mismatches. Limit to `{max-records}` records per side (default 200).
**Step 1: Read the store catalog (bigcommerce server)**
Call `bigcommerce-get-product` with `max-records` set. Keep `id`, `sku`, `name`, `price`, `cost-price`, `visible`. Ignore products with an empty `sku`, but count them.
**Step 2: Read the GP items (powergp-online-ai server)**
Call `powergp-online-get-items` with `company` set to `{company}` and `max-records` set. Keep `item-number`, `item-description`, `current-cost`.
**Step 3: Match**
Match `sku` to `item-number` ignoring case and surrounding spaces. For each match compare `cost-price` with `current-cost` and flag where `price` is below `current-cost`. Before calling a SKU missing from GP, retry once with `powergp-online-get-items` filtered by `item-number`.
**Step 4: Report**
Three tables: (a) store products with no GP item, (b) GP items with no store product, (c) matched items where cost differs or the web price is below GP cost (SKU, web price, web cost, GP current cost). End with counts of each.
**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:**
* If either side returns nothing, say which server returned nothing and stop.
* If no SKU matches any item number, say the two systems appear to use different identifiers and stop without guessing.
* A listing capped by `max-records` is a sample: say so.Who it's for
One answer, three teams that use it
Catalog managers
Find products with no GP item
Store products with no item can not be fulfilled or costed properly, and this lists them.
Which BigCommerce products have no PowerGP Online item in company TWO?
Finance analysts
Catch web prices below cost
Matches where the web price is under GP cost are listed for a pricing fix.
Which BigCommerce products are priced below GP cost in company TWO?
Ecommerce managers
Find items not yet online
GP items with no store product show what you could be selling.
List GP company TWO items that are not in our BigCommerce catalog, 300 records per side.
How it works
What PopdockAI does when you ask
You name the GP company and your AI assistant reconciles BigCommerce products to PowerGP Online items. It stops if no SKU matches at all.
01
Ask
You name the GP company and, optionally, how many records to read per side.
02
Read
It reads BigCommerce products and PowerGP Online items.
03
Match
It matches SKU to item number and retries once before calling an item missing.
04
Report
You get items missing on either side, cost differences and prices below GP cost.
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
powergp-online-get-items
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
Missing items and below-cost prices in one report
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)
