Tuesday, September 14, 2010

What data should I keep in my database for my online store?

I am building myself an online store front (using PHP and MySQL) and I need to know what fields to add to my database so that I can track all the data I need to. What data should I record for my inventory? My orders? My customers? Is there any specific data that I should not record? Opinions from anyone with experience maintaining a database for an online store would be greatly appreciated.