We are an internet based business selling products through ClickBank (CB). We need a web-based reporting utility which will automatically e-mail an Excel-formatted report weekly containing data obtained from the CB API.
**Requirements**
1. Every Monday, the utility will gather a subset of data from a single CB account via the CB API. The utility will report on the sales & refund transactions for two specific product IDs (14 & 15) from the previous week (Mon through Sun).
2. Using the API, the report will gather the following data - Transaction Date, Transaction Type, Item, Country, State, Last Name, First Name, E-Mail & Phone Number
3. The utility will take the data received from CB's API & store it in a simple MySQL database (hosted on our server) that tracks data referred to above.
4. The utility will use the data stored in the MySQL database to e-mail an Excel-formatted or Excel-friendly CSV file as an attachment to the same two recipients every Monday morning (Denver Time). The recipient addresses will stay the same week to week.
5. The utility will have a web-front end so that we can look at the data & re-run the Excel / CSV export should something happen to the e-mail attachment.
6. The code must be well structured & most importantly commented.
**Additional CB API Info**
? [login to view URL]
? [login to view URL]
**Skills Required**
php, microsoft-excel, mysql, web-services, rest
**Essential Qualifications**
English Proficiency to level where you are able to carry on conversation about this project &/or project requirements via Skype. Accents are fine, we have accents too. :) We hope to establish a long-term relationship with a solid programmer who we can turn to for all of our Web Services API integration projects. The ideal c&idate will have enough availability to h&le 3-4 larger projects per month & is comfortable chatting via Skype (when needed) & can work from bullet lists of requirements & wire-frame mock-ups. The ideal c&idate will use his or her experience to underst& what we are asking for but at the same time ask questions so that we get to the same end point.