# Find Composite Products Customers Cannot Finish

> Composite products can show as in stock while a required step has nothing left to choose. This finds them.

- Job: [Catalog & products](https://storeagent.ai/mcp-recipes/job/catalog/)
- What it does: Read only: looks, never changes anything
- Time saved: ~30 min vs doing it by hand
- Requires: StoreAgent (free plugin, MCP on every plan) + WooCommerce Composite Products
- Works in: Claude, ChatGPT, Cursor and any MCP client connected to the store through StoreAgent MCP
- Web page: https://storeagent.ai/mcp-recipes/composite-products-cannot-finish/

## The prompt

```text
Check every composite product. For each required component, look up the stock status of every option by product ID. Flag components where no option is in stock, because customers cannot finish building the product, and components whose default option is out of stock. Composite products can still show as in stock when this happens, so check every option. Show a table with the composite, the component, its options and their stock. Do not change anything.
```

## What happens when you paste it

You: Check every composite product…

Assistant: 2 of your 14 composite products cannot be finished. Build Your Outfit shows as in stock, but both Extras options are sold out. Calling: `woocommerce-composite-products/query-composite-products`, `woocommerce/products-query`.

Assistant: 3 more have an out-of-stock default. Restock Belt or add an in-stock option to Extras to fix Build Your Outfit.

## Abilities this recipe calls

- **Find composite products** (`woocommerce-composite-products/query-composite-products`, read only, from WooCommerce Composite Products): Finds composite products with their price range, components, options, defaults and scenarios.
- **Find products** (`woocommerce/products-query`, read only, from WooCommerce): Finds products by name, SKU, status, type or stock status, with prices and stock.

## Variations

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

- Also check optional components.
- Only check composite products in [category].

## Related recipes

- [Trash Out-of-Stock Products That No Longer Sell](https://storeagent.ai/mcp-recipes/trash-dead-stock.md): Finds products that are out of stock and have had no orders in a year, so you can clear old listings out of your catalog.
- [Find Out Why Products Get Left in Carts](https://storeagent.ai/mcp-recipes/why-carts-get-abandoned.md): Looks at your most abandoned products next to their price, stock and sale status to spot the likely reason shoppers leave.
- [Which Products Are Missing Their Options?](https://storeagent.ai/mcp-recipes/ppom-missing-options.md): Find products in a category that do not have the right PPOM field group attached, then attach it after you say yes.

---

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/