Connectors

/

BigCommerce

/

Reconcile BigCommerce catalog to PowerGP Online items
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile BigCommerce catalog to PowerGP Online items
Reconcile our BigCommerce catalog against GP company TWO items, 200 records per side.
187 of 200 store SKUs match a GP item, and 9 web prices are under GP cost. - 13 store products have no GP item - 21 GP items have no store product - WIDGET-100: web price 18.00, GP current cost 19.40 - 6 matched items have a web cost that differs from GP cost Both reads reached the 200 record cap, so this is a sample. Want the full lists?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-product
powergp-online-get-items

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

Connect BigCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Read

It reads BigCommerce products and PowerGP Online items.

bigcommerce-get-product
powergp-online-get-items

03

Match

It matches SKU to item number and retries once before calling an item missing.

No items found.

04

Report

You get items missing on either side, cost differences and prices below GP cost.

Your AI tool

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.

get-data

bigcommerce-get-product

Returns products from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
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.
Read only.Nothing in BigCommerce 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

Missing items and below-cost prices in one report

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