How Would You Structure This?

[eluser]xwero[/eluser]
It seems like a fairly easy thing to do.

For the frontend you would have one page for this where the first product in the list is shown with the possibility to buy it. For the backend you would have a page where they see the list of products which they can alter and a part where they can add products to the list from their product list. Then you would have a page where the can add and delete products.

For the database i would say at least 3 tables : products, productlist, orders. But it depends on which data they require. If they want to keep previous stocks, if they would have centralized customer data, ...