Connectors

/

Shopify

/

Reconcile Shopify stock with Dynamics 365 Business Central by SKU
Report
Cross-Connector

Stop overselling when Shopify stock outruns Business Central

For operations teams who want Shopify quantities compared with Dynamics 365 Business Central by SKU, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Shopify stock with Dynamics 365 Business Central by SKU
Compare Shopify stock with Business Central for every SKU and flag gaps over 5.
22 SKUs differ by more than 5, and 9 risk overselling. - Oversell risk: WT-GRY-01, Shopify 40, Business Central 12 - On order: 30 units on a purchase order for WT-GRY-01 - Missing: 4 SKUs have no Business Central item - Pack size: MUG-SGE-02 may be counted in packs of 6 Want the full comparison?
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

Shopify shows stock Business Central does not have

When Shopify shows more stock than Dynamics 365 Business Central holds, you sell what you cannot ship. Comparing quantities by SKU across hundreds of variants, allowing for service items, packs and sell when out of stock, is too slow to do often.

Without PopdockAI

  • Export Shopify variants with quantities
  • Look up each SKU or barcode in Business Central
  • Allow for service items, packs and overselling settings
  • Find out when an order cannot ship

With PopdockAI

  • Each variant is matched to its Business Central item by SKU or barcode
  • Variants where Shopify shows more come first
  • Sales and purchase order quantities are shown alongside
  • Missing items and pack mismatches are noted, and stock is never adjusted

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 quantity Shopify shows as in stock for each variant with the inventory Business Central holds for the matching item, and report every difference larger than `{quantity-threshold}` (default 0). Limit the check to SKU `{sku}` when it is given.

**Step 1: Read Shopify stock**

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

**Step 2: Read Business Central stock**

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`, retry with `gtin` set to the barcode. Keep `item-number`, `description`, `type`, `inventory`, `quantity-on-sales-order`, `quantity-on-purchase-order` and `reorder-point`.

Ignore Business Central items whose `type` is not an inventory item (services and non-inventory items carry no stock) and list them separately. If no item is found, record the variant as missing from Business Central and continue.

**Step 3: Compare**

Difference = Shopify `inventory-quantity` minus Business Central `inventory`. Flag the variant when the absolute difference is greater than `{quantity-threshold}` (default 0).

**Step 4: Report**

A table of flagged variants: SKU, title, Shopify quantity, Business Central inventory, difference, Business Central quantity on sales order, quantity on purchase order. Put variants where Shopify shows more than Business Central first, since those risk overselling, then the rest.

Then list: variants missing from Business Central, non-inventory items, and variants whose Shopify `inventory-policy` allows selling when out of stock while Business Central inventory is 0 or less.

**Rules & Guidelines:**

* `shopify-get-product-variant` is on the shopify server. `business-central-get-item` is on the business-central server.
* Both figures are totals across all locations. Do not try to compare location by location.
* This prompt is read-only. Do NOT call `shopify-add-inventory-level`, `business-central-update-item` 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.
* Business Central inventory is in the item's base unit of measure. If a variant looks like a pack (for example the title says 6-pack or case), say the difference may be a unit-of-measure difference rather than a stock error.

Who it's for

One answer, three teams that use it

Inventory planners

Stop selling what you cannot ship

Variants where Shopify shows more than Business Central come first, with open orders to judge the risk.

Which Shopify variants show more stock than Business Central? Flag gaps over 3.

Purchasing managers

See incoming stock beside the gap

Purchase order quantities next to each gap show whether stock is already on the way.

Compare Shopify stock for SKU BK-1002 with Business Central, including open purchase orders.

Ecommerce managers

Catch settings that oversell

Variants set to sell when out of stock while Business Central has none are listed, ready to switch off.

Which Shopify variants keep selling when out of stock while Business Central has none?

How it works

What PopdockAI does when you ask

You can name a SKU or a threshold, and your AI assistant compares Shopify and Business Central quantities. It only reports and puts the overselling risks at the top.

01

Ask

You optionally name a SKU and a threshold.

Your AI tool

02

Read

It reads Shopify variant stock and the matching Business Central items.

shopify-get-product-variant

03

Compare

It flags where Shopify shows more, missing items and pack size mismatches.

No items found.

04

Report

You get overselling risks first, with sales and purchase order quantities.

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

Oversell risks spotted before orders arrive

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