Building your materials library

Variable-length materials: chain, wire, sheet stock

Some materials don't come in tidy unit-of-one quantities. You buy chain by the foot. You buy wire by the spool. You buy sheet stock by the square inch. And you consume them in whatever amount a specific piece requires.

There are three reasonable ways to model these in your library, and the right answer depends on how you actually buy and use the material.

• Per-unit (per-inch, per-gram, per-foot). Track the raw material once, with a cost per inch or per gram. BOMs read "16 × box chain (per inch)" or "1.4 × 14K yellow gold sheet (per gram)." Best when you cut to length often, want clean cost math on variable-length pieces, and buy in bulk. One library entry, infinite flexibility.
• Per-piece (finished sizes). Track each common finished length as its own material: "16-inch box chain, finished," "18-inch box chain, finished." BOM rows read "1 × 16-inch box chain." Simpler per-item entry, more library maintenance. Best when you sell standardized lengths and don't cut-to-length often.
• Hybrid. Track the raw chain per-inch as one material, and keep finished-chain entries as separate materials whose cost is the inch-level chain plus finishing labor and findings. More library complexity, but you get unit-cost precision on the raw material and one-click application on common lengths.

The same tradeoff applies to wire, sheet, solder, and findings sold by weight: anything you buy as a continuous quantity and consume in variable amounts per piece. Start with per-unit. It's the most flexible and the one you can always retrofit later.

Consumables and findings: what to track, what to lump

Every piece uses a long tail of small things: flux, pickle, sandpaper, polishing compound, jump rings, ear posts, clasps. Individually they're under a dollar; collectively, across hundreds of pieces, they add up to real money. The question is never whether to account for them. It's how much precision is worth the bookkeeping.

A working framework, ordered by cost-per-piece:

• Under ~$0.50/piece, bake into overhead. Flux, pickle, sandpaper, polishing compound. Don't track per-piece. Make sure your monthly overhead reflects what you actually spend on shop supplies, and let the per-hour overhead rate carry it.
• $0.50–$3.00/piece, flat fee material line. A "Standard findings, earrings" material at $2.00 covers 2× ear posts + 2× ear backs across a typical mix. You're averaging, not itemizing. One library entry, applied to every relevant piece.
• Over $3.00/piece, real material entries. A $4.00 magnetic clasp or a hand-fabricated bezel cup deserves its own material in the library, with its own cost. The spread is wide enough that averaging hides the truth.

Where the line falls is your call. The thresholds above are starting points, not rules. The test is whether the precision changes a pricing decision. If swapping a flat fee for itemized entries wouldn't shift the retail price by more than a few dollars, the flat fee is fine.

Naming materials so you can find them

A library that grows past about 20 entries gets hard to scan if names are inconsistent. A naming convention you can stick to is worth more than any specific format.

Listings show only the name and a category badge. Metal type, karat, and color don't appear as columns, and findings don't have a metal field at all. If you want that info visible at a glance, it has to live in the name.

Two patterns work. Pick one and apply it to every entry.

Metal-first (recommended)

Lead with karat, color, and metal, then the form factor and a dimension when sizes vary.

Schema: [Karat] [Color] [Metal] [Form factor] [Dimension]

Sorts by metal, so everything in a given karat clusters together. Useful when you think "I'm working in 14K today, what do I have?"

• 14K Yellow Gold Casting Grain
• 14K Yellow Gold Sheet 24ga
• 14K Yellow Gold Wire 1mm
• 14K White Gold Bezel Cup 6mm
• Sterling Silver Casting Grain
• Sterling Silver Wire 1mm
• Sterling Silver Earring Post
• Gold-Filled Earring Post

Form-factor-first

Lead with form factor and dimension, then a trailing clause for karat, color, and metal.

Schema: [Form factor] [Dimension], [Karat] [Color] [Metal]

Sorts by form factor, so everything in a given shape clusters together. Useful when you think about your bench by what's in each drawer.

• Casting Grain, 14K Yellow Gold
• Casting Grain, Sterling Silver
• Sheet 24ga, 14K Yellow Gold
• Wire 1mm, 14K Yellow Gold
• Wire 1mm, Sterling Silver
• Earring Post, Sterling Silver
• Earring Post, Gold-Filled

Both patterns scan and sort cleanly. The mistake is using both at once: half your sheet entries lead with the metal, the other half lead with Sheet 24ga,, and the table won't cluster either way. Pick one and apply it to every new entry.

For non-metal materials (gemstones, packaging, polishing cloths), the same care applies. Lead with what distinguishes them most: stone type and cut for gems, function for packaging. CZ Round 2mm, Lab Sapphire 4mm, Velvet Pouch Small, Polishing Cloth.

Common naming slips

A few patterns that look fine on entry three and break by entry thirty.

Mixed capitalization on karat marks. Pick one and use it everywhere. The table sorts case-sensitively, and 14k lands in a different place than 14K.

Missing karat or alloy. A piece that lists "Gold Sheet" tells you nothing about cost. The same name across 10K, 14K, and 18K is three different prices.

Vague dimensions instead of specs. "Small" is relative; 1mm is a fact. When you come back in six months you'll remember the millimeter, not which wire you once thought of as small.

Inconsistent dimension format. Pick one convention (1mm or 1 mm, 24ga or 24g) and use it everywhere. The table sorts character by character, so 1mm and 1 mm won't cluster.

Inconsistent ordering of facets. If one entry leads with the alloy and the next leads with the shape, neither pattern sorts the way you expect.

The materials table is searchable and sortable, but a consistent name turns scanning into reading.