Amazon purchases - importing and categorizing

Sal_Ohcin · ‎Nov 05, 2020

I’m looking to import and categorize my amazon purchases.
I have all of my purchases in a spreadsheet that I downloaded from Amazon (after I requested it). It lists each item by ASIN (a unique ID# for each product) but it does not include the category (e.g., Home and Kitchen, vs. Baby vs. Food, etc).
I can search by ASIN on a third party website (https://amazon-asin.com/) and it will give me the category.
Does anyone know how to write a script that can go to a webpage and retrieve the category text? I’m not good with writing code so curious if this is possible. And if so, can someone assist me or point me in the right direction?
Thanks so much

Bill_French · ‎Nov 06, 2020

Are you an MWS reseller?

Sal_Ohcin · ‎Nov 06, 2020

No. just doing it for personal finance reasons.

Bill_French · ‎Nov 06, 2020

Okay, three observations:

It is possible for a script to do this, but there are services out there that can do it for you (like Apify).
The script is not trivial and further, such activity tends to violate your ToS with Amazon. It’s not illegal per-se, but it is cause for termination of all access to Amazon.
The cost of acquiring such information for personal reasons is likely impractical given the benefit.

Sal_Ohcin · ‎Nov 06, 2020

Thank you @Bill.French for your thoughtful and very helpful response

Chris_Guthrie · ‎Nov 06, 2020

Basic product info can be obtained without the MWS API.

You should be able to use the Product Advertising API to get a lot of product information.

Although I haven’t used them, there are several Google Sheets solutions that can retrieve Amazon product information.

BlockSpring and Gorilla

M_k · ‎Nov 06, 2020

Hi @Sal_Ohcin

You could also look into using Integromat.

You will have to check it out and if it might cause any problems with Amazon.

Mary Kay