here in baltimore we use a lot of binders (mostly because we're in the midst of trying to translate this system to an electronic one)

we have the following

a master bike inventory.
a build-a-bike inventory (project)
a shop bike inventory (bikes that pay the rent)

each bike that gets checked in gets an unique number that is recorded in the master one. (it's sequential... which also helps us determine how many bikes we've processed since we've adopted this system.)

each of these bikes have a checklist of stuff to do.  it's pretty standard, and when I get to work tomorrow I can upload it.  it's not the best one tho (please have the colorado collective chime in since theirs are AWESOME)  they also have an info sheet that records wheel/frame size, etc.

if it's deemed for personal projects (build a bike) it gets a B prefix to it
if it's for shop, it gets an S.

each of these tags are written on colored tape thats taped to the bike.

so for example, all of our bikes have numbers like s-1425  or b-1423.  they then can be referenced in the appropriate book.

eventually, we'd like a simple application that will enable us to enter this info and then do searches like, "give me red bikes that are 52cm with cantilever brakes."



Boson Au
303 Whitridge Ave
Baltimore, MD 21218
443-286-8494
http://velocipedebikeproject.org


On Sun, Sep 19, 2010 at 4:49 PM, DancesWithCars <danceswithcars@gmail.com> wrote:
I've seen in QBP catalog a page or so where
they print out tags, probably subcontracted to another
company...

Checking various ones in the Washington DC area,
only Mount Rainier Bike Coop (MRBikeCoop.com)
uses paper tages.

Phoenix has an old computer system, but actually
locating the bike as it moves around the shop,
seems difficult as shop inventry moves
outside each open day...

VeloCityCoop.org is new, and I've hoped something
would be developed, irght not they are using
a colored tag sytesm.
something part it out, pull the good stuff,
 frame or other serious issues, not worth savin
Blue? Refurbish the bike
Pink Sell bike, price marked

On Sun, Sep 19, 2010 at 4:40 PM, Godwin! <goodgodwin@hotmail.com> wrote:
> First off, I think you'll have to be really organized to keep this on track.
> I'm not saying you're shop is not but the experience I had running our shop,
> we had constant troubles keeping member's project bikes tagged with basic
> info, if at all. I think your system will have to be designed to be as easy
> as possible to use by your volunteers/staff and you may want to discuss how
> to avoid not tagging correctly and what happens in that case ect.
>
> I have never done this but two ideas spring to mind. Use multiple tags that
> can be put together to make the entire description, one card for wheel size,
> one for frame size... This would not work too well for describing work that
> needs to be done, you would have to make a grading system or tag parts of
> the bike that need repair. The other would be to implement a software
> database and print up numbers. You would be able to store whatever
> information you wanted and it would even be searchable. You would also have
> a historic record of bikes that have gone through the shop. After we finish
> (and start) work on the website, this is something I'm hoping to put into a
> much larger application but will certainly be far off in the future.
>
> .godwin
>
>
>
> ________________________________
> Date: Sun, 19 Sep 2010 15:31:16 -0400
> From: dugan.meyer@gmail.com
> To: thethinktank@bikecollectives.org
> Subject: [TheThinkTank] Request for Inventory Tag Templates or Ideas
>
> Hiya!
>
> Do any of you wonderful shops out there have a usable bike inventory tag you
> could share with us at MoBo? We're trying to design a tag for available
> project bikes in our basement that would list basic info like top tube
> length, wheel size, etc. etc. and notes about work needed -relevant info for
> members sifting through potential projects and then recording work done over
> the course of the project.
>
> If you have something that's worked for your shop or a document from another
> source and would pass it along, we'd be grateful. Advice on things to
> include would also be helpful.
>
> Thanks, friends!
>
> Dugan Meyer
> MoBo Bicycle Cooperative, Cincinnati
>
> _______________________________________________ Thethinktank mailing list
> Thethinktank@bikecollectives.org To unsubscribe, send a blank email to
> TheThinkTank-leave@bikecollectives.org To manage your subscription, plase
> visit:
> http://lists.bikecollectives.org/listinfo.cgi/thethinktank-bikecollectives.org
> _______________________________________________
> Thethinktank mailing list
> Thethinktank@bikecollectives.org
> To unsubscribe, send a blank email to TheThinkTank-leave@bikecollectives.org
> To manage your subscription, plase visit:
> http://lists.bikecollectives.org/listinfo.cgi/thethinktank-bikecollectives.org
>
>



--
DancesWithCars
leave the wolves behind ;-)
_______________________________________________
Thethinktank mailing list
Thethinktank@bikecollectives.org
To unsubscribe, send a blank email to TheThinkTank-leave@bikecollectives.org
To manage your subscription, plase visit:
http://lists.bikecollectives.org/listinfo.cgi/thethinktank-bikecollectives.org