This workflow allowed users to break Amazon transactions with many disparate parts (e.g. food, protector, and syrup) into discrete transactions for granular categorization. To pull these line items into their spreadsheet, users simply visited Amazon’s Order History portal, downloaded the CSV, and imported that data into the TCS add-on.
Today, I updated the Import CSV Line-item workflow to read the Retail.OrderHistory.1.csv file in the “Your Orders” Privacy Central download. The data mapping isn’t exactly the same as the previous version of this tool but it is really close.
Do not miss the first bullet about Amazon Fresh purchases below…
Some Important Notes
The old report did not include Amazon Fresh purchases— that data is now interleaved with the rest of your Amazon purchases— and these can be really high volume. Inexplicably, these purchases are identified in the CSV as coming from the “panda01” website. I added a filter for those of you who want to remove these items from your import (see screenshot at bottom).
The old report was based on a user-selected time range. The new report will contain your entire Amazon history, slowing down performance of the initial upload step considerably (it now takes several minutes for me). You may also want to use the Start Date filter to avoid importing very old transactions (e.g. beyond the beginning of your spreadsheet’s time range).
I believe the part of the workflow that excludes purchases that match previously-imported transactions still works (across old- and new-workflow records)— please let me know if you find this not to be the case and are seeing duplicates.
The new Privacy Central CSV includes information on Amazon returns, but I have not yet updated this import mapping. I hope to get to that in the coming weeks.
This import workflow is currently only available in Google Sheets.
I hope this helps those of you who miss the old workflow.
Looks very neat. Do you know if it includes Amazon.ca (Canada)? I am hoping it does since you referenced maple syrup in your post!
Edit: I just checked, and there is an option to download data via Amazon.ca, but after I confirmed, it gave me this message: We will provide your information to you as soon as we can. Usually, this should not take more than a month.
The site says it can take days or even weeks but mine took about 24 hours. As you all receive them, let us know what your experience is in this thread.
P.S. I’m not sure on the Amazon Canada import, @galatic_incipient. Unfortunately, I’m not clever enough to hide maple-leaf emojis as confirmation that it is working. (I like your sleuthing instincts though.) Let me know how it goes for you.
Thanks for the update! I just set it up and it works great. I just have to change my existing Amazon charge to “Amazon” and the rest to whatever. I did pull in all Amazon, including Fresh, etc. which I like since I occasionally might purchase stuff in person that’s not groceries, so it’s a bit more detailed if I want.
I actually preferred not to filter since I had to change the original transaction from my card to “Amazon.” So I started from 2023 and then just scrolled down until I saw blank categories and put in the correct category and the CC transaction I switched to Amazon.
I requested mine earlier today and got an email to download within ~2 hours. Over 1500 orders dating back to 2001! I think I probably had other orders before this that they lost track of. The very first thing they have record of me ordering? “Hamilton Beach TrueAir Plug-Mount Odor Eliminator with 3 Replacement Filters”. What the heck was going on in my life on that day…