Connectors

/

WooCommerce

/

Sync WooCommerce prices from Dynamics GP
Write
Cross-Connector

Update WooCommerce prices from Dynamics GP list prices

For ecommerce and pricing teams who want store regular prices set from Dynamics GP list prices, SKU by SKU, by their AI assistant.

Try PopdockAI free
Get a live demo
Sync WooCommerce prices from Dynamics GP
Update WooCommerce prices for MUG-BLU, TEE-BLK-L and BLEND-01 from Dynamics GP.
2 of 3 SKUs need a new regular price from Dynamics GP. - MUG-BLU: 12.00 to 13.50 - TEE-BLK-L: 25.00 to 22.00, no higher than the 22.00 sale price - BLEND-01: already matches, left out Shall I update the 2 regular prices?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-product
woocommerce-get-product-variation
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-price
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

Price changes retyped product by product

When list prices change in Dynamics GP, someone has to update the same SKUs in WooCommerce one by one. Mistakes are easy: the wrong unit of measure, a price below a running sale or a zero price published by accident.

Without PopdockAI

  • Look up new list prices in Dynamics GP
  • Find each SKU in WooCommerce
  • Retype prices for every variation
  • Publish a zero price by mistake

With PopdockAI

  • Each SKU's GP list price is read
  • Current and new regular prices are shown side by side
  • Unclear and zero prices are skipped, and sale price clashes flagged
  • Only the regular price is written after you confirm

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 regular price for SKUs {skus} to the Dynamics GP list price in currency {currency-id} (default: the only currency GP returns) for unit of measure {unit-of-measure} (default: the item's selling unit of measure), 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, regular-price and sale-price.

**Step 2: Read the GP list price (dynamics-gp)**

For each SKU call `dynamics-gp-get-iv-item` with item-number set to it to get its selling-u-of-m. Then call `dynamics-gp-get-iv-item-price` with item-number, unit-of-measure set to {unit-of-measure} or the selling-u-of-m, and currency-id set to {currency-id} when it is given. Use list-price only when exactly one row comes back.

**Step 3: Preview and confirm**

Show a table: SKU, name, current regular price, GP list price, change. Leave out SKUs whose price already matches to within 0.01. Flag any SKU where the new regular price would be at or below its current sale-price. List SKUs missing from either system, or with several or no GP price rows, separately. Ask the user to confirm before writing anything.

**Step 4: Write (woocommerce)**

Only after the user confirms, set regular-price, rounded to 2 decimals: for a product call `woocommerce-update-product` with product-id and regular-price; for a variation call `woocommerce-update-product-variation` with variation-id, product-id and regular-price.

**Step 5: Report**

Each SKU with its old and new regular price 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 regular-price.
* Never change sale-price, stock or status in the store.
* Never write to GP. Do not call `dynamics-gp-iv-item-price-update`, `dynamics-gp-iv-item-price-add` or `dynamics-gp-iv-item-update`.

**Validation:**

* If {skus} lists more than 50 SKUs, ask the user to narrow it.
* If GP returns several price rows, show them and skip the SKU unless the user picks one.
* If the GP list price is 0 or empty, skip the SKU. Never set a store price to 0.
* 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

Pricing managers

Roll out a price change to the store

Update store prices from GP for a list of SKUs, with every change reviewed first.

Update WooCommerce prices for CHAIR-01, DESK-02 and LAMP-03 from Dynamics GP.

Ecommerce managers

Protect running sales

New prices at or below the sale price are flagged, so promotions still make sense.

Sync WooCommerce prices from GP for SKUs on sale and flag any sale price clashes.

Operations teams

Avoid zero price accidents

Zero and unclear GP prices are skipped rather than published.

Pull Dynamics GP list prices in USD for BLEND-02 and BLEND-03 into WooCommerce.

How it works

What PopdockAI does when you ask

You give a list of SKUs, and your AI assistant lines up store prices with GP list prices. Nothing changes until you confirm, and sale prices, stock and GP are never touched.

01

Ask

You give a list of SKUs, and optionally a currency and unit of measure.

Your AI tool

02

Read

It finds each SKU in the store and reads its GP list price.

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

03

Confirm

You review current and new prices, with sale price clashes flagged.

No items found.

04

Update

It writes only the regular price.

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

Returns inventory item records from Dynamics GP Inventory, including item type, class, costs, units of measure and valuation settings. Filter by item class code, item description, current cost, item number, abc code, item short name, valuation method and item tracking option, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-iv-item-price

Returns item price list records from Dynamics GP Inventory, including price level, unit of measure, quantity breaks and pricing method. Filter by price level, price method, unit of measure, item number, currency ID, item description and item type, 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

Store prices that follow GP, reviewed first

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