PartsBox vs spreadsheet: Version 2 of my home lab electronic parts stocking system

PartsBox vs spreadsheet: Version 2 of my home lab electronic parts stocking system

#electronics #inventory #stock
I moved from a spreadsheet system to PartsBox to list all my electronics parts list and connect them to projects I make. Here I share how to add parts, connect them to storages and projects while transferring a system from a simple spreadsheet.

0:00 Intro
01:59 Parts
09:26 Storage
11:08 Projects
13:54 Outro: My thoughts on Bill of Materials and inventory system

‣ Some links below are affiliate. I receive a small commission at no extra cost to you.

100pcs clear Zip Lock Bags 10x15cm

My spreadsheet for parts list

Stocking parts for an electronics prototyping lab



New Morning by TrackTribe from YouTube Audio Library


  1. EvertZwevert on March 8, 2023 at 5:51 am

    Interesting ! I started a physical storage system, but have not yet come around to digitize it. Your videos provide an inspiring guide for this next step.

  2. Greg Clare on March 8, 2023 at 5:58 am

    PartsBox looks interesting. Thanks for the walk-through. Unfortunately, the paid versions are way too expensive for a hobbiests budget. And, for the free hobbiest version, I can’t find any details on the website covering exactly what the limitations are? A feature comparison page would have been useful. So, I’m put off by the thought of spending the time loading up my free version and then finding that to get useful functionality I really need a paid version (which is beyond my budget).

  3. HULL GUITARS USA on March 8, 2023 at 6:07 am

    Wow! Your channel is criminally underrated. Just found you and very glad to pour over your great content!

  4. Fang Zhe on March 8, 2023 at 6:13 am

    Well done

  5. Nakul Singh on March 8, 2023 at 6:15 am

    You are the best

  6. Hemon Dey on March 8, 2023 at 6:21 am

    Thanks for this, parts box looks like a useful tool. One problem I have had is trying to work out how much to replenish my parts inventory when I am planning more than one project on the go. I’ve had to combine BOMs and work with pivot tables in Excel to get the totals to offset against what I have in stock, before ordering enough to top up the inventory. Do you know if parts box can automatically mark parts as "reserved" for a current project, so that when I’m planning multiple simultaneous boards to make, I don’t accidentally count a part as available more than once?

  7. Saiful Koh on March 8, 2023 at 6:22 am

    Your videos are really helpful. Please continue sharing. Keep up. Don’t give up.

  8. Ali G on March 8, 2023 at 6:23 am

    I think you should definitely try Partkeepr. I tried to install it once and gave up but I will certainly give it a go in a couple of months time.

  9. Stephen Eaton on March 8, 2023 at 6:24 am

    As a maker Ive been using partsbox for a few years now and what I also do is I have an "In-Transit" location. At the time of purchase I also create the components (if new) as I order them, so have price etc at my fingertips and allocate the location to "In-Transit" therefore when they arrive its just a matter of moving them, or if I dont have time right there and then, they will go into my in-box, I know that anything in my inbox already has a partsbox part with pricing etc so no need to remember pricing or then have to sit down and create a new part etc. I just have to move it. This has allowed me to go from piles of components I ordered some time ago and couldn’t remember what I had, and also putting off because of the time to process, to some semblance of organisations 🙂

  10. grousemoor on March 8, 2023 at 6:32 am

    I can see you put great deal of effort in making those videos, you deserve much more views than you have now! Thanks for the information, I plan to start doing electronics projects in more structured way, I will try out PartsBox for sure.

Leave a Comment