/
/
Find stock gaps between Shopify and Sage Intacct by SKU
For operations teams who want Sage Intacct on-hand quantities compared with Shopify available stock, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Stock checks against Intacct are too slow to happen
When Shopify shows stock Sage Intacct says is gone, or the reverse, you oversell or leave sellable items hidden. Comparing quantities item by item across systems and locations takes so long that it rarely happens.
Without PopdockAI
- Export Sage Intacct on-hand quantities
- Add up Shopify available stock by location
- Match SKUs and guess which locations pair up
- Let the check slide because it takes too long
With PopdockAI
- Sage Intacct on-hand quantities are read for active stocked items
- Shopify available stock is summed for the exact same SKU
- Locations are paired only where names match exactly
- Duplicated SKUs are flagged, 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:** Compare stock on hand in Intacct with available stock in Shopify for `{sku}` (default: every item, up to `{max-items}` items, default 50) and report every SKU where the two differ by at least `{min-difference}` units (default 1).
**Step 1: Read the Intacct items**
If `{sku}` is set, call `intacct-get-item` with `item-id` = `{sku}`. Otherwise call `intacct-get-item` with `status` = active and `max-records` = `{max-items}` (default 50). Keep `item-id`, `item-name`, `item-type` and `on-hand`. Skip items whose `item-type` shows they are not stocked (non-inventory or kit items).
For a per-warehouse view, call `intacct-get-item-warehouse` with the same `item-id` and keep `warehouse-id` and `on-hand`.
**Step 2: Read Shopify stock for each SKU**
For each Intacct `item-id`, call `shopify-get-inventory-level` with `sku` = that item-id. Sum `available` across every location returned. Treat the SKU as matching only on an exact, case-sensitive match; do not trim or pad it.
If Shopify returns nothing, record the item as "in Intacct, not in Shopify" and continue.
**Step 3: Line up locations (optional)**
Call `shopify-get-location` and `intacct-get-warehouse` once each. Where a Shopify location `name` equals an Intacct `warehouse-name`, compare that pair's quantities too. Do not guess a pairing for names that do not match; list them as unpaired.
**Step 4: Report**
A table with columns: SKU, item name, Intacct on hand, Shopify available, difference (Shopify minus Intacct). Include only rows where the absolute difference is at least `{min-difference}` (default 1), sorted by largest absolute difference. Then list SKUs found in only one system, and any unpaired locations or warehouses.
**Rules & Guidelines:**
* `intacct-get-item`, `intacct-get-item-warehouse` and `intacct-get-warehouse` are on the intacct server. `shopify-get-inventory-level` and `shopify-get-location` are on the shopify server.
* This prompt is read-only. Do NOT call `shopify-add-inventory-level`, `intacct-create-order-entry-document` or any other create or update tool on either server.
* Shopify "available" excludes committed stock, so a small positive gap in Intacct is expected for unfulfilled orders. Say so in the report rather than treating it as an error.
**Validation:**
* If `intacct-get-item` returns nothing for `{sku}`, try `shopify-get-product-variant` with `sku` = `{sku}` to confirm it exists in Shopify, report which side it is missing from, and stop.
* If an Intacct item-id matches more than one Shopify inventory item, list the matches and flag the SKU as duplicated in Shopify rather than summing them.Who it's for
One answer, three teams that use it
Inventory planners
Find gaps before they cause oversells
Gaps over your minimum come largest first, so the risky SKUs are fixed first.
Reconcile stock between Shopify and Sage Intacct for our top 50 items, minimum gap 2.
Operations managers
Make the stock check routine
A check that once took days runs in one question, so it can happen weekly.
Which SKUs are out of step between Shopify and Sage Intacct this week?
Product data managers
Clean up duplicated SKUs
SKUs duplicated in Shopify and SKUs found in only one system are flagged for cleanup.
List SKUs that exist in only one of Shopify or Sage Intacct, and any SKUs duplicated in Shopify.
How it works
What PopdockAI does when you ask
You name a SKU or a number of items, and your AI assistant compares Sage Intacct on hand with Shopify available. It explains that committed orders cause small expected gaps.
01
Ask
You name a SKU or check a set number of active stocked items.
02
Read
It reads Sage Intacct on-hand quantities.
03
Compare
It sums Shopify available stock for the exact SKU across locations.
04
Report
You get gaps largest first and SKUs found in only one system.
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.
sage-intacct-get-item
sage-intacct-get-item-warehouse
shopify-get-inventory-level
shopify-get-location
sage-intacct-get-warehouse
shopify-get-product-variant
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
Every out of step SKU, largest gap first
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)
