Track Profit Per Product SKU: Printify + Shopify

Table of Contents

1. Why Revenue Lies — And Profit Per SKU Tells the Truth
2. The Four Numbers You Need For Every SKU
3. Method 1: Printify's Product Performance Dashboard
4. Method 2: Shopify's Built-In Profit Reports
5. Why Both Native Tools Fall Short
6. Method 3: Manual Spreadsheet Reconciliation
7. Method 4: Let Victor Do It Automatically
8. How to Read Your SKU Profit Numbers and Act on Them
9. FAQs

Why Revenue Lies — And Profit Per SKU Tells the Truth

Shopify shows you revenue — but revenue is not profit. A product can be your top seller by order count and still drain your bank account if the margin is thin and your ads are expensive.

Profit per SKU is the number that actually tells you whether a product deserves more budget, a price increase, or a quiet retirement. Without it, you're scaling guesses instead of results.

The challenge is that this data lives in at least four places: Printify (base cost and shipping), Shopify (transaction fees and refunds), Meta/Google (ad spend), and your bank account. Pulling it together is where most sellers stall.

The Four Numbers You Need For Every SKU

For every SKU, the profit formula is the same:

Profit per unit = Selling price − Production cost − Shipping cost − Fees − Ad spend per order

Breaking it down:

• Selling price — what the customer paid, after discounts.
• Production + shipping cost — the prices displayed in the Printify Catalog represent production prices, which, along with shipping costs, make up the total cost for a product. This changes by print provider and destination country.
• Shopify and payment-processor fees — Shopify's transaction fee (varies by plan) plus Stripe/Shopify Payments processing. These are per-order, not monthly flat costs.
• Ad spend per order — your Meta or Google spend divided by the orders that channel drove. This is the number most sellers skip — and it's often the one that flips a "profitable" SKU into a loser.

Exact costs vary by print provider and change over time, so always check the live price in the Printify Catalog for your specific product and provider before setting your retail price.

Method 1: Printify's Product Performance Dashboard

Printify gives you a starting point inside its own analytics.

In the "Product performance" dashboard, you can calculate the profit per product: export detailed performance data on the sales of a particular product and its variants, then create profit and loss calculations by adding your retail prices and fees per listing.

Here's the step-by-step:

1. Open Printify Insights → Product performance.
2. Choose your preferred values in the filter — set a time range and select a specific product.
3. Performance data by product variant will be displayed in the "Your product sales" table.
4. Select "Download data" to export it, then choose your preferred file format.
5. After opening the spreadsheet, insert additional columns for retail price data, fees per listing, and other fees per product.
6. Calculate the cost per item by dividing the total cost by the number of items sold.
7. To calculate your profit, subtract the fees and costs per item from the retail price.

What this misses: Shopify transaction fees, payment processing, and — critically — ad spend. You'll see gross profit, not net profit.

Method 2: Shopify's Built-In Profit Reports

Shopify has a native profit report, but it requires manual setup first.

To get value from your profit reports, you need to add a cost per item to your products. The cost per item is how much it costs you for the product or variant — for example, the price you paid the manufacturer, excluding taxes, shipping, or other costs.

If your product has variants, you need to edit each variant to add the cost per item.

Once costs are entered, you get two useful reports:

• The Gross profit by product report displays your gross profit by product for the selected date range.
• Gross profit by product variant shows the gross margin and total profit made on each variant during the time period.

The problem: Profit is reported only for products that had cost recorded at the time they were sold. If you didn't pre-fill the cost field, historical orders are blank. And Shopify never sees what you actually paid Printify — you have to type it in yourself, and update it every time Printify changes provider pricing.

Why Both Native Tools Fall Short

Shopify shows revenue and order count, but it never sees what you paid Printify or Printful for production and shipping. The COGS field in Shopify is a manual entry: you have to type in a flat cost per product variant.

That flat cost creates a second problem: Printify's fulfillment cost isn't flat. COGS is dynamic per order — the same SKU can cost $13 to fulfill domestically and $22 internationally, because Printify and Printful charge real shipping at the moment of fulfillment.

Shopify's Profit by Product and Finance Summary use a static Cost per Item value, ignore ad spend, and don't separate refunds-after-fulfillment from refunds-before-fulfillment.

Neither tool sees your Meta or Google ad spend at all. For a paid-traffic POD store, that gap makes the profit number almost meaningless.

For a deeper comparison of dedicated profit-tracking apps, see our guide on BeProfit vs Lifetimely for POD profit tracking.

Method 3: Manual Spreadsheet Reconciliation

A spreadsheet can work if you're disciplined. Here's the structure:

