Ecommerce profit calculator built into every order
Ecommerce profit calculator for every order: markup vs margin analysis, break even analysis and real contribution margin per product.
In short
The ecommerce profit calculator in StoreChart starts from the order total before VAT and subtracts product cost, the shipping you pay and the card processing fee at the rate you set for the store. Product cost uses weighted average, FIFO or a fixed price, and for imported goods it includes freight and customs. WooCommerce and Shopify platform fees aren't included.
Profit and margin on every order
Product cost, shipping and card fees come off every order automatically
- Every order shows profit and margin after product cost, shipping and card fees
- For imported goods, freight, customs and insurance join the product cost when the goods are received
- Shipping cost as a flat rate or tiers per store, with manual edits when needed
- In BI dashboards: profit trend, revenue vs. profit and a cost breakdown
Everything the profitability module covers
From one product's cost to your profit trend over time
Profit calculation in three steps
Three settings, then profit on every order
Enter product costs or log goods receipts, then set shipping cost and the card fee percentage for each store.
From then on every order is calculated for you, including import costs for goods that came in an import shipment.
Check the profit card on each order, and the profit trend and cost breakdown in BI dashboards.
Profit calculation for every order
The order total is the first number you see, and the most misleading one. Part of it goes to VAT, the supplier, the courier and the card processor. Calculating profitability per order breaks that total down, so decisions on pricing, shipping and coupons rest on what's really left.
What goes into the profit calculation
The calculation starts from the price before VAT and subtracts:
- Product cost: according to each product's costing method.
- Shipping cost: what you pay, according to the store's settings.
- Card fee: at the percentage you set for each store, along with the VAT on the fee.
What stays out of a single order: WooCommerce and Shopify fees, ad spend, rent and subscriptions. You see those fixed expenses in the income statement.
Example: a ₪354 order
Illustrative only, with a product cost of ₪70 per unit, shipping that costs you ₪32 and a 1.5% card fee:
- Before VAT: a two-item order of ₪354 including VAT is ₪300 before VAT.
- Product cost: ₪140.
- Shipping: ₪32.
- Card fee: about ₪6.
- Profit: about ₪122, roughly 41%.
Example: a coupon and a small order
With the same shipping and card fee:
- 15% coupon: the same order drops to about ₪255 before VAT, and about ₪78 is left, roughly 31%.
- Coupon effect: it takes away more than a third of the order's profit.
- One cheap item: ₪59 including VAT is ₪50 before VAT, minus ₪28 cost and ₪32 shipping. The result is negative, and the order shows in red.
Cases like these are why stores find out late that a minimum order or a small shipping charge would have changed the picture.
Free shipping, coupons and pricing
- Free-shipping threshold: if small orders lose money, raise the threshold or add a shipping charge below a set amount.
- Coupons: test a coupon on a real order before you send it out.
- Repricing: a product with a consistently low margin is a candidate for a price rise, another supplier or leaving the catalogue.
This is how you find those cases:
- Filter the profits screen to a month or two.
- Look at the categories with the lowest margin.
- Open a few of their orders in the orders table. Twenty red orders from one category are a pattern.
- After a change, come back in two weeks and check whether the margin moved.
The profits screen and income statement
- Order profit card: helps with pricing decisions.
- Profits screen: how things are going now, for any date range: gross profit, revenue before VAT, costs, margin and a split by category.
- Missing cost: the screen shows how many orders in the period lack a product cost, since they look more profitable than they are.
- Saved cost: a cost saved on an order line stays there, so a price change tomorrow doesn't alter yesterday's order.
- Income statement: a closed month, quarter or year, from revenue through gross profit to operating profit after fixed expenses. Filtered to specific stores, it stops at gross profit.
Who it's for and what's not included
- Good fit: stores whose costs vary, especially importers, and stores that run lots of coupons and sales.
- Weaker fit: a single product at a fixed price with no shipping. Simple margin maths will do.
- Bookkeeping: StoreChart doesn't do bookkeeping and doesn't replace your accountant.
- Platform fees: WooCommerce and Shopify fees aren't part of the calculation.
- Alerts: a losing order shows in red, with no separate notification.
Connects to your sales and procurement data
Frequently asked questions about profitability
How do I set a product's cost in the system?
Enter a cost on the product, or log a goods receipt with a unit cost. Depending on the costing method you chose, the system uses weighted average, FIFO or a fixed price.
What's the difference between gross and operating profit?
Gross profit is revenue before VAT minus product cost, shipping and card fees, and it's shown on every order and on the profits screen. Operating profit appears in the income statement, after the fixed expenses from the Expenses module are subtracted. The statement also shows how many of the expected expenses have been collected, so you know whether the figure is final.
Are card fees included in the profit calculation?
Card processing fees are: you set a percentage for each store, and it comes off every order's profit along with VAT on the fee. WooCommerce or Shopify platform fees aren't part of the calculation.
Can I see profitability broken down by store?
Yes. The store selector shows a single store, and in BI dashboards you can filter by store and date range to see the profit trend and revenue vs. profit.
How is this different from a profit spreadsheet?
The calculation runs on every new order by itself, using the costs already set in the system. In a spreadsheet you have to update every order and every cost change by hand.
How do I spot an order that loses money?
Profit is shown on every order, and an order with negative profit appears in red, so an underpriced product or an expensive shipment stands out. No separate notification is sent.
Can I update a product's cost retroactively?
When the cost is saved on the order line, changing the product cost doesn't change it, so the profit on past orders stays as it was. New orders use the updated cost.
Related capabilities
The real profit on every order
Set your basic costs and see the profit on your next order


