It's remarkable how you can enter specific details about an item, including manufacturer SKU, and get complete nonsense as search results.
”Remarkable” really is the right word for it. It’s impressively bad. I’ve experienced the exact same thing, where even a specific SKU doesn’t find the right item (even if they have it, with the same SKU saved in the item’s metadata).
I’m sure part of the search sucking has to do with the fact that third party sellers can modify the dataset: if they add the ASIN (Amazon Standard Identification Number) to their list of items they sell, they can then modify the authoritative metadata of that ASIN. This is how they steal obsolete listings for highly-rated products, resulting in an ice cube tray becoming a trashy smartphone gimbal, with the hundreds of positive reviews of the former outweighing the overwhelmingly bad reviews of the latter.
But even when not used for outright fraud, third party metadata editing is likely how we end up with inconsistent product options, with some variants missing and listed as their own separate item, while other variants are listed multiple times, etc. I wonder whether former/discontinued variants are still considered in the search, perhaps due to reviews. Maybe the content of reviews is also part of the search index.
Either way, what a goddamned joke it’s become. Thank goodness that, at least for consumer electronics, computers, cameras, etc. Switzerland is now one of the cheapest countries in Europe to buy in, so that there’s no need to import and I can happily use a local online shop whose standard shipping will have the goods at my door by the next day.