/
/
Make your store and Sage Intacct agree on SKUs, price and stock
For operations and finance teams who want the WooCommerce catalog compared with Sage Intacct items by SKU by their AI assistant.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
The problem
Store and ledger disagree on what you sell
Your WooCommerce catalog and Sage Intacct items should describe the same products, but SKUs go missing, discontinued items stay published and prices drift. Some stock gaps are just orders waiting to ship, which hides real problems.
Without PopdockAI
- Export products and Intacct items
- Match SKUs and UPCs by hand
- Compare prices and stock
- Chase stock gaps that were only timing
With PopdockAI
- Published products and variations are matched by item ID or UPC
- Missing and inactive items are listed
- Price and stock differences are shown
- Timing-only stock gaps are grouped apart, 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 the published WooCommerce catalog (in categories containing `{category}`, default all) with Intacct items, SKU by SKU, using stock from Intacct warehouse `{warehouse-id}` (default: the item's total on hand). Check at most `{max-products}` products (default 250).
**Step 1: Read the WooCommerce catalog**
Call `woocommerce-get-product` with `status` = publish, `categories.contains` = `{category}` when set, and `max-records` = `{max-products}` (default 250). Keep `product-id`, `name`, `type`, `sku`, `regular-price`, `stock-quantity` and `stock-status`.
For every product whose `type` is variable, call `woocommerce-get-product-variation` with `product-id` and use each variation's `sku`, `regular-price`, `stock-quantity` and `stock-status` in place of the parent's. Treat an empty `stock-quantity` as "stock not managed".
List products and variations with no SKU separately; they cannot be matched.
**Step 2: Read the Intacct items**
Call `intacct-get-item` once with `max-records` = 2000 and match locally on `item-id` = SKU, then on `upc` = SKU. If exactly 2000 rows came back, look up each still-unmatched SKU one at a time with `item-id`. Keep `item-id`, `item-name`, `status`, `on-hand`, `uncommitted` and `base-price`.
If `{warehouse-id}` is set, call `intacct-get-item-warehouse` with `warehouse-id` = `{warehouse-id}` and use its `on-hand` per `item-id` instead of the item total.
**Step 3: Compare**
* Missing in Intacct: a SKU with no Intacct item.
* Inactive in Intacct: a published WooCommerce SKU whose Intacct item `status` is not active.
* Stock differs: stock is managed and `stock-quantity` differs from the Intacct on hand. For each, call `woocommerce-get-order-line` with `line-sku` and `order-status` = processing and total `line-quantity`: WooCommerce reduces stock when an order is placed, Intacct when it ships, so a difference equal to those units is timing, not an error.
* Stock status wrong: stock is not managed, and `stock-status` is instock while Intacct has nothing on hand, or outofstock while Intacct has stock.
* Price differs: `regular-price` differs from `base-price` by more than 0.01.
**Step 4: Report**
One table per finding type, with SKU, WooCommerce name, the WooCommerce value, the Intacct value and the difference. Put stock differences explained by processing orders in their own "timing only" group. End with counts: SKUs checked, matched, and each finding type.
**Rules & Guidelines:**
* `woocommerce-get-product`, `woocommerce-get-product-variation` and `woocommerce-get-order-line` are on the woocommerce server. `intacct-get-item` and `intacct-get-item-warehouse` are on the intacct server.
* This prompt is read-only. Do NOT call `woocommerce-update-product`, `woocommerce-update-product-variation` or `woocommerce-add-product`. To fix stock, suggest the sync-stock-from-intacct prompt.
* Leave the Intacct `company` parameter empty unless the user names an Intacct entity.
**Validation:**
* If WooCommerce returns no products, report the filters used and stop.
* If no SKU matches any Intacct item, say the two catalogs may use different identifiers (for example Intacct item IDs that are not the store SKUs) and stop rather than reporting every product as missing.
* If `{max-products}` was reached, say the result is partial.Who it's for
One answer, three teams that use it
Inventory managers
Separate real stock errors from timing
Gaps explained by processing orders are grouped apart, so you chase only real differences.
Compare WooCommerce stock with Sage Intacct for the Main warehouse and separate timing gaps.
Ecommerce managers
Unpublish discontinued items
Products whose Intacct item is inactive are listed, so they can come off the store.
Which published WooCommerce products are inactive or missing in Sage Intacct?
Finance analysts
Check prices against the base price
Store prices that differ from the Intacct base price are shown side by side.
Show WooCommerce products in the Furniture category whose price differs from Intacct.
How it works
What PopdockAI does when you ask
You can narrow to a category or warehouse, and your AI assistant compares the catalog with Sage Intacct. It is read-only and stops if no SKU matches at all.
01
Ask
You optionally name a category or warehouse.
02
Read
It reads published products and variations and the Intacct items.
03
Match
It matches each SKU by item ID or UPC and compares price and stock.
04
Report
You get real differences, with timing-only stock gaps grouped apart.
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
sage-intacct-get-item-warehouse
woocommerce-get-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
Store and ledger agree on SKUs, price and stock
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)
