Hello, I’ve recently started a handmade jewelry business with a partner and I’m trying to figure out if there’s an efficient way of tracking inventory for handmade jewelry that involves high quantities of beads and small things like that.

Currently, I’m using Google Sheets and writing down the quantity of product, the number of pieces, total cost, length of its chain/rope, color, and material. I essentially think tracking inventory is important for having an accurate COG (Cost of Goods). Knowing what inventory is low is less important because that will be visibly seen at this stage but if there’s an easier way than counting each bead put into a product then I would love any advice or tips.

If you make custom products and sell at vendor markets, Etsy, online, or just have knowledge that would be helpful please leave a comment!