Connectors

/

Shopify

/

Compare Shopify and Dynamics 365 Business Central item prices
Report
Cross-Connector

Find Shopify prices that no longer match Business Central

For ecommerce and finance teams who want price differences between Shopify and Dynamics 365 Business Central found by SKU, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare Shopify and Dynamics 365 Business Central item prices
Compare Shopify prices with Business Central and show anything off by more than 1.00.
14 variants differ from Business Central by more than 1.00. - Largest: WT-GRY-01, 89.00 in Shopify, 99.00 in Business Central - Missing: 6 variants have no Business Central item - No SKU: 11 variants - Blocked: 2 matched items are blocked Want the full list of differences?
Shopify
Sample figures. Your results come from your own account.
shopify-get-product-variant

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

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

Try PopdockAI free

The problem

Store prices quietly drift away from Business Central

Prices set in Dynamics 365 Business Central and prices shown in Shopify drift apart as products are added and repriced. Finding mismatches means matching SKUs to item numbers row by row, and variants with no SKU slip through.

Without PopdockAI

  • Export Shopify variants and Business Central items
  • Match SKUs to item numbers in a spreadsheet
  • Compare prices row by row
  • Miss variants with no SKU or no matching item

With PopdockAI

  • Shopify variants are matched to Business Central items by SKU or barcode
  • Differences beyond your tolerance are listed largest first
  • Missing, blocked and near-match items are called out
  • Neither the store nor Business Central is edited

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 selling price of Shopify product variants with the unit price of the matching Business Central items and report every mismatch larger than `{price-tolerance}` (default 0). Limit the check to SKU `{sku}` when it is given; otherwise check every variant.

**Step 1: Read the Shopify variants**

Call `shopify-get-product-variant` with `sku` set to `{sku}` when it is given, otherwise with `max-records` 250. Keep `sku`, `title`, `product-id`, `price` and `barcode`. Skip variants with an empty SKU and count them.

**Step 2: Find each variant in Business Central**

For each variant, call `business-central-get-item` with `item-number` set to the Shopify `sku`. If nothing comes back and the variant has a `barcode`, call `business-central-get-item` again with `gtin` set to the barcode. Keep `item-number`, `description`, `unit-price` and `blocked`.

If neither lookup finds an item, record the variant as present in Shopify and missing from Business Central, and continue.

**Step 3: Compare**

Compare the Shopify `price` with the Business Central `unit-price` as numbers, rounded to 2 decimals. A difference whose absolute value is greater than `{price-tolerance}` (default 0) is a mismatch.

**Step 4: Report**

A table of mismatches with: SKU, Shopify product and variant title, Shopify price, Business Central item number, Business Central unit price, difference (Shopify minus Business Central). Sort by the size of the difference, largest first.

Then list separately: variants with no Business Central item, variants with no SKU (count only), and matched items that are blocked in Business Central.

End with totals: variants checked, matched, mismatched, missing from Business Central.

**Rules & Guidelines:**

* `shopify-get-product-variant` is on the shopify server. `business-central-get-item` is on the business-central server.
* This prompt is read-only. Do NOT call `business-central-update-item`, `shopify-update-product` or any other create, add or update tool on either server.
* If the user names a Business Central company, pass it as `company` on every Business Central call.

**Validation:**

* If Shopify returns no variants, report that and stop.
* Match SKU to item number exactly as stored, with no case folding. If an exact match fails but the same value in a different case exists, report it as a probable match to fix, not as a match.
* Shopify prices are in the shop currency and Business Central unit prices are in the company's local currency. If the user says the two currencies differ, report the figures without flagging mismatches and say why.

Who it's for

One answer, three teams that use it

Pricing analysts

Catch price drift before customers do

Get every variant that differs from Business Central, ordered by the size of the gap, without building a lookup sheet.

Compare all Shopify variant prices with Business Central and list anything more than 0.50 apart.

Ecommerce managers

Keep the storefront in line with the ERP

Check after a repricing that the store shows what Business Central says, and see which items are missing or blocked.

Did the new prices from Business Central make it to Shopify? Show differences and any items missing from Business Central.

Product data managers

Fix SKU gaps that break matching

Variants with no SKU and near matches in a different case are listed, so you can clean the data that causes drift.

Which Shopify variants have no SKU or a SKU that only matches Business Central in a different case?

How it works

What PopdockAI does when you ask

You set a tolerance or name a SKU, and your AI assistant matches each Shopify variant to its Business Central item and compares prices. It only reads and lists what to fix.

01

Ask

You optionally name one SKU or a tolerance.

Your AI tool

02

Match

It reads Shopify variants and finds each item in Business Central by SKU or barcode.

shopify-get-product-variant

03

Compare

It compares prices and notes missing, blocked and near-match items.

No items found.

04

Report

You get differences largest first, with gaps and SKU fixes listed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.

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 Shopify 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 price mismatch in one list, largest first

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