Connectors

/

BigCommerce

/

Reconcile a BigCommerce product with its Dynamics GP item
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile a BigCommerce product with its Dynamics GP item
Compare BigCommerce SKU NW-TEA-250 with the Dynamics GP item and tell me where they disagree.
SKU NW-TEA-250 differs on cost and stock. - Name: match ignoring case and spacing - Price: 18.50 against GP list price 18.50, match - Cost: BigCommerce 9.20, GP current cost 9.45, differs by 0.25 - Stock: BigCommerce 140, GP available 128 (150 on hand less 22 allocated) Want me to check another SKU?
BigCommerce
Sample figures. Your results come from your own account.
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

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

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.

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

Your AI tool

02

Read

It reads the BigCommerce product, then the GP item, price and quantities.

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

03

Compare

It compares name, price, cost and available stock, treating prices within 0.01 as equal.

No items found.

04

Report

You get a table of matches and differences, with no winner picked.

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

bigcommerce-get-product-variant

Returns product variants from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

microsoft-dynamics-gp-get-iv-item

Returns inventory item records from Dynamics GP Inventory, including item type, class, costs, units of measure and valuation settings. Filter by item class code, item description, current cost, item number, abc code, item short name, valuation method and item tracking option, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-iv-item-price

Returns item price list records from Dynamics GP Inventory, including price level, unit of measure, quantity breaks and pricing method. Filter by price level, price method, unit of measure, item number, currency ID, item description and item type, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-iv-item-quantity

Returns item quantity records by site from Dynamics GP Inventory, including quantities on hand, allocated, on order and back ordered. Filter by quantity on hand, item description, location code from item master, item class code, item type, record type and item number, and pick the company and the maximum number of records.
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

Every disagreement for a SKU in one table

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