This project is a renovation/expansion of an existing system...
Website and Opportunity Overview
The website allows subscribers, both trial and paying, to have access to premium stock trading content. The site is built in HTML and PHP and utilizes a MySQL database to store customer information, enable dynamic data on the website, and transfer data to necessary third parties. The site was originally constructed for one service offering, but now needs to be able to accommodate multiple different services. Enhancements to the membership administration and access control are also needed.
Current Website Components
1. Customer Registration – Subscribers join the website in one of two ways: (1) through a trial subscription, and (2) signing up directly. Website allows trial registrants access to the site for a set period of time, after which registrants are prompted to pay for access or let their trial expire. All information is contained in a MySQL database and administrators have access to view and edit data through membership administration pages (see below).
2. Payment Processing – Customers who wish to purchase a subscription with a credit card do so through the website. Subscribers are able to choose from several payment options and also receive specially subsidized rates. The actual payment processing is handled by a third party company (LinkPoint), but the Market Insider website handles all data transfer and receipt from the payment processing company.
3. Access Control – Individuals requesting content must possess a unique username and password in order to access it. Once logged into the site users are able to access many different features without having to resubmit their credentials. Additionally, all administrative functions are protected by a similar system and require certain rights be granted to them by controlling administrators.
4. Member Communication – A primary function of the website is to communicate information to subscribers. All communications originate from the administrative portion of the website and are archived for members to view. Communications are both regular as well as ad hoc and are sent through the website's email server.
5. Membership Administration – There is currently an administrative portion of the website which controls the membership database, manages membership communication, and marketing efforts.
1. Introduction of Additional Customer Groups and Services
The website is currently built to handle one customer group with one membership service. Development is needed to expand the service offering, allowing multiple subscriptions per member. The process for adding new services should be easily scalable to meet future needs. Additionally, each new service will need to be able to be customized, e.g. possess different trial period lengths, offer different discounts, etc.
2. Customer Database Expansion
Customer information is currently contained in one database, but with the addition of additional service offerings the database must be expanded to accommodate such a scenario. For instance, a customer might belong to several different services, but would possess one single account on file. Additional reporting metrics and methods would need to be developed to accommodate the multiple service offerings.
3. Expansion of Payment Processing Capabilities
Payment processing is currently set up to handle only one product. Development would have to be done to allow multiple items to be passed through for payment and to process and document multiple payments from customers. Information currently is posted to payment processing site and returning information must be parsed in order to enter into customer database.