Ecommerce Margin Health Checker

What it does

You look at your store dashboard and see revenue, but you know not every product is profitable. Manually checking margins across hundreds of SKUs takes hours. This skill does the math automatically: feed it your product costs and prices, and it flags the ones bleeding cash, suggests new prices to hit your target margin, and gives you a clear report you can act on today.

Quick scan

• Best for: Ecommerce managers, DTC brand owners, library sellers.
• Output: A margin health report with scores, flags, and repricing suggestions per SKU.
• Inputs needed: Product list with at least SKU, name, unit cost, and selling price. Optional: extra variable costs, monthly sales volume.
• Time saved: Turn a half-day manual audit into a 5-minute review.
• Main caveat: Works best with standardized product data; not a full accounting tool.

When to use it

Use it before pricing meetings, after supplier cost changes, or when you suspect your margins are eroding. Run it monthly as a health check. It's especially valuable for DTC brands and library sellers who manage hundreds of products and need quick, actionable insights.

Don't rely on it for complex costing scenarios like multi-currency, dynamic discounts, or bundled products—those require a dedicated financial system.

How to install and use

1. Download the ZIP (includes SKILL.md, README, COPYRIGHT, and metadata).
2. Place the skill folder in your AI skills directory (see your Claude client docs).
3. Start a new Claude session.
4. Say: "Check my product margins and flag underperformers."
5. Paste your product data as a table (CSV, spreadsheet rows, or typed list). Include at least SKU, name, unit cost, and selling price.
6. Optionally, add a column for extra per-unit costs (shipping, transaction fees) and monthly sales volume for prioritization.
7. The skill will ask for a target margin if not provided (default 30%).
8. Review the generated margin health report.

A concrete example

A DTC brand selling running apparel has 120 SKUs. They import their Shopify product export with cost and price columns. After running the skill, they see 12 SKUs flagged as bleeding—including a popular jacket selling at $80 with a total cost of $65, giving only 18.75% margin. The report suggests a new price of $92.86 to reach 30% margin while still staying under competitor pricing (if provided). They also identify a low-volume accessory with negative margins and decide to discontinue it. The whole audit took 5 minutes instead of a full morning.

Limitations

• Data dependency: If your input data is wrong or incomplete, the output will be misleading. Double-check costs and prices before running.
• Not a pricing optimizer: Repricing suggestions are based solely on achieving the target margin—they don't consider demand elasticity or competitive dynamics unless you manually provide competitor prices.
• Fixed costs ignored: This skill works at the product contribution margin level. It doesn't allocate overhead, which is fine for most operational decisions but not for P&L reporting.

Download the skill

Download Ecommerce Margin Health Checker

The ZIP includes the SKILL.md, README, COPYRIGHT, and metadata.json—everything you need to run it in your Claude workspace.

Related skills

• _If you're also managing inventory, pair with a Draft Inventory Reorder Planner (coming soon)._
• _For performance marketing teams, check out our upcoming ROAS Auditing Toolkit._

Related skills

Skills that pair well, or that you'd reach for instead:

Install

Start with the ZIP package, then choose the AI tool workflow that fits your setup.

1. Download ecommerce-margin-health-checker.zip (5.4 KB).
2. Open the package and read SKILL.md, plus any included references, templates, or scripts.
3. Use the instructions directly in any AI tool that supports reusable instructions, project knowledge, custom agents, or uploaded reference files.

In Claude, open the command picker with / and select this skill by name when you want to use it.

For Claude Code, unzip into ~/.claude/skills/ so the folder lands at ~/.claude/skills/ecommerce-margin-health-checker/, then reload Claude Code. For Claude.ai, upload the same ZIP from Customize → Skills.

Use with other AI tools

This package is not locked to one vendor. If your AI tool does not support Claude-style skills, copy the core instructions from SKILL.md into the tool's custom instructions, project prompt, agent setup, or reusable prompt library.

• Upload or paste any included reference files as project knowledge where your tool supports it.
• Keep the output format from SKILL.md intact so results stay predictable.
• Run a small test with your own data before using the workflow in production.

Compatibility depends on the features your AI tool provides. Treat scripts as optional local helpers unless your environment can run them safely.

Claude installation reference