# See which products lost margin after your supplier raised prices > Two pasted price lists turn into a ranked list of the items quietly eating your profit. Paste your supplier's new price list next to your own prices. You get a table of what each item now costs you to make, your new margin, and a fair new price for the ones that slipped. - Page: https://thesolocreators.com/prompts/menu-margins-after-a-supplier-price-rise/ - Category: Make smarter decisions - Made for: Small business owners - Works in: ChatGPT, Claude, Gemini - Time: About 10 minutes - Effort: Just copy and paste - Published: 2026-10-25 ## How can AI show me which products lost profit after a price rise? Paste your supplier's new price list and your own product list into one chat and ask for a margin table sorted by the biggest drop. ChatGPT, Claude and Gemini all handle this as a single paste. If you only know rough amounts per item, say so, and ask it to flag anything it had to estimate. Check the flagged items against your latest invoice before you change any price on the shelf. ## The prompt Fill in the parts in [square brackets], or leave them and the AI will ask you for them. ```text I run [YOUR BUSINESS, e.g. a small bakery]. My supplier just sent new prices. Below are two lists. List 1, my supplier's new prices (and old prices if I have them): [SUPPLIER PRICE LIST] List 2, what I sell, my selling price, and roughly what goes into each item: [MY PRODUCTS AND PRICES] Please: 1. Work out what each of my items now costs me to make, using the new supplier prices. 2. Give me a table: item, old cost (if known), new cost, selling price, margin percent, change. 3. Sort it so the items that lost the most margin come first. 4. For each item below [TARGET MARGIN, e.g. 60%], suggest a new price that gets it back to target, rounded to a price customers are used to seeing. 5. Point out any item where a cheaper swap or smaller portion might work better than a price rise. If an amount is missing or unclear, ask me instead of guessing. ``` ## Step by step 1. Copy your supplier's latest price list from their email or portal 2. Copy your own product or menu list with prices and rough ingredient amounts 3. Paste both into a new chat with the prompt and fill in your details 4. Check the flagged items against your last invoice before you change a price ## What you'll get A sorted margin table showing each item's new cost and margin, plus suggested new prices for the ones that dropped below your target. ## Good to know **How can AI show me which products lost profit after a price rise?** Paste your supplier's new price list and your own product list into one chat and ask for a margin table sorted by the biggest drop. ChatGPT, Claude and Gemini all handle this as a single paste. If you only know rough amounts per item, say so, and ask it to flag anything it had to estimate. Check the flagged items against your latest invoice before you change any price on the shelf. **Which AI tools does this work in?** It works in ChatGPT, Claude and Gemini. On this page, ChatGPT and Claude open with your prompt already typed in. No paid plan is noted for this one. **How long does it take?** About 10 minutes. It's rated "Just copy and paste". There are 4 steps, listed above. **What do I need before I start?** Just your details for 4 blanks: your business, supplier price list, my products and prices and target margin. You can skip any, and your AI will ask for them. **What will I get back?** A sorted margin table showing each item's new cost and margin, plus suggested new prices for the ones that dropped below your target. Idea spotted on Reddit, shared by u/Confection-maker2307 (thread), r/smallbusiness: https://www.reddit.com/r/smallbusiness/comments/1xcmlcy/what_can_ai_actually_do_for_a_small_non_tech_food/. The prompt is The Solo Creators' own version. ## Go further Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Board of Advisors (Convene seven AI advisors who debate your decision, vote, and hand back a stress-tested verdict); Fact Checker (Every quote, number, date, and link in your draft checked against its real source, with the fixes handed back as tracked changes you accept or reject). From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.