Hi, I'm reasonably skilled at VBA and have studied iMacros and have used it for an iterative purpose, but I'm unclear how to get started on this:
I want to end up with a table of my Amazon.com purchases; from there, I'll filter and sort to create reports on purchases I've made for an advocacy (read: volunteer) project. I've made probably 150 or so purchases over the past few years. I think that such a report is available for "commercial" type accounts. Mine isn't such an account, it's simply a regular consumer account. I've asked customer service a couple of times, and have been told that there's no download available, at least for regular accounts.
After logging into Amazon, I can pull up order history information, but there are various challenges. These include:
There is no "all orders" capability. Using a drop down, I can choose from:
Open and recently placed orders
Orders placed in the past 6 month
Orders placed in 2008
Orders placed in 2007
Orders placed in 2006
Orders placed in 1998
A comprehensive set presumably would be to use "Orders placed in 2008" through "Orders placed in 1998"
This project started in 2003, so I "only" need 2003 through 2008.
Another challenge is that the orders for a given year don't necessarily appear on a single page. For example, for 2008, the bottom of the page says:
"More Orders: 1 | 2 | 3"
And in that sentence, "2" is a link, and "3" is a link. ("1" is not a link, presumably because it presently is being displayed.)
Each page is a report of "orders". Let's call this an "Orders Report Page" and the entire set of pages for a given year the "Orders report".
The number of orders on an Orders Report Page varies, due to that a given order can have more than one item.
In the Orders Report Page itself, no price is shown. Additionally, the amount of info about the title and author varies; it appears, for example, that if there's a long title, the author info isn't shown.
For each order, there is a "View Order" button. Clicking it brings one to what I'll the Order Report.
As mentioned, an order can have more than one item.
Within the Order Report, each item is listed. I'm unsure whether long orders end up having multiple pages.
Within the Order Report, items with long titles have only a truncated title. The title text is itself a link to the item's "regular" page (containing a picture, reviews, links to ordering from 3rd party sellers, links to other editions, etc.).
Within the Order Report, each item's author is shown--um, that is, if there is an author. It appears that if an item isn't a book or the like, then there is no "By: " and no author listed. Multiple authors might be listed.
My goal is to end up with the following fields:
(ideally) published date
(ideally) shipping cost. (Note--for part of the period, I had Amazon's "prime" service, such that I paid an annual fee and had [two-days] no shipping charge for items I bought from Amazon (rather than 3rd parties).
(ideally) link to the item's regular page
Nice-to-haves would include shipping costs. Oh, and the editorial reviews, and the top-rated reader-written reviews.
This all seems so complicated that I thought I'd start out with an inquiry post, hoping for some combination of that someone's already got this running, or to get feedback on whether it'd be faster simply to "scrape" this info manually rather than trying to build an iMacro.
This is my first post here. I'd welcome any feedback (including negative, of course).