# Set Wholesale Prices at a Fixed Percentage Off Retail

> Works out new wholesale prices for a group of products from their regular price, shows old and new side by side, then saves them.

- Job: [Pricing & wholesale](https://storeagent.ai/mcp-recipes/job/pricing/)
- What it does: Asks first: changes your store, only after you say yes
- Time saved: ~40 min vs doing it by hand
- Requires: StoreAgent (free plugin, MCP on every plan) + Wholesale Suite
- Works in: Claude, ChatGPT, Cursor and any MCP client connected to the store through StoreAgent MCP
- Web page: https://storeagent.ai/mcp-recipes/bulk-set-wholesale-prices/

## The prompt

```text
Find my published simple products that match "[search term]". For each one, show the regular price and the current wholesale price for the Wholesale Customer role. Work out a new wholesale price at [30]% off the regular price, rounded to 2 decimals. Show me a table of product, regular price, current wholesale price and new wholesale price, and wait for my OK. This replaces the current wholesale prices, so do not save anything until I confirm. Then set only the ones I approve.
```

## What happens when you paste it

You: Find my published simple products that match "[search term]"…

Assistant: 24 products match "tote". 15 have a wholesale price now, 9 have none. Current prices range from 22% to 41% off retail. Calling: `woocommerce/products-query`, `wholesale-suite/get-wholesale-price`, `wholesale-suite/set-wholesale-price`.

Assistant: This will make changes in WooCommerce. Do you want me to go ahead?

Assistant: Set 24 wholesale prices at 30% off retail. 9 products got a wholesale price for the first time. 6 prices went down and 9 went up.

## Abilities this recipe calls

- **Find products** (`woocommerce/products-query`, read only, from WooCommerce): Finds products by name, SKU, status, type or stock status, with prices and stock.
- **Get wholesale price** (`wholesale-suite/get-wholesale-price`, read only, from Wholesale Suite): Shows the wholesale price saved on a product for one wholesale role.
- **Set wholesale price** (`wholesale-suite/set-wholesale-price`, asks first, from Wholesale Suite): Sets or clears the saved wholesale price on a simple product or variation.

## Variations

Add one of these to the end of the prompt. Swap anything in [brackets] for your own details.

- Skip any product that already has a wholesale price.
- Clear the wholesale price on products that are out of stock.

## Related recipes

- [Spot Wholesale Prices Below Your Margin](https://storeagent.ai/mcp-recipes/wholesale-margins.md): Checks every wholesale price against retail so nothing sells at a loss after the last price change.
- [Put a Group of Products on Sale](https://storeagent.ai/mcp-recipes/bulk-sale-prices.md): Sets a sale price on every product you name, or that matches a search, and shows the old and new prices before anything changes.
- [Check What a Wholesale Customer Actually Pays](https://storeagent.ai/mcp-recipes/check-customer-wholesale-price.md): Answers "what price does this account see" by comparing the saved wholesale price with the final price after category and role rules.

---

Part of the StoreAgent WooCommerce MCP Recipes directory: https://storeagent.ai/mcp-recipes/ (index for LLMs: https://storeagent.ai/mcp-recipes/llms.txt). Get StoreAgent free: https://app.storeagent.ai/sign-up/