The Ovi Store for Nokia N900 is still not open to the public, but there’s a URL trick to let you see what’s inside using your desktop browser. As expected, there aren’t many apps available and you will not be able to download anything yet.
Thanks to Bruce from the Maemo forums for the tip:
When logged into the Ovi Store click this link.
It will set your device to N900. We cant download the apps yet but we can view them.
I hope to see more apps, games, and themes when the Ovi Store opens for the Nokia N900. I’m not sure when that will be, but one developer said they thought it was supposed to happen weeks ago.