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.
The Prompt
For each product, calculate the following: - Total units sold - Total revenue - Total cost (quantity × unit_cost) - Total gross profit (total revenue − total cost) - Gross margin percentage (gross profit ÷ revenue × 100) Return this as a table ranked by gross profit, highest to lowest.
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.
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.
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.