Project ID:
1463154
Project Type:
Hourly
Hours of work:
Unspecified
Project Duration:
1 - 4 weeks
Budget:
$15-$25 AUD / hour
(Approx. €11-€20 EUR)
Project Description:
Outline:
To create complete; Vehicle make, model, year, month variant master list. That can be easily managed, updated and added too. End database will interface (suggested layout concept attached) with Magento website as a "Fit My Car" wizard. This wizard will push selected stock items into shopping cart.
Who We Are:
Roof Rack World - A Specialist Retailer of Car Accessories (focusing on roofracks, towbars and accessories). We have a fantastic specialist bricks and mortar shop but want to create a complete oline experience.
Experience Required:
- Master Level of Excel - The ability to create database by merging 6 excel spreadsheets (attached) that need to be merged, duplicates removed into one format. Vehicle master list is most critical example attached).
- Understand car makes and models and variants.
- Master Level for Magento experience to get database to interface with website wizard and be able to get magento to push multiple stock items into shopping cart from Wizard.
-Have a great eye for design
Deliverables:
- Create Master Vehicle List by merging 6 spreadsheets and removing duplicates. Suggested Detail attached
- Create Database for roofracks, towbars, snow chains using 6 supplied spreadsheets re-allocating stock items to new master list
- Create Magento Workable Wizard that utilizes stock items from database (suggested layout supplied)
- Have Selected Result push multiple stock items into magento shopping cart.
- Re-design current magento menu heading to full size menu choice (eg www.REI.com)
- tweak current website design to help unify branding
- upload around 2000 Magento shopping cart products images and descriptions with great seo
- design and create brochure pages
- upload master pic's for car make and model
Skills required:
Database Administration,
Excel,
Magento,
Website Design
Additional Files:
Catalogue+at+10+11+2011.xls
HR+Price+and+parts+List+2011.xls
Fit+Guide+Excel+Mar+2011.xlsx
ROLA+Fitguide+September+2011.xlsx
Rhino111128-FITGUIDE_AUS.xlsx
THuleFitguideDecember1011.csv
Masterfit+list+example.xlsx
web+layout+fit+my+car.docx