In the past I sometimes wanted to repurchase some product that I’d previously bought on Amazon, but couldn’t find it with the Amazon search facility. So I created a database to record all of my Amazon orders. One line for each purchase. Each line has five fields:
* Product description
* Order date
* Price
* Order number
* Product URL
I can sort the database by any field. That makes repurchases easy, and makes it easy to see price changes.

Until a couple of weeks ago the URLs were long causing line wraps in my database display. But now they’re much shorter – no more line wraps. An example of the new form URL:

https://a.co/d/ba22jUM

Not to spoil your love affair with the short URL's but do you realize that Amazon keeps a record of all your purchases forever and even provides a button to automatically reorder any item from any previous order. The orders are also fully searchable. It is located in your account history stored by year of purchase.

^^^^^^^
I do know of that, but my database works better for me.

The Amazon Search Orders function is something I’ve found useful for years.

But I love a good searchable and sortable database.

quote:

Originally posted by straightshooter01:
Not to spoil your love affair with the short URL's but do you realize that Amazon keeps a record of all your purchases forever and even provides a button to automatically reorder any item from any previous order. The orders are also fully searchable. It is located in your account history stored by year of purchase.

I like keeping records too but since Amazon does it for me already, I don't bother. The Search function on My Orders works wonderful for me.

As noted, it sounds like you're just spending time duplicating Amazon's existing account order database functionality. But if that's what gets your rocks off, then you do you.

However, saving the entire URL was even more unnecessary. You just needed to save the item's 10 digit ID number, the ASIN ("Amazon Standard Identification Number"). Think of it like a proprietary UPC number used by Amazon. You can enter that ID number into the Amazon search field, and go directly to that exact product.

For example, if the Amazon URL was "https://www.amazon.com/Trijicon-MRO-C-2200003-Miniature-Riflescope-Adjustable/dp/B013XADFXM/ref=sr_1_3?keywords=trijicon+mro&qid=1657813524&sr=8-3" then the collection of capital letters and numbers after "dp/" in the URL is the ASIN. In this case it would be B013XADFXM. Plug that ASIN into the search bar at Amazon.com, and you go directly to that exact item.

If parsing URLs is too troublesome for you, you can also find the ASIN in a product listing under the "Product Information" section about halfway down the product page. One of the entries there is "ASIN", where that number is also listed.

For the griddle scraper linked in the OP, the ASIN is B09PHP6ZP8. That ASIN is shorter than even the new short URLs...

quote:

Originally posted by Pipe Smoker:
^^^^^^^
I do know of that, but my database works better for me.

Whatever trips your trigger. Like the others: I just use my order history.

I placed 358 orders in 2021...and am on track for same in 2022.

I can't imagine being a slave to that spreadsheet.

I use MANY key words to find anything in my history using the Amazon function.

Yeah, sorry man but the Amazon search function will work much faster and is so easy to use.

Just last week I needed to replace a fluid transfer pump I bought there over ten years ago. It took about 15 seconds for me to find it.

Buy it again works great for me!!!!!

Also, be sure to price check your Amazon items.
Some are competitive and some are way more than other suppliers. For common household items many other sellers ship free with a minimum purchase amount.

quote:

Originally posted by thumperfbc:
The Amazon Search Orders function is something I’ve found useful for years.

But I love a good searchable and sortable database.

I use that feature often just never look at your yearly totals.

Guys, it's cuz Amazon's order history is the wrong pixel size. Leave him be.