Automotive Web Site With Database & Web Service Integrations

Web site for automotive purchase program. Key design deliverables are: a) create approx 10 user facing web pages. have template already designed. b) create backend admin panel to support edit site content, generate reports, and control form routing c) develop backend email routing table for control of routing of form data via adf email based on predeterimed zipcode and vehicle critieria in table. table must be accessed in admin panel. e) create web service integration to chrome construct product to allow users to select and view vehicles and data by year, make and model f) create web service integration with chrome construct to allow users to compare and view vehicles and data by year, make and model g) create backend tool to parse file and display preowned vehicle data ## Deliverables A) See [[login to view URL]][1] for the company's current web site that this new site will replace. Key design deliverables are: B) New site will require approx 10 user facing web pages that need to be created. I have template graphic already designed however am open to creative suggestions. Pages - Home, About Us, Contact Us, Site Map, Disclosure, New Vehicles, Preowned Vehicles, Shopping Tools, New Vehicle Specials, Used Vehicle Specials And Partner. ? Note: o Home page will include scrolling vehicles on top of screen plus scrolls for testimonials and company description (see sample pic below). In addition to this pic design will need to integrate banner ad spaces. o The New Vehicles pages(s) will utilize chrome web services which integrations will need to be developed. Services will need to allow site visitors to search, select, view, price and compare vehicles and data by year, make and model and price. Developers guide included below. ? See "new car search" and ui display "functionality" of [login to view URL] o Preowned Vehicle page(s) content will be driven from files received daily via ftp feed. Will need a parser built to parse pertinent data from these files and make available to users. Data parsed will include vehicle year, make, model, options, vin, links to pics etc. Services will allow users to search, select, view, vehicle by year, make and model and price range. ? Comparable to "preowned search" and ui functionality" at [login to view URL] C) A backend administration panel will need to be created to support the edit of all site content, generation of reports and control of form routing. Vehicle inquiry forms will need to have drop down selectable fields for *Company (configured in admin panel), *Vehicle Year, *Vehicle Make, *Model, Options, Color, *First name, *Last Name, City, State, *Zip, *Email and *Phone. Forms drilled down to from actual new or used vehicle selections should prepopulate with vehicle data. D) A backend vehicle inquiry form email routing table (accessed through the admin panel) will need to be created to control the routing and accounting of vehicle inquiry form data. Forms should be sent via adf email to recipient based on predeterimed zipcode and vehicle routing critieria indicated in table by admin user. I.E Table Parameters ? Toyota 07006,07007 <leads@[login to view URL]>, <leadcc@[login to view URL]> ? Chevrolet 07006,07007 <leads@[login to view URL]>, <leadcc@[login to view URL]> Note: i.e. table must allow admin user to config all Toyota form inquiries which user input zip code is 07005 or 07006 to be routed in adf format to <leads@[login to view URL]> and <leadcc@[login to view URL]>. All chevy inquiries which user input zip code is 07005 and 07006 to be routed in adf format to <leads@[login to view URL]> and <leadcc@[login to view URL]> E) A backend parse will need to be created to parse and display preowned vehicle data received daily via ftp file from 3rd party vendor. See exhibit below for sample data. F) Exhibits: ** Sample Home Page & Site Layout (Attached) ** Raw Preowned Vehicle Data Sample "DealerID","VIN","StockNumber","Status","VehicleType","Year","Make","Model","Trim","Body","VehicleClass","VehicleCategory","Mileage","Transmission","EngineDisplacement","EngineSize","Induction","DriveTrain","FuelType","FuelEconomyCity","FuelEconomyHighway","FuelEconomyCombined","Doors","OEMColorCodeExterior","OEMColorCodeInterior","OEMColorNameExterior","OEMColorNameInterior","GenericColorExterior","GenericColorInterior","InternetPrice","ComparisonPrice","WholeSalePrice","MSRP","InternetSpecial","OemModelCode","HasWarranty","CertificationWarranty","WarrantyMonth","WarrantyMiles","CertificationNumber","ServiceContract","InServiceDate","CertificationDate","DateManufactured","DateCreated","DateUpdated","DateRemoved","DatePhotosUpdated","Photos","SuperSizePhotos","AddendumDetails","DepartmentComments","VehicleComments","Options","PurchasePayment","PurchaseDownPayment","PurchaseTerm","PurchaseDisclosure","PurchaseRate","LeasePayment","LeaseDownPayment","LeaseTerm","LeaseDisclosure","LeaseRate","LeaseResidual","Reserved1","Reserved2","Reserved3","Reserved4","Reserved5","Reserved6" "224","3VWRF71K06M702222","704961","A","1","2006","Volkswagen","Jetta","","4 Dr Sedan","Passenger","Retail","84950","Automatic","2.5","5 Cyl.","Fuel Injected","FWD","Gasoline","19","28","0","4","","","Reflex Silver","","Silver","Gray","11990","11990","","","N","","N","192","0","0","","N","1900-01-01 00:00:00","1900-01-01 00:00:00","2005-08-01 00:00:00","2010-04-09 14:39:00","2011-11-01 17:22:00","1900-01-01 00:00:00","2010-04-10 22:36:00","9","9","","","Come check out this 06 Jetta 2.5 and feel good going down the road German Style!! Handles great and runs like a well enginered car..Has all the necesary options including Power Leather Seats and Freezing Cold AC. The 2.5 is a pretty strong engine that gets a very good fuel rating!! And the comfort level in this car is very good. Call Claude Today to take a ride German Style..717-432-3064","Leather or Leatherette Upholstery|Power Steering|Power Brakes|Power Door Locks|Power Windows|Radial Tires|Alloy Wheels|Gauge Cluster|Clock|Trip Odometer|Tachometer|Air Conditioning|Tilt Steering Wheel|Cruise Control|Tinted Glass|Interval Wipers|Rear Defroster|Console|Carpeting|Vanity Mirror|Day/Night Lever|Dual Sport Mirrors|Front Bucket Seats|Reclining Seats|Center Arm Rest|Inside Hood Release|Courtesy Lights|Driver Side Remote Mirror|Map Lights|Child-Proof Locks|AM/FM Stereo Radio|Keyless Entry|(ABS) Anti-Lock Braking System|Traction Control|C.D. Player|Driver Side Air Bag|Passengers Front Airbag|Side Air Bag(s)",".00",".00","0","",".00",".00",".00","0","",".00",".00","","","","","","" ? Other raw preowned vehicle data will include links to pics required for site display