The supermarket is set to close in the coming months following a costly refurb in the last two years as a new mega store will take over the 15,000 square foot space