The supermarket has apologised for the inconvience caused