Working as an engineer in the manufacturing industry I very regularly have to use completely horrendous websites but one day I came across this beauty. Nearly half a million products and it works like a charm.

McMaster-Carr


PS Whats the architecture behind it? I'm new to this game.