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 many times you sell through your stock and how long it sits. Set a target to see how much cash reaching it would free up.
Example values are shown. Use cost values throughout, in one currency.
Inventory turnover = cost of goods sold ÷ average inventory
Days of inventory on hand = days in the period ÷ inventory turnover
Average inventory is usually the start value plus the end value, divided by two. Turnover tells you how many times you sold through your stock. Days on hand tells you how long stock sits before it sells.
A store's cost of goods sold for the year is 180,000. Its stock was worth 40,000 at cost on the first day and 50,000 on the last.
If that store reached 6 turns a year on the same sales, it would need only 30,000 of stock on average, which frees 15,000 in cash.
There is no single good number, because it depends on what you sell. Fresh food turns over far faster than furniture or jewellery. A more useful comparison is your own number over time, along with trusted benchmarks for your own trade.
High isn't automatically good either. Very high turnover can mean you run out of stock often and lose sales, so read it alongside your stockout rate. Low turnover ties up cash and raises the risk of markdowns, so look at it product by product: a store-wide average can hide a few fast sellers carrying a lot of dead stock.
Inventory turnover = cost of goods sold ÷ average inventory. Average inventory is usually the opening value plus the closing value, divided by two, both at cost.
Divide the number of days in the period by the turnover. A turnover of 4 over a 365-day year means about 91 days on hand.
Use cost of goods sold. Inventory is valued at cost, so using sales mixes in your margin and overstates turnover.
It depends on what you sell, so no single number applies to everyone. Compare your own trend over time and look at it by product, since a store-wide average can hide dead stock.
Enter that period's cost of goods sold and its number of days. The calculator shows the turnover for the period and the yearly pace, so you can compare periods of different lengths. Seasonal stores should treat the yearly pace with care.
Turnover is only as good as the inventory value behind it. Stocktake lets you count WooCommerce stock with a phone scanner, review the differences in units and money, then apply them with a backup and one-click undo.
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 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 →See how much gross margin each unit of money in stock earns, and the cash a target would free.
Open tool →