Handmade Inventory Management: SKU, Stock, and Reorder Workflow for Craft Sellers
seller educationinventorySKU managementstock planninghandmade business

Handmade Inventory Management: SKU, Stock, and Reorder Workflow for Craft Sellers

HHandicrafts Live Editorial Team
2026-11-19
7 min read

Learn how to track handmade stock with SKUs, inventory fields, reorder points, and weekly and monthly workflows for craft sellers.

Reliable handmade inventory management does not require expensive software. A clear SKU system, consistent stock counts, and a simple reorder workflow can help craft sellers know what is ready to ship, what is reserved, what needs materials, and what deserves production time next. This guide explains what to track, how often to review it, and how to use the information for ready-to-ship, made-to-order, and multi-channel handmade businesses.

Overview

Inventory is more than a count of finished products. For a craft business, it includes raw materials, works in progress, completed goods, items held for customers, damaged pieces, packaging, and products listed across different sales channels. If these categories are mixed together, it becomes easy to oversell an item, overlook a popular design, or buy materials before checking what is already available.

A useful inventory system should answer five questions quickly:

  • What products and materials do I have?
  • Where is each item stored?
  • Which stock is available, reserved, damaged, or still in production?
  • What should I make or reorder next?
  • Do the quantities match my shop, marketplace, craft fair, and order records?

A spreadsheet is often sufficient when product ranges are small or moderate. Use one master inventory record rather than separate informal lists for each channel. Marketplace inventory-sync features, barcode tools, and point-of-sale systems can reduce duplicate entry, but they still depend on accurate product names, SKUs, quantities, and adjustments.

What to track

1. Create a practical SKU system

A stock-keeping unit, or SKU, is an internal code that identifies a specific product or variation. It is not the same as a barcode, which is a scannable code used by compatible equipment or systems. A handmade SKU can be short and readable. For example, MRG-BLU-12 might represent a blue mug in a particular collection and size. Choose a format you can apply consistently rather than one that contains too much information.

Useful SKU fields include product family, material or collection, color or variation, size, and version when needed. Avoid changing a SKU merely because a product photo, description, or price changes. Create a new SKU when the item is materially different, such as a different size, finish, pattern, or set quantity.

2. Build a reusable inventory record

Use one row per distinct product variation. Your craft business inventory template should include:

  • SKU and product name: The internal code and customer-facing title.
  • Category and variation: Such as ceramic, woven, wood, color, size, or pattern.
  • Material usage: The amount of clay, yarn, fabric, wood, beads, packaging, or other inputs used per finished unit.
  • Production status: Raw material, planned, in progress, quality check, ready to ship, reserved, completed, or discontinued.
  • Quantity on hand: The physical count currently held.
  • Reserved stock: Items set aside for paid orders, custom clients, or an upcoming event.
  • Damaged or unsellable stock: Pieces that should not be listed as available, even if they remain physically present.
  • Available stock: A clear figure that excludes reserved and damaged units.
  • Storage location: A shelf, bin, drawer, studio zone, or market crate.
  • Sales channel: Website, marketplace, local shop, wholesale account, craft fair, or direct order.
  • Reorder point: The stock level at which you review whether to make or purchase more.
  • Lead time and capacity note: The time or labor required to obtain materials or produce another batch.
  • Last counted and last updated: Dates that show whether the record is current.
  • Seasonal demand notes: Holiday, wedding, home-refresh, or event-related patterns you have observed.

For materials, track units in a way that supports production decisions. Record fabric by meters or yards, clay by weight, and packaging by piece, for example. If one product uses several inputs, a bill-of-materials note can show the required quantity of each material per unit. This helps you identify a finished-product shortage that is actually caused by a material shortage.

3. Separate inventory types

Ready-to-ship products should be counted as finished, inspected, packaged or package-ready units. Made-to-order products should generally be tracked through available materials and production capacity rather than represented as completed stock. A listing can remain active while its inventory record shows the number of orders you can reasonably accept based on materials, labor time, and promised turnaround.

