Stacks of Snacks is an Australian Snack Company having more than 40 franchisees across the country. Stacks of Snacks have new franchise territories available in Victoria, Queensland and Western Australia. It also have two franchisee resale territories available in South Australia.
STACKS OF SNACKS is a National franchisor, specialising in workplace confectionery and snacks. Stacks of Snacks stocks well known products from Cadbury, Masterfood, Nestle, Arnotts, Hilliers and Sunshine Coast Snack Company. Medma Infomatix acted as an software development provider for this project.
This project Stacks of Snacks includes development of web based application for an Australian Snacks company running their business through more than 40 franchisees. The application provides a way to manage all their products, manuals, operations and franchise activities through a simple web interface.
The main problem in designing this web interface is Scattered databases, large text based un-organized databases, remote access, slow coordination and time consuming reports. So for this We have developed a customized CMS having complete inventory control, Sales management, billing, reporting tool havinf full ERP functioning.
The purpose was to provide a web based application accessible from any franchise location and to collect all the transactions in a central database so that reports & analysis can be done instantly without requiring any franchisee to coordinate with the head office.
As there were many franchisees and database was un-organized & large so we have used database views, indexing and cloud servers in order to fetch results fast. We have developed a customized CMS having complete inventory control, Sales management, billing, reporting tool. Franchisees login into our online application and can update sales, revenue, stocks, download Product updates, manuals, prices, marketing materials etc in real time. Different types of users exist in system - Administrator, Franchisee, Franchisee Staff, Suppliers, SOS staff, Site visitors etc. Admin can set/revoke privileges of different Users and even can create Users, User types, privileges in real time.
MySQL Server was used for the back-end database process. Other technologies used are :
Google Map API