Car Wheel E-Seller Site (updated)

!!!!!YOU DO NOT NEED TO COMPLETE ANY DESIGN WORK, ALL WORK DESCRIBED BELOW ARE PURE PHP AND MYSQL DB WORK!!!!! Site Visitor Visitors will have the ability to browse rims by category. The system will display the category title and image that will link to the subcategories. Sub categories will appear in columns with the rim vendor code and the part number that will link to the full rim information. The full rim information will include the description bolt pattern thread size lugs per wheel vendor name price part number style rearback spacing offset size desc lug style hub ring center cap and image. The full information will also display the tires associated with the rim. Tires will display the price vendor code part number tire description load rating and speed rating. The full rim information will also include installation kits. Installation kits will display the price vendor code part number and description. Visitors will have the ability to have the wheels and tires mounted. They will select whether their vehicle has TPMS or not. Visitors will then have the ability to enter the quantity for the rim tires and installation then add everything to their cart. Visitors will then have the ability to view their cart or continue shopping. Visitors will have the ability to search by year make model finish subcategory size brand or any combination. Results will be handled in the same fashion as mentioned above. The drop downs will be dynamically generated based on the first selection. The Visitors shopping cart will display the product name description unit price quantity and total price per product and per order. Visitors will have the ability to edit their quantity or remove the items from their cart then proceed with checkout. They will enter their name email address phone username and password. The system will calculate the shipping cost based on UPS or FedExs shipping API. Customers will then proceed to make their payment quoted for PayPal [login to view URL] or LinkPoint. Upon a successful transaction the order will be placed. Site Member Secured Login. Members will manage add edit view delete their personal information. Members will have the ability to place orders in the same fashion as mentioned above. The system will automatically populate the ship to information. Members will have the ability to view their order history. The system will display the order number and date of the order which will link to the full order details. Admin Secured Login. Admin will manage add edit view delete all products. Adding a product will consist of selecting the product type see below. If the product type is a rim the Admin will type the description bolt pattern finish brand thread size lugs per wheel vendor name part number style rearback spacing offset size desc lug style hub ring center cap and attaching an image jpeg gif only. The Admin will then have the ability to select a category subcategory enter the years makes and models and price. When the Admin enters a part number the system will check to see if it is currently in the system. If it is the system will automatically populate the product information. Tire product set up will consist of typing the tire title vendor code part number tire description load rating price and speed rating. Installation kit set up will consist of typing the installation kit name vendor code part number price and description. The Admin will have the ability to associate each product with compatible products for the tires and installation kit system. The Admin will manage edit view the prices for the mounting option. The price break downs will be as follows 13 to 17 will have a price per wheel only and a price per wheel with TPMS for both cars and trucks determined by the category and subcategory. Admin will manage add edit view delete mark complete change status all orders. Ordered will display the order number order date and order total that will link to the full order information. Admin will manage add edit view delete all order status options. Adding a status will consist of typing the title. Admin will have the ability to search orders by order number or customers name. Results will display the order numbers and customers name that will link to the full order information. Admin will manage add edit view delete categories. Adding a category will consist of typing the title and attaching an image jpeg gif only. Admin will manage add edit view delete all subcategories. Adding a subcategory will consist of typing the title and assigning it to a category. Notes 1. The system will automatically generate an order number upon a successful transaction. 2. Quantities will default to 4.