Connectors

/

PowerGP Online

/

Find PowerGP Online items missing from Shopify and the reverse
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find PowerGP Online items missing from Shopify and the reverse
Which items in GP item class FINISHED-GOODS at Contoso are not in Shopify, and which Shopify SKUs have no GP item?
Of 200 GP items checked, 12 are not in Shopify, and 5 Shopify SKUs have no GP item. - GP only: WIDGET-210 and 11 others, after excluding 8 non-sales items - Shopify only: 5 SKUs, including TEE-BLK-L - Look-alike: WIDGET-100 in GP, widget-100 in Shopify - Matched: 180 items Want the full list of the 12 GP items?
PowerGP Online
Sample figures. Your results come from your own account.
powergp-online-get-items
shopify-get-product-variant

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

PowerGP Online

PowerGP Online
Run it on your own PowerGP Online data.

Connect PowerGP Online, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

GP

It reads the GP items, up to the record limit.

powergp-online-get-items

03

Shopify

It reads variants and confirms missing SKUs directly.

shopify-get-product-variant

04

Report

You get items missing on each side, a matched count and look-alike SKUs.

Your AI tool

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.

get-data

powergp-online-get-items

Returns items from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

shopify-get-product-variant

Returns Shopify product variants with their SKU, barcode, price, inventory quantity and inventory policy. Filter by product, variant, SKU, barcode, title, price and inventory quantity.
Read only.Nothing in PowerGP Online Changes

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.

How Popdock AI secures your data

The outcome

Catalog gaps listed in both directions

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation