The missing word is 'at'. The sentence should be: 'The shop opens at the weekend.' This is because 'at' is used to specify a particular time or point in time.