/
/
Find Shopify prices and costs that drifted from Dynamics GP
For ecommerce and finance teams who want Shopify price and cost checked against Dynamics GP items, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Shopify prices and costs drift away from Dynamics GP
Prices and costs in Shopify drift from the item records in Dynamics GP as one side is updated and the other is not. Finding the differences means comparing every variant's price and cost against the GP list price and current cost by hand.
Without PopdockAI
- Export Shopify variants with price and unit cost
- Look up each SKU as a Dynamics GP item number
- Work out which price level applies
- Find out about thin margins after the sale
With PopdockAI
- Shopify variants are read with their price and unit cost
- Each SKU is checked against GP current cost and list price
- Differences beyond your tolerance are listed with margin
- Missing SKUs and prices are shown as missing, 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.
**Objective:** For products whose vendor or title contains `{product-filter}` (default: all, up to 100 variants), compare the Shopify selling price and unit cost with Dynamics GP, and report every variant where they differ by more than `{tolerance-percent}` percent (default 1).
**Step 1: Read the Shopify variants**
If `{product-filter}` is given, call `shopify-get-product` (Shopify server) with `title.contains` = `{product-filter}`, and if that returns nothing, with `vendor.contains` = `{product-filter}`. Then call `shopify-get-product-variant` (Shopify server) with each `product-id`. With no filter, call `shopify-get-product-variant` with `max-records` = 100. Keep `sku`, `title`, `price` and `inventory-item-id`.
For the cost, call `shopify-get-inventory-item` (Shopify server) with `sku` and read `cost`.
**Step 2: Read Dynamics GP for the same item numbers**
The Shopify `sku` is the Dynamics GP `item-number`. Call `dynamics-gp-get-iv-item` (Dynamics GP server) with `item-number` = the SKU for `current-cost` and `standard-cost`, and `dynamics-gp-get-iv-item-price` (Dynamics GP server) with the same `item-number` for `list-price`. Pass `company` = `{gp-company}` on both when it is given. If the price list has several rows, use the one for the item's selling unit of measure with the lowest `start-quantity`, and say which `price-level` you used.
**Step 3: Report**
A table: SKU, Variant, Shopify price, GP list price, Price difference %, Shopify cost, GP current cost, Cost difference %, and Margin at Shopify price (price minus GP current cost, as a percent of price). Only rows over the tolerance, largest difference first. Then list variants with no SKU and SKUs not found in GP.
**Rules & Guidelines:**
* Tools whose names start with shopify are on the Shopify server; tools whose names start with dynamics-gp are on the Dynamics GP server.
* This is read-only. Do NOT call `shopify-update-product`, `dynamics-gp-iv-item-update`, `dynamics-gp-iv-item-price-update` or `dynamics-gp-iv-item-price-add`.
**Validation:**
* If either price is zero or empty, show it as missing rather than computing a percentage.
* Assume both systems use the same currency; if GP's `currency-id` differs from the Shopify store currency, flag the row instead of comparing it.Who it's for
One answer, three teams that use it
Pricing analysts
See every price gap with its margin
Differences come largest first with the margin at the Shopify price, so you know which ones hurt most.
Compare Shopify prices and costs with Dynamics GP for all variants and show anything over 1.00 apart.
Purchasing managers
Check costs after a supplier increase
Confirm Shopify costs reflect the current cost in GP for a vendor's products after new prices arrive.
Are Shopify costs for our Contoso Supplies products in line with current cost in Dynamics GP?
Ecommerce managers
Find products missing from the ERP
Variants with no SKU and SKUs not found in GP are listed, so nothing sells online without an item behind it.
Which Shopify variants have no SKU or a SKU that does not exist in Dynamics GP?
How it works
What PopdockAI does when you ask
You filter by product or vendor if you like, and your AI assistant compares each Shopify variant with its Dynamics GP item. It only reads and says which price level it used.
01
Ask
You optionally filter by product title or vendor and set a tolerance.
02
Read
It reads Shopify variants with their price and unit cost.
03
Compare
It looks up each SKU in Dynamics GP for current cost and list price.
04
Report
You get differences largest first with margin, plus SKUs missing from GP.
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.
shopify-get-product
shopify-get-product-variant
shopify-get-inventory-item
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-price
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
Online prices and costs that match your ERP
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)
