Find CRM product prices that don't match the current price list

About this exercise

Compare the CRM product prices with the current price list (effective Nov 1). Write a markdown table of mismatches only, with columns SKU, List, CRM, Difference, where Difference is (CRM - List) / List as a percent with a sign and one decimal (like +7.6%), sorted by the size of the difference from largest to smallest ignoring the sign. Add a last line "Matching: [SKUs]". Use the current list, not the August one. Under 90 words.

Common mistakes when you ask AI for this

• Using the August list. The AI treats S-200 and S-500 as matching. Try: Add: "Compare with the current list effective Nov 1, not the August list."
• Wrong percent base. The AI divides by the CRM price. Try: Add: "Difference = (CRM - List) / List."
• Wrong sort or missing sign. The AI sorts by SKU and drops signs. Try: Add: "Sort by size of difference, largest first; keep the sign."
• Extra commentary. The AI adds recommendations. Try: Add: "Table plus the Matching line only, under 90 words."

What a strong prompt includes

• Names the columns
• Current list
• Formula
• Sort
• Matching line

Practice this now ↑

Related exercises

• Accept the buyer's counteroffer on three stated conditions (Sales AI · Sales and customer success)
• Accrue unpaid wages for the working days after the last pay period (Finance AI · Accountants)
• Age a returns queue in business days and flag the ones over the limit (Customer Support & Success AI · Customer support teams)
• Alert sales to a competitor's price change, facts only (Research & AI Search · Product managers)
• Announce a discount-approval process change in three bullets (Sales AI · Managers and team leads)