We require a Domain Renewal Management system
1) to quiery our online accounts with suppliers such as Networksolutions, Srsplus, Nominet and CentralNic and produce a list of all customers due for renewal in the next 4 months.
2) Using a lookup table to map Domain to Company details, generate a paper based renewal letter for each Company (a4, details the domains and asking for payment details)
3) To manage a database of which customers havs renewed/canceled/not replied and if they have not replied with in one month, generate a urgent reminder letter.
4) to offer our system admin the abillity to renewal the domain with the relivant registry from the management interface and send emails to the billing department to confirm they should bill the client for the domain.
5) tools will need to be provided to manage the two letters (we have used fckediter for simalar requirements).