# Put a Group of Products on Sale

> Sets a sale price on every product you name, or that matches a search, and shows the old and new prices before anything changes.

- 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: ~30 min vs doing it by hand
- Requires: StoreAgent (free plugin, MCP on every plan)
- Works in: Claude, ChatGPT, Cursor and any MCP client connected to the store through StoreAgent MCP
- Web page: https://storeagent.ai/mcp-recipes/bulk-sale-prices/

## The prompt

```text
Find all published products whose name contains [search term]. Put them on sale at [20]% off the regular price, rounded to the nearest .95. Show me a table with each product, SKU, regular price and new sale price, and leave out any product that already has a sale price. Wait for my OK before you change anything, then tell me how many were updated.
```

## What happens when you paste it

You: Find all published products whose name contains [search term]…

Assistant: Found 23 products with "linen" in the name. 3 already have a sale price, so 20 are left. Calling: `woocommerce/products-query`, `woocommerce/product-update`.

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

Assistant: 20 products are now on sale. The Linen Shirt went from $79.00 to $62.95. The 3 that were already on sale are unchanged.

## 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.
- **Update a product** (`woocommerce/product-update`, asks first, from WooCommerce): Changes a product's name, descriptions, prices, SKU, status or stock.

## Variations

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

- End the sale instead and clear the sale price on all of them.
- Only include products that are in 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.
- [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.
- [Set Wholesale Prices at a Fixed Percentage Off Retail](https://storeagent.ai/mcp-recipes/bulk-set-wholesale-prices.md): Works out new wholesale prices for a group of products from their regular price, shows old and new side by side, then saves them.

---

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/