/
/
Line up Shopify available stock with Dynamics GP
For operations teams who want Shopify available stock compared with Dynamics GP available by SKU, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Online stock and GP stock disagree, and both ways hurt
When Shopify shows stock Dynamics GP does not have you oversell, and when GP has stock Shopify hides you lose sales. Comparing them means adding up Shopify locations and subtracting GP allocations for every SKU.
Without PopdockAI
- Add up Shopify available stock across locations
- Read GP on hand and allocated for each item
- Work out GP available by hand
- Compare hundreds of SKUs in a spreadsheet
With PopdockAI
- Shopify available stock is totalled across locations
- GP available is worked out from on hand minus allocated
- Differences beyond your tolerance are listed largest first
- Adjustments are suggested but never made
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare stock between Shopify and Dynamics GP for `{sku}` (default: every tracked SKU, up to 200), and report every SKU where the two systems disagree by more than `{tolerance}` units (default 0).
**Step 1: Read Shopify stock**
Call `shopify-get-inventory-level` (Shopify server) with `sku` = `{sku}` when it is given, otherwise with `tracked` = true and `max-records` = 200. Sum `available` across every `location-id` for each `sku`. Skip rows with an empty `sku` and count them separately.
**Step 2: Read Dynamics GP stock for the same SKUs**
The Shopify `sku` is the Dynamics GP `item-number`. For each SKU call `dynamics-gp-get-iv-item-quantity` (Dynamics GP server) with `item-number` = the SKU, passing `company` = `{gp-company}` when it is given. Use the row whose `record-type` is the item summary (the total across sites) for `quantity-on-hand` and `quantity-allocated`. If only site rows come back, sum them. Available in GP = `quantity-on-hand` minus `quantity-allocated`.
If GP returns nothing, report the SKU as in Shopify and missing from GP, and continue.
**Step 3: Report**
A table with the columns SKU, Shopify available, GP on hand, GP allocated, GP available, Difference (Shopify minus GP available). Only rows where the absolute difference is above `{tolerance}`, largest first. Then a short list of SKUs missing from GP, and the count of Shopify rows with no SKU.
**Rules & Guidelines:**
* `shopify-get-inventory-level` is on the Shopify server; `dynamics-gp-get-iv-item-quantity` is on the Dynamics GP server.
* This is read-only. Do NOT call `shopify-add-inventory-level`, `dynamics-gp-iv-inventory-transaction-add` or `dynamics-gp-iv-item-update`. Suggest adjustments, do not make them.
**Validation:**
* If Shopify returns no inventory levels, say so and stop.
* Match SKUs exactly after trimming spaces. GP item numbers are usually upper case; if an exact match fails, retry once with the SKU upper-cased and say in the report which SKUs only matched that way.Who it's for
One answer, three teams that use it
Inventory planners
Line up online and warehouse stock
Gaps come largest first, so you fix the SKUs most likely to oversell or sit hidden.
Reconcile Shopify stock with Dynamics GP for every SKU, tolerance 5.
Warehouse managers
Find stock the store hides
SKUs where GP has more available than Shopify shows are listed, so sellable stock goes back online.
Where does Dynamics GP have more available stock than Shopify is showing?
Ecommerce managers
Spot SKUs missing from GP
SKUs not in GP and Shopify rows with no SKU are counted, so catalog gaps can be fixed.
Which Shopify SKUs are missing from Dynamics GP, and how many rows have no SKU?
How it works
What PopdockAI does when you ask
You name a SKU or check them all, and your AI assistant compares Shopify available stock with Dynamics GP. It only reads and notes SKUs that matched only in upper case.
01
Ask
You name a SKU or check every tracked SKU, and set a tolerance.
02
Total
It totals Shopify available stock across locations.
03
Compare
It reads Dynamics GP on hand and allocated and works out GP available.
04
Report
You get differences largest first, missing SKUs and suggested adjustments.
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-inventory-level
microsoft-dynamics-gp-get-iv-item-quantity
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 stock that matches the warehouse
Related use cases
More ways to put this data to work
Copy Shopify tracking numbers to Dynamics GP
Ask your AI to copy tracking numbers to Dynamics GP and it collects them from the Shopify order, finds the GP document by customer PO and adds each one after you confirm.
Learn More
Link a Shopify B2B company to a Dynamics GP customer
Ask your AI to link a Shopify B2B company to Dynamics GP and it finds candidate customers, links or creates one after you confirm and reads both sides back.
Learn More
Post a Shopify order to Dynamics GP
Ask your AI to post a Shopify order to Dynamics GP and it checks for duplicates, resolves the customer and items, and creates the document after you confirm.
Learn More
Compare Shopify and Dynamics GP item cost and price
Ask your AI to compare Shopify with Dynamics GP and it checks each variant's price and cost against the GP item, with margin shown and differences largest first.
Learn More
Match Shopify refunds to Dynamics GP credit memos
Ask your AI to match Shopify refunds to Dynamics GP and it pairs each refund with GP credit memos and returns by order name, listing gaps and mismatches.
Learn More
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.