Creativity & Magic eCommerce

EXECUTIVE SUMMARY THIS PAPER WILL OUTLINE THE DESIGN OF THE ECOMMERCE FUNCTIONALITY OF THE CREATIVITY & MAGIC, INC. WEBSITE. I WILL PROVIDE THE MERCHANT ACOOUNT INFORMATION AND THE PRODUCTS AND SERVICES INVENTORY. THE SITE IS PRETTY TYPICAL, BUT I WILL GO THROUGH THE FUNCTIONALITY TO ENSURE THAT EVERYTHING IS CLEAR. NECESSARY FUNCTIONALITY THE ECOMMERCE WEBSITE MUST PROVIDE THE FOLLOWING FUNCTIONALITY: Ø THE ABILITY FOR THE USER TO LOGIN TO HIS/HER ACCOUNT. Ø IF THE USER IS NOT REGISTERED, HE/SHE MUST REGISTER. Ø THE ABILITY FOR THE USER TO REGISTER AS A CORPORATE USER ($750.00) OR A HOME/HOME OFFICE USER ($250.00) I WILL NEED TO HAVE THE ABILITY TO CHANGE THIS AT WILL. Ø THE REGISTRATION FEE IS PAID FOR WITH A CREDIT CARD, TELEPHONE NUMBER, ONLINE CHECK OR PAYPAL. CUSTOMER DATA IS PASSED TO THE DATABASE WHETHER THE PAYMENT WENT THROUGH OR NOT. THEN CREDIT CARD INFORMATION IS INPUTTED AND MAY OR MAY NOT BE PASSED TO THE DATABASE. Ø THE INITIAL REGISTRATION (HOME/HOME OFFICE AND CORPORATE USER) OPENS A GENERIC PROJECT, WHICH WILL BE MODIFIED AT A LATER POINT. Ø IF, DURING REGISTRATION, THE CREDIT CARD IS SUCCESSFUL, LOGIN INFORMATION AND A TRANSACTION RECIEPT APPEARS ON THE SCREEN, AND IN THE CUSTOMERS INBOX. THE DATA USED WITH THE CREDIT CARD IS RETRIEVED FROM THE DATABASE AND A PROFILE PAGE IS CREATED FOR THE CUSTOMER BASED ON THAT DATA. Ø IF, DURING REGISTRATION, THE CREDIT CARD IS DECLINED, THE INFORMATION IS STILL CAPTURED IN THE DATABASE. A CUSTOM MESSAGE (WHICH I OR THE CREDIT CARD PROCESSOR WILL PROVIDE) APPEARS ON THE SCREEEN AND IN THE CUSTOMERS INBOX THAT OFFERS THE CUSTOMER OTHER PAYMENT OPTIONS. THE DATA IS ARCHIVED FOR MARKETING PURPOSES BUT NO PROFILE PAGE IS CREATED. Ø IF, DURING REGISTRATION, THE CREDIT CARD IS SUCCESSFUL, THE USER IS SENT TO HIS/HER PROFILE PAGE. ONCE ON THE PROFILE PAGE THE USER WILL HAVE THE ABILITY TO PERFORM THE FOLLOWING ACTIVITES: o INITIATE NEW PROJECTS (REQUEST A PROPOSAL). o RESET PASSWORD. o ORDER NEW PRODUCTS/SERVICES (CERTAIN PACKAGES WHICH I WILL PROVIDE). o VIEW ALL PROJECTS (OPEN AND CLOSED). I. MAKE PAYMENT ON OPEN PROJECTS. o VIEW ACCOUNT ACTIVITY (PAYMENT HISTORY) FOR ALL PROJECTS. o VIEW/MODIFY COMPANY PROFILE. o VIEW/MODIFY PRIMARY CREDIT CARD PROFILE. o ALL OF THIS DATA IS DATABASE DRIVEN. o QUESTION: ONCE LOGGED IN TO THE ECOMMERCE SIDE, HOW WILL WE HANDLE THE SITUATION OF THE USER ACCESSSING THE FLASH SIDE? I. THE “LOGIN” FUNCTION. DATABASE DRIVEN. FROM THE HOMEPAGE THE USER HAS THE ABILITY TO “LOGIN” OR “REGISTER”. II. THE “PASSWORD LOOKUP” FUNCTION. DATABASE DRIVEN. FROM THE LOGIN PAGE THE USER HAS THE ABILITY TO HAVE THEIR PASSWORD EMAILED TO THEM. DUE TO THE FACT THAT CREDIT CARD INFORMATION MAY BE STORED HERE, THE PASSWORD LOOKUP SHOULD FURTHER CHALLENGE THE USER, WITH MAYBE A SECRET QUESTION. III. THE “REGISTRATION” FUNCTIONALITY. DATABASE DRIVEN. FROM THE LOGIN PAGE THE USER CAN ACCESS THE “REGISTRATION” PAGE. ON THE “REGISTRATION” PAGE THE USER CAN CHOOSE CORPORATE –OR- HOME/HOME USERS REGISTRATION. THIS IS WHERE THE REGISTRATION FUNCTIONALITY OUTLINED IN THE “EXECUTIVE SUMMARY” COMES INTO PLAY. IV. THE “OPEN ACCOUNTS” FUNCTIONALITY. DATABASE DRIVEN. THIS ASP PAGE DISPLAYS OPEN PROJECTS AT THE TOP OF THE SCREEN AND CLOSED PROJECTS AT THE BOTTOM OF THE SCREEN. THE OPEN PROJECTS ALLOW THE USER TO MAKE A PAYMENT ON THAT PROJECT. EACH PROJECT IS A LINE ITEM ON THE PAGE. EACH LINE ITEM HAS THE FOLLONG ATTRIBUTES: o PROJECTID o DATE OPENED o PROPOSAL o PRODUCT/SERVICE o BALANCE DUE o MINIMUM PAYMENT o MAKE PAYMENT V. THE “RESET PASSWORD” FUNCTIONALITY. DATABASE DRIVEN. SPEAKS FOR ITSELF. VI. THE “ACCOUNT ACTIVITY” FUNCTIONALITY. DATABASE DRIVEN. EVERYTIME A PAYMENT IS MADE, THAT TRANSACTION IS PASSED TO THE DATABASE. THIS PAGE DISPLAYS ALL PAYMENTS, CREDITS AND CHARGES BY CREATIVITY & MAGIC. THIS COVERS ALL PROJECTS FOR AN ACCOUNT. VII. THE “ORDER NEW PRODUCTS/SERVICES” FUNCTIONALITY. DATABASE OR STATIC PAGE. THIS PAGE IS A LISTING OF EACH PRODUCT AND SERVICE AND HAS THE ABILITY TO ADD EACH SERVICE TO THE SHOPPING CART. WHEN YOU CLICK ON THE NAME OF THE PRODUCT THERE IS A POP-UP WINDOW APPEARS WITH A DESCRIPTION OF THE PRODUCT AND THE DIFFERENT PACKAGES/PRICES AVAILABLE. VIII. THE “VIEW/MODIFY COMPANY PROFILE” FUNCTIONALITY. DATABASE OR STATIC PAGE. SPEAKS FOR ITSELF. IX. THE “CREDIT CARD INFORMATION” FUNCTIONALITY. DATABASE OR STATIC PAGE. SPEAKS FOR ITSELF. X. THE “ACCOUNT VS PROJECT” THEORY. AN ACCOUNT MEANS A COMPANY OR A PERSON (IN THE CASE OF A HOME USER). BUT WITH VERY LARGE COMPANIES LIKE THE UNITED STATES GOVERNMENT IT COULD GET CONFUSING. EACH ACCOUNT HAS A UNIQUE ID. A PROJECT MEANS AN IT INITIATIVE WITHIN A COMPANY OR HOUSEHOLD. EACH PROJECT HAS A UNIQUE ID. XI. THE “INITIATE NEW PROJECTS (REQUEST FOR PROPOSAL)” FUNCTIONALITY. DATABASE OR STATIC PAGE. THIS PAGE WILL WE COMPOSED OF FIELDS THAT CAPTURE ENOUGH INFORMATION TO BUILD A PROPOSAL. UPON SUBMISSION THE INFORMATION WILL BE PASSED TO THE DATABASE AND AN EMAIL WILL BE SENT TO ME THAT CONTAINS THE DATA. I WILL SEND YOU THE FIELD NAMES SOON. XII. THE “MAKE PAYMENT” FUNCTIONALITY. DATABASE OR STATIC PAGE. THIS PAGE ALLOWS THE USER TO MAKE A CREDIT CARD PAYMENT (HOPEFULLY, THE CREDIT CARD INFORMATION IS CACHED) AND REDUCE THE BALANCE ON THE PROJECT AND ADD THE PAYMENT THE PAYMENT HISTORY TABLE.