Dropshipping COGS Tracking: Why Your Margins Are Wrong (And How to Fix Them)

You're checking your Shopify analytics and seeing a 45% gross margin. That's great, right?

Wrong.

If you're dropshipping, that number is probably a fantasy. And you're not alone—we've audited hundreds of dropshipping businesses, and nearly 90% are reporting margins that are 5–15 percentage points higher than reality.

The culprit? Broken COGS tracking.

Unlike traditional retail where you buy inventory once and mark it up, dropshipping COGS is a moving target. Supplier prices shift. Currency exchange rates fluctuate. Shipping costs hide in plain sight. By the time you realize your numbers are wrong, you've already made decisions based on false data.

Here's what we're going to cover:

• Why dropshipping COGS is uniquely difficult to track
• The four mistakes that tank your margins
• A real-world example that might hit close to home
• Three concrete methods to fix it
• An actionable audit checklist

Let's start with the mess.

Why Dropshipping COGS Tracking Is Harder Than You Think

You know you need to track the cost of goods sold. The problem is: dropshipping breaks every standard assumption about what that even means.

1. Supplier Prices Change Without Notice

When you source a product from AliExpress or CJDropshipping, you get a price. That becomes your COGS, right?

Not even close.

Supplier prices change constantly. Sometimes weekly. A product you sourced at $2.15 three months ago might be $2.40 today. If you're not checking those prices regularly—and most dropshippers aren't—you're basing profitability decisions on outdated data.

The kicker? You don't get a notification when prices shift. You have to actively hunt for changes on each supplier platform, manually compare against your records, and update your system. Most people don't.

2. "Product Cost" Doesn't Include Supplier Shipping

This is the sneaky one.

A supplier lists a product at $2.15. You think: "Great, my COGS is $2.15."

But that's just the product. Getting it from Shanghai to your customer's door costs extra. ePacket, Yanwen, DHL, SF Express—each has a different rate. And that shipping cost is part of your COGS.

Many dropshippers ignore this entirely. Others estimate it badly. The result is the same: margin miscalculation.

3. Currency Conversion Adds a Hidden Layer

If you're sourcing from Chinese suppliers, you're buying in CNY and converting to USD (or your local currency). That exchange rate isn't static.

When you lock in a $2.15 price on a product, you're implicitly fixing a currency rate. But that rate moves. Over time, if the dollar weakens against the yuan, your effective cost per unit rises.

Plus, payment processors and suppliers charge conversion fees. Credit card payment to AliExpress? That's another 2–3% on top.

Most dropshippers don't factor any of this into their COGS model.

4. Multiple Suppliers for the Same Product

You've got the same t-shirt listed from three different suppliers:

• Supplier A: $3.20 + $0.50 shipping
• Supplier B: $2.95 + $0.70 shipping
• Supplier C: $3.40 + $0.30 shipping

Which one's your COGS? All of them? The cheapest? The fastest?

If you're rotating between suppliers (which most dropshippers do for resilience), your actual COGS per unit is a weighted average—not a single number. And that weighted average changes as you adjust supplier preferences.

5. Bundle and Variant Complexity

You're selling a "t-shirt bundle" with three colors. In your Shopify store, it's one SKU, one price, one "COGS."

In reality:

• Blue shirt: $2.15 from Supplier A
• Red shirt: $2.40 from Supplier B (out of stock at A)
• Gray shirt: $2.20 from Supplier C

Your bundle's actual COGS is $6.75. But if you're assigning a single COGS to the bundle, you're blind to the real cost of each variant.

This scales across your entire catalog. 50 products × 3 variants each × multiple suppliers = chaos.

The Four Mistakes That Wreck Your Margins

Now that we've established why it's hard, let's talk about the mistakes you're probably already making.

Mistake #1: Using Stale Product Costs

You sourced a product four months ago at $2.15. That became your COGS in Shopify. Case closed.

Except the supplier's current price is $2.55. You've been selling 20 units a week for four months. That's 320 units.

