/
/
Match WooCommerce stock to what Dynamics GP can ship
For operations teams who want store stock set from Dynamics GP available quantity, SKU by SKU, by asking their AI assistant.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
The problem
The store selling stock that is already allocated
Keeping WooCommerce stock in line with Dynamics GP means reading available quantities, subtracting what is allocated and typing the result into each product and variation. It is slow, so it gets done weekly at best, and the store sells allocated stock.
Without PopdockAI
- Read on hand and allocated quantities in GP
- Work out what is really available
- Type it into each product and variation
- Sell stock that was already promised
With PopdockAI
- GP available quantity is on hand less allocated, never below zero
- Current and new store stock are shown side by side
- Matching SKUs are left out and missing ones listed
- Only stock quantity changes after you confirm, and GP is never changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Set the WooCommerce stock quantity for SKUs {skus} to the quantity available in Dynamics GP at site {site-id} (default: all sites combined), after the user confirms the changes.
**Step 1: Find each SKU in the store (woocommerce)**
Split {skus} on commas. For each SKU call `woocommerce-get-product` with sku set to it. If nothing comes back, call `woocommerce-get-product-variation` with sku set to it. If neither returns anything, record the SKU as not in the store. Keep the product-id, the product-variation-id for a variation, the name and the current stock-quantity.
**Step 2: Read GP availability (dynamics-gp)**
For each SKU call `dynamics-gp-get-iv-item-quantity` with item-number set to it. Use the overall record, or the record for site {site-id} when it is given; record-type tells them apart. Available quantity is quantity-on-hand minus quantity-allocated, rounded down to a whole number, and never below 0. If nothing comes back, record the SKU as not in GP.
**Step 3: Preview and confirm**
Show a table: SKU, name, current store stock, GP available, new store stock. Leave out SKUs whose stock already matches. List SKUs missing from either system separately. Ask the user to confirm before writing anything.
**Step 4: Write (woocommerce)**
Only after the user confirms, for each SKU: for a product call `woocommerce-update-product` with product-id and stock-quantity; for a variation call `woocommerce-update-product-variation` with variation-id, product-id and stock-quantity. Check the stock-quantity the tool returns. If it did not change, the product does not manage stock; report that and do not set manage-stock unless the user asks.
**Step 5: Report**
Each SKU with its old and new stock and whether the write succeeded.
**Rules & Guidelines:**
* Tools whose names start with woocommerce- are on the woocommerce MCP server; tools whose names start with dynamics-gp- are on the dynamics-gp MCP server. If a tool from either server is not available, stop and say which server is not connected.
* If the user names a Dynamics GP company, pass it as company on every dynamics-gp call.
* Match a store SKU to a GP item number exactly, after trimming spaces. If that fails, try the SKU in upper case once. Never match on descriptions or partial codes.
* The only tools that may write are `woocommerce-update-product` and `woocommerce-update-product-variation`, only after the confirmation in step 3, and only to set stock-quantity (plus manage-stock if the user asks for it).
* Never change prices, names or status in the store.
* Never write to GP. Do not call `dynamics-gp-iv-inventory-transaction-add`, `dynamics-gp-iv-item-update` or any other dynamics-gp tool that adds or updates.
**Validation:**
* If {skus} lists more than 50 SKUs, ask the user to narrow it.
* If you cannot tell which GP record is the overall one, show every record for that SKU and ask the user which to use.
* If a write fails, report the error and carry on with the next SKU.Who it's for
One answer, three teams that use it
Inventory managers
Update store stock in minutes
Get the change list for your SKUs and approve it, instead of retyping quantities.
Sync WooCommerce stock for TEA-01, TEA-02 and TEA-03 from Dynamics GP.
Ecommerce managers
Stop selling allocated stock
Store stock reflects on hand less allocated, so promised stock is not sold twice.
Update WooCommerce stock for BOOT-41 and BOOT-42 from GP site WEST.
Warehouse leads
Keep the store honest after a stock count
After a count in GP, bring the store in line in one reviewed step.
We just counted site MAIN. Sync WooCommerce stock for CHAIR-01 and DESK-02 from Dynamics GP.
How it works
What PopdockAI does when you ask
You give a list of SKUs and optionally a GP site, and your AI assistant works out what the store should show. Nothing is written until you confirm, and stock tracking is never switched on for you.
01
Ask
You give a list of SKUs, and optionally a GP site.
02
Read
It reads GP on hand less allocated, rounded down, with zero as the floor.
03
Confirm
You review current and new stock, with missing SKUs listed.
04
Update
It changes only the stock quantity.
What PopdockAI provides
The tools behind the answer
Ready made tools for WooCommerce and one secure connection to your AI tool. No code, no exports.
woocommerce-get-product
woocommerce-get-product-variation
microsoft-dynamics-gp-get-iv-item-quantity
woocommerce-update-product
woocommerce-update-product-variation
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 what GP can ship
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)
