Upload your order export and your costs, and get the real profit on each order and product after product cost, shipping, platform fees and ad spend.
Who it is for
Online sellers who know their revenue but not what they actually keep on each order.
Tools
Claude or ChatGPT with file upload
Your order export (CSV)
A list of product costs, shipping costs, fees and ad spend
Steps
Export last month's orders as CSV. Remove customer names and addresses.
Write down your costs: product cost per item, average shipping, platform and payment fees as you are charged them, and total ad spend.
Upload the file and paste the costs into the prompt below. Anthropic says you can upload CSV files for analysis and have Claude create Excel files with working formulas.
Check two orders by hand against the result before trusting it.
Look at the products with the lowest profit per order first; those are your pricing or ad decisions.
Keep the spreadsheet it builds and drop in each month's export.
The prompt
I uploaded last month's orders. Calculate true profit per order and per product. Use only my file and these costs:
Product cost per item: [LIST]
Shipping cost: [PER ORDER OR AVERAGE]
Platform and payment fees: [EXACTLY AS I AM CHARGED]
Ad spend for the month: [TOTAL]
1. Confirm the columns you used and how you matched products to costs.
2. Profit per order = revenue - product cost - shipping - fees - (ad spend / number of orders). Show it for 3 sample orders.
3. Table by product: orders, revenue, total profit, profit per order, sorted lowest first.
4. Build it as an Excel file with formulas I can reuse.
If a cost is missing, say so instead of guessing.
Tips
Spreading ad spend evenly is a simple start; split it by product later if you track that.
Refunds and returns change the picture; add them as a column.
Re-check fees when your platform changes its pricing.