Inventory and margin review agent for online sellers
A true-margin review for online sellers: per-product margin including fees and ads, the loss-maker list, slow-mover flag, three actions, and the one metric to track monthly.
Fill in the Template
0 / 7 filledYour Built Prompt
Updates live as you typeAct as my margin review agent. I want to look at last month's sales and figure out which products actually made money once all the real costs come out, and which ones are quietly losing me cash.
Period being reviewed: {{period}}
Top sellers by units (top 10): {{top_sellers}}
Cost of goods per unit (or rough %): {{cogs}}
Average shipping + packaging cost per order: {{shipping}}
Payment processor + marketplace fee % I should assume: {{fees_pct}}
Ad spend allocated to product sales this month: {{ad_spend}}
Inventory on hand value (rough $): {{stock_value}}
Return:
1. Per-product true margin - for each top seller: revenue minus COGS minus shipping minus fees minus ad allocation = real margin per unit + % margin. Sorted from best to worst.
2. The loss-makers - any SKU selling below 15% real margin. Name them. Flag whether it is COGS, shipping, fees, or ads dragging it under.
3. Inventory turn check - which SKUs are sitting in stock more than 90 days (use the stock value + sales pace I gave you). Flag the 3 worst.
4. Three pricing or sourcing actions I can take this week (e.g. lift price on SKU X by $4, find a cheaper supplier for SKU Y, kill ad spend on SKU Z).
5. One number I should now track every month so the same pattern is caught earlier next time.
AU English. Numbers lead. Skip the corporate buzzwords. If the data is too rough to tell, say so.Fill in the required fields above to copy or run this prompt.
This prompt produces general information, not financial or tax advice. Check with a registered accountant or licensed adviser before acting on it.
Tags
Community Feedback
0 commentsRelated Prompts
More in BusinessProduct Delivery Agent
A deployable AI agent that drafts PRDs, synthesises customer feedback, plans the roadmap, and writes release notes. Configure once, run per feature.
Hiring Funnel Agent
A deployable AI agent that runs your hiring funnel — JDs, candidate triage, interview kits, offer letters, candidate comms. Configure once, run per role.
Monthly Bookkeeping Agent
A deployable AI agent that runs your monthly close, BAS prep, and cash flow updates — AU-tax compliant. Configure once, run every month.
Write a sales-to-CSM handoff
Drafts a structured sales-to-CSM handoff document so customers don't repeat themselves.