One of the rainiest springs on record boosted soup sales while denting those for sun cream, figures suggest.