At the old (wrong) cost: you thought you made 45% margin.

At the real cost: you actually made 38% margin.

That's a $128 difference on one product alone. Multiply that across 50 products, and you're suddenly looking at thousands of dollars in miscalculated profit.

But the real damage isn't just the historical calculation. The real problem is that you're making future decisions based on false data. Should you invest more in marketing for this product? Scale it up? Your margin math says yes—but that math is lies.

Mistake #2: Forgetting Supplier Shipping

You've added product cost to your COGS. You've even added your fulfillment fees. But supplier shipping? Not there.

Let's say:

• Product cost: $2.15
• Your fulfillment setup time: $0.25
• Supplier shipping: $0.80 (ePacket to customer)
• Your reported COGS: $2.40 (missing $0.80!)
• Your actual COGS: $3.20

Your margin is 8 percentage points lower than you think. On a $15 sale, that's $1.20 per unit you thought you were making but actually aren't.

Mistake #3: Ignoring Currency Conversion Costs

You're sourcing from Chinese suppliers. You lock in a product cost of $2.15 USD (let's say that's roughly 15.5 CNY at today's rate).

Next month, the USD strengthens. Now 15.5 CNY = $2.10. Good for you, right?

Wrong. You're not actually buying at the new, cheaper rate. Your suppliers adjusted their prices too. And their USD prices now reflect the new exchange rate.

Meanwhile, you're still running analytics based on the old $2.15 figure.

Even worse: if you're paying with credit cards, add 2–3% for currency conversion fees. That extra cost almost never makes it into COGS calculations.

Mistake #4: Treating All Variants as One Cost

You're selling a hoodie in five colors, all under one SKU (or grouped in your mind as "the same product"). Your COGS is set at $5.20.

But here's the reality:

• Black: $5.20
• Navy: $5.20
• Red: $5.80 (supplier charges more for custom dyes)
• White: $5.00 (bulk discount available)
• Gray: $5.30

Your blended average is $5.46, but you're using $5.20 for profitability decisions.

Over a month, if you sell 10 of each, that's 50 units. Your error: $0.26 × 50 = $13 in margin miscalculation. On a $25 hoodie, that's real money.

And if red sells better than expected (higher price, higher actual cost), you're pushing margin-destroying inventory harder than profit-maximizing inventory.

The Real Impact: A Concrete Example

Let's walk through a real scenario. You're running a dropshipping store with 50 products, three main suppliers (Alibaba, CJDropshipping, and a private Chinese manufacturer), and you haven't updated costs in four months.

Your Reported P&L:

• Monthly revenue: $12,000
• COGS (in your system): $6,600 (55%)
• Gross profit (reported): $5,400 (45%)

The Audit:

You pull current prices from each supplier. You note that:

• 30 products are 8–15% more expensive than your COGS list
• 15 products haven't changed (lucky you)
• 5 products are cheaper (supplier liquidating old stock)

You also realize you've been missing supplier shipping (averaging $0.60–$1.20 per unit) and haven't accounted for the recent 3.5% USD/CNY shift.

Your Actual P&L:

• Monthly revenue: $12,000
• COGS (actual): $8,280 (69%)
• Gross profit (actual): $3,720 (31%)

That's a $1,680 difference. Your margin just dropped from 45% to 31%.

[IMAGE PLACEHOLDER: Chart showing reported 45% margin vs. actual 31% margin]

And here's the kicker: you probably made scaling and marketing decisions based on the 45% number. You increased ad spend because the unit economics looked good. They didn't. Now you're bleeding money faster.

This is what happens when you don't track COGS properly in dropshipping.

The Three Methods to Track Dropshipping COGS

Okay, enough fear. Let's fix it.

There are three approaches to COGS tracking, each with tradeoffs:

Method 1: Manual Spreadsheet (Free, But Broken)

How it works:

1. You maintain a spreadsheet with product names, SKUs, and costs
2. Weekly (or when you remember), you check supplier websites for price changes
3. You manually update the spreadsheet
4. You export that spreadsheet and manually update your Shopify product data or profit tracker
5. Repeat forever

