Well, here I am again asking you guys for advice. All the other forums that I frequent while knowledgeable on that subject just can't help me.

I'm looking for software that would allow tracking of our products individually all the way from production/testing to shipping to returns for service etc. So someone could enter a serial number and find out exactly what has happened in the product's life including how it left the factory. It would basically get barcode scanned at every point with extra data entered as needed (fault info/setup data etc)

Free is nice (something like PHP+MySQL based) but I don't mind paying since we have nothing now and there are no plans in upper management to implement it. They are ignorant and we need it IMO.

We're talking quantities of anywhere upto 500,000 units a year so it would need to be scaleable and I can justify the appropriate hardware for it.

Ideas? I can't even seem to find anything really. Googling for '(product) tracking system' seems to mainly return bug tracking type systems.

TIA guys