Connectors

/

WooCommerce

/

Sync WooCommerce stock from Dynamics GP
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Sync WooCommerce stock from Dynamics GP
Sync WooCommerce stock for MUG-BLU and BLEND-01 from Dynamics GP site MAIN.
Both SKUs need a stock change from Dynamics GP site MAIN. - MUG-BLU: store 40, GP available 18 - BLEND-01: store 0, GP available 25 - Stock tracking: on for both Shall I update the 2 stock quantities?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-product
woocommerce-get-product-variation
microsoft-dynamics-gp-get-iv-item-quantity
woocommerce-update-product
woocommerce-update-product-variation

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

WooCommerce

WooCommerce
Run it on your own WooCommerce data.

Connect WooCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It reads GP on hand less allocated, rounded down, with zero as the floor.

microsoft-dynamics-gp-get-iv-item-quantity
woocommerce-get-product
woocommerce-get-product-variation

03

Confirm

You review current and new stock, with missing SKUs listed.

No items found.

04

Update

It changes only the stock quantity.

Your AI tool

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.

get-data

woocommerce-get-product

Returns WooCommerce products with prices, stock, status, categories, total sales and average rating. Filter by SKU, name, category, type, status, stock status, price range or a low stock threshold.
get-data

woocommerce-get-product-variation

Returns the variations of WooCommerce variable products with SKU, prices, sale flag and stock. Filter by parent product, SKU, status, stock status, price range, on sale or a low stock threshold.
get-data

microsoft-dynamics-gp-get-iv-item-quantity

Returns item quantity records by site from Dynamics GP Inventory, including quantities on hand, allocated, on order and back ordered. Filter by quantity on hand, item description, location code from item master, item class code, item type, record type and item number, and pick the company and the maximum number of records.
run-action

woocommerce-update-product

Updates an existing WooCommerce product by id: name, description, SKU, prices, stock quantity, stock status and publishing status. For a variation use Update WooCommerce product variation.
run-action

woocommerce-update-product-variation

Updates one variation of a WooCommerce variable product by id: SKU, prices, stock quantity, stock status and publishing status.
Read only.Nothing in WooCommerce Changes

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.

How Popdock AI secures your data

The outcome

Online stock that matches what GP can ship

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation