A couple of months ago you quoted to build a database for me which would fill the criteria below. I have been away for a couple of months and would now like to hire you for the job. You quoted $299.
Would you still be interested?
The job is as follows and would need to be very user friendly and expandable in the future to integrate with 1 shopping cart and processing through a DVD fulfilment house. At a future date we would like to automate everything as much as possible i.e. take the initial order. plug the customer into the database the try to automate from there.
Here is the initial project:
We will be launching a DVD home study course consisting of 14 DVD's. One DVD to be sent out to each customer per month until they have received the full course over a 14 month period.
The database would need to handle recurring billing. We would require the database to be able to handle the following tasks:
To be able to enter customer details such as general contact details
To be able to list on a daily basis which customer requires which DVD and when. ie. customer A requires DVD #7 on 28th October 2013
To be able to record when a particular DVD was shipped.
To be able to list if a specific customer has paid for a particular DVD before we ship
To be able to handle 10,000 individual customers
To be able to handle recurring billing. i.e we receive the first payment from the customer and ship DVD1, the following month we receive the second payment from the customer and ship DVD2, month 3 we receive payment and ship DVD3 and so on.
We use Macbook pro laptop computers so the system would need to be compatible with Mac OSX 10.5 if desktop based. An online app would also suffice.