PHP Script to Parse Your eBay Items Sold From Your Commission Junction Sales Report
Ok, this first version of the script is really crude, but is still very useful if you are curious what items on eBay you have received commissions from. This will spit out a list of item numbers with a link to each auction. It is a direct link without any affiliate info so you don’t have to worry about it affecting your CJ stats.
Download one of your sales reports and choose PIPE delimited file and save it as “cj.txt”.
Open it and remove the first line or two that looks something like this:
Date|Event_Date|Action_Name|ID|Action_Type|Status|
Corrected|Sale_Amount|CommissionWebsite_ID|
Website_Name|Ad_ID|Advertiser_ID|Advertiser_Name|
SID|Order_ID|Click_Date|Action_ID|Ad_Owner_Advertiser_ID
After you delete that, move the data below it up so that the first entry is on the first line.
Upload your cj.txt file and this script to your server and then open it in your browser like:
http://www.yourdomain.com/cj.php
That should do it… you should then see a list of eBay auctions that gave you a commission.
Once again, this is VERY crude… if anyone wants to add on to it, or knows of a better script, feel free to comment. The main thing that is needed is a script to process your Commission Junction reports that is NOT on someone else’s server… because you know for sure that person is looking through every report to see what niches are working and which ones are not.
Download the Commission Junction report script here