Re: database design for webstore with over 2000 products
So you can keep track of product discounts.
Just sit down and think what you need to know about your store. You need to know the product name, a description (maybe short and long), a price, quantity in stock, attributes. If you sell nothing but t-shirts, the attributes will be fairly simple. If you have a large variety of different products, you'll need a more complex system of storing product attributes, likely creating a few more tables.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.