Pros:

• Free
• Full control
• Works offline

Cons:

• Takes 3–5 hours per week for a 50-product store
• Always outdated (prices change faster than you update)
• Prone to human error (typos, missed suppliers, forgotten products)
• Doesn't scale (100 products? Good luck)
• No visibility into when costs changed or why

Real workflow time estimate:

• Weekly check of three suppliers: 2 hours
• Manual updates to spreadsheet: 1 hour
• Syncing to your system: 1 hour
• Total: 4 hours per week, every week, forever

If your time is worth $50/hour, that's $10,400/year in labor for one person.

Method 2: CSV Import into a Profit Tracker (Better)

How it works:

1. You export costs from your supplier(s) as CSV files
2. Weekly, you upload these CSVs into a tool like Shopimize
3. The tool matches SKUs, updates costs automatically, and recalculates margins
4. You get an alert if any costs changed significantly
5. Repeat weekly

Pros:

• Scales to 100+ products
• Faster than manual (30 minutes per week)
• CSV export is usually free from suppliers
• Tool does the matching and calculation for you
• You get historical cost data and alerts

Cons:

• Requires manual export from suppliers (not fully automated)
• Still depends on you remembering to do it weekly
• Works only if supplier provides CSV export (not all do)

Real workflow time estimate:

• Export CSVs from suppliers: 10 minutes
• Upload to profit tracker: 5 minutes
• Review alerts and changes: 10 minutes
• Total: 25 minutes per week

At $50/hour, that's $1,300/year in labor. Much better.

Method 3: Automated Sync (Best)

How it works:

1. You connect your supplier account(s) to a tool
2. The tool automatically pulls current costs daily or weekly
3. Costs are updated in real-time without your intervention
4. You get notifications when costs change significantly
5. Your profit calculations stay current always

Pros:

• Fully automated, no manual work
• Always up-to-date (daily or weekly pulls)
• Historical tracking (you see cost changes over time)
• Alerts for suspicious changes or price spikes
• Scales infinitely

Cons:

• Requires API access to supplier (not all suppliers provide this)
• More expensive (premium tool)
• Dependent on supplier maintaining their API

Real workflow time estimate:

• Setup: 30 minutes (one-time)
• Ongoing work: 0 minutes
• Review alerts: 5 minutes per week
• Total: 5 minutes per week ongoing, after initial setup

At $50/hour, that's $130/year in labor. Nearly free.

---

Comparison table:

Our recommendation: Start with CSV import. It's the sweet spot for most dropshippers. As you scale, move to automated.

Your COGS Audit Checklist

Before you overhaul your system, do a quick audit. Here are five things to check this week:

1. **Compare Your COGS to Current Supplier Prices**

Pick three random products from your store. Look them up on your supplier's website. Is the price the same as what's in your Shopify product data?

If not, how old is your data? If it's more than a month old, you've got a problem.

2. **Check If Supplier Shipping Is Included**

Look at your COGS for five products. Does that number include:

• Product cost? (Yes)
• Supplier shipping to you? (Probably not)
• Supplier shipping to customer? (Probably not)

If you're not including at least shipping to customer, your COGS is too low by 5–20%.

3. **Verify Currency Conversion Rates**

If sourcing from overseas:

• What's the exchange rate you used when calculating COGS?
• What's the rate today?
• The difference is money lost (or made).

Also: are you accounting for currency conversion fees charged by your payment processor? (Usually 2–3%.)

4. **List Variants and Their Actual Costs**

Pick a product with variants. Assume you sell it in three sizes or colors.

Do you have the same COGS for all variants, or do you break it down by variant?

If it's the same, check supplier prices for each variant. I bet they're different.

5. **Calculate How Old Your COGS Data Really Is**

When was the last time you updated product costs in bulk?

If it's been more than 4 weeks, your data is stale. If it's been more than 8 weeks, it's useless for decision-making.

---

