Customer Database Management

I need a script to compile and manage customer records for myself and my sales agents. The script will compile customer records from various places, and each source will be setup to handle customers slightly differently. Sources: There are two types of sources that the software must compile data from: Company provided site: This is a site provided by the network marketing company. This site processes retail orders and member orders (which will have to be handled slightly differently). I receive an email anytime an order is placed. These order alert emails can be setup so that they are sent to an email address that the software can have access to (an email on the same domain/server). The software must then extract the customer data from the order alert emails. The software must then login to the back office of the website and extract the rest of this information. The customer record is now complete and is sent along to be processed. Mal's Ecommerce: We also have sites which use the Mal's Ecommerce shopping cart. The orders placed through this system are sent via email. The script can extract all the necessary data from the email, then send the record along for processing. Notes: The software must support multiple sources - each source has to be treated as separate. Each Mal's E source would have a unique email address. Each company website source will have a unique email address / account number combination. I must be able to easily add sources. Data Processing: Once the customer data is extracted from the various sources, it is then processed. The following are processing options that need to be supported. I will set which processing options should be used for each specific source. The rest of the project description is contained in the attached file. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Technical Info: The script will be running on a server with PHP 4.4.2 on Apache with MySQL 4.1.21. Cpanel is the control panel software.