83212 Affiliate Program Project

In Corso Pubblicato May 16, 2002 Pagato alla consegna
In Corso Pagato alla consegna

Background: [url removed, login to view] sells access to password protected directories on its website. There are reports on fitness in the various directories. Customers pay either a one-time fee or a recurring subscription fee to access the information. The software “Dreamaccount” manages the subscriptions and password protection of the directories containing the content that we sell. Transactions are processed through Cybersource. We need to integrate the software “Ultimate Affiliate” so that we can have affiliate websites refer customers to us and then we can pay them a commission. The RFP follows: Terms: ProfessorX: Apache Server Cyclops: MySQL server Dream Account: This PHP/MySQL program allows for subscription payments and/or one time payments for access to password protected directories on the ProfessorX server for a predetermined period of time. It has a web GUI that makes it easy to .htaccess protect directories and it handles recurring billing. Our hacked version is here: [url removed, login to view] DreamAccount Discussion Board [url removed, login to view] Dream Account Developer: [url removed, login to view] Ultimate Affiliate: This PERL/MySQL program allows for the management of an affiliate program. Signup to become an Affiliate [url removed, login to view] Ultimate Affiliate Discussion Board [url removed, login to view] Here’s the initial projects. 1. We need to integrate the Ultimate Affiliate Software with the Dream Account software so that we can run an affiliate program and pay our affiliates for the sales they make. 2. We need to enable the Replicated Websites feature for Ultimate Affiliate. Here are our next projects: 1. When creating a subscription, the system gives you the option to select the checkbox “Available to Shoppers?” “Available to Shoppers?” really means available for sale. When checked, a subscription can be sold, when not checked, a subscription cannot be sold. This feature is great, but we need the option to have a subscription be available to shoppers (i.e. available for sale) but not displayed in the list of subscriptions available to be purchased found on URL [url removed, login to view] Here’s why we need this feature. If we decide to change the price of a subscription, every customer who purchased a subscription in the past at an old price will have his or her recurring price adjusted to the new price. We want to leave the old subscription price in place so as not to affect the past subscribers, but remove it from the list of currently offered subscriptions so we can offer a new subscription at a new price. Keep in mind we need to be careful and think about how this will affect the .htpasswd file is there are multiple subscriptions accessing the same file in the same directory. 2. We need to be able to set the order of the subscriptions available to shoppers on the page [url removed, login to view] In the admin section, we need to be able to number our subscriptions 1., 2., 3., … on the page [url removed, login to view] so that they appear in that order on the page [url removed, login to view] Perhaps we could accomplish the goal of project 1, the previous project by allowing all subscriptions numbered 0 to be available to shoppers, but not to appear in the list of subscriptions for sale on page [url removed, login to view] 3. The reason is so that if we change the price of the content in a .htaccess protected directory, those purchasing with the old price will still be charged, but no one else will be able to buy at the old price unless the subscription is again made both available to shoppers and on display in the list of subscriptions for sale. Slowness of the order system As you will see when you view the admin section of the system, the performance of the system leaves a lot to be desired. We need the performance studied and improved. We can discuss this in greater detail later. Here are some of my thoughts on why the system is so slow. a) I think the admin section is so slow because the system is trying to “load” all of our user accounts into drop down menus. This will only denigrate over time and I do not see why this is even necessary. Instead it would be better to have a better means to query the accounts. b) When a new customer orders a subscription, I believe the system queries the entire MySQL database and regenerates the .htpasswd files by requerying the entire database – looking for all the users that should have access to that directory. Obviously, the more customers that purchase a subscription to a directory, the longer this will take. c) From Submit to billing a credit card until access to a directory is given, it takes a long time with no “we are now processing your order message.” It would be better to speed up the processing time and to have a “your order is being processed” message appear. Reporting Currently, there is not much in the way of reporting. We need the following reports: For a specified date range, we need to have reports of: a) The dollar value of all subscriptions for the specified period. b) The number and dollar value of each different subscription ordered over a specified period. c) The dollar amounts charged to each type of credit card (VISA, AmEx, Discover, MasterCard) over a date range. Functionality 1. It appears that there is no way to associate order numbers with customers. This makes if difficult to issue a refund. 2. It appears there is no way to issue a refund without going to Cybersource and issuing a refund directly. 3. The “Account Search” is poor. It should pull up all accounts that match a term. For example if someone’s last name is Willingham, it should come up in a search for Willing, etc. It should not be case sensitive. 4. Free trial. There needs to be a way to offer a free trial for say one week and then to have billing automatically begin after a specific date. It appears that the only way to cancel a subscription is for the customer to email us and for us to cancel it ourselves. This is not necessarily a bad thing. Lastly, we MUST be able to reach the programmer by telephone.

Odd Jobs Perl PHP

Rif. progetto: #1829669

Info sul progetto

Progetto a distanza Attivo Jul 11, 2012