372690 OSCommerce Enhancements

This job is to implement a number of changes to OSCommerce. This job will require expert knowledge of OSCOmmerce and PHP. Please do not bid on this project unless you have a proven track record. Requirements: 1) Customer Groups: Set up 4 customer groups / types. For this example, they are called: Standard customer Gold Customer Wholesale Business These are not the actual names, these will be finalised later. When a customer signs up, they can request that they be moved to another group - the three other choices above should be in a dropdown list or radiobutton group. If they choose "Gold customer" or "Wholesale Customer", then 3/4 extra textboxes will appear which must be populated. These will be defined shortly after the project starts. If they choose "Business", then another textbox will appear (company name) which must be populated. A shop admin MUST approve this change. The customer will be a standard customer until this is approved, so will NOT see the prices for this group until it's approved. The shop admin must be notified in some way that a customer has requested their account type be changed - a flag on the account would be ideal, plus email notification. The shop admin should be able to sort and/or filter on this customer type in the admin section. 2) Customer Details I'd like the address format changed from the US format - these will most likely be minor text changes, and perhaps some work around the "State" dropdown. Allow checkout without registration 3) Products: Each product must have be able to have 4 different prices, matching the groups above. Unless a customer is logged in and has had their application to be changed to a different group approved, then the Standard Customer price will be displayed to everyone. Multiple image support (2 is fine), plus the small image must be properly thumbnailed, not just resized in the HTML on the product info pages. 4) Other Free shipping on all orders over €100. An extra column on the right hand side for a few small banner images. Design-wise, this should blend in with the design of the left hand side category column. A simple WSYIWYG editor (e.g. tinyMCE) to be used for product details. An additional payment gateway will have to be installed. This is pretty standard, but may require changes to the checkout page. 5) Site optimisation: This shop is going to store thousands of products. Please optimise the code (unnecessary queries etc) where possible to improve performance. 6) Security This is vital - please install any security contributions that you feel will assist with this. Other info: My plan is to purchase a template, so you will not be editing a vanilla install. However, if you can design a similar template yourself (without breaching copyright of the template) as part of this project, then I would be willing to increase the fee. Again - a portfolio is required for this. Obviously you are free to use any existing contributions, but they must all hang together seamlessly and there must not be any additional licensing cost to me.