How to request your amazon order history data in bulk
Who’s this for: Anyone who’s bought something off amazon and is filing an insurance claim for the contents of their residence in need of listing an inventory.
What’s this for: Assist in itemizing your belongings purchased from Amazon as well as parsing out the replacement cost data from every amazon purchase you’ve ever made. This can help to fill in the blanks for items owned and lost that need to listed for insurance companies in order to be replaced.
How does it work: You can request Amazon to send you a file with all of your order history data. The data will arrive in the form of a spreadsheet (.csv) which can then be converted into a Google Sheet and collaborated on by any family, friends, and support people assisting with organizing an insurance claim. The processing time can vary, we’re seeing an average of 90 mins from request to receipt.
Why does this level of data matter?: It can be very difficult to remember the entire contents of one’s home, and credit card data won’t include each item in an amazon order so hopefully this information can help provide additional insight. Additionally, the more data you can provide about each item in your claim, the more information the insurance company has to accurately compute replacement cost data. (fyi this is not legal advice).
What you’ll need:
10-15 Minutes of prep
Your amazon login
Google Drive/Dropbox/Access to a computer connected to the internet
Ability to open a .xls file (Google Sheets, Microsoft Excel, Numbers)
Where to start
Here’s the link to begin and you’ll find instructions below.
This doc is best viewed on a desktop or in the Google docs app on a mobile phone iPhone app Android App
(Please see the Resources section below for an alternative option using a chrome extension if you prefer to try that route, we’ve seen mixed outcomes)
Sending love to anyone needing to use this <3
**FYI The author of this doc is not affiliated with Amazon or any insurance company in any way and is merely providing this public information in an organized way in hopes of helping out and reducing mental load during these difficult times.
Note: If you share your amazon prime account with friends or family the notification and verification emails may be sent to them.
Note: This doc will evolve as new information is gathered
Table of Contents
1. Log into your amazon account
2. Click link https://www.amazon.com/hz/privacy-central/data-requests/preview.html
3. Select data category: Your Orders
5. Receive verification email and/or message within the Amazon app or site.
6. Navigate to My Account to view
7. In Account Click Your Messages
8. Click message Your Data Request Confirmation
9. Click Confirm Data Request button
10. Receive Confirmation > Click Contact Us
11. Write & send message describing your urgency
12. Monitor email & Amazon Messages click Your Data Request message
13. Click Download Data button
14. See File Name .zip and click Download button
15. Locate downloaded file Your Orders.zip and click to unzip (typically in Downloads folder)
16. Open Your Orders Folder to view
17. Click to open folders Digital-Ordering
18. Click file Digital Items.csv which is a spreadsheet to open
19. Upload File and convert to Google Sheets
Instructions
Log into your amazon account
Click link https://www.amazon.com/hz/privacy-central/data-requests/preview.html
Select data category: Your Orders
Click Submit request
Receive verification email and/or message within the Amazon app or site.
Navigate to My Account to view
In Account Click Your Messages
Click message Your Data Request Confirmation
Click Confirm Data Request button
Receive Confirmation > Click Contact Us
Write & send message describing your urgency
This is just an example of text to include, feel free to adapt for your purposes.
Monitor email & Amazon Messages click Your Data Request message
Average wait time we’re seeing is ~90 mins
Click Download Data button
See File Name .zip and click Download button
Locate downloaded file Your Orders.zip and click to unzip (typically in Downloads folder)
Open Your Orders Folder to view
There will likely be many files depending on how long you have been a customer and what types of purchases you have made.
Click to open folder(s) Digital-Ordering
Click file Digital Items.csv which is a spreadsheet to open
You may need to save to Google Drive to open in Google Sheets if you do not have Excel Software or Numbers app on your device.
Example file (link)
This will have an enormous amount of data, some useful, most not. If you scroll all the way over on the right of the sheet, you’ll be able to see the Product Name column. I recommend clicking and dragging that column to the left all the way to column A. There are many columns with information that you can delete.
The columns to keep
Order ID | Unit Price Tax | Payment Instrument Type |
Order Date | Shipping Charge | Shipping Address |
Unit Price | Total Owed | Billing Address |
Upload File (.csv) and convert to Google Sheets
By converting the file to Google Sheets you’re able to access it anywhere from any device with connection to the internet as well as share and collaborate on it with any folks helping with your claim.
How to Import CSV to Google Sheets? - Layer Tutorial
What to do next
While every claim is different and every insurance company handles this process differently, you will most likely copy the line items from this spreadsheet into your primary inventory of your home’s contents. This may be in a spreadsheet from your insurance company or public adjuster, or within your insurance company’s online claim portal.
Below are some helpful links for some carriers
State Farm
Home & Property Inventory Tools
CA Property Inventory Blank Spreadsheet .xls download link (this is likely a useful template for organizing your inventory for any carrier)
USAA
Resources
- Amazon Order History Reporter - Chrome Extension that may be able to do this for you as well - https://chromewebstore.google.com/detail/amazon-order-history-repo/mgkilgclilajckgnedgjgnfdokkgnibi