Onions and Shallots are very similar in structure and density, however, shallots are sweeter and slightly milder in flavour (so they wont make your eyes water!). If you're deciding which one to pickle then think about sharpness; onions are sharper and have a more 'traditional' pickled onion flavour whilst shallots are milder with a slight garlic flavour.
eBay