KiloClawPowered by OpenClaw
Back to Cookbook

Per-SKU True Profitability Calculator

aka “True Profit Calculator”

Know your real margin per SKU after every hidden fee

Marketplace fees, shipping, returns, and ad spend hide real margin fast. This recipe pulls transaction data from your channels and calculates actual profit per SKU after the costs people usually forget.

House RecipeWork5 min setup
Try in KiloClawFree 7-day trial

INGREDIENTS

✈️Telegram💬Slack

PROMPT

Calculate true per-SKU profitability across all my sales channels. Pull transaction data from [Shopify/Amazon/WooCommerce/eBay]. For each product, calculate: revenue minus (COGS + marketplace fees + payment processing fees + shipping costs + FBA fees + advertising cost per unit + return costs). My COGS data is in [spreadsheet/provide per-SKU]. Pull ad spend from [Amazon Ads/Google Ads/Meta Ads]. Output: a ranked profitability report showing true net margin per SKU and per channel. Flag any products with negative margins. Show margin trends over the last [3/6/12] months. Export as CSV and send a monthly summary to [email/Telegram/Slack].

How It Works

Your Claw pulls financial data from every platform you sell on —

marketplace fees, payment processing fees, shipping costs, advertising

spend, return costs, and fulfillment fees. It combines this with your COGS

data to calculate true net profit per SKU, per channel, and overall.

What You Get

  • Per-SKU profitability after marketplace, payment, fulfillment, shipping, return, and ad costs
  • Channel-by-channel comparisons
  • Margin trend over time
  • Loss-leader detection
  • Monthly P&L-style summaries across channels
  • Exportable reports for finance review

Setup Steps

  1. Connect your sales channels
  2. Provide your COGS data
  3. Connect ad platforms if you want ad spend folded in
  4. Review the cost mapping so fees land in the right buckets
  5. Verify the first report against a period you already know well

Tips

  • The quality of your COGS data determines whether this is interesting or actionable
  • Include return shipping and write-offs if you want the true picture
  • Ad spend allocation by SKU is imperfect, so document the attribution method
  • Your top-line best seller is often not your best-margin product
  • Review this monthly, not once, because fees and mix drift over time
Tags:#ecommerce#analytics#profitability#accounting#reporting

Related Recipes

Morning Brief

Every KPI from every channel in one report before your coffee gets cold

Stop logging into 6 platforms every morning. Your Claw pulls yesterday's numbers from all your sales channels, ad platforms, and email tools, then delivers a single dashboard with the metrics that actually matter.

Work5 min setup

Nexus Monitor

See where you may be approaching a sales tax obligation

Track state-by-state sales activity, compare it against current nexus thresholds you provide or verify, and surface where you may need to review your tax setup. This is an alerting workflow, not legal advice.

Work5 min setup

Social Content Engine

Turn your product catalog into platform-ready social posts

Turn product data and product photos into platform-specific social drafts you can review, schedule, and reuse. Best for brands that already have a catalog but need a repeatable content workflow.

Creative5 min setup

Mistake Tagger

Label mistakes so patterns become obvious

Traders often report that profitability improved only after tracking mistakes (not just P&L). This recipe forces a mistake tag on every trade and compiles a mistake leaderboard.

Personal6 min setup