3 ms·

Can it connect to Amazon and extract my purchases and classify them? Almost all of our purchases are from Amazon these days and categorizing them as "Shopping"

by mdeeks 6y ago

Can it connect to Amazon and extract my purchases and classify them? Almost all of our purchases are from Amazon these days and categorizing them as "Shopping" or "General Merchandise" is almost useless. Someone please let me know if this exists somewhere. Aside from that I'd also love the ability to amortize some of these yearly payments I have. When you're trying to answer "How much money am I putting away each month" all of these random yearly, quarterly, one-time expenses end up ruining that.

cosmie 6y ago
Amazon doesn't expose that via an API, so the data you're after can't be gotten to easily. That said, there are a few options: - This[1] report from Amazon gives you an incredibly detailed export of physical purchases. Caveat being that digital-only goods are missing, as well as items which didn't ship (either because you or because Amazon canceled the item prior to shipment). So depending on your purchase patterns, it may cover substantially all your needs or have so many holes in it as to be near useless. - This[2] Github project exports your order history to a SQLite file. It's based on parsing/scraping the Order History pages themselves, so doesn't have the gap of the above report but also has the potential to break if/when Amazon changes the source code for the Orders page. The project hasn't been updated in several years, so no clue if the current parsing heuristics are valid or not. - This[3] Github project is also based on scraping the Order History pages, but is much more recent than [2] and still being actively developed. However, [2] is designed as a ruby script that syncs a SQLite database whereas [3] runs as a Chrome extension. [1] https://www.amazon.com/gp/b2b/reports/ https://www.amazon.com/gp/b2b/reports/ [2] https://github.com/chrisb/amazon-orders https://github.com/chrisb/amazon-orders [3] https://github.com/philipmulcahy/azad https://github.com/philipmulcahy/azad

by mdeeks 6y ago

cosmie 6y ago

Amazon doesn't expose that via an API, so the data you're after can't be gotten to easily. That said, there are a few options: - This[1] report from Amazon gives you an incredibly detailed export of physical purchases. Caveat being that digital-only goods are missing, as well as items which didn't ship (either because you or because Amazon canceled the item prior to shipment). So depending on your purchase patterns, it may cover substantially all your needs or have so many holes in it as to be near useless. - This[2] Github project exports your order history to a SQLite file. It's based on parsing/scraping the Order History pages themselves, so doesn't have the gap of the above report but also has the potential to break if/when Amazon changes the source code for the Orders page. The project hasn't been updated in several years, so no clue if the current parsing heuristics are valid or not. - This[3] Github project is also based on scraping the Order History pages, but is much more recent than [2] and still being actively developed. However, [2] is designed as a ruby script that syncs a SQLite database whereas [3] runs as a Chrome extension. [1] https://www.amazon.com/gp/b2b/reports/ https://www.amazon.com/gp/b2b/reports/ [2] https://github.com/chrisb/amazon-orders https://github.com/chrisb/amazon-orders [3] https://github.com/philipmulcahy/azad https://github.com/philipmulcahy/azad