Connectors

/

WooCommerce

/

Update WooCommerce stock and prices from Dynamics 365 Business Central
Write
Cross-Connector

Bring WooCommerce stock and prices in line with Business Central

For operations teams who want store stock and prices updated from Dynamics 365 Business Central in one reviewed pass by their AI assistant.

Try PopdockAI free
Get a live demo
Update WooCommerce stock and prices from Dynamics 365 Business Central
Update WooCommerce stock and prices for the Coffee category from Business Central.
23 Coffee items differ from Business Central. - Stock: 15 changes, such as BLEND-01 from 40 to 12 - Price: 8 changes, such as MUG-BLU from 12.00 to 13.50 - Skipped: 2 blocked and 1 ambiguous SKU - Note: stock is summed across all locations Shall I apply the 23 changes?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-product
woocommerce-get-product-variation
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

Bulk updates that overwrite the wrong fields

Dynamics 365 Business Central holds the true stock and prices, but WooCommerce has to be updated to match. Doing it by hand is slow, and a careless bulk update can overwrite the wrong fields or push tax-inclusive prices into the store.

Without PopdockAI

  • Export stock and prices from Business Central
  • Match SKUs to products and variations
  • Update each one by hand
  • Push tax-inclusive prices by mistake

With PopdockAI

  • Published products and variations are matched by SKU
  • Only differences are listed, and stock is never negative
  • Missing, blocked and ambiguous SKUs are skipped and named
  • A shared percentage gap stops it to ask about tax

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Bring WooCommerce products in line with Business Central, which is the source of truth. Sync {sync-fields} (stock, price or both; default stock) for published products in category {category} (if blank, all categories). Use Business Central company {company} (if blank, leave `company` off).

**Step 1: Collect the WooCommerce SKUs**

Call `woocommerce-get-product` with `status` publish, `max-records` 100, and `categories.contains` set to {category} if given. For each variable product, call `woocommerce-get-product-variation` with its `product-id` and work with the variations instead of the parent. Keep product-id, product-variation-id (for variations), sku, name, regular-price and stock-quantity.

**Step 2: Read Business Central**

For each SKU, call `business-central-get-item` with `item-number` set to the SKU, then with `gtin` set to the SKU if the first finds nothing. Keep inventory, unit-price and blocked.

**Step 3: Build the change list**

* **Stock** (when syncing stock): only where WooCommerce stock-quantity is set, meaning stock is managed. The new quantity is Business Central inventory rounded down to a whole number, and never below zero. List it only if it differs from WooCommerce.
* **Price** (when syncing price): the new regular price is Business Central unit-price. List it only if it differs by more than 0.01.
* Skip, and list separately: SKUs with no Business Central item, items that are blocked, and products with no SKU.

If most price changes are the same percentage, stop before Step 4 and ask the user whether one system includes tax, instead of syncing prices.

**Step 4: Confirm**

Show a table of SKU, name, field, current WooCommerce value and new value, plus the skipped list. Wait for the user to confirm. They may exclude rows.

**Step 5: Update**

For a simple product, call `woocommerce-update-product` with `product-id` and only the changed `stock-quantity` and/or `regular-price`. For a variation, call `woocommerce-update-product-variation` with `product-id`, `variation-id` (the product-variation-id) and the changed values. One call per product or variation.

**Step 6: Confirm and report**

Re-read the changed products with `woocommerce-get-product` or `woocommerce-get-product-variation` filtered by `sku`, and report each change as applied or failed, with the skipped list at the end.

**Rules & Guidelines:**

* Tools whose names start with woocommerce- are on the woocommerce server; tools whose names start with business-central- are on the business-central server.
* Only `woocommerce-update-product` and `woocommerce-update-product-variation` may write, and only after confirmation. Pass only stock-quantity and regular-price. Never change status, name, sale-price, manage-stock or stock-status.
* Never write to Business Central. Do not call `business-central-update-item` or `business-central-create-item`.
* Do not unpublish products for blocked items; report them instead.

**Validation:**

* Business Central inventory is summed across all locations. Say so in the confirmation step.
* If a SKU matches more than one Business Central item, skip it and list it as ambiguous.
* If nothing needs changing, say so and stop without calling any update tool.

Who it's for

One answer, three teams that use it

Operations managers

Bring the store in line in one pass

Review a list of only the differences and drop any rows before confirming.

Update WooCommerce stock and prices for the Tea category from Business Central.

Pricing managers

Avoid tax mistakes on prices

When all price gaps share one percentage it stops and asks about tax.

Sync WooCommerce prices from Business Central for all published products.

Inventory managers

Refresh stock without touching prices

Choose stock only, so prices stay exactly as they are.

Update only WooCommerce stock from Business Central for the Equipment category.

How it works

What PopdockAI does when you ask

You choose stock, price or both, and your AI assistant lists only what differs. Nothing is written until you confirm, and nothing is written to Business Central.

01

Ask

You choose stock, price or both, and optionally a category.

Your AI tool

02

Compare

It matches published products and variations to Business Central by SKU.

woocommerce-get-product
woocommerce-get-product-variation

03

Confirm

You review the change list, drop rows and see skipped SKUs.

No items found.

04

Update

It writes only stock and regular price and reads results back.

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

The store reflects ERP stock and prices

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