Interview Question in Microsoft CRM


 

Interview Question :: Looking for a free web based serial number, customer and warranty tracking system

I'm looking for a web based application for tracking products that people have ordered from us. We need something that's web based (php with mysql preferably, or cgi could also work), can track order and shipping dates, multiple serial numbers of the various components and customer contact information (name, address, phone, email). Its for internal use for warranty tracking and contacting customers about updates. And looking for something free/open source as we don't have a budget for this.
I have tired several CRM's, none of them have serial number tracking abilities, plus they seem to be overkill, we don't need the account aspect end.
Thanks for the assistance!
by ksk