BESPOKE DATABASE SYSTEMS, SOLUTIONS and iOS APPS USING FileMaker Pro

Product Development

A product development company supplying the major retailers wanted to unify data, avoid duplication and errors and make it available to all in real time. It replaced numerous spreadsheets and a couple of access databases that had been developed over time by various individual members of staff to be able to do daily tasks. It covered a number of disciplines, which included…

  • [1] A series of screens walk through product development. Building up new pack ideas by combining existing components and/or specifying new ones. Requests for artwork/samples are generated here.
  • [2] Those design briefs then appear in the design Department’s ‘in tray’. Associated jobs are able to be allocated to various members of the design team. Individuals log in to see their list of jobs.
  • [3] Requests for quotes (RFQs) are collated and emails automatically sent out inviting companies to quote via a secure web portal.
  • [4] From this plethora of info the latest/best prices are automatically pulled through for the sales department. A complex script runs looping through all the quotes selecting chosen over latest over estimate etc and presenting a summary of the latest best prices. Staff are able to set various scenarios based upon real time info. Improving their liaison with the customers.
  • [5] Various departments enter their interests. FOB quotes (in various currencies and countries) are converted to DDP prices to the warehouse in GBP
  • [6] The Quality Control Dept monitors customer audit requirements and which suppliers comply. They also add safety testing requirements to individual products. This automatically allows a report to flag (in red) when situations do not comply will all necessary tests and regulations.
  • [7] Numerous ‘trackers’ then follow the development and pricing of the packs through to procurement orders. Allowing staff to immediately sense where/when bottle necks and potential issues might arise.

Database sheets