We are transferring the current site (www.sylvan.co.nz) to our content editor (SOHO) under a new domain name (www.gdrutter.co.nz) , and we need the following functions to replace the sylvan product catalogue.
The product data will be always maintained by the site owner in a spreadsheet, and the spreadsheet will be uploaded to the database whenever there are changes.
We need functions that will create a category/product menu system (mouse-over ‘product Catalogue on www.sylvan.co.nz) and other functions which will automatically create the actual category and product webpages from the data in the database.
The functions must be written in PHP/CSS + java where required, and must be held in the /media folder. The functions must use the existing Mysql database in www.gdrutter.co.nz and there are some simple standards that must be followed.
The content editor normally generates .PHP pages which are stored in the root folder; page properties are stored in the Mysql database. The content editor uses an auto-menu system and automatically integrates pages with an HTML template. We will need functions to generate PHP pages that automatically use the HTML website template and which must also update the database so that the pages are 100% usable by the editor.
Note that colors, fonts etc. must use the custom.css file as described. Position, data item and all variables must be meaningfully named and easily identifiable in the code, so that I can make simple changes to the layout myself.
More detail is available in the uploaded spec document, and I will supply the Vendor with clear visual images + measurements of how the pages and menu-disply in the spec should look.