element14 Community
element14 Community
    Register Log In
  • Site
  • Search
  • Log In Register
  • About Us
  • Community Hub
    Community Hub
    • What's New on element14
    • Feedback and Support
    • Benefits of Membership
    • Personal Blogs
    • Members Area
    • Achievement Levels
  • Learn
    Learn
    • Ask an Expert
    • eBooks
    • element14 presents
    • Learning Center
    • Tech Spotlight
    • STEM Academy
    • Webinars, Training and Events
    • Learning Groups
  • Technologies
    Technologies
    • 3D Printing
    • FPGA
    • Industrial Automation
    • Internet of Things
    • Power & Energy
    • Sensors
    • Technology Groups
  • Challenges & Projects
    Challenges & Projects
    • Design Challenges
    • element14 presents Projects
    • Project14
    • Arduino Projects
    • Raspberry Pi Projects
    • Project Groups
  • Products
    Products
    • Arduino
    • Avnet Boards Community
    • Dev Tools
    • Manufacturers
    • Multicomp Pro
    • Product Groups
    • Raspberry Pi
    • RoadTests & Reviews
  • Store
    Store
    • Visit Your Store
    • Choose another store...
      • Europe
      •  Austria (German)
      •  Belgium (Dutch, French)
      •  Bulgaria (Bulgarian)
      •  Czech Republic (Czech)
      •  Denmark (Danish)
      •  Estonia (Estonian)
      •  Finland (Finnish)
      •  France (French)
      •  Germany (German)
      •  Hungary (Hungarian)
      •  Ireland
      •  Israel
      •  Italy (Italian)
      •  Latvia (Latvian)
      •  
      •  Lithuania (Lithuanian)
      •  Netherlands (Dutch)
      •  Norway (Norwegian)
      •  Poland (Polish)
      •  Portugal (Portuguese)
      •  Romania (Romanian)
      •  Russia (Russian)
      •  Slovakia (Slovak)
      •  Slovenia (Slovenian)
      •  Spain (Spanish)
      •  Sweden (Swedish)
      •  Switzerland(German, French)
      •  Turkey (Turkish)
      •  United Kingdom
      • Asia Pacific
      •  Australia
      •  China
      •  Hong Kong
      •  India
      •  Korea (Korean)
      •  Malaysia
      •  New Zealand
      •  Philippines
      •  Singapore
      •  Taiwan
      •  Thailand (Thai)
      • Americas
      •  Brazil (Portuguese)
      •  Canada
      •  Mexico (Spanish)
      •  United States
      Can't find the country/region you're looking for? Visit our export site or find a local distributor.
  • Translate
  • Profile
  • Settings
Community Hub
Community Hub
Member's Forum How do you manage "on stock" component on your personal lab?
  • Blog
  • Forum
  • Documents
  • Quiz
  • Events
  • Leaderboard
  • Polls
  • Files
  • Members
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
Join Community Hub to participate - click to join for free!
Actions
  • Share
  • More
  • Cancel
Forum Thread Details
  • Replies 26 replies
  • Subscribers 536 subscribers
  • Views 3975 views
  • Users 0 members are here
Related

How do you manage "on stock" component on your personal lab?

strb
strb over 2 years ago

I was just wondering, how do you keep track of components on a personal lab?

I started by simply not doing it but pretty quickly found myself searching among an increasing amount of small component bags in search of the most close resistor value or the best op. amp. I have on hand for the job. For general passive components (resistor and capacitor) I've bought a couple of cheap kits but I suppose they were too cheap because values are scattered without an apparent logic (some E12 component, some E24 value, missing E12 values etc...).

I then started tracking available components in a simple Excel table and that for me was a big step forward: I could search any available component at "design stage" without needing to bring out the component box. A couple hours of inventory once saves me from needing to search among bags of component each time I'm designing something or drawing a scheme.

Less than a month ago I switched from Excel to "DB Browser for SQLite". I'm still learning it and using at most basic level but I'm quite pleased with the result even at this early stage.

image

This is my experience so far and I'm not regretting doing it. What's your experience on this matter? Do you have any hints?

  • Sign in to reply
  • Cancel

