Warehouse inventory management

I need a database driven website. The software will manage the inventory in a warehouse. The warehouse is used as an intermediate step when transferring a product from a manufacturer to a dealer. Here is what's suppose to happen: - There are many Dealers, and about 5 manufacturers. - Dealer orders a item(s) directly from a manufacturer. - Item(s) are delivered to warehouse for storage. - Dealer can log into website to view their inventory. - Dealer can't see any other inventory but their own. - Dealer selects item(s) from inventory and generates a "pick list" or "order" and submits it to the warehouse. - After item(s) are loaded on the truck and shipped, the item(s) get reduced from inventory. - Before an item is "shipped", it should be able to get put back into inventory if the Dealer decides not to have it shipped at that time. - Each item has a unique serial number. (Think VIN number on a car. There are many Ford Mustang GT's, but only one that has a VIN = 123456789ABC) - There is a need to have accessories get added to an item. Accessories are received into inventory for a specific item. (using the same example as the Ford Mustang, a Dealer will order a Blue Mustang GT, and then will order a ground effects kit to go on it. The ground effects kit will be received separately at the warehouse than the Mustang ... the warehouse will assemble the kit onto the car and then send it to the Dealer.) - Warehouse personnel, and management, must be able to bring up a full inventory list and sort by Dealer and other methods.