Pull these exports weekly or monthly, paste them into your sheet, and use VLOOKUP or XLOOKUP to join on Order ID or SKU. Profit per SKU is then a pivot table away.

Spreadsheets work initially but break down without a connected data source. The moment you have 50+ SKUs and are running ads on two platforms, the manual pull becomes a Sunday-afternoon chore that either takes hours or quietly stops happening.

If you're exploring other income streams while you scale, our how to earn extra money and how to get paid on TikTok guides cover complementary revenue moves.

Method 4: Let Victor Do It Automatically

PodVector AI's AI employee Victor connects your Shopify store, your Printify account, and your Meta and Google Ads accounts, then calculates true profit per SKU for you — without spreadsheets, exports, or manual cost entry.

Victor works out profit per order the right way: what the customer paid, minus the Printify production cost, the real shipping charge, Shopify fees, and the ad spend that drove the sale. You just ask, and he answers in plain English — "which SKU has the lowest margin this month?" or "what's my net profit on the black crewneck after Meta spend?"

A key advantage: PodVector AI pulls your Printify product costs before you sell anything, so Victor can tell you the margin on a new product with zero orders. You don't have to wait for sales history to know whether a launch is priced right.

Every Monday Victor sends you a Weekly Health Report covering last week's products, traffic, ads, and margins — so you always have a current SKU-level view without opening four dashboards. When you ask Victor to act — say, reprice a product to hit a target margin — he shows you the exact change as a card first, and nothing runs until you approve it.

Victor reads your Printify costs but can't make changes on Printify itself. Where he does execute changes — Shopify prices, Google Ads budgets, Meta Ads targeting, Klaviyo flows — everything is shown to you first.

This fits squarely into a broader print-on-demand strategy that treats profit visibility as the foundation for every growth decision. Browse all our print-on-demand guides to see how the pieces connect.

How to Read Your SKU Profit Numbers and Act on Them

Once you have profit per SKU, you need a decision rule. Here's a simple framework:

Tier 1 — High margin, growing sales: Scale ad spend. If a SKU is profitable after all costs, push more budget to it on Meta or Google.

Tier 2 — Low margin, high volume: Price test first. A $2–$3 price increase on a best-seller often improves margin significantly with minimal volume loss. Victor can reprice products across a whole Shopify category at once and undo the change if needed.

Tier 3 — Negative margin after ad costs: Pause ads immediately. Check whether the product can survive on organic traffic alone, or retire it. Printify recommends keeping at least a 40% profit margin to help your business grow.

Tier 4 — No sales data yet: Use your Printify cost from the catalog and your planned retail price to estimate margin before you run a single ad. If the math doesn't work at break-even ad efficiency, reprice before launch.

For additional ways to grow revenue alongside tighter profit tracking, see our guides on Store Envy, Print Aura, Klaviyo abandoned cart flows, Beacons vs Stan Store, and Gumroad vs Stan Store.

FAQs

Does Shopify automatically track profit per SKU for Printify products?

No. Shopify never sees what you paid Printify for production and shipping. The COGS field in Shopify is a manual entry — you have to type in a flat cost per product variant. You have to fill it in yourself and update it any time Printify's costs change, which means it goes stale quickly.

What costs should I include when calculating profit per SKU?

Include all of these: Printify production cost, Printify shipping cost (which varies by destination), Shopify transaction fee, payment-processing fee, and the ad spend attributed to that SKU's orders. Leaving out any one of them overstates your real margin.

Can I calculate profit per SKU before I get any sales?

Yes. PodVector AI pulls your Printify product costs before you sell anything, so Victor can calculate the projected margin on a new product the moment you connect your account — no sales history required.

Why is my Printify cost different for the same SKU across orders?

COGS is dynamic per order — the same SKU can cost $13 to fulfill domestically and $22 internationally, because Printify and Printful charge real shipping at the moment of fulfillment. A static cost-per-item field in Shopify can't capture this variance.

How often should I review profit per SKU?

At minimum, monthly. If you're running paid ads on Meta or Google, weekly is better — ad costs shift fast enough that a SKU that was profitable last week can be underwater this week. Victor's Weekly Health Report gives you a Monday recap of last week's margins automatically.

What profit margin should I aim for on Printify products?

Printify recommends keeping at least a 40% profit margin to help your business grow. That said, this is your gross margin before ad spend. After ads, many experienced sellers target at least 20–25% net, which means your product pricing needs to support a gross margin well above 40% if you rely on paid traffic.

Can Victor make changes to my Printify account to fix margins?

No — Printify is read-only for Victor. He reads your Printify costs and can suggest moves, but he can't change anything inside Printify. Where he can act — and does, with your approval — is on Shopify pricing, Google Ads budgets, Meta Ads campaigns, and Klaviyo flows.