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.
Add to database – records will be added to a database, which my then be viewed and printed by source and date.
Email – records may be emailed to an email address. The email address would be specified individually for each
Add to autoresponder – leads may be added to an auto responder. The autoresponder would be specified for each
Records For Each Customer:
The script will be running on a server with PHP 4.4.2 on Apache with MySQL 4.1.21. Cpanel is the control
We have access to an SMTP mail server.