Running a LEGO reselling operation without proper inventory tracking is like building without instructions. You lose money, waste time hunting for pieces, and miss profitable opportunities. A solid LEGO inventory spreadsheet template gives you control over your stock, tracks values in real time, and helps you spot trends before your competition. Whether you're managing 100 minifigures or 10,000 sets, the right template becomes your business backbone. Here's how to build one that actually works for serious resellers.
Essential columns for your LEGO inventory template
Start with these core data points: Item Name, Set Number, Category (minifig, set, part), Condition (new, used, missing pieces), Purchase Price, Purchase Date, Current Market Value, and Location. Add Quantity on Hand, Reserved Stock, and Sold Quantity to track movement. Include a Profit Margin column that auto-calculates your markup percentage.
Setting up automated pricing updates
Manual price updates kill productivity. Use VLOOKUP functions to pull current BrickLink average prices, or set up API connections if you're comfortable with spreadsheet automation. Create separate sheets for different marketplaces since eBay, Whatnot, and BrickLink prices vary significantly. Update weekly for fast-moving items, monthly for slower inventory.
Organizing inventory by storage location
Your template needs a location system that matches your physical setup. Use simple codes like "A1-B3" for shelf locations or "BIN-047" for storage bins. Add a Notes column for condition details like "missing cape" or "yellowed torso." This saves hours when photographing and listing items.
Tracking costs beyond purchase price
Add columns for shipping costs, fees, and time invested. Include marketplace fees (eBay 13%, BrickLink 3%) to calculate true profit margins. Track packaging costs and your hourly rate for sorting and listing. Most resellers underestimate these hidden costs and wonder why profits disappoint.
Building sales tracking into your template
Create a separate "Sales" sheet that links to your main inventory. Track Sale Date, Platform, Final Price, Fees Paid, and Shipping Cost. Use formulas to automatically update your main inventory quantities when items sell. This prevents overselling and shows which items move fastest.
Related reading
| Feature | Basic Template | Advanced Template |
|---|---|---|
| Item tracking | Manual entry | Barcode lookup |
| Pricing | Static values | Auto-updated |
| Sales integration | Separate tracking | Linked inventory |
| Reporting | Basic totals | Profit analysis |
| Time investment | 2-3 hours/week | 30 min/week |
FAQ
What's the best format for a LEGO inventory spreadsheet?
Excel works best for most resellers because it handles large datasets and complex formulas better than Google Sheets. Use separate tabs for inventory, sales, and marketplace-specific pricing. Keep one master sheet and create filtered views for different categories.
How often should I update my LEGO inventory values?
Update weekly for popular minifigures and new releases, monthly for everything else. Set calendar reminders and batch your updates. Focus on items worth over $20 first since small price changes on $2 parts don't impact your bottom line much.
Should I track individual minifigure parts separately?
Only if you part out figures regularly. Most resellers do better tracking complete minifigures and noting missing accessories in a condition column. Tracking every tiny weapon and hairpiece creates more work than profit for casual resellers.
How do I handle inventory for items stored in multiple locations?
Add separate rows for each location or use a quantity breakdown column like "Home: 5, Storage: 12." The key is consistency. Pick one method and stick with it so you don't double-count inventory or lose track of items.
Spreadsheets work, but scanning hundreds of minifigures one by one gets old fast. Start scanning free with brickem.io and save 20+ hours in your first month or we'll refund you. No credit card required.
