Find Profit Traps and Hidden Winners in Your Product Range
Use this as the third prompt immediately after generating the profitability table. It surfaces which high-revenue products are actually poor performers and which low-revenue products deserve more attention.
The Prompt
Looking at the profitability table you just created: - Identify any products with high revenue (top 25% by revenue) but low margin (below 30%). These are potential profit traps. - Identify any products with low revenue (bottom 25% by revenue) but high margin (above 50%). These are potential hidden winners. - Flag any products with fewer than 5 orders that are running at near-zero or negative margin.
From the guide
How to use AI to analyze three months of your own sales data and tell you which products or services are actually making you money →Related Prompts
Identify Products With Missing Cost Data
Use this troubleshooting prompt if your profitability results look off. It identifies which products are missing cost data so you can fill them in and re-run the profitability calculation.
Track Month-Over-Month Profit Trends by Product
Use this as the fourth prompt to see whether your most profitable products are trending up or down over the 90-day period, rather than just looking at a snapshot ranking.
Calculate Product Profitability and Gross Margin
Use this as the second prompt after confirming the AI can read your file. It generates the core ranked profitability table showing gross profit and margin for every product.
Check Your Sales CSV File With AI
Use this as the first prompt after uploading your sales CSV to verify the AI has correctly read your file and identified all products before running any calculations.