/
/
Show the stock you really have, straight from Sage Intacct
For operations teams who want WooCommerce stock updated to match Sage Intacct quantities by asking their AI assistant.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
The problem
Store stock out of step with the ledger
When WooCommerce stock falls out of step with Sage Intacct, the store oversells items you do not have or hides items you do. Updating quantities product by product takes hours, and one wrong edit can switch off stock tracking.
Without PopdockAI
- Export stock from Sage Intacct
- Compare it with each product and variation
- Update quantities one at a time
- Switch off stock tracking by mistake
With PopdockAI
- Quantities that differ from Intacct are listed
- Negative quantities become zero and are flagged
- You review every change, in batches of 50 for long lists
- Only stock quantity changes, and each change is read back
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Update WooCommerce stock to match Intacct for SKU `{sku}` (default: every stock-managed product), using the Intacct `{quantity-basis}` quantity (on-hand or uncommitted, default on-hand) from warehouse `{warehouse-id}` (default: the item's total). Write nothing without the user's confirmation.
**Step 1: Read the WooCommerce stock**
If `{sku}` is set, call `woocommerce-get-product` with `sku` = `{sku}`, and if nothing matches, `woocommerce-get-product-variation` with `sku` = `{sku}`. Otherwise call `woocommerce-get-product` with `status` = publish and `max-records` = 500, and for each variable product call `woocommerce-get-product-variation` with its `product-id`.
Keep only rows with a SKU and a non-empty `stock-quantity`. A product with an empty `stock-quantity` does not manage stock: skip it and never switch stock management on.
**Step 2: Read the Intacct quantities**
If `{warehouse-id}` is set, call `intacct-get-item-warehouse` with `warehouse-id` = `{warehouse-id}` (and `item-id` = `{sku}` when set). Otherwise call `intacct-get-item` (with `item-id` = `{sku}` when set, or once with `max-records` = 2000). Match on `item-id` = SKU. Take `uncommitted` when `{quantity-basis}` is uncommitted, otherwise `on-hand`.
**Step 3: Build the change list**
For each matched SKU whose WooCommerce `stock-quantity` differs from the Intacct quantity, record: SKU, product name, product-id, variation id when it is a variation, current WooCommerce quantity, new quantity. Round the new quantity down to a whole number. If the Intacct quantity is negative, set it to 0 and flag it.
Also list SKUs with no Intacct match; they are left unchanged.
**Step 4: Confirm, then update**
Show the whole change list and the unmatched SKUs. If there are more than 50 changes, confirm and apply them in batches of 50. Only after a yes for a batch, for each change:
* a simple product: call `woocommerce-update-product` with `product-id` and `stock-quantity`;
* a variation: call `woocommerce-update-product-variation` with `product-id`, `variation-id` = the variation's `product-variation-id` and `stock-quantity`.
Pass no other field.
**Step 5: Confirm**
Report each update's result, then re-read the changed SKUs with `woocommerce-get-product` or `woocommerce-get-product-variation` and list any whose `stock-quantity` still differs from the target.
**Rules & Guidelines:**
* `woocommerce-get-product`, `woocommerce-get-product-variation`, `woocommerce-update-product` and `woocommerce-update-product-variation` are on the woocommerce server. `intacct-get-item` and `intacct-get-item-warehouse` are on the intacct server.
* The only write tools this prompt may call are `woocommerce-update-product` and `woocommerce-update-product-variation`, only for `stock-quantity`, and only after confirmation. Intacct is the source and is never written: do NOT call any intacct create or update tool. Do NOT change prices, status, `manage-stock` or `stock-status`.
**Validation:**
* If nothing differs, say stock is already in line and stop.
* If an update fails, show the error, skip that SKU, continue with the rest, and list the failures at the end.
* WooCommerce has already taken processing orders out of its stock that Intacct may still count as on hand. If the user syncs on-hand, warn that those units could be sold twice, and suggest uncommitted instead.Who it's for
One answer, three teams that use it
Inventory managers
Sync the whole store at once
Every stock-managed product is compared and updated after one review.
Sync all WooCommerce stock from Sage Intacct using on-hand quantity.
Ecommerce managers
Show only uncommitted stock
Use uncommitted quantity so the store does not sell stock already promised.
Update WooCommerce stock from Intacct uncommitted quantity in warehouse WH2.
Operations teams
Fix one SKU fast
Bring a single product in line after a stock problem without touching anything else.
Sync WooCommerce stock for SKU KETTLE-05 from Sage Intacct.
How it works
What PopdockAI does when you ask
You name a SKU or all stock-managed products and a quantity basis, and your AI assistant lists every difference. Nothing is updated until you confirm, and price, status and tracking are never touched.
01
Ask
You name a SKU or all stock-managed products, the quantity basis and a warehouse.
02
Compare
It lists WooCommerce quantities that differ from Sage Intacct.
03
Confirm
You review every change, with negative quantities flagged as zero.
04
Update
It changes only stock quantity and reads each change back.
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
sage-intacct-get-item-warehouse
sage-intacct-get-item
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
The stock you really have, on the store
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)
