Customers at the supermarket giant, which is rivalled by Lidl, were gutted after a store favourite vanished from shelves across stores in the UK.