Show & Tell
sharing our inventory management setup because i think its cool and maybe useful for other small ecommerce folks
we sell handmade candles (about 200 SKUs). our setup:
stock tracking table: product name, SKU, current_stock, reorder_point, supplier, cost
order form: staff fills out when shipping an order. auto-decrements stock in the table
restock alert workflow: runs daily, checks for products below reorder point, emails our procurement person with a list
incoming stock form: when new stock arrives, scanned in and table gets updated
weekly inventory report: scheduled workflow that summarizes stock levels, low stock items, and top sellers
before this we were using a google sheet that was always out of date because nobody remembered to update it after shipping orders. now the stock updates happen automatically when the shipping form is filled out
the reorder alerts alone saved us from 3 stockout situations in the first month
this is really cool. the reorder alert workflow is genius. we sell jewelry and have a similar problem with knowing when to reorder supplies
the auto-decrement on shipping is chef kiss. no more "oops we sold more than we had in stock" situations
nice system. one thing you might want to add: a barcode/QR code scanning option on the incoming stock form. we use a simple phone camera barcode scanner that fills the SKU field automatically. speeds up the receiving process a lot