Top Replies

  • baldengineer
    baldengineer over 2 years ago +6
    For personal stock and projects, I tried using all of the various online part-database services. I disliked all of them. Most are highly focused on pulling Octopart data on active ICs. The problem is the…
  • baldengineer
    baldengineer over 2 years ago in reply to markeno +3
    I use one of these for my random strips of parts. Then I place small labels on the "Row" with whatever the part is. https://www.adafruit.com/product/520 You could even put 2 or 3 strips in a single…
  • Andrew J
    Andrew J over 2 years ago in reply to dougw +2
    It’s not a massive commitment recording mechanism is simple and their location is also recorded. When I have a project, I do check what I have in-stock and everything else is ordered. Stuff goes in a project…
Parents
  • Gough Lui
    Gough Lui over 2 years ago

    To probably no surprise to anyone ... I don't keep track of stock at all.

    I just store my parts in boxes or bins where they should be. If I come to a project and find there's not enough, then I'll start my game of substitutions or ordering "way more than I'd ever need" and waiting it out for delivery (often taking advantage of specials and price breaks).

    As it's not really a job, just a hobby, I try not to take things too seriously. I don't need a full-blown stocktake inventory system, sign-in and sign-out of parts, quality management, safe work procedures, etc ... I just don't think I'd have the discipline to keep it up to date even if I had one, as I'd grab a component for a quick trial-and-error substitution and forget to note it down.

    - Gough

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • colporteur
    colporteur over 2 years ago in reply to Gough Lui

    Phew, there is more than one of me. It embarrassed me to confess my parts organization or lack of it.

    I stored the components in the clear plastic bags they arrive in, arranged in an elongated cardboard box, like a card index filing system. I have a few other small boxes with lids that hold other larger stuff or more quantities.

    I visit the box regularly and shuffle through the bags, looking for something I might have or forgot I ordered. I do envy people that are organized but not enough to invest in the organization myself. I use very few smaller components, mostly prebuilt modules. Connectors, screw and crimp as well as sockets to install Arduino boards are consumed the most.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • markeno
    markeno over 2 years ago in reply to colporteur

    I am not a professional engineer.  I did take electronics in school, but for me projects are hobby projects.  I do at times repair various things.  I started getting back into electronics about ten years ago after about 15 years away from doing anything component level in electronics.

    For me it is mostly finding a place for items that I will be likely to find them quickly if I have them.  I did start an inventory list years ago when I started getting back to electronics, but I quickly realized it is more work than it is worth at the level of work and quanity of work that I am doing.  I found if I can have it where it is easy to find, or I know where to look for items of that type, I can usually get away with not having and inventory.  Yes, I have purchased "not best item" but "the best fit" of item that is in stock, only to find that while I am putting away surplus parts after I have finished the project that I had exactly what I wanted in stock..  Generally, if I have to order any parts, it isn't a huge deal if I ordered some items I didn't need.  It is a bigger deal if I had "only" ordered that part and paid all the shipping etc for no reason.

    There is a point where organizing becomes more important.  When I started getting into some electronics projects I didn't have much of anything to track, but as I ended up with more parts I had to start working on organizing so I didn't spend so much time looking through what I had.  There is a point where an inventory I would say comes in too.  I am just not there yet.  I can still fairly quickly go through and tell if I have what I need or not.

    I mostly use clear compartment bins for small items.  Plano Fishing Tackle clear flat compartment bins, some cheaper similar bins.  Various sets of components that were ordered as a kit remain in their bins.  For larger items I often put into larger parts organizers with removable / configurable open bins in them that have a clear top cover. Stuff like switches, DIN connectors, IC sockets, knobs anything in those size ranges.  For ESD I use the old style black slightly crumbly conductive foam and put all my ICs and various mossets and such into that before putting into the parts bins.  I put small labels on the various compartments of what type or value the item is in that compartment for quick identification.  Some ICs are tough to read if the light is not just right, small capacitors and such. For modules and micro controllers, they remain in esd bags and then are organized in various bins.  I try to group related/similar parts into the bins to it so I can check if I have what I need.  Unique stuff, or items I am unlikely to use, go into various other boxes that aren't right at my bench. I have various ammo boxes/bins dedicated to certain types of larger items, like usb cables/parts and related things.

    Just last week I couldn't find a part for the project I was working on, as I got it in early, it was sitting on the bench for a few weeks waiting on other parts.  I put it away somewhere at some point when clearing the bench to work on something else.  I put it in  "safe place" and forgot where that place was.  That night I reordered it after tearing open all my bins, containers, drawers.  In the morning I went over to my one "deep" storage box that is in the other room and it was sitting on the top.  So an inventory list wouldn't have been much help on that bit, as I certainly knew I had it, but I couldn't find it.  If I get to doing an inventory, I do intend to have a "Location" entry, and a "date" that location was last updated.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
