E-commerce profitability in these cash-strapped times
October 15th, 2008 by Aaron Rubin
Obtaining funding today is hard. If you’re burning cash, even if you have solid long-term profitability expectations, your business model may have to change.
This week it was Mercado being unable to get financing and then selling for $6.5M to omniture, which was probably a small fraction of the money sunk into the biz.
The lowest risk strategy is to reduce costs without reducing long term prospects. It’s also quite difficult. I’d like to discuss over the next few weeks some methods that may work for your small-mid online retail company.
In this post, I will focus on identifying and reducing your money losing orders.
For every order you can calculate the profitability. To do so you take Gross Revenue (item and shipping charges) and subtract out all the costs associated with the order. The list of costs are long and complex and to manually calculate profitability for a single order takes way too long to be practical. Fortunately it should be a fairly straightforward algorithm which any decent programmer with access to the necessary data can implement.
So, have a programmer implement it (I’ve listed some notes on the algorithm below).
Then look for the outliers, such as orders where you lost money or had your lowest profit margins. Once you’ve identified those orders, try to figure out why they underperformed. I’ve found shipping inefficiencies such as orders being packed in oversized boxes that weren’t supposed to be, pricing errors due to input costs being underestimated and opportunities for greatly improved profitability.
A simplified example opportunity is a high volume item that sold for $37.95 and had a $1 net profit, was raised to $39.95. Volume dropped by almost 20% but with the adjusted net profit amount it’s a money maker.
And that’s the point of this exercise - Maximize your bottom line today.
Your input costs will vary but don’t forget these:
- Item cost including after discounts
- Outbound shipping cost
- Inbound shipping costs
- Stocking costs
- Carrying cost - If your average unit of this item sits on your shelf for 6 months, you’re paying storage space and interest on the cost of that item for 6 months.
- Picking and packing cost for that order - both the labor and the material. Boxes aren’t cheap!
- Return costs - It’s important to factor this in at a sku level, don’t just take a round number. I have a lot more judo uniforms returned for size issues than I do boxing gloves.
- Phone costs - If the order is taken by phone that adds significant costs.
- Manual processing costs - if someone screens your orders, what’s the cost to screen this order
- Credit card processing costs
Be specific! Generalizing your costs in this calculations will cost you accuracy and keep you from spotting the outliers that we’re trying to identify.

An E-Commerce CEO