How I found out my best-selling product was making 14% margin

The problem

For three years I ran my store on a simple rule: if it sells, stock more of it. The revenue report agreed with me. One phone case was always at the top. It was the first product I ever listed, it had hundreds of reviews and it brought in more revenue than anything else.

What I did not know was that it was also the product I could least afford to sell.

The old way

I had a spreadsheet with cost prices in one tab and sales in another. Every time I updated it, something broke. The formulas did not cover variants, and I matched product names by hand.

It was a three-hour job I avoided, which is how the problem survived for three years.

The questions I typed

First I uploaded a CSV with SKU, product cost and packaging cost. Then I asked:

“What is my gross margin by product for the last quarter? Show revenue, cost of goods, gross profit and margin percentage. Sort by revenue.”

Then:

“Which products have revenue over $2,000 but a margin below 25%?”

What came back

The top product by revenue was a phone case with $18,400 in quarterly revenue and a 14% gross margin. It was also the product I spent the most on ads to promote.

A mid-priced desk organiser had less than half the revenue but a 46% margin — and I had never featured it.

The phone case was not a loss leader. It was a popular product with a cost problem I had never measured.

The follow-ups

I asked:

“What is my blended margin by category?”

Phone cases were 38% of revenue but only 19% of gross profit. Desk gear was 21% of revenue and 34% of gross profit. That changed how I thought about the catalogue.

“If I raised the phone case price by $4, what would the margin be?”

At the same unit volume, the margin moved from 14% to 26%. I did not need to sell more. I needed to stop losing money on every sale.

What I did

1. 1. Raised the phone case price by $4. Sales volume dipped 6% in the first month, but gross profit rose.
2. 2. Stopped free shipping on the phone case and made it a threshold incentive instead.
3. 3. Bundled the phone case with the high-margin cable kit, so the order stayed attractive.
4. 4. Featured the desk organiser on the homepage and in post-purchase emails.
5. 5. Re-uploaded costs quarterly instead of once a year.
6. 6. Added a margin check to the monthly dashboard.

The result

Gross profit was up $4,100 in the following quarter with no increase in ad spend. The desk gear share of gross profit moved from 34% to 41%.

What I’d do differently

I’d upload costs before I ever ran a sale. My first instinct was to discount the phone case to “make up” for lost volume, which would have made the margin worse.

The other mistake was treating gross margin as net profit. It is not. Shipping, payment fees and ad spend still come out of that number. But gross margin is the first honest checkpoint, and I had been skipping it.