Counting stock
When the number on the screen is not the number on the shelf.
- A Month-End Inventory Routine for Shopify A 30-minute month-end inventory routine for a Shopify store: the snapshot and value reports, a cycle count, adjustments to review, and costs to update. 3 min read
- Bulk Updating Inventory in Shopify Without Losing Sales Three ways to update many Shopify stock counts at once (the bulk editor, the inventory CSV and a stock count) and which one keeps an audit trail. 3 min read
- Cycle Counting in Shopify: Count a Little, Often How to run cycle counts with Shopify's stock counts: which products to count how often, how ABC grades help, and a weekly routine for a small team. 3 min read
- How to Audit Your Shopify Inventory A practical Shopify inventory audit: pick a sample, count it, trace each difference through adjustment history, fix the cause, and check the value. 3 min read
- How to Do a Stocktake in Shopify How to plan and run a full stocktake in Shopify: freezing orders, counting by location, reviewing differences, approving, and what to count outside Shopify. 3 min read
- Shopify Inventory Adjustments: Set To, Adjust By, Reasons How to adjust stock in Shopify with Set to or Adjust by, which reason to pick for each change, and how unavailable stock like damaged or safety stock works. 4 min read
- Shopify Unavailable Inventory: Damaged, QC, Safety Stock What Shopify's unavailable inventory states mean (damaged, quality control, safety stock, other), how to move stock in and out, and when to use each. 3 min read
- Year-End Inventory for a Shopify Business How to close the year's inventory on Shopify: the count, the export, the value report, and the ingredients and packaging your accountant needs too. 3 min read
- Butcher Shop Inventory: Lots, Grinding Logs and Counts Butcher shop inventory: receiving boxes with plant and lot, the grinding log federal law asks of retail stores, counting the case by weight, a spreadsheet. 5 min read
- Candy Store Inventory: Bulk Bins by Weight, Shrink, Dates Candy store inventory: counting bulk bins by weight, the label each bin needs, shrink from samples and spills, packaged candy by date, and a spreadsheet. 5 min read
- Liquor Store Inventory: Counting, Receiving and Records Liquor store inventory: counting cases and loose bottles, par levels, receiving against the invoice, the federal records retailers keep, a spreadsheet. 6 min read
- Pet Store Inventory: Par Levels, Food Lots and Orders Pet store inventory: par levels and cases to order, keeping food lots and best-by dates on the floor, ordering by vendor, and a free spreadsheet. 5 min read
- How to Organize a Stockroom: Zones, Codes, One Home Each How to organize a stockroom for a small food store: zones, shelf codes, backstock in sales floor order, a hold area, chemicals apart, a free stockroom map. 5 min read
- Planogram Template for a Small Store (Free, With Facings) A free planogram template for a small store: each product's shelf, facings and depth, shelf capacity, days of supply, and flags for too little or too much. 5 min read
- Shelf Tag Template With Unit Prices (Free, Printable) A free shelf tag template for a small store: product, price, unit price and code on each tag, filled from one product list and printed three across. 4 min read
- Stock Card Template: Bin Cards for Ingredients and Supplies A stock card template, or bin card: what goes on it, how the running balance and reorder level work, why cards drift from counts, a free card per item. 5 min read
- Convenience Store Inventory Management, With a Workbook Convenience store inventory management: route deliveries checked at the door, dates, losses by reason, counts by section, a store's month, a workbook. 7 min read
- Grocery Store Inventory Management, With a Workbook Grocery store inventory management: produce orders from what sells a day, whole cases, dates, shrink by department, counts, and a free workbook. 8 min read
- Grocery Store Shrink: Measure It, Find It, Cut It Grocery store shrink: the formula, known and unknown shrink by department, where it comes from, a plan that saves $990 each month, and a free workbook. 7 min read
- How to Create SKU Numbers for Your Products How to create SKU numbers: a scheme of short codes, broadest first, examples for a maker, the rules that keep them working, and a free SKU builder. 7 min read
- Inventory Policy Template for a Small Business (Free) A free inventory policy template: receiving, storage, rotation, counts, adjustments and approvals, holds, valuation and write-offs, for a food maker. 6 min read
- Sell-Through Rate Formula, With a Free Calculator The sell-through rate formula: units sold divided by units available, by product and by shop or market, a candle maker's holiday season, and a calculator. 6 min read
- ABC Analysis Inventory Example, With an Excel Template ABC analysis of inventory worked through: usage value, running share, A, B and C cutoffs, what to count weekly, what to reorder tightly, and a free template. 7 min read
- Inventory Transfer Form: Moving Stock Between Sites A free inventory transfer form: each item and lot sent and received, the difference and why, signatures at both ends, and a log of what's in transit. 6 min read
- How to Calculate Inventory on Hand, Available and Free How to calculate inventory on hand: the formula, on hand against available and free to use, weeks on hand, the spreadsheet formula, and why it drifts. 6 min read
- Inventory Audit Form, With Test Counts and Cut-Off Checks How a small maker audits inventory: test counts both ways, cut-off checks around the count date, cost checks against invoices, a checklist, and a free form. 7 min read
- Inventory KPIs for a Small Maker, With a Dashboard Nine inventory KPIs for a small maker: turnover, days on hand, count accuracy, write-offs, expiring stock, stockouts, on-time suppliers, and a free dashboard. 7 min read
- Inventory Reconciliation Template, With a Worked Example How to reconcile inventory: books against the count, what explains each difference, entering the missing records first, the value check, and a free template. 6 min read
- How to Inventory Jewelry: Materials, Pieces and Counts How to inventory handmade jewelry: materials in the unit you use, finished pieces by design and location, counting tiny findings by weight, and a spreadsheet. 7 min read
- How to Keep Track of Inventory for a Small Business How to keep track of inventory in a small business: an item list, units, a starting count, every movement recorded, regular counts and reorder points. 7 min read
- Inventory Accuracy Formula, by Item and by Value The inventory accuracy formula two ways, by item within a tolerance and by value, worked on a week's count, with a sensible target and how to raise accuracy. 6 min read
- Inventory Adjustment Form (Free Template) An inventory adjustment form with a reason, a value at cost and an approval on every line, the reasons worth using, a month by reason, and a free template. 6 min read
- Multi-Location Inventory for a Small Business Multi-location inventory for a maker with a kitchen, a shop and a market stall: stock per site, transfers and stock in transit, counts per site, restocking. 6 min read
- Perpetual vs Periodic Inventory, With a Record Format Perpetual inventory updates stock with every movement; periodic counts it at period end. Both side by side, a perpetual record format, and which fits a maker. 6 min read
- Cycle Count Form and Schedule (Free Excel Template) Count a few items every week instead of everything once a year. How to sort items into A, B and C, a quarter's schedule, and the form, free in Excel. 7 min read
- Waste Log Template for a Kitchen (Free Excel File) A waste log that says what went in the bin, why, and what it cost, then adds it up by reason. A real month filled in, what it showed, and the free Excel file. 7 min read
- Year-End Inventory Count for a Small Business How to plan, run and value a year-end inventory count, what to include, the cut-off mistakes that move your tax bill, and where the number goes on Schedule C. 7 min read
- Inventory Count Sheet Example (Free Excel Template) A count sheet in shelf order, with full cases and loose units counted separately and no expected column. A real count filled in, and the Excel file. 7 min read
- Inventory Variance Formula, With a Worked Example Inventory variance is counted minus expected, in units, percent and dollars. The formulas, a full count worked through, and when a gap is worth chasing. 7 min read
- Why Doesn't My Inventory Match? 8 Causes and Fixes The spreadsheet says 40, the shelf says 12. The eight usual reasons inventory never matches, how to tell which one it is, and one gap traced to the pound. 7 min read
- Offline Inventory Software for a Small Business What "offline" has to mean in a walk-in or at a market stall, the three kinds of software that claim it, and a ten-minute test to run before you pay. 7 min read
- How to Count Inventory in a Small Food Business A count that takes all day and still comes out wrong usually failed before it started. How to prepare, count and handle the differences. 7 min read
Let’s get your stack in order.
Get TaroStack
Sign up now for your free 14 day trial. No credit card required.
