Workflow Guide

Know Your True Etsy Profit

See exactly what you made on every Etsy order — after fees, shipping, materials, and packaging. No more guessing.

Why Profitability Is Hard to Track

Your revenue number isn't telling you the whole story

Etsy sellers face a unique challenge: your real profit is spread across four different cost sources, none of which Etsy surfaces in one place. Most sellers either ignore some of these costs or track them in a spreadsheet that quickly gets out of date.

๐Ÿท๏ธ

Etsy Fees

Transaction (6.5%), payment processing (~3%), listing fees, offsite ads, promoted listings

๐Ÿ“ฎ

Shipping Labels

What you actually pay on Pirate Ship, Shipstation, etc. โ€” usually less than what the customer paid

๐Ÿงต

Cost of Goods

Raw materials to make the product โ€” yarn, blanks, resin, vinyl, etc.

๐Ÿ“ฆ

Packaging

Boxes, mailers, tissue paper, ribbon, thank-you cards, stickers

Without tracking all four, your "revenue" number is misleading. You might feel profitable looking at Etsy deposits, while quietly losing money on certain products. The Profit Report pulls all of this together per order so you can see the real picture.

What the Report Shows

Every column explained — and where the data comes from

Gross Revenue
What the customer paid on Etsy โ€” including item price, shipping they paid, and any applicable tax. Pulled automatically from Etsy's payment ledger using the billing_r OAuth scope. This is your starting point before any deductions.
Etsy Fees
All fees Etsy charges you โ€” transaction fee (6.5% of item + shipping), payment processing (~3%), listing fees ($0.20/listing), offsite ad fees, and promoted listing spend. These are pulled automatically from Etsy's ledger. Shown as a negative number. Sales tax is excluded โ€” Etsy collects and remits it on your behalf, so it's pass-through, not your cost.
Actual Shipping
What YOU paid for the label โ€” entered manually by clicking the "—" in that column. This is different from what the customer paid for shipping. If you bought a label on Pirate Ship for $4.20, enter $4.20. Shown as a negative number. Without this, net profit is understated.
Shipping Δ
The spread between what the customer paid for shipping and your actual label cost. A positive delta means you recovered more than you spent โ€” extra margin from shipping. A negative delta means you over-spent, subsidizing shipping out of pocket. Use this column to find out if your shipping prices are calibrated correctly.
COGS
Cost of Goods Sold โ€” the raw material cost to produce one unit. Set per product via CSV import (see Step 3 below). Does not include your time — just materials. Shown as a negative number. Packaging cost is tracked separately and also included in this deduction.
Net Profit
green = profit ยท red = loss
What's left after everything. Gross Revenue minus Etsy Fees minus Actual Shipping minus COGS minus Packaging. Green means profitable. Red means you lost money on that order. This is the number that matters.
Margin %
green >30% ยท amber below ยท red if negative
Net Profit ÷ Gross Revenue. Shows profitability as a percentage of what the customer paid. Green above 30%, amber below, red if you lost money. Use this to quickly spot which products (or which order sizes) are most and least profitable.

Example Order Math

$38.00 revenue $3.95 Etsy fees $4.20 shipping $2.40 COGS $0.45 packaging = $27.00 net · 71% margin

Step 1: Connect Etsy with Billing Access

Fee data requires the billing_r OAuth scope

The Profit Report reads Etsy's payment ledger to pull your fee data automatically. This requires the billing_r OAuth scope, which was added to OrderBridge after the initial launch. If your Etsy connection predates this feature, the report will show "no fee data" on most orders.

Heads up: If you see "no fee data" on most orders, you need to reconnect Etsy to grant billing access. This is a one-time step.

Go to Settings → Etsy Integration

Open your OrderBridge dashboard and navigate to the Settings page. Find the Etsy Integration section.

Disconnect your current Etsy connection

Click Disconnect. This does not affect your synced orders — it only revokes the OAuth token. Your order history stays intact.

Reconnect via Etsy OAuth

Click Connect Etsy and complete the OAuth flow. This time, OrderBridge will request the billing_r scope in addition to the standard scopes. Etsy will ask you to approve the updated permissions.

Reload the Profit Report

Once reconnected, fee data will appear for all orders within your selected date range. Historical orders are covered — Etsy's ledger goes back years.

Note: Reconnecting does not interrupt order syncing. OrderBridge picks up syncing immediately after you reconnect.

Step 2: Enter Actual Shipping Costs

The difference between what the customer paid and what you paid

Etsy's ledger shows what the customer paid for shipping. But what you actually paid for the label โ€” on Pirate Ship, Shipstation, or through Etsy's own label purchase — is almost always different. Commercial rates are typically $2–5 less than what shoppers pay at retail. That spread is real margin you're earning (or losing).

How to Enter Shipping Costs

On the Profit Report page, find the Actual Shipping column for any order. Click the (dash). Type your label cost and press Enter or click away. It saves immediately — no submit button needed.

โœ… Positive Delta Example

Customer paid $6.50 shipping. You bought a label on Pirate Ship for $4.20.

Shipping Δ = +$2.30 โ€” extra margin you're earning on shipping

โš ๏ธ Negative Delta Example

