An on-line one language shop for a bookshop using Drupal 7 + a simple blog to announce the shop activities, sharing templates at pages such as the homepage.
An static designed webpage to use as a template sample + Excel DB with +12000 book references and some 8 fields each.
PROJECT IN DETAIL
Develop the on-line shop in Drupal 7 keeping a visual design close to the given webpage and inserting the +12000 book references from a given Excel DB.
1.- Each book will have some 12 - 15 fields within the Drupal site, feeding them from the given Excel DB and logic relations between them, as well as keeping the new ones empty which will be filled in manually by the shop owner (*). Some of the fields include cover image, link to a book review shop, language/s,...
2.- At least 3 interrelated content types will be needed: books + authors (some 5 fields each) + publisher (some 5 fields each). Books have to be flexibly associated to at least one author and to a publisher.
3.- Shop has to have most common features such as shopping cart + VAT (taxes) specification + possibility to mark as 'offer'/'recommended'/'new' + homepage showcase for different selected books depending on its designation (such as 'offer'/'recommended'/'new' or simply marked as to appear on homepage) + search by word/author + category ordered + alphabetically ordered by book title/author name within each category + 'related books' or 'people who bought this book also ordered...' + on-line payment through Visa credit card in euros (€) in a Spanish bank (bank connection guidelines provided) and/or off-line payment on receipt + delivery costs depending on bill amount and/or quantity of ordered books (**)
4.- Products can/have to appear in: a) home page, b) their own category/ies, c) on their own in their more complete view
5.- Three users profiles: a) Users (and only logged users) can buy, post comments on each book, recommend each book. b) Bookshop owner who can add, modify, delete books and manage the shop and the blog. c) Admin
It has to carefully be developed in short logic fully operational stages in order to have control on the project accuracy to the shop client's will, being the template applied at the very end of the development.
It should be using stable maintained popular existing modules recommended. E-commerce solution: Ubercart, Commerce or any other robust suggestion.
Any extras such as bulk operations, one-click back ups, alternative book list views such as 'only book front cover images', 'simple lists by author/category/...',... are a plus
Clear and commented mark up validating (or close) with xtml
No need of Flash, java, ajax,... unless it supposes a great advantage
Website is to be delivered in Spanish language but whole project will be managed in English. Only contents will be in Spanish and anything can be translated on demand of the developer but the book, authors and publishers contents. Comments in code go in English too.
It is more important to keep it simple (both programming, bookshop owner interface, features) than a complex and instable development
The whole installation and modules should be easy to update despite it is assumed it'll be kept withing the Drupal 7 branch
No commercial code or resources should be used, nor in a legal nor illegal way
Authorship of any required new modules or amendments to any existent can be done but the final property of the final result will be adopted by the client. Therefore no author mark should be added to the project except for the beforehand mentioned modules when it may apply, keeping it all as opensource.
The totality of the project will be accurately defined once a freelance is chosen within the above described parameters.
(*) Appreciated mass field nodes feeder
(**) Appreciated possibility of turning on/off some features such as one of the payment modes or, at some point even the possibility of online shop (keeping the website as a on-line screen shop