99% of AI content online is prompts without examples. this one has both.
• here's a real script input — your sales history, five columns
• here's the prompt you paste into claude to build it
• here's the actual output — every SKU graded on two axes, ranked for action
paste the headers and a few sample rows into claude, then ask: "build me a python script and a batch file to run it. the script should read sales_history.csv, calculate 12-month hits (unique order count), 12-month profit (revenue minus cost), and assign ABC ranks on each axis using pareto's rule. combine into a 9-box tier. output as abc_9box_analysis.csv — item, description, vendor, hits rank, profit rank, 9-box, hits 12M, profit 12M, unit cost."
Try for yourself and see if you get what you’re looking for.