/
/
Reconcile web store stock with Dynamics GP by SKU
For operations teams who run a WooCommerce store on Dynamics GP stock, and want the two compared by asking their AI assistant.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
The problem
Stock compared SKU by SKU across two screens
Web store stock and Dynamics GP stock should agree, but they are compared by hand, SKU by SKU. GP holds quantities by location, so you add them up first, and oversells go unnoticed until a customer complains.
Without PopdockAI
- Read web stock for each product
- Look up quantities per GP location
- Add them up and compare by hand
- Learn about the oversell from a complaint
With PopdockAI
- Web stock is read, with products missing a SKU listed
- PowerGP Online quantities are added up across locations
- SKUs are matched ignoring case and spaces
- Mismatches and unmatched products are grouped, 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 PowerGP stock to WooCommerce stock for item/SKU `{item-number}` (default: every product returned, up to 50) in PowerGP company `{company}`, and report where they disagree.
**Step 1: Read WooCommerce stock**
Call `woocommerce-get-product` (woocommerce server) with `sku` = `{item-number}` if given, `max-records` 50. Keep `sku`, `name`, `stock-quantity`, `stock-status`. Skip products with an empty `sku` and list them separately.
**Step 2: Read PowerGP stock**
For each SKU, call `powergp-online-get-itemsitequantities` (powergp-online-ai server) with `item-number` = that SKU and `company` = `{company}`. Sum `quantity-on-hand` across locations and note `quantity-on-order`. The join is WooCommerce `sku` = PowerGP `item-number`; compare case-insensitively after trimming spaces.
**Step 3: Report**
A table: SKU, product name, WooCommerce `stock-quantity`, PowerGP total on hand, difference, PowerGP on order. Group into: matches, mismatches, in WooCommerce but not in PowerGP, and WooCommerce products that do not track stock.
**Rules & Guidelines:**
* Tools starting powergp-online- are on the powergp-online-ai server; tools starting woocommerce- are on the woocommerce server. Both servers must be connected.
* This prompt is read-only. Never call any WooCommerce write tool (`woocommerce-update-product`, `woocommerce-update-product-variation`, `woocommerce-add-product`, `woocommerce-update-order`, `woocommerce-add-order`, `woocommerce-add-order-note`, `woocommerce-add-refund`, `woocommerce-add-coupon`, `woocommerce-update-coupon`, `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-send-order-details`).
* Report what the tools return. Do not guess values.
* Call no other powergp-online- tool for this job.
**Validation:**
* If WooCommerce returns no products, say so and stop.
* If a SKU has no PowerGP record, report it as absent from PowerGP and continue.
* If `{company}` is empty, omit the company filter and say which companies the rows came from.Who it's for
One answer, three teams that use it
Inventory managers
Catch oversells before customers do
Web stock, GP on hand, difference and on order are shown side by side.
Compare WooCommerce stock with Dynamics GP for the first 50 products in company TWO.
Ecommerce managers
Check a single SKU
Check one item before a promotion so you do not sell more than you have.
What is the GP on hand for SKU BOOT-42 compared with WooCommerce stock?
Operations analysts
Find products that do not track stock
Products missing from GP or not tracking stock are grouped, ready to fix.
Which WooCommerce products are missing from GP or do not track stock?
How it works
What PopdockAI does when you ask
You name an item or accept up to 50 products, and your AI assistant compares web stock with GP quantities. Unmatched SKUs are listed, not guessed.
01
Ask
You name an item or SKU, or accept up to 50 products.
02
Read
It reads WooCommerce stock and the PowerGP Online quantities for each SKU.
03
Compare
It adds up GP quantity on hand across locations and finds the differences.
04
Report
You get matches, mismatches and unmatched products in groups.
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
powergp-online-get-itemsitequantities
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
Stock differences listed by SKU
Related use cases
More ways to put this data to work
Check a WooCommerce order against PowerGP Online sales
Ask your AI whether a WooCommerce order has a matching PowerGP Online sales document and it compares the totals, lists every candidate and changes nothing.
Learn More
Compare WooCommerce prices with PowerGP Online cost
Ask your AI to compare WooCommerce prices with PowerGP Online current cost and it flags low or negative margins by SKU, skipping unpriced rows and changing nothing.
Learn More
Find WooCommerce products missing from PowerGP Online
Ask your AI to check WooCommerce products against the PowerGP Online item master and it lists missing items, products with no SKU and possible SKU collisions.
Learn More
Match a WooCommerce customer to a PowerGP Online account
Ask your AI to match a WooCommerce customer to their PowerGP Online account and it shows recent orders, balance due and open items, never choosing on a weak name match.
Learn More
Add missing WooCommerce customers to a Mailchimp audience
Ask your AI to add missing WooCommerce customers to a Mailchimp audience and it skips existing members in any status and adds only what 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.