Joomla module / Excel & MySQL data manipulation / Web Design

Introduction I run a Japanese car dealer website and I require a programmer who is familiar with Joomla and databases to assist me with the following: (1)Create an attractive, bright and light template for my car sales website. We import Japanese vehicles to the United Kingdom. (2)Automate vehicle listings from an excel spreadsheet then manipulate the data for display in my Joomla website. Please note that there is no actual auction system or bidding involved, so the system is very simple. All customer interaction takes place over email. I do not require an auction system. I will go into more detail about the requirements below: Template This needs to be designed as per my requirements. Good Photoshop skills are a must, because I require a very polished look which captures the visitors attention. You will be manipulating vehicle photos to create the look I want. I will provide examples of websites I like to guide and assist. Vehicle listing automation Back end (a) The ability to upload a number of excel spreadsheets to my server. The spreadsheets can be up to 15 meg in size. (b) Once uploaded a script will scan the spreadsheet and import data to an mysql database for manipulation in the Front end. See below for more details. (c) There needs to be an easy to use GUI for the user to see upload status. (d) Spreadsheets containing vehicles will be uploaded three times a day. Each spreadsheet upload session will replace the previous ones. The script will need to delete all old entries and use the new spreadsheet data only. (e) The spreadsheets will contain vehicle details, auction time, links to photos and vehicle price. (f) The vehicle price needs to be manipulated using a formula which I will provide. There will be a currency conversion involved from Japanese Yen to British Pounds. The exchange rate will change from time to time. This needs to be automated or the GUI needs to provide an option to change this. Front end (a) There needs to be an attractive and easy way for visitors to the website to search for vehicles. (b) Visitors need to be able to search by keyword, colour and year. For example they may want to search for a car called Skyline / Blue / 2001 – 2005. This should be fairly easy to implement since the excel spreadsheets are well organized. There also needs to be an option to provide commonly searched keywords as a static feature. I will provide a list of these for implementation into a menu. (c) Once individuals search for the vehicle they want, a list should appear with all the available vehicles. No photos are loaded at this point. Only when they select a vehicle should the photos be loaded. The spreadsheets containing the data has links to a photo page for each individual vehicle. The photos need to be extracted and displayed on our website. (d) There needs to be basic paypal and google checkout integration by way of a simple deposit payment button. This should be fairly easy to do, as nothing complicated is required. We are currently simply using a paypal button – this is adequate enough. (e) All other interaction with customer takes place over email and telephone. There is no further work needed for the system at this stage, although it may be needed at some point in the future. (f) I have a server already running a car import website. You will need to install a new instance of Joomla and switch the website over to the new one when it is ready. Downtime needs to be minimised. I think this is a fairly easy project for someone that knows their way around Joomla, MySQL and data manipulation. A fully working solution is required. I am looking for someone with experience in these areas. In your bid, please could you detail what experience you have had in the areas above. Payment terms I will setup milestone payments in advance on a regular basis. These will be released when agreed milestones have been reached. I propose the following milestones: (1)Completion of the Joomla template (30% payment release) (2)Completion of automation script (30% payment release) (3)Templete and automation goes live and is fully working with no bugs (40% payment release) I expect this project to take no more than 5 – 7 days. I trust that the above payment terms are fair. I look forward to hearing your bid and proposal.