Bars in the Northern Quarter have been forced to stock up on their most popular seller - but some haven't been so lucky