The business grew quickly and soon, inventory maintenance, orders, customers and shipping—handled by just a few employees—quickly became complex. Now, the company uses FileMaker Pro to track everything. "FileMaker Pro is like a smart employee who keeps up with all of the details of our business. We are not programmers and our database needs are constantly changing. FileMaker Pro is wonderfully flexible as our company grows," says Brown.
To run the business, the company has developed a FileMaker Pro solution called Mission Control—a name that hearkens back to the retro robots and space age toys the company sells. Despite lack of in–depth programming acumen, the team has been able to add layouts, scripts, fields and relationships to Mission Control with ease.
With the addition of FileMaker Pro 11, TinToyArcade.com has shifted its business into warp speed. "There are many impressive new features in FileMaker Pro 11," says Brown. "Our favorite new feature is the revamped, integrated ODBC Driver. TinToyArcade.com is a mySQL/PHP–based web store. FileMaker Pro 11 with the new and improved ODBC driver allows a live connection between our in–house FileMaker Pro 11 database and the online store. Linked to our online store, FileMaker Pro 11 solves huge problems and saves countless hours of work."
While the company is generally satisfied with its PHP online sales software, it has very limited back–office functions and that, in turn, meant the company had to hire outside resources to write custom code. This is no longer the case with FileMaker Pro 11.
"The scripting in FileMaker Pro 11 is easy and remarkably powerful. We connect to our online data using the intuitive relationships graph," he says. "We have written simple scripts to sort and process our data while preserving the original information in the mySQL files."