Amazon.com - A Programmer's RantFri, 16th Mar '12, 4:07 pm::
Amazon.com, we need to talk. I love your service. I happily pay $79/year for Amazon Prime to get free shipping and on-demand video rentals. I buy something from you every week and spend thousands each year on Prime Eligible products. I even used your EC2 AWS service when I had to crunch through a lot of data during my research for KType. So it hurts me to tell you that you have the worst product sort and filter interface that I have ever used. Not because you do not have enough features or the interface is confusing or bland, but because you do it wrong. Here's what's wrong with a typical search on Amazon.com:
1) Incorrect sort order: I searched for 'cat food', filtered for only Prime-Eligible items, and sorted it by Price: High to Low as you can see in the first screenshot. I don't think $34.89 > $38.99 > $39.74. I understand that behind-the-scene, you are trying to calculate the lowest price offered either by you or a 3rd-party vendor and applying lots of complex calculations based on item characteristics, bulk quantity, and other parameters to make sure each item price is calculated correctly but that is not what I asked for. I said Prime-Eligible for a reason - I want to buy directly from you and I don't want to pay for shipping. Most of your 3rd-party vendors charge slightly lower than you but charge a lot for shipping. You need to ignore their prices when I choose "filter for prime-eligible, sort by price"
2) Broken filters: Why is the second item in the first screenshot even shown? At first glance, it doesn't have a price, it is not prime eligible, and it doesn't even seem to be sold directly by you. When I dug in, I found out that Amazon.com does sell this item directly, with free shipping for $42.84. If that is the case, then it should have said Prime-Eligible and shown up higher up in the sort order. Look at the second screenshot. I searched for new, Prime-Eligible 'tv remote' under $25. Why is the first item you show me priced at $69.95? What about the second and third item that are missing prices?
3) Unavailable sort: Why do I have to "Choose a Department to enable sorting"? Why do I have to decide if "disposable nitrile gloves" are categorized under "Health & Personal Care", "Home & Kitchen", "Automotive", "Industrial & Scientific", or "Patio, Lawn & Garden" by you or other 3rd-party vendors before I can sort by price or customer review? Especially since the same products show up in most of the departments. If external sites can do this using your API, why can't you?
It's 2012. Sorting and filtering at the most basic database operations. You created A9.com - a product search engine. You enable programmers around the world to use your servers at low-prices so they can build complex websites backed by your RDS and SimpleDB database services. You have some of the smartest developers around the world working for you. And yet I get frustrated every time I try to find something on your site. I can't be the only person who has a problem with the aforementioned issues. Can you please fix them so my cats don't go hungry? Think of the kittens!