Reply
  • markeno
    markeno over 2 years ago in reply to colporteur

    I am not a professional engineer.  I did take electronics in school, but for me projects are hobby projects.  I do at times repair various things.  I started getting back into electronics about ten years ago after about 15 years away from doing anything component level in electronics.

    For me it is mostly finding a place for items that I will be likely to find them quickly if I have them.  I did start an inventory list years ago when I started getting back to electronics, but I quickly realized it is more work than it is worth at the level of work and quanity of work that I am doing.  I found if I can have it where it is easy to find, or I know where to look for items of that type, I can usually get away with not having and inventory.  Yes, I have purchased "not best item" but "the best fit" of item that is in stock, only to find that while I am putting away surplus parts after I have finished the project that I had exactly what I wanted in stock..  Generally, if I have to order any parts, it isn't a huge deal if I ordered some items I didn't need.  It is a bigger deal if I had "only" ordered that part and paid all the shipping etc for no reason.

    There is a point where organizing becomes more important.  When I started getting into some electronics projects I didn't have much of anything to track, but as I ended up with more parts I had to start working on organizing so I didn't spend so much time looking through what I had.  There is a point where an inventory I would say comes in too.  I am just not there yet.  I can still fairly quickly go through and tell if I have what I need or not.

    I mostly use clear compartment bins for small items.  Plano Fishing Tackle clear flat compartment bins, some cheaper similar bins.  Various sets of components that were ordered as a kit remain in their bins.  For larger items I often put into larger parts organizers with removable / configurable open bins in them that have a clear top cover. Stuff like switches, DIN connectors, IC sockets, knobs anything in those size ranges.  For ESD I use the old style black slightly crumbly conductive foam and put all my ICs and various mossets and such into that before putting into the parts bins.  I put small labels on the various compartments of what type or value the item is in that compartment for quick identification.  Some ICs are tough to read if the light is not just right, small capacitors and such. For modules and micro controllers, they remain in esd bags and then are organized in various bins.  I try to group related/similar parts into the bins to it so I can check if I have what I need.  Unique stuff, or items I am unlikely to use, go into various other boxes that aren't right at my bench. I have various ammo boxes/bins dedicated to certain types of larger items, like usb cables/parts and related things.

    Just last week I couldn't find a part for the project I was working on, as I got it in early, it was sitting on the bench for a few weeks waiting on other parts.  I put it away somewhere at some point when clearing the bench to work on something else.  I put it in  "safe place" and forgot where that place was.  That night I reordered it after tearing open all my bins, containers, drawers.  In the morning I went over to my one "deep" storage box that is in the other room and it was sitting on the top.  So an inventory list wouldn't have been much help on that bit, as I certainly knew I had it, but I couldn't find it.  If I get to doing an inventory, I do intend to have a "Location" entry, and a "date" that location was last updated.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
Children
  • colporteur
    colporteur over 2 years ago in reply to markeno

    I've gone looking for parts that are actually in my hand. When this happens I abandon the exercise and just sit and have a beer. Provided I can find the bottle opener.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • dougw
    dougw over 2 years ago in reply to markeno

    I can relate to searching in vain for a part I know I have, giving up and ordering it, only to discover it later. When such a part is found it is usually obvious why it was stored there. Sometimes it is even obvious why I couldn't find it.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
element14 Community

element14 is the first online community specifically for engineers. Connect with your peers and get expert answers to your questions.

  • Members
  • Learn
  • Technologies
  • Challenges & Projects
  • Products
  • Store
  • About Us
  • Feedback & Support
  • FAQs
  • Terms of Use
  • Privacy Policy
  • Legal and Copyright Notices
  • Sitemap
  • Cookies

An Avnet Company © 2025 Premier Farnell Limited. All Rights Reserved.

Premier Farnell Ltd, registered in England and Wales (no 00876412), registered office: Farnell House, Forge Lane, Leeds LS12 2NE.

ICP 备案号 10220084.

Follow element14

  • X
  • Facebook
  • linkedin
  • YouTube