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.
The Prompt
Which products have a unit_cost of zero? List them.
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
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.
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.