Redesign and improve Add-to-cart wholesale website(repost)

Use latest stable versions of OsCommerce, PHP and mysql to modify existing add-to-cart retail website to wholesale website. Most of the functions (including code) can be cloned from existing website: [login to view URL] Most part of webpage layout is same as existing website. Major changes: 1) homepage color, theme, graphic, etc. 2) user info and user management 3) item price and price management (related to user account) 4) others See below for more info about detailed requirements. Other websites which can be used as references of homepage graphic and theme designs: [login to view URL], [login to view URL], [login to view URL] ## Deliverables This project basically is a clone of our retail website [login to view URL] (which is testbed) with some extra/customized features. It has been partly done by previous worker. Website: [login to view URL] minimum requirements: 1) Web page Layout and functions should be same as [[login to view URL]][1] (OSCommerce, PHP, mysql based) But color/theme must be different. => some pages in OSCommerce admin panel have not done yet. 2) Graphic design is required with flash on homepage => done. May need to shrink the homepage to fit on screen. 3) only admin (in admin panel) can create users (venders). User cannot create account (this is different with [login to view URL]) user info should include: AccountID - accmulative number, unqiue, int login name - required, string, at least 3 characters long login password - required field, at least 6 characters long, at least one number and one letter Company name - required, string, up to 128 char DBA - optional, string, up to 128 char Federal Tax ID - required, string, 32 char State Tax ID - required, string, 64 char Billing address line1 - required, up to 128 char Billing address line2 - optional, up to 128 char City - required, up to 128 char State/Province - required, up to 64 char ZIP - required, int Country - required, up to 64 char, default value is USA Check box of Shipping address is same (if same shipping address is populated automatically) Shipping address line1 Shipping address line2 City State/Province ZIP Country Phone number - required Fax number - optional email - required web url - optional Contact person - required Contact person phone - required Contact person email - required Dealer price category - drop down box 1, 2, 3, 4 Account status, dropdown box, active or inactive Dealer store credit- optional, default value is 0. When check out, user final balance = total item price - credit - coupon + shipping. => all done except default country (USA), automatically populate shipping address, account status and dealer store credit. 4) Users can update basic info(such as password) but not all. User Login section is on the top right of homepage. => unfinished. 5) Each product should have 6 prices: MSRP, MAP, wholesale1, wholesale2, wholesale3, wholesale4 in admin panel. Only MSRP price is shown to public (no login requried to see this price). Other prices can be seen for logged in users. => prices are set but display on webpage is incorrect: MAP (retail) can be seen w/o login. 6) Each user is assigned to a pricing tier (wholesale1 thru 4). User can see following 3 prices: MSRP, MAP and this user's wholesale price. For example, userA is assigned to dealerprice1 category by admin and userB is assigned to dealerprice2 category. After login, userA can see MSRP, MAP and wholesale1 price. userB can see MSRP, MAP and wholesale2. When checkout, dealer price applies, as well as coupon discount (if any) => Not implemented correctly. User can't see his/her own level price after login. MAP price is not displayed correctly. 7) In admin panel, admin can update all user's info, including password reset. => done 8) Side Nav. bar includes product categories: Paintball, Airsoft, Parts & Accessories, => done 9) Layout and content of product info page refer to: [login to view URL] => product info page in admin panel needs SEO meta tags such as description and keywords. In public web: each product has at least two tags: Description and Specification. The layout is also not correct. 10) Top Nav bar includes Search Bar and links of Home, New Arrivals, Why KonKor(About us), Dealer Application(Application Form Download), Contact us ,Polices & Terms, Bottom Nav bar includes links fo facebook, twitter and youtube. => all done except links to facebook, twitter and youtube. 11) checkout page includes dealer price, store credit coupon code, shipping cost. => unfinished. 12) Payment gateway: [login to view URL] => unfinished. 13) shipping is calcuated (USPS including international, Fedex, and UPS). => partially done. 14) If the order total (before credit and coupon) is more than $3000 and the shipping address is in 48 continental states, shipping is Free. => unfinished. Other websites which can be used as references of homepage graphic and theme designs: [login to view URL], [login to view URL], [login to view URL]