A notorious city pub where a former boxing champion was gunned down is set to reopen as a supermarket this week.

A Tesco Express is moving into the former Marmion pub in Gracemount, where Jamie Bain murdered 32-year-old Alex McKinnon and shot his brother-in-law, James Hendry, leaving him badly wounded, in April 2006.

The pub was put on the market in 2008.