/
/
Know what to reorder in Shopify, with demand in view
For inventory planners who want low Shopify stock checked against incoming stock and open orders, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Reorder decisions without incoming stock or demand in view
Deciding what to reorder in Shopify means checking available stock per location, then what is already on its way and what open orders still need. Doing that item by item across locations is slow, and short items are easy to miss.
Without PopdockAI
- Filter inventory by location for low items
- Look up incoming stock and expected dates
- Count demand from unfulfilled orders
- Miss items that are short once demand is counted
With PopdockAI
- Tracked items at or below your threshold are found
- Incoming stock with dates and open order demand are added
- Rows where demand exceeds supply are marked short with the cost
- No reorder quantities are invented, 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:** List the tracked items with `{threshold}` or fewer units available (default 5) at the location `{location-name}` (default all active locations), together with incoming stock and open demand, ranked by urgency.
**Step 1: Resolve the location**
`shopify-get-inventory-level` filters by location id only, so resolve the name first. Call `shopify-get-location` filtered by `name.contains` set to `{location-name}`, or filtered by `active` true if no name was given. If the name matches more than one location, list them and stop. Keep location-id and name.
**Step 2: Find the low stock**
For each location, call `shopify-get-inventory-level` filtered by `location-id`, `tracked` true and `available.max` set to the threshold. Keep inventory-item-id, sku, available and cost.
**Step 3: Add context**
* Call `shopify-get-inventory-item` filtered by `inventory-item-id` for product-title and variant-title.
* Call `shopify-get-inventory-level-scheduled-change` filtered by `inventory-item-id` and `location-id` for incoming quantity and expected-at.
* For open demand, call `shopify-get-fulfillment-order-line` filtered by `sku` and add up remaining-quantity. Cap this at the 25 lowest items and say so if you stopped.
**Step 4: Report**
Per location, a table sorted by urgency (negative or zero available with open demand first, then lowest available):
| SKU | Product | Variant | Available | Open demand | Incoming | Expected | Unit cost |
Mark rows where open demand exceeds available plus incoming as short. End with the count of short items and the total cost to cover the shortfall at unit cost.
**Rules & Guidelines:**
* This prompt is read-only. Do not call `shopify-add-inventory-level`, `shopify-update-product`, `shopify-update-location` or any other add or update tool.
* Only include tracked items; an untracked item's available count is meaningless.
* Do not recommend reorder quantities; there is no sales-velocity data here. Report the shortfall only.
**Validation:**
* If nothing is at or below the threshold, say so and stop.
* If the location name matches nothing, list the active location names from `shopify-get-location` and stop.Who it's for
One answer, three teams that use it
Buyers
Reorder with demand already counted
Incoming stock and open orders sit beside each low item, so you reorder only what is really short.
Which Shopify items are at 10 or fewer across all locations, with incoming stock and open demand?
Store managers
Know what your location is short of
Filter to your own location to see what to request before shelves run empty.
What is low in Shopify at the Bristol store, and is anything already on its way?
Inventory planners
Cost the shortfall
Short rows come with the cost to cover them, so you can plan the purchase budget.
Show Shopify items at 3 or fewer that are short against open orders, with the cost to cover.
How it works
What PopdockAI does when you ask
You set a stock threshold, and your AI assistant lists low Shopify items with incoming stock and open demand. It only reads and skips untracked items.
01
Ask
You set a stock threshold and optionally a location.
02
Read
It finds tracked items at or below the threshold.
03
Add
It adds incoming stock with dates and demand from unfulfilled orders.
04
Report
You get the 25 lowest items, shortfalls marked with the cost to cover.
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
shopify-get-location
shopify-get-inventory-item
shopify-get-inventory-level-scheduled-change
shopify-get-fulfillment-order-line
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
The true shortfall per location, before customers feel it
Related use cases
More ways to put this data to work
Stock a Shopify variant at a new location
Ask your AI to stock a Shopify variant at a new location and it resolves the SKU and location, checks it is not already there and connects it after you confirm.
Learn More
Shopify fulfillment backlog review
Ask your AI to review the fulfillment backlog and it finds why each old Shopify order is stuck, whether a hold, a fulfillment service or stock, grouped by location.
Learn More
Reconcile Shopify inventory valuation with Rillet
Ask your AI to reconcile inventory with Rillet and it values Shopify stock at cost by location and compares it with the Rillet balance sheet line.
Learn More
Reconcile Shopify stock with Intacct by SKU
Ask your AI to reconcile stock with Sage Intacct and it compares on-hand and available by exact SKU, largest gap first, with duplicated SKUs flagged.
Learn More
Add missing Shopify customers to a Constant Contact list
Ask your AI to add missing Shopify customers to Constant Contact and it finds opted-in buyers not already there, skips anyone who unsubscribed and adds them after you confirm.
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.