/
/
Find products that exist in GP or Shopify but not both
For operations teams who want gaps between the GP item master and the Shopify catalog found by asking their AI assistant.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
Catalog gaps stay hidden until an order fails
Someone scrolls through the Dynamics GP item list and the Shopify product list to find products that exist in only one system. SKUs that differ only in case or spacing are easy to miss, so gaps stay hidden until an order fails.
Without PopdockAI
- Scroll the GP item list and the Shopify product list
- Compare SKUs by eye in both directions
- Miss SKUs that differ only in case or spacing
- Find the gap when an order fails
With PopdockAI
- GP items and Shopify variants read, up to 200 per side
- Missing SKUs confirmed directly in Shopify before they are listed
- Gaps in both directions, a matched count and look-alike SKUs
- A partial comparison flagged, 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:** Find catalog gaps between Dynamics GP items and Shopify variants for GP item class `{item-class-id}` (all classes if empty), in company `{company}` (default if empty), looking at up to `{max-records}` records per side (default 200).
**Step 1: GP items**
Call `powergp-online-get-items` (powergp-online-ai) with `item-class-id` = `{item-class-id}` if given, `company` if given, and `max-records`. Keep `item-number`, `item-description`, `item-type`.
**Step 2: Shopify variants**
Call `shopify-get-product-variant` (shopify) with `max-records` as above. Keep `sku`, `title`, `price`. For GP items not found in that page, confirm with `shopify-get-product-variant` filtered by `sku` for up to 20 of them before declaring them missing.
**Step 3: Report**
Three lists: GP items with no Shopify SKU, Shopify SKUs with no GP item, and matched count. Flag Shopify SKUs that look like a GP item number with different case or spacing.
**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.
* Exclude GP items whose `item-type` is not a sales item (for example discontinued or misc charges) from the missing list and say how many you excluded.
**Validation:**
* If either side returns the maximum number of records, warn that the comparison is partial.
* If no SKUs overlap at all, say the SKU convention probably differs and show five examples from each side.Who it's for
One answer, three teams that use it
E-commerce managers
Find products missing from the store
GP items with no Shopify SKU are listed, so sellable products get published before customers ask for them.
Which GP items in class ACCESSORIES are not in our Shopify store?
Inventory controllers
Find Shopify SKUs with no GP item
Products sold online with no GP item are listed, so orders do not fail when they reach the ERP.
List Shopify SKUs that have no matching item in our Contoso GP company.
Product data managers
Clean up look-alike SKUs
SKUs that differ only in case or spacing are flagged, so you can fix the format at the source.
Compare GP items and Shopify SKUs and show me any that nearly match.
How it works
What PopdockAI does when you ask
You name an item class and company, or leave them empty, and your AI assistant compares the two catalogs. It warns you when a side hits the record limit.
01
Ask
You name an item class and GP company, or leave them empty.
02
GP
It reads the GP items, up to the record limit.
03
Shopify
It reads variants and confirms missing SKUs directly.
04
Report
You get items missing on each side, a matched count and look-alike SKUs.
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
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
Catalog gaps listed in both directions
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)
