359948 SHOP: PHP+Mysql+website design

SCOPE OF THE PROJECT Programming a website (online shop: FRONT END + BACK END) and making it work at the hosting. I will supply access to the host and to the database. The scope includes the design of the pages and the scripts behind it. The site is to be developed in PHP. Database is Mysql. WEBSITE OPERATION The system will handle the purchase and the sale of products. Products are grouped in Families of products. There is a limited number of Families and an unlimited number of products. The products have a short lifetime (~1 week), and the purpose is to offer the products to the customers, who may purchase only a part of one or several products. Since there is a short lifetime to sell the products, we shall quickly match demand and offer At the expiration date of the sold products, some of the customer will require to be charged back according some logic linked to the product. Programmer shall develop the logic, that will lay on parameters that the webmaster must automatically load timely. CONDITIONS LANGUAGES 1 Site is to be developed in English (master version). 2 Site will be Multilanguage. For every language, it will be available a full version or a limited version of the shop. (full will have all the options available; limited will have some options available. There will be 2 layouts (full and limited), but texts and banners will be specific to each language. 3 In the back end we will drive separately the “standard” text in different languages and the messages in the banners in different languages 4 Webmaster must be able to drive the site in several languages, and for each of them to choose: (“off”, “on” full version, “on” limited version) SOFT 5 Webmaster must be able to open the site by using Dreamweaver (or proper lternative to be suggested) 6 Must use CSS, 7 There will be SSL security in place. 8 5 The website will be able to send email to customers to confirm order reception, order completions, balance, reminders, etc. PASSWORDS AND LOGGING 9 Handle user register and log in: Will require validation of some fields (to be arranged what fields and the validation logic). Webmaster must be able to enable and disable captcha system (for user registration and login). Function (I forgot my password: Enter email and resend it): PAYMENT 10 Pricing of the Products will depend on user's profile 11 Accepted payments: Paypal + Credit card (Interface with the bank to be supplied) + Bank Transference + load of files containing info of payments received. DATA 12 For the database to run quicker, old records will be removed from the “production” tables and put in the “history” tables 13 System must be prepared to import / export data safe and easily from / to webmaster's PC COMMODITIES 14 Link/button: “add to my favourites / markers” in the browser GENERAL 15 System will have 4 levels of access (non identified users – identified customers – supervising webmaster (no data alteration allowed) - full webmaster (data maintenance allowed) 16 User may want to access and edit his data. Also access to his history in the website (past orders, products purchased, amounts charged back, account movement) 17 There will be pre-defined calculations, statistics and reporting (screen definition of users, web browser, visitors per country, sales, most ordering one). 18 Keep track of emails sent to customers. 19 Ability of making discounts among the customers (i.e. from a certain date onwards, give a bonus or award to users every 10 purchases, (to be defined) 20 Promotion to customers: Generate series + sequence number per sale and give it to the customer whenever a sale is made. 21 Some of data of sensible fields will not be shown to customers via screen (i.e. bank account details, will show only first 3 and last 3 digits) 22 Customers may define a limit of weekly expenses 23 Must show the steps in the purchasing sequence (1 define preferences – 2 Log in…) 24 System will forecast virtual balance of customer (evaluate his balance, orders placed, available products, and weekly expense limitation) 25 Link / button for customer to be deleted from the database. 26 Webmaster can undo some of the purchases of the customers. 27 Webmaster can accede to customer's data, and edit it. 28 Webmaster can delete 1 user 29 If used external code (PERL, Pear, Captcha, etc. programmer will deliver a list of codes and where it has been sourced) BACK END 30 System shall evaluate orders in place (which may) and depending on them and on some “flags” and triggers will make different things to happen. When available, it will match orders and available products. NOTES 31 Mysql database: I will suggest the tables and the fields. 32 Used programs and scripts must be free from license payments 33 Due to nature of purchase orders -(customers may subscribe indefinitely (even if he has not money), and orders must be evaluated timely to confirm that there is offer, that customer has money, that he has not overrun his weekly spend limitation, - it is possible that a Os-commerce solution can not be applied I will define the guidelines of the system, I will define triggers (time based or click based), flow charts, the tables, the fields, the working logic and the algorithms, screen shoots and details of the connection to the banks. Thus your job should be focused on the programming.