Build and implement an online store from scratch.

I'm after an experienced php mysql developer (2-3 years minimum experience) to develop an online store that looks very polished, neat and professional. [[login to view URL]][1] is a good basis for what I'm after. I have been down the path of an off the shelf package like oscommerce however I want something developed from scratch that is customised without all of the other confusing features which I won't use (other employees found it very difficult to use). I also need it designed for search engine optimisation, pages with relevant names/titles etc. I also want the design to be well structured using css and not having tables used everywhere in the html. The code must be commented as well so other developers can easily work out what is happening in the future. I will need a developer who can provide me further support in the future in regards to changes to the site etc so I need to know your standard hourly rate. ## Deliverables See Attached Document for all info (including screen shots) I'm after a website that looks very polished, neat and professional. [[login to view URL]][1] is a good basis for what I'm after (not exactly the same though). I have been down the path of an off the shelf package like oscommerce however I want something more customised without all of the other confusing features which I won't use (other employees found it very difficult to use). I also need it designed for search engine optimisation, pages with relevant names/titles etc. I also want the design to be well structured using css and not having tables used everywhere in the html. The code must be commented as well so other developers can easily work out what is happening in the future. It will need to be tested for all of the most common browsers (internet explorer, firefox, safari etc) testing for mobile devices isn't required yet but I will be going down that path in the future. There needs to be a menu on the side which has Search textbox below this it needs to list categories and associated sub categories. In the main section it will list all products assigned to those sub categories. (Note a product could be assigned to multiple sub categories). At the bottom there needs to be sales and support link (content needs to be editable). Below is an example of what the menu would contain (from categories and sub categories table) Window Accessories Window Winders Window Locks Window Fittings Door Accessories Door Handles Entrance Sets Deadlocks Door Hinges Door Rollers Flyscreen Accessories Brackets Flyscreen When you click on a category I need the sub categories to expand fluently (like how the menu expands on the kogan website) Products can also be assigned to any brand/grouping. When a user selects a sub category there will be a combobox where they can also filter any products assigned to the brand for that sub category. The product detail section can list products in grid view as per attached document with a couple of products going across and them all going down. In list view the products will go down the page and display the key points listed in tblproduct. Only show key points where there are key points entered. Each product has add to cart and view details (don't need the upgrade warranty option like Kogan after item is added to cart), the quantity in stock will also be displayed Details Page - Needs to have option of viewing photos, specs/comments and warranty information. - (maybe see if can have link to like the page via facebook and twitter like kogan - not urgent). Shopping Cart Page - once item added to cart need link to view kart with items added to kart. Shopping Cart user can add to shopping cart at any time. As soon as an item added to cart need to show box with your kart. Shopping Cart need postage calculator like kogan for an order where the user can enter their postcode and it will add total like Kogan website, based on the package dimensions and weight stored in tblProduct. (have tblPostcode to store the from postcode which I can change if we move etc) using Australia Post calculator. Shopping cart needs to accept the following Payment Methods - Paypal / Eway. Need to investigate what is required for eway to work. Once a sale is complete send email to user accounts which have email addresses - with sale details including postage address, products, quantity etc. The user also needs to receive an email confirming their order. Needs to handle user sessions appropriately, Admin I need a user friendly admin section which can be accessed via a specific web address etc. Need staff to be able to login, Assign other login user accounts (including email address) Assign product as sale item on front page. Update text on homepage under weekly special about our business. View items to be posted list and mark items as posted so they don't appear on the list anymore. View sales for date range. Add Product Category Add Product Sub Category and Assign it to a Category Add new product - assign photos and description and assign it to multiple sub categories. Update product quantities including out of stock Put a product on sale - offer discount on a product etc Remove Stock - also have an option to assign as non-current so it doesn't come up in searches but can be shown again later. View Orders to be posted. Flag orders as posted Export sales data as csv as well as product table. Need to discuss ability to send specials offer emails to people in tblMailingList Product pictures need to accept a standard size and re adjust image size for display in cart etc (they need to zoom not clip or stretch). Pages Required * Home Page - Lists the current weekly special (tblProduct.fldWeeklySpecial=true) if any, as well as basic information about the business which can be changed via the admin section. * Search Results - displays products based on what the user searched for (see product list below). * Product List - Displays products based on sub category/brand selection. In both grid and list view - list view displays product key points (if any) from tblProduct * Product Details (Photos) - Allows user to view additional photos for the product from tblProduct * Product Details (Specs/Warranty) - Allows user to view specs and warranty information from tblProduct * View Shopping Cart - As soon as a user adds an item to a shopping cart I would like a list of their select items to appear. They can checkout as soon as they add a product to the cart. * Checkout - will display the products that they have added to their cart. The can choose the quantity for each product (default is 1). It needs to include the postage cost based on the postage calculator. The user can there move onto making their payment via PayPal or eway, like the kogan website (may need to discuss this part) * Sales and Support - content needs to be editable. Will contain information regarding pickup or contact information for support. <!-- --> * Admin login - this is for staff to login and alter the website content * User Accounts - gives us the ability to add other staff to tblUserAccounts so they can login etc. * Product List (including ability to assign to Sub Category and Brand) * Product Quantity list - screen to update stock quantities quickly. Basically see the products in a list and filter by category and subcategories and edit stock. * Category List - allows users to add/edit/remove categories * Sub Category List (including ability to assign to Category) - allows users to add/edit/remove sub categories * Brand List - allows users to add/edit/remove brands * Sales figures - ability to view, print and export (csv) sales figures based on a date range. * Postage list - ability to view, print and export (csv) sales figures. * Media page (not required just yet but may want it in the future) Relationship Diagram (open to change) ![][2] Sample page layouts (needs a more polished look, fonts, colours etc.) ![][3] ![][4]