ChatGPT JSON to Markdown
Convert a local ChatGPT export into readable Markdown. Preview a conversation or download a ZIP of notes for Obsidian.
Open tool →See how much gross margin your stock earns for every unit of money tied up in it, and how much cash you could free up by reaching a target.
Example values are shown. Use one currency and leave out sales tax. Nothing leaves your browser.
GMROI = gross margin ÷ average inventory at cost
GMROI stands for gross margin return on investment. Gross margin is net sales minus the cost of the goods sold. Average inventory is usually the opening value plus the closing value, divided by two. The result tells you how much gross margin each unit of money tied up in stock earned.
Over a year you sold 120,000 of goods that cost you 72,000. Your stock was worth 26,000 at the start and 22,000 at the end, both at cost.
Every 1.00 held in stock earned 2.00 of gross margin over the year. To reach 3.00 on the same margin, you'd need 16,000 of average inventory, which frees up 8,000 in cash.
A GMROI above 1 means your stock earned more gross margin than it cost to hold at that value. It doesn't mean you made a profit, because rent, staff, shipping and marketing all come out of gross margin. So there's no universal good number. A store with high overheads needs a higher figure than one with low overheads.
The figure is most useful for comparing your own categories and products, or the same category from one year to the next. Use the yearly pace to compare periods of different lengths, and be careful with seasonal products: a single peak quarter will overstate the year.
GMROI is gross margin % × sales ÷ average inventory, so you can improve it from either side:
A high margin with a low GMROI usually means too much stock. A low margin with a high GMROI can still work if the stock moves quickly. ABC analysis helps you see which products are carrying the rest.
GMROI is only as good as the two cost figures in it. In WooCommerce, the difficulty is usually knowing what your stock cost and what it's worth today. Our guide to WooCommerce inventory valuation covers how to get those figures, and what to check before you rely on them.
GMROI = gross margin ÷ average inventory at cost. Gross margin is net sales minus cost of goods sold. Average inventory is usually the opening value plus the closing value, divided by two.
A figure above 1 means your stock earned more gross margin than its value at cost, but other costs still come out of that. There's no universal target, because it depends on your overheads and category. Compare your own categories and years.
No. It uses gross margin, which comes before rent, staff, shipping and marketing. A store can have a healthy GMROI and still lose money.
Earn more on each sale by reviewing prices, supplier costs and discounts, or hold less stock for the same sales by ordering smaller amounts more often and clearing what doesn't sell.
Yes. Enter that period's figures and its number of days. The calculator shows the GMROI for the period and the yearly pace, so you can compare periods of different lengths. Be careful with seasonal products.
Keep suppliers, purchase orders and goods received next to your WooCommerce stock. Record what arrived, what it cost and what is still on order.
Explore Free and Pro →Read the step-by-step guideConvert a local ChatGPT export into readable Markdown. Preview a conversation or download a ZIP of notes for Obsidian.
Open tool →Open a WooCommerce stock CSV, count products in a browser worksheet, or download a printable inventory count sheet PDF. Review differences and export your count record.
Open tool →Turn daily demand, supplier lead time and safety stock into a reorder point and stock-position check.
Open tool →Generate up to 500 variations and a draft product CSV, or review an existing variation CSV for parent links, SKUs, prices and local attributes.
Open tool →Work out buffer stock from demand and lead-time variation at the service level you choose, with a reorder point.
Open tool →Find the cheapest order size, rounded to your pack size and supplier minimum, and compare it with what you order now.
Open tool →See how often you sell through your stock, how long it sits, and the cash a higher turnover would free.
Open tool →See how much of your stock has sold, how long the rest will last and when you'll reach your target.
Open tool →Download a template for any product type, and catch rows that will fail or silently import the wrong data.
Open tool →Check a whole list of GTIN, UPC or EAN codes, add check digits, and find lost zeros, spreadsheet damage and duplicates.
Open tool →Turn product names and attributes into readable, unique SKUs, with a list or a WooCommerce import file to download.
Open tool →Sort products into A, B and C classes by value, straight from a WooCommerce export or a pasted list.
Open tool →Work out your shrinkage rate on stock, cost of goods sold and sales, and see which lines lost the most.
Open tool →