Connectors

/

Shopify

/

Compare Shopify and Dynamics GP item cost and price
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Compare Shopify and Dynamics GP item cost and price
Compare prices and costs for our Fabrikam products in Shopify against Dynamics GP.
32 Fabrikam variants checked, and 7 differ beyond the tolerance. - Largest: FB-CHAIR-01, Shopify 249.00, GP list 279.00 - Cost gap: FB-DESK-02 cost 180.00 in Shopify, 196.40 in GP - Margin: FB-LAMP-03 earns 8 percent at the Shopify price - Not in GP: 2 SKUs Want the full comparison?
Shopify
Sample figures. Your results come from your own account.
shopify-get-product
shopify-get-product-variant
shopify-get-inventory-item
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-price

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

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.

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

Your AI tool

02

Read

It reads Shopify variants with their price and unit cost.

shopify-get-product
shopify-get-product-variant
shopify-get-inventory-item

03

Compare

It looks up each SKU in Dynamics GP for current cost and list price.

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

04

Report

You get differences largest first with margin, plus SKUs missing from GP.

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

Returns Shopify products. Filter by title, handle, product type, vendor, tags, product id and created date.
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.
get-data

shopify-get-inventory-item

Returns Shopify inventory items, the stock record behind each product variant, with SKU, tracking and country of origin. Filter by SKU, product, variant, tracked and updated date.
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.
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

Online prices and costs that match your ERP

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