You charged $3.00 flat shipping. The label cost $5.80.

Shipping Δ = −$2.80 โ€” you're subsidizing shipping, eating into profit

Tip: Enter label costs consistently to get accurate net profit numbers. Without them, the Actual Shipping column shows — and net profit is understated. Even an approximate average per order is better than nothing.

The Shipping Delta column is particularly useful for spotting products where your flat shipping rate doesn't match reality. If you sell heavy items and consistently see a negative delta, it may be time to adjust your Etsy shipping prices.

Step 3: Set COGS and Packaging Costs

Enter your material and packaging costs via CSV — takes about 5 minutes

๐Ÿงต What is COGS?

Cost of Goods Sold — the raw material cost to produce one unit. For example: if you make badge reels, your COGS might be $0.85 (badge reel blank + vinyl). This does NOT include your time — just physical materials.

COGS is per product โ€” each Etsy listing has its own COGS value

๐Ÿ“ฆ What is Packaging Cost?

The cost of packing materials per order — boxes, mailers, tissue paper, ribbon, thank-you cards, stickers. Tracked separately from COGS because it's a per-order cost, not per-product.

Example: $0.45 for a poly mailer + tissue paper

The CSV Workflow

Go to the Profit Report page (or Mappings page) and click Export Costs. This downloads a CSV with all your products pre-filled: etsy_listing_id, sku, variant_title, etsy_title, cogs, packaging_cost. The variant_title column shows the human-readable variant name (e.g., 1x car coaster only or 2x car coasters only) so you can identify each row without needing to know the SKU by heart.

Open the CSV in Excel or Google Sheets.

Fill in the cogs column for each product — enter the cost in dollars (e.g. 0.85 for $0.85). Leave blank to keep existing values unchanged.

Fill in the packaging_cost column — enter your average packaging cost per order (e.g. 0.45 for a poly mailer + tissue paper). Most sellers use the same value across all products.

Save the file as CSV.

Back on the Profit Report page, click Import Costs and upload your file. OrderBridge updates all matching products immediately.

The Profit Report refreshes — COGS and packaging now appear in the report and are factored into net profit.

Important notes on the CSV:

  • Blank cells on import are left unchanged — you don't need to re-enter everything each time.
  • Enter 0 to clear a cost back to zero.
  • Products that appear in orders but have no product mapping will also appear in the export.
  • Per-variant COGS: If a listing has multiple SKUs (e.g., a 1-pack and a 2-pack), each SKU gets its own row with its own COGS value. The report matches by SKU first, then falls back to the listing-level value if no SKU-specific row exists.
  • Adding a SKU to a no-SKU row: If a row has no SKU and you fill one in and reimport, OrderBridge promotes that existing entry to carry the SKU — no duplicate rows are created.

⚠ Important: SKU changes here only affect the Profit Report — not order routing. The SKU field in this CSV controls which COGS value is applied when calculating profit. It does not change how OrderBridge matches Etsy orders to Shopify product variants — that mapping is managed separately by the OrderBridge sync process and is completely unaffected by COGS imports.

Reading Your Results

Making sense of what the report tells you

Use the date range selector

The summary cards at the top aggregate totals across all orders in the selected date range. Switch between 7d / 30d / 90d / All Time to compare periods or spot seasonal trends.

Expand any order for the full breakdown

Click any order row to see the Etsy Breakdown panel — every individual fee type: transaction fee, payment processing, shipping Etsy charges the customer, promoted listing spend, listing fees, and more. "Net from Etsy" shows exactly what Etsy deposits to your account after all their fees.

Spot "no fee data" orders

Orders showing "no fee data" mean Etsy's ledger didn't return data for that order. This usually means the billing_r scope wasn't authorized when that order was synced. Reconnect Etsy (Step 1 above) and reload — the ledger data is retroactive.

Look for patterns, not just totals

Filter by product to find your most and least profitable items. A product with strong revenue but thin margin is a candidate for a price increase or a COGS reduction. A product with a consistently negative shipping delta may need its shipping price updated on Etsy.

Sorting columns: Click any column header in the report table to sort by that column. Click again to reverse the sort order. Sorting by Net Profit or Margin % quickly surfaces your best and worst-performing orders.

Sorting columns: Click any column header in the report table to sort by that column. Click again to reverse the sort order. Sorting by Net Profit or Margin % quickly surfaces your best and worst-performing orders.

Pro Tip: The Margin % column is color-coded for a reason. Scan for red rows — any order where you lost money is worth understanding. Was it an unusually heavy shipment? An offsite ad that drove a small order? Knowing why helps you fix it.

Start Tracking Your Real Profit

Enable the Profit Report from your OrderBridge dashboard. It's included in all plans — no upgrade required.

Get Started

More OrderBridge Guides

Getting Started Guide โ†’ Auto-Restock Etsy Inventory โ†’ Delayed Import + Extension โ†’ Follow-Up Email Automation โ†’ SKU & Product Mapping โ†’ Tracking Notification Emails โ†’ Etsy Profit Report โ†’ Zero-Revenue Import โ†’

Ready to sync your Etsy orders to Shopify? Start your free trial โ†’