I have an orders table, which currently stores the product ID and the quantity.

However, should the product be removed from the site, then when getting the data for the order, there won't be a relationship between the order and products (product no longer exists). 

What is the best way of rectifying this? Do I need to store the product name etc with the order?