Keep reserved stock separate from available stock. A customer order, market allocation, or wholesale hold should not reduce the physical count, but it should reduce what can safely be sold. Damaged items should be recorded separately so recurring defects become visible without inflating sellable inventory.

Cadence and checkpoints

Use a weekly stock workflow

  1. Collect records: Gather marketplace orders, direct sales, craft fair notes, returns, cancellations, and material purchases.
  2. Count high-risk items first: Check best sellers, low-stock variations, small items that are easy to misplace, and products listed on multiple channels.
  3. Reconcile changes: Subtract shipped units, add completed work, move reserved items into the correct status, and record damage or loss.
  4. Compare channels: Confirm that the quantity shown online does not exceed available stock after reservations.
  5. Flag decisions: Mark products that need production, materials that need review, and listings that should be paused or adjusted.

Use a monthly review for slower-moving pieces, supplies, packaging, and seasonal notes. Compare units sold with time spent making them, material availability, returns or repairs, and the space required for storage. A quarterly review can be useful before collection launches, busy selling periods, or major craft fairs. For event preparation, the craft fair vendor checklist can complement your stock count by helping you plan display quantities and post-event reconciliation.

Set reorder points thoughtfully

A reorder point is a prompt for review, not an automatic instruction to buy or make more. Set it using expected demand, production or supplier lead time, material availability, and a modest buffer that suits your business. A product with a long production cycle may need an earlier review point than a quick item, even if both sell at similar rates.

For handmade goods, “reorder” may mean ordering supplies, scheduling a batch, reserving studio time, or contacting a maker who provides a component. Write the intended action beside the reorder point so the number leads to a decision.

How to interpret changes

When a quantity changes, identify the reason before changing your production plan. A sudden shortage may reflect a genuine sales increase, a delayed stock update, a market sale entered late, a damaged batch, or a reserved order. Reconcile the record first, then interpret the trend.

Look for patterns across several review periods rather than reacting to one unusual week. Repeated low stock on one variation may suggest that it deserves a higher reorder point, a larger batch, or a clearer listing. Repeated unsold stock may indicate that production should be reduced, the product repositioned, or the design retired. Keep seasonal demand notes separate from general demand so a temporary event does not become a permanent assumption.

Also compare sales with production effort. A popular item can still be a poor use of capacity if it consumes scarce materials or requires extensive finishing. Review your handmade product pricing and profitability records alongside inventory data. Inventory tells you what moves; production and cost records help determine what is worth repeating.

For sustainable handmade products, inventory accuracy can also reduce avoidable overproduction and unnecessary purchasing. Track remnants, reusable components, and imperfect pieces that can be repaired or transformed where appropriate. Material descriptions and care requirements should remain accurate; the handmade material labels guide provides useful context for organizing those details.

When to revisit

Return to your inventory system weekly for counts and reconciliation, monthly for product and material decisions, and quarterly for broader capacity planning. Revisit it before launching a collection, accepting a large custom order, preparing for a craft fair, or entering a seasonal selling period. Count again after an event or promotion so unsold, sold, returned, damaged, and reserved items are all assigned correctly.

Update your workflow whenever a selling platform changes its inventory fields, channel-sync behavior, order statuses, or barcode support. Platform features can vary, so confirm the current settings in the relevant seller tools rather than assuming that a connection prevents overselling. Review your spreadsheet or software fields at least annually to remove unused columns and add any recurring source of error.

To put this into practice, start with your 10 most important products. Give each one a consistent SKU, count finished and reserved stock, record its storage location, and note the materials needed for another unit. Add a reorder point and a seasonal note. After four weekly reviews, adjust the fields and thresholds based on the decisions you actually had to make. A small, maintained system is more valuable than a detailed tracker that is never updated.

Related Topics

#seller education#inventory#SKU management#stock planning#handmade business
H

Handicrafts Live Editorial Team

Seller Education Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.