Extract Amazon Affiliate earnings script
My earlier posts have been about creating links to Amazon that are localised in WordPress, see my posts here and here. One perk of using the excellent Amazon Link plugin for WordPress is that I get a small commission for items sold through the Amazon Affiliate program. It is not much, but it keeps this site running plus a cup of coffee or two a year. I have an Amazon Affiliate account in
- United States
- United Kingdom
I can log into each site and get a report telling me how much I earned in the local currency. These site use different currencies, we have American dollars, Canadian dollars, British pounds, European euros and Chinese yuan. But I just needed a very simple number, how much is my total commission across all the sites in my local Danish currency? For this purpose I found a PHP framework called Open Affiliate Report Aggregator (OARA)1 to create a small script to extract the information from each site and use google currency converter to sum the total to my local currency.
When executing the script using three Amazon Affiliate accounts (US, UK and DE) one gets the following simple output
Notice that the final output is the ~13 USD and ~5 EUR summed and converted into Danish kroner.
- Follow the installations instructions found on the PHP-OARA GITHUB here
- Download the file
AmazonAffiliateReportExtractor.phpfrom GITHUB here
$credentials["password"]to match your login to Amazon Affiliate. This scripts assumes that you use the same login and password for all sites. I recommend you create a serviceuser account with limited access if you are going to have any password in a script
- Set which currency you want the final result in
- Add a name for the report in
- For each Amazon Affiliate account you want to login you need the following four lines. Change only the first and second line to the corresponding Amazon locale and currency
Run the script by invoking it
You should get an output similar to the example above. If you want this report mailed every month you can use CRON like this (assuming sending mail has been configured, I use Googles SMTP server for this):
This setup sends me a short report every month to my email with all my Amazon Affiliate commissions summed into a single total in my chosen currency. This means I spend less time logging into my 8 Amazon Affiliate account and manually extracting the numbers, converting them into a common currency and calculating a total. If you know of a better way to do this, please leave me a comment.
A few weeks ago, extracting data from Amazon.com always failed. I performed the change described here to patch php-oara and it worked again