In Pokémon SoulSilver, fossils cannot be bought at any shop or market. Instead, they must be excavated through gameplay:
Once obtained, take fossils to the Fossil Restoration Center on Route 8 (accessible after obtaining the National Pokédex). The scientist there will revive them into prehistoric Pokémon such as Omanyte, Kabuto, Aerodactyl, and more.
While you can't simply purchase them, the thrill of excavation and revival makes adding these ancient creatures to your team a rewarding adventure.