Amazon used to let you download a csv (spreadsheet) file with your entire Amazon order history. That option has been replaced with a “Request your data” page, which lets you download all different kinds of data, including your order data.
But instead of one spreadsheet, Amazon divides it into spreadsheets like orders, returns, digital purchases, and so on. So getting all that data compiled into one spreadsheet can take some time.
That’s where Tiller’s Import CSV Line Items workflow can help you save lots of time and make sure data is imported properly. Tiller connects your banks to your Google Sheets or Microsoft Excel spreadsheets and automatically tracks your daily spending, income, and balances in easy, customizable templates so you can manage your money your way.
The Tiller Import CSV Line Items workflow integrates with Tiller’s Foundation Template, which is an automated spreadsheet that imports data from many sources to let you track your finances all in one place. You can track your spending, control your expenses, and confidently plan your financial future. You can try Tiller completely free for 30 days.
How to download your Amazon order history
To access your Amazon order history, you’ll need to visit Amazon’s “privacy central” service. There you’ll be able to request a comprehensive record of everything Amazon knows about you – including your order history.
Amazon says it can take days or even weeks to send your data, but it often is available within a few hours.
They’ll send you a link to a zip file to download. You’ll unzip that file and get several folders with files in each.
Tiller’s Import CSV Line Items workflow automatically adds this data to your Tiller Sheet.
The Import CSV Line Items workflow can now read the Retail.OrderHistory.1.csv file in the “Your Orders” Privacy Central download. Note that this workflow is available only in Google Sheets, not Excel.
The workflow will walk you through the steps to get your order history into Tiller. You will need to do it once for purchases and once for returns since Amazon splits those into two separate files.
Note that those are the only two files that the Import CSV Line Items is able to handle. You may have other files in your Amazon data. To add those items, you’ll need to copy and paste the matching data into your Transactions Sheet. Unfortunately, there is no automated way to import those currently.
You can find more detailed information about the Import CSV Line Items workflow in our Tiller Community.
I’m seeing the same thing with my personal Amazon account too. I’ve started a chat/support request with them to see if they can remove the redirect.
They indicate:
I’ve just check with my lead there is some technical issue with that link we are already working on it please don’t worry we’ll solve the problem i request you to please try after 24-48 hours
I’m experiencing the same issue with Amazon History Reports. However, I do not believe that it is a Tiller issue. Just spent over an hour on chat w/Amazon, and they have no solution – it must be a problem on the Amazon end.
If you go to this Amazon help page: https://www.amazon.com/gp/help/customer/display.html?nodeId=201983330
The hyperlink for “Order History Reports” on this help page shows the URL: https://www.amazon.com/gp/b2b/reports . However, this URL redirects to the page: https://www.amazon.com/gp/your-account/order-history , which is the “Your Orders” page – this experience is the same as reported in the issues logged previously on this topic.
Thanks @heather! Hopefully they fix it soon!
Yes @houtexdavid definitely a Amazon issue (not Tiller). I just wanted to make sure it wasn’t an issue specific to me!
Well… that’s a bummer.
They hid the link in their Accounts page a month or so ago, but, as @houtexdavid observed, one could still access the CSV creator page via the link within the Tiller Money Labs workflow instructions.
With that link now redirecting, I’m not sure how we can get access. I imagine many Amazon customers will be disappointed to lose access to this feature.
P.S. It appears their support content has not kept pace with their ability to deprecate cherished features.