We are in need of a script that can export a list of customers from a Magento database based on a list of SKUs they purchased. Our goal is to setup an automated script that can send leads to our sales people so they can import them into their CRM system.
**Example of how the script must flow:**
Every 15 minutes export (in CSV format) a list of customers who bought SKU 01-SCC-1011 or SKU 01-SCC-1012 since the last export and email the results to someone.
**Deliverables:**
1) App must export complete customer information (Company name, first name, last name, phone number, email address, address1, address2, city, state, zip)
2) App must export the quantity, SKU and SKU name (only export SKU info based on query)
3) App must be able to be schedule at a custom increment (e.g. every 15 min, every hour, every day....)
4) Must be able to add a list of SKUs to query on (e.g. 01-SSC-1011, 01-SSC-1012....)
5) Must be able to specify email address to send the CSV file to.
6) All send emails must be CC'd to an additional email address.
7) Must be able to setup multiple export scripts.
## Deliverables
PHP script
Can be executed from CRON