How to Track SKU Costs Across Multiple Marketplaces Without Losing Your Mind
10 min read
Last month, SKU B07X on Amazon turned from a $12.50 profit into a $0.87 loss. The culprit? A $3.20 referral fee hike I missed for three weeks. That’s $1,400 gone before I even noticed. If you’re selling on more than one marketplace, you’re already bleeding money on hidden fees, refunds, and currency swings. Here’s how to track every SKU cost in real time—before it costs you more than your product does.
Why Your Spreadsheet is Lying to You (And What to Use Instead)
Most sellers start with a Google Sheet. It’s free, familiar, and wrong within a week. You forget to add the 15% Temu platform fee, the $0.45 eBay final value fee, or the 2.9% Shopify payment processing cut. By month two, your "$8 profit" column is actually a $1.20 loss.
I learned this the hard way with SKU A1B2C3. We listed it on Amazon ($29.99), Shopify ($32.99), and Walmart ($27.99). The spreadsheet said 38% margin. Reality? 18% after Amazon’s 15% referral fee, Shopify’s 2.9% + $0.30, Walmart’s 6% + $0.45, and a 3% currency conversion loss when Temu paid in Thai baht.
The fix isn’t more columns. It’s automation. Tools like Gomarginify pull live fees, refunds, and ad spend from 10 marketplaces into one dashboard. No manual entry. No forgotten fees. Just the real net profit per SKU, updated daily. If you’re still using a spreadsheet, you’re flying blind—and your bank account is the crash site.
The 4 Costs You’re Probably Missing (And How to Catch Them)
Most sellers track product cost and marketplace fees. That’s table stakes. The money leaks are in the details.
First, refunds. Last quarter, SKU C4D5E6 had a 7% refund rate on TikTok Shop. Each refund cost us $4.20 in platform fees + $1.80 in shipping. Spreadsheets don’t auto-deduct these, so we booked $2,100 as profit—until the chargebacks hit. Now we flag refunds in real time and adjust margins immediately.
Second, ad spend. We spent $1,200 on Amazon PPC for SKU F7G8H9 last month. The spreadsheet only showed the $12.50 product cost and $4.50 Amazon fee. The PPC spend? Buried in a separate tab. By the time we realized, our "$8 profit" was a $3.20 loss.
Third, shipping. Temu’s free shipping isn’t free. It’s baked into the product cost, but if you’re comparing to Amazon FBA ($3.99 shipping), your margin math is off. We switched to a 3PL in March to cut shipping costs by 22%, but the savings didn’t show up in our spreadsheets for two months.
Fourth, currency. Selling on Shopee in Malaysia? Your Malaysian ringgit revenue converts to USD at a 2.7% worse rate than the market rate. We lost $800 last quarter just on currency swings. Multi-currency tools like Gomarginify auto-convert to your base currency at the real-time rate—no surprises.
How to Set Up Real-Time SKU Cost Tracking in 60 Minutes
You don’t need a data team. You need a process. Here’s how we set up tracking for 47 SKUs across Amazon, Shopify, TikTok Shop, Temu, eBay, Etsy, Walmart, AliExpress, Shopee, and Lazada in one afternoon.
First, pick your tool. If you’re on a budget, start with Gomarginify’s 7-day free trial. It connects to all 10 marketplaces, pulls live fees, and emails you daily profit reports. No credit card required. If you’re scaling, set up a Zapier workflow to push marketplace data into Google Sheets. We did both—free trial first, then Zapier for SKUs with high volume.
Next, map your costs. For each SKU, list: product cost, marketplace fees, shipping, ad spend, refunds, and currency conversion. On Amazon, the referral fee is 15% for most categories, but 8% for electronics. On Temu, it’s 11% + $0.30 per order. On Shopify, it’s 2.9% + $0.30 + payment processor fees. Miss one, and your margin is fiction.
Then, automate the data pull. Gomarginify does this automatically. If you’re using Zapier, set up triggers for new orders, refunds, and ad spend. We use a Slack bot to ping us when a SKU’s margin drops below 15%. No more spreadsheet sleuthing.
Finally, set alerts. We flag SKUs with refund rates above 5%, ad spend exceeding 10% of revenue, or currency losses over 2%. These are the silent margin killers. The alerts give us 48 hours to adjust pricing, pause ads, or switch fulfillment before the bleed starts.
The One Metric That Exposes Your Real Margins (And How to Use It)
Most sellers track gross margin. Smart sellers track net profit per SKU. The difference? Gross margin ignores fees, refunds, ad spend, shipping, and currency. Net profit per SKU is revenue minus every single cost—then converted to your base currency.
Here’s the brutal math. SKU J0K1L2 sold 120 units on Amazon last month at $24.99. Product cost: $8.50. Amazon fee: 15% ($3.75). Shipping: $3.99 (FBA). Ad spend: $1.20 per unit. Refunds: 6 units ($14.99 revenue lost, $2.40 fee refunded). Currency: no conversion (US sales).
Gross margin: ($24.99 - $8.50) / $24.99 = 65.9%.
Net profit per SKU: ($24.99 * 120) - ($8.50 * 120) - ($3.75 * 120) - ($3.99 * 120) - ($1.20 * 120) - ($14.99 * 6) + ($2.40 * 6) = $1,248. Net profit per unit: $10.40. Net margin: 41.6%.
Wait, 41.6%? That’s not 65.9%. The difference is the hidden costs. If we’d only tracked gross margin, we’d have kept selling SKU J0K1L2. Instead, we paused ads, switched to cheaper shipping, and raised the price by $2. Net margin jumped to 48%.
Track net profit per SKU. Not gross. Not revenue. Net. If your tool doesn’t give you this, switch. Now.
Step by step
- 1
Step 1: List Every Fee for Every Marketplace
Grab the fee schedule for each marketplace. Amazon’s is here: https://sellercentral.amazon.com/gp/help/help.html?itemID=200386250. Temu’s is in your seller dashboard under "Fee Structure." Shopify’s is 2.9% + $0.30 + payment processor fees (Stripe: 2.9% + $0.30, PayPal: 3.49% + $0.49). eBay’s final value fee is 13.25% for most categories. Walmart’s is 6% + $0.45. AliExpress and Shopee vary by category. Write these down. If you miss one, your margin math is wrong. We keep a Google Doc with all fee schedules. Update it quarterly.
- 2
Step 2: Pull Live Order Data (No Manual Entry)
If you’re using a spreadsheet, stop. Pull live order data from each marketplace. For Amazon, use the Reports tab in Seller Central. For Shopify, export orders via Settings > Apps > Export. For TikTok Shop, go to Analytics > Orders. For Temu, check Seller Center > Orders. For eBay, use Seller Hub > Orders. For Walmart, go to Seller Center > Orders.
We use Gomarginify to pull this automatically. It connects to all 10 marketplaces and updates daily. No manual exports. No forgotten rows. If you’re on a budget, use Zapier to push order data from each marketplace to Google Sheets. Set up a workflow for new orders, refunds, and ad spend. We did this for 3 weeks before upgrading to Gomarginify. The Zapier setup took 2 hours. The time saved? 10 hours a month.
- 3
Step 3: Add Hidden Costs (Refunds, Ads, Shipping, Currency)
For each order, add refunds, ad spend, shipping, and currency conversion. Refunds: deduct the revenue lost and the platform fee refunded. Ad spend: pull from Amazon PPC reports, TikTok Ads, or your ad platform. Shipping: use the actual cost per unit (FBA, 3PL, or carrier). Currency: convert revenue to your base currency at the real-time rate.
We lost $800 last quarter on Shopee sales because we didn’t account for currency. The Malaysian ringgit revenue converted to USD at a 2.7% worse rate than the market rate. Gomarginify fixed this by auto-converting to USD at the real-time rate. No more surprises.
- 4
Step 4: Calculate Net Profit Per SKU (Not Gross Margin)
For each SKU, calculate: (Revenue * Units Sold) - (Product Cost * Units Sold) - (Marketplace Fees * Units Sold) - (Shipping * Units Sold) - (Ad Spend * Units Sold) - (Refund Revenue Lost) + (Refund Fee Refunded) - (Currency Conversion Loss).
Divide the result by Units Sold to get net profit per unit. Divide by Revenue to get net margin.
SKU M5N6O7: Revenue $19.99, Units 85, Product Cost $6.20, Amazon Fee 15% ($3.00), Shipping $3.99, Ad Spend $0.95, Refunds 4 units ($79.96 revenue lost, $12.00 fee refunded).
Net profit: ($19.99 * 85) - ($6.20 * 85) - ($3.00 * 85) - ($3.99 * 85) - ($0.95 * 85) - $79.96 + $12.00 = $425. Net profit per unit: $5.00. Net margin: 25%.
If your tool doesn’t give you this number, switch. Now.
- 5
Step 5: Set Up Alerts for Margin Drops and Refund Spikes
We flag SKUs with net margins below 15%, refund rates above 5%, or ad spend exceeding 10% of revenue. These are the silent margin killers.
Gomarginify emails us daily profit reports. If a SKU’s margin drops below 15%, we get a Slack ping. If refunds spike above 5%, we pause ads and check product quality. If ad spend exceeds 10% of revenue, we reallocate budget to higher-margin SKUs.
The alerts give us 48 hours to adjust before the bleed starts. Without them, we’d still be selling SKU P8Q9R0 at a 12% loss. Now it’s at 22% margin after we raised the price and switched to a cheaper 3PL.
- 6
Step 6: Review and Adjust Weekly (Not Monthly)
We review SKU margins every Monday. Not monthly. Not quarterly. Weekly.
On Monday, we pull the Gomarginify report. We check net margins, refund rates, and ad spend. If a SKU’s margin drops below 15%, we investigate: Is the product cost up? Did a fee change? Did refunds spike?
Last week, SKU S1T2U3’s margin dropped from 18% to 12%. Turns out, Amazon increased the referral fee for our category from 15% to 17%. We raised the price by $2 and switched to FBM for cheaper shipping. Margin back to 17%.
Weekly reviews catch issues before they compound. Monthly reviews? You’re already bleeding.
FAQ
Do I really need a tool like Gomarginify, or can I do this in Google Sheets?
You can do it in Google Sheets, but you’ll hate your life. Manual data pulls from 10 marketplaces? Forget it. Refunds, ad spend, currency conversion—all buried in separate tabs. We tried it for 3 months. Spent 10 hours a week updating spreadsheets. Then we switched to Gomarginify. Time saved: 8 hours a week. Money saved: $1,200 a month in missed margin adjustments. If you’re selling on 3+ marketplaces, use a tool. If you’re on 1-2, Google Sheets might work—but set a calendar reminder to update it weekly.
How do I handle currency conversion for marketplaces like Temu or Shopee?
Most sellers ignore it until they see the chargeback. Temu pays in Thai baht, Shopee in Malaysian ringgit. Convert to USD at the real-time rate, not the market rate. We lost $800 last quarter because we used the market rate. Gomarginify auto-converts at the real-time rate. If you’re doing it manually, use XE.com’s API or a multi-currency tool. Or just accept that your margin math is fiction.
What’s the fastest way to find hidden fees in my spreadsheets?
Run a profit and loss report for each marketplace. For Amazon, go to Reports > Payments > Transaction View. Filter for fees. For Shopify, go to Analytics > Reports > Finances. For TikTok Shop, check Seller Center > Reports > Transaction History. Look for "Referral Fee," "Payment Processing Fee," "Shipping Fee," "Refund Fee," and "Currency Conversion Loss." If you don’t see these, your spreadsheet is missing costs. We found $1,400 in hidden fees this way last month.
Track your real profit across every marketplace
Stop guessing your margins. Learn how to track SKU costs across Amazon, Shopify, TikTok Shop, Temu, eBay, and 5 more marketplaces with real numbers and tools that actually work.
Start 7-day free trial