I need a recurring billing system for osCommerce stores. When a customer is checking out, the system should ask them if they want to automatically repeat their order and give them options for how often (ie, once weekly, once every 2 months, customer's choice). If the customer chooses to repeat their order, their credit card number must be stored encrypted in the database. The automatic orders will then be entered into the system one week ahead of time, the customer will have the option to modify or cancel the order before it is placed. If no action is taken the order will be automatically placed and the customer's card charged.
As described in the summary, customers will have the option to make their order a recurring order.
Before the recurring order is due, an email is sent to the customer describing their recurring order and giving options. Admin can define a configuration constant for how many days ahead the email should be sent.
If customer logs in after the email is sent and before the order is placed, customer can modify/add to/cancel the recurring order. Customer must be able to place a separate order during this time also, leaving the recurring order in place.
Customer must be able to see all recurring orders at any time through the "my account" screens. Also in this area, allow the customer to modify his recurring order (add or remove products, change quantities) for the next renewal. Customer must have the option to cancel recurring orders. Store admins need the ability to see, modify and cancel any recurring orders through the store admin panel.
Assuming customer has not canceled his recurring order, the order must be inserted into the database and the credit card charged on the prescribed date. If the customer's card is declined or the customer has no card on file, insert the order into the database with a different status (which is defined in a configuration constant) for store admins to process. Send an email to the customer detailing his order and its status (paid, not paid, ready to ship or not).
This project should be completed as a modification to osCommerce [url removed, login to view], which can be downloaded here:
[url removed, login to view]
-all new or modified files
-SQL file with all database modifications
-text document describing the changes to be made to existing files and how to manage the recurring billing orders
If necessary I can provide a working environment on my servers with osCommerce pre-loaded.