Big Cart Anxiety

spi said:
I've lost a large tayda cart that I was procrasticating on ordering before, just checked one day and my cart was empty--that's when I learned there's a save cart feature, which I use now to prevent it.
Click to expand...
Saved. Thanks for the reminder on that. I've used that feature before, but I hadn't yet on this round of parts. I feel better already.
 
Erik S said:
Have you tried the Tayda ones recently? I think maybe they were floppy a few years ago and got better. I’ve only been doing this since 2023 and they’ve been consistent over that time.

I just spot checked a handful of tayda ones and some floppy ones I got at an estate sale. Legs on the floppers are around .014” the tayda ones are all around .019”

View attachment 97536
View attachment 97537
Click to expand...
I have serious micrometer envy....
 
I too hate paying for shipping, thanks Amazon....

I keep a very detailed spreadsheet of my entire parts inventory complete with formulas and alerts that flag anything running low. For example, if resistor stock drops below 15, the cell turns red so I know to reorder. I always build in some buffer and order extras of everything. Mouser has resistors for a penny each QTY 10+, may as well order 100.

For example, right now I’ve got 112 pots on hand, but all except 26 are already allocated. projects I have lined up. I’m currently short one A100k — I have 11 on hand but need 12 to finish the ~20 builds I’ve got queued up. So I’ll have to either hold off on one of the A100k builds until my next parts order goes in later this week or substitute a different taper in the meantime.

When I order, I double-double check the spreadsheet against my cart before I order it, just to make 100% sure.

I learned the hard way early on that it REALLY sucks to have to order $3 in parts from Tayda and have $10 in shipping. Happened twice on the same build, never again.
 
CheapSuitG said:
I keep a very detailed spreadsheet of my entire parts inventory complete with formulas and alerts that flag anything running low.
Click to expand...

I simplified my system at some point - I don't keep any inventory of what I have, and I no longer check stock before I order.

Every time I get boards, I order all the parts for that set of boards. That's pretty much the whole system. Cheap generic stuff I round up and get extras, pricier or specialty stuff, I order exactly what's needed. If I "steal" a specialty part for a repair or a perfboard or something, I write it down and add it to the next order.

Excel does two things for me: It gets me to a consolidated buy list for the batch I'm working on, and it totals the parts cost for each pedal, which I can look at if I want to sell something.


CheapSuitG said:
it REALLY sucks to have to order $3 in parts from Tayda and have $10 in shipping
Click to expand...

It does suck.

I've played the game of starting a new batch to justify that $3 in parts, but now I just face the mistake and pay the piper when that happens.

I did exactly that on my last PPCB order. Placed the order for a set of boards, and realized the next day I forgot to order some specialty transistor Robert stocks in the component section because they're not available from the standard places. I was ready to cough up the extra 5 bucks for my mistake, but Robert caught the two orders and combined them for me. Not gonna get that kind of customer service from Mouser!
 
Erik S said:
I simplified my system at some point - I don't keep any inventory of what I have, and I no longer check stock before I order.

Every time I get boards, I order all the parts for that set of boards. That's pretty much the whole system. Cheap generic stuff I round up and get extras, pricier or specialty stuff, I order exactly what's needed. If I "steal" a specialty part for a repair or a perfboard or something, I write it down and add it to the next order.

Excel does two things for me: It gets me to a consolidated buy list for the batch I'm working on, and it totals the parts cost for each pedal, which I can look at if I want to sell something.




It does suck.

I've played the game of starting a new batch to justify that $3 in parts, but now I just face the mistake and pay the piper when that happens.

I did exactly that on my last PPCB order. Placed the order for a set of boards, and realized the next day I forgot to order some specialty transistor Robert stocks in the component section because they're not available from the standard places. I was ready to cough up the extra 5 bucks for my mistake, but Robert caught the two orders and combined them for me. Not gonna get that kind of customer service from Mouser!
Click to expand...
Sounds like a good system too. My system could be the fact I like owning 10,000 things. Other than grains of rice.
 
Erik S said:
Every time I get boards, I order all the parts for that set of boards. That's pretty much the whole system. Cheap generic stuff I round up and get extras
Click to expand...
so you get an endless accumulation of cheap parts that you never look at again?
 
spi said:
so you get an endless accumulation of cheap parts that you never look at again?
Click to expand...
Exactly! 😆

I keep saying I’m going to start doing more breadboard / perfboard / ptp stuff. If that ever happens I’ll be covered for resistors and caps.

I mostly stick to the build docs and don’t do a lot of mods, but I like to at least have the option.
 
Y'all should look into Odoo community free edition. It has everything you need keep stock levels, set up alerts, create products with BOMs etc. Makes the whole thing a lot easier than dicking around with Excel, at least for me.
 
You must log in or register to reply here.
Back
Top