Shopify COGS Calculator: Track Costs & Profit
Most Shopify store owners know their revenue number by heart. Far fewer know their actual cost of goods sold — and that gap is where profits quietly disappear. Without accurate COGS tracking, you’re guessing at margins, mispricing products, and potentially misreporting income on your taxes.
This guide gives you a clear framework for calculating COGS on Shopify, a free template you can start using today, and the automation tools that make ongoing tracking painless.
What Is COGS and Why It Matters for Shopify Stores
Cost of Goods Sold (COGS) is the total direct cost to produce or purchase the products you sell. Think raw materials, manufacturing fees, packaging, and inbound freight — anything directly tied to getting that product ready for sale.
The standard COGS formula is straightforward: Beginning Inventory + Purchases – Ending Inventory = COGS. For example, if you start the month with $5,000 in inventory, buy $12,000 worth of new stock, and end with $4,500 remaining, your COGS is $12,500.
COGS includes product costs, packaging materials, inbound shipping, import duties, and manufacturing labor. It excludes outbound shipping to customers, marketing spend, Shopify subscription fees, and employee salaries — those fall under operating expenses.
When you ignore COGS, your profit numbers lie to you. You might think you’re running a 50% margin store when the real number is 22% after accounting for landed costs. The IRS also requires accurate COGS reporting on IRS Schedule C (sole proprietors) or corporate tax returns, so getting this wrong creates tax liability risk. (Source: IRS Publication 334, 2025)
How to Calculate COGS on Shopify (Step-by-Step)
Step 1: Enter cost per item in Shopify Admin. Go to Products, select a product, and open each variant. You’ll see a “Cost per item” field — enter your true purchase cost here. This is the foundation for every COGS calculation Shopify can run.
Step 2: Choose an inventory valuation method. The two most common are FIFO (First In, First Out) and the Average Cost Method. FIFO assumes your oldest inventory sells first, which is standard for perishable goods and IRS-preferred. Average Cost takes your total inventory value and divides by total units, smoothing out price fluctuations across purchase orders.
Step 3: Pull COGS data from Shopify Analytics. Navigate to Shopify Admin > Analytics > Reports > Finances summary. If you’ve filled in cost fields, you’ll see a COGS line item. Note: the full Finances summary report with built-in COGS is available on Shopify Advanced and Plus plans. Basic and standard Shopify plans require you to export product data and calculate manually. (Source: Shopify Help Center, 2026)
Step 4: Apply the COGS formula for your chosen time period. Grab your beginning inventory value, add all purchases during the period, and subtract ending inventory. For a monthly calculation, this gives you an exact dollar figure of product costs tied to actual sales.
Step 5: Cross-check against supplier invoices. Pull your purchase orders and supplier bills for the same period. If your calculated COGS doesn’t align with what you actually paid suppliers (plus freight and duties), you’ve likely got a data entry error or a missing cost update in Shopify Admin.
Real-world example: A home goods brand on Shopify discovered a $3,800/month discrepancy between their Shopify COGS and supplier invoices. The culprit? They had entered sample pricing (lower negotiated rates) into Shopify instead of actual landed costs that included freight forwarding from China.
Shopify COGS Calculator: Free Template & Tool Options
You don’t need expensive software to track COGS accurately. A Google Sheets template with the right columns handles this well for most stores.
Your free COGS calculator template should include these fields: SKU, product name, unit cost (landed), units sold in the period, total COGS (unit cost × units sold), revenue per SKU, gross profit per SKU, and gross margin percentage. Duplicate this sheet monthly and compare trends over time.
For Shopify-native options, the Finances reports on Advanced ($399/month) and Plus (starting at $2,300/month) plans show COGS data directly in your dashboard. (Source: Shopify Pricing, 2026)
Third-party apps fill the gap if you’re on a lower-tier plan:
| Approach | Best For | Cost |
|---|---|---|
| Google Sheets template | Stores with under 200 SKUs | Free |
| Shopify Finance reports | Advanced/Plus plan users | Included in plan |
| BeProfit | Multi-channel profit tracking | From $25/month |
| Triple Whale | DTC brands with heavy ad spend | From $100/month |
| A2X for Shopify | Accounting-focused COGS sync to QuickBooks or Xero | From $29/month |
Manual spreadsheets work fine for smaller catalogs. Once you pass roughly 200 SKUs or sell across multiple channels, the time cost of manual updates usually justifies a paid tool.
COGS vs. Gross Profit vs. Net Profit: Know the Difference
These three numbers tell completely different stories about your business health.
Gross Profit = Revenue – COGS. This tells you how much money remains after paying for the products themselves. The gross margin percentage formula is: (Gross Profit ÷ Revenue) × 100. A healthy ecommerce Gross Profit Margin for physical goods falls between 40–60%. (Source: NYU Stern Margins Database, 2025)
Net Profit = Gross Profit – Operating Expenses. Operating expenses include ad spend, Shopify subscription fees, app costs, salaries, rent, and outbound shipping. This is the money that actually stays in your pocket.
Here’s why this matters with real numbers. Say your Shopify store does $50,000/month in revenue. Your COGS is $30,000, giving you $20,000 gross profit (40% margin). But after $8,000 in Facebook and Google ads, $3,000 in shipping costs, $2,000 in app subscriptions and Shopify fees, and $2,000 in other overhead, your net profit is $5,000 — a 10% net margin. High revenue stores lose money every day because owners only watch the top line.
Case study: A skincare brand selling on Shopify believed their margin was 42% based on simple product cost vs. selling price. After correctly accounting for landed cost (including packaging inserts, customs duties, and freight from their Korean manufacturer), their actual gross margin was 18%. They raised prices by 15% and renegotiated supplier terms, bringing their real margin to 34%.
Common COGS Mistakes Shopify Sellers Make
Stale cost fields. Supplier prices shift with raw material costs, tariffs, and currency fluctuations. If you entered product costs 18 months ago and haven’t updated them, your profit reports are fiction.
Counting outbound shipping as COGS. What you pay to ship orders to customers is an operating expense. Inbound shipping — the cost to get products from your supplier to your warehouse — belongs in COGS as part of your landed cost.
Ignoring bundle math. If you sell a bundle of three products for $45, you need to split the COGS across individual SKUs. Many sellers enter the bundle retail price or a rough estimate, throwing off per-product margin analysis.
Skipping landed cost components. Your product cost isn’t just what you pay the manufacturer. Add import duties, freight forwarding fees, inspection costs, and customs brokerage fees. For US importers, tariff rates changed significantly in 2025–2026, making this even more critical to track. (Source: US Customs and Border Protection, 2026)
Forgetting shrinkage and returns. Damaged inventory, customer returns you can’t resell, and warehouse shrinkage all affect your true COGS. If 3% of your inventory is lost to damage and returns, that’s real cost you should capture.
How to Use COGS Data to Set Smarter Shopify Prices
Once you have accurate COGS, pricing stops being guesswork.
Cost-plus pricing is the simplest method: multiply your COGS by a markup factor. If your landed cost is $12 and you want a 60% gross margin, use a 2.5× multiplier — your price is $30. The formula to reverse-engineer a target margin is: Price = COGS ÷ (1 – desired margin). So $12 ÷ (1 – 0.60) = $30.
Competitor-based pricing has its place. But without knowing your COGS, you can’t tell if matching a competitor’s $25 price makes you money or bleeds cash. Always calculate your floor price — the minimum that covers COGS plus per-order operating costs — before adjusting for market positioning.
Watch the full-funnel math. If your Facebook CPA is $15 and your COGS is $20 on a $40 product, you’re left with $5 per order before Shopify fees, shipping, and returns. That math collapses fast. Review COGS monthly and adjust prices proactively — before margin erosion stacks up over a full quarter.
Shopify’s bulk price editor lets you apply percentage or fixed-dollar price increases across entire collections, so scaling price adjustments after COGS shifts takes minutes, not hours.
Automating COGS Tracking in Shopify for 2026
Manual COGS tracking works early on. But automation saves you from costly errors as you grow.
Shopify’s native product cost field captures per-variant costs, and inventory reports reflect those values. But Shopify doesn’t automatically adjust costs when you receive new purchase orders at different prices — you need to update the cost field or use an inventory app that handles this.
Inventory management integrations bridge this gap. Stocky (included free for Shopify POS Pro users) handles purchase orders and cost tracking. Cin7 and Linnworks offer multi-warehouse, multi-channel inventory management with automatic cost updates as new stock arrives. (Source: Shopify App Store, 2026)
Accounting sync is where the real time savings appear. Connecting QuickBooks Online to Shopify through apps like A2X automatically maps COGS to the correct accounts in your chart of accounts. Your bookkeeper or CPA sees accurate COGS data without manual journal entries.
In 2026, AI-powered categorization tools from platforms like Triple Whale and Finaloop can auto-classify expenses as COGS vs. operating costs based on vendor history and transaction patterns. (Source: Triple Whale, 2026) These tools reduce the risk of miscategorization, especially for stores with complex supply chains.
Set up automated monthly report emails from Shopify Analytics to get COGS summaries delivered to your inbox on the first of every month. But don’t rely on Shopify reports alone for tax filing — always reconcile against your accounting software before handing numbers to your CPA.
COGS for Dropshipping vs. Print-on-Demand vs. Wholesale on Shopify
Your business model changes how COGS works in practice.
Dropshipping: Your COGS equals the supplier price per order. Since you hold no inventory, there’s no beginning or ending inventory to track — every sale has a clear, known cost. This makes COGS tracking simpler, but margins are typically thin at 20–30%. (Source: Shopify Commerce Trends, 2025)
Print-on-demand (Printful, Printify): Your COGS includes the base product cost plus the fulfillment fee charged per item. A t-shirt through Printful might cost $9.50 for the blank plus printing, and $3.50 for fulfillment — so your COGS per unit is $13.00. Margins generally run 30–45% depending on niche and pricing.
Wholesale and private label: This is where COGS gets complex. Your landed cost includes manufacturing, ocean or air freight, customs duties, inspection fees, and domestic shipping to your warehouse. Private-label brands that manage this well can achieve 50–70% gross margins, but only if every cost component is captured accurately.
Example: A Shopify seller sourcing private-label yoga mats from Vietnam calculated their manufacturing cost at $8 per unit. But after adding $2.50 in ocean freight, $1.20 in customs duties, and $0.80 in inspection and packaging, their true landed cost was $12.50 — a 56% increase over the raw manufacturing price.
Regardless of your model, you still need COGS tracked for profit reporting and tax compliance. The IRS doesn’t care whether you hold inventory or not — if you sell physical products, COGS must appear on your return.
Frequently Asked Questions
Does Shopify automatically calculate COGS?
Shopify tracks COGS if you enter a cost per item for each product variant. On Advanced and Plus plans, the Finances summary report shows COGS. On Basic and standard Shopify plans, you’ll need to export data or use a third-party app to get a full COGS report.
What is a good COGS percentage for a Shopify store?
For physical product ecommerce, a COGS ratio of 40–60% of revenue is typical, meaning a gross margin of 40–60%. Dropshipping stores often see COGS at 70–80% of revenue. Private-label brands can achieve COGS as low as 25–35%.
How do I find the cost of goods sold in Shopify Analytics?
Go to Shopify Admin > Analytics > Reports > Finances summary. You’ll see a COGS line if cost fields are filled in for your products. You can also export the Products report and multiply unit cost by units sold for each SKU.
Is shipping to customers included in COGS?
No. Outbound shipping (what you charge or pay to deliver to customers) is an operating expense, not COGS. Inbound shipping — the cost to get goods from your supplier to your warehouse — is included in COGS as part of landed cost.
Can I use a spreadsheet instead of a Shopify COGS app?
Yes. A Google Sheets or Excel template works well for stores with fewer than 200 SKUs. You need columns for unit cost, units sold per period, and total COGS. For larger catalogs or multi-channel selling, an app like BeProfit or A2X saves significant time.
How often should I update my COGS in Shopify?
Update cost fields in Shopify whenever your supplier prices change, after every new purchase order, and at minimum once per quarter. Stale cost data leads to inaccurate profit reports and poor pricing decisions.