This is a custom order tracking system for Watermatters.org. I designed and built it from scratch using PHP and MySQL. The customer site helped manage and deliver over 4 million water education brochures to happy customers, while staff love the admin area for its easy inventory management and dynamic reports. I designed this app, wrote all of the PHP/jquery code and designed the database structure. Behind the scenes it's a complex and custom web admin area that allows multiple people to track and ship orders, print shipping labels, customize order reports, manage a print inventory of hundreds of thousands of publications, as well manage the PDF print files.