If you're failing two or more of these checks, your margins are wrong. Probably by 5–15 percentage points.

How Shopimize Handles Dropshipping COGS

This is where we come in. Shopimize is built specifically for sellers like you—people trying to understand real profitability in dropshipping.

Here's how we solve this:

CSV Import with SKU Matching

You export costs from your supplier as a CSV. We handle the heavy lifting:

• Automatic SKU matching (even if your SKU naming is messy)
• Variant-level cost tracking (color, size, etc. each get their own cost)
• Bulk cost updates without touching individual products
• Conflict detection (if you have the same SKU from two suppliers, we flag it)

Automatic P&L Recalculation

When costs change, so does your profit. We recalculate:

• Per-product margins
• Channel-level profitability (Shopify, Amazon, TikTok, etc.)
• Customer lifetime value
• Which products are actually worth promoting

You're not flying blind anymore. Every decision is based on current data.

Historical Cost Tracking

We keep a log of every cost change:

• When it changed
• What it was before
• What it is now
• How that impacted your profit

Use this to spot supplier trends, plan for future price hikes, and understand seasonal cost fluctuations.

Alerts for Anomalies

When a supplier suddenly raises prices 20%, you know immediately. Not in a weekly review. Not when you remember to check. Immediately.

This matters because it gives you time to source alternatives or adjust your prices before margin damage spreads.

---

Want to see this in action? Here's a quick 3-minute tour of how it works.

FAQ: Dropshipping COGS Tracking

Why does my Shopify COGS look so different from my supplier's prices?

Shopify COGS is just what you entered as the product cost. It doesn't include supplier shipping, currency conversion fees, or payment processor fees. Those are profit-killers you have to track separately.

Should I include supplier shipping in COGS or as a separate expense?

Supplier shipping (the cost to get the product from the supplier to your customer) is part of COGS. It's a direct cost of goods. If you're tracking it separately, you're fragmenting your margin data.

How often should I update product costs?

Weekly is ideal if you're using CSV import. Daily if you can automate it. Anything longer than monthly means your data is stale and your decisions are risky.

What if my supplier doesn't provide a CSV export?

Then you need to choose: manually export (time-consuming), find a different supplier, or invest in a tool that can scrape supplier websites (riskier, requires more setup).

Can I use a different COGS for each variant?

Yes, and you should. Most profit trackers support variant-level cost data. Shopimize definitely does.

What's a "good" gross margin for dropshipping?

It depends on your niche, but typical ranges are:

• Fashion/apparel: 40–55%
• Electronics: 25–40%
• Home & garden: 45–60%
• Niches with high competition: 25–35%

But these are actual margins with accurate COGS. Your reported margin might be 10 points higher. Keep that in mind when benchmarking.

How do I account for returns and refunds in COGS?

That's a separate conversation, but short answer: returns reduce revenue but don't reverse COGS. They lower your gross margin. Track them in a separate column so you can spot if one product has abnormally high returns.

What if a product's cost changes mid-month?

Update it immediately. That costs the product the new COGS going forward. Don't recalculate historical orders (that gets complicated). Just make sure new orders use the new cost.

Should I manually verify a few costs every week?

Absolutely. Pick 5 random products and check them against supplier prices. This catches system errors and gives you confidence in your data.

---

The Bottom Line

Your dropshipping margins are probably wrong. Not by a little—by a lot.

The gap between reported margin and actual margin is where dropshipping profits disappear. It's not a one-time audit and done situation. It's an ongoing process because your costs are constantly changing.

You have three options:

1. Keep doing it manually and lose thousands in labor and miscalculations
2. Switch to weekly CSV imports and reduce labor while improving accuracy
3. Automate completely and never think about it again

Your choice depends on how many products you have and how much you value your time.

But whatever you choose, do something. Because right now, if you're like most dropshippers, you're reporting 45% margin when your actual margin is 31%.

That gap is real money. And it's going away.

---

Want to track your dropshipping COGS accurately — with automatic updates when costs change? Try Shopimize free and see your real margins per product.