database design for webstore with over 2000 products

Reply

Join Date: Apr 2009
Posts: 281
Reputation: SKANK!!!!! is an unknown quantity at this point 
Solved Threads: 2
SKANK!!!!! SKANK!!!!! is offline Offline
Posting Whiz in Training

database design for webstore with over 2000 products

 
0
  #1
18 Days Ago
what do i need im a newb just wondering. have subscibed will be otofied of any posts.
Reply With Quote Quick reply to this message  
Join Date: May 2006
Posts: 1,824
Reputation: ithelp is a name known to all ithelp is a name known to all ithelp is a name known to all ithelp is a name known to all ithelp is a name known to all ithelp is a name known to all 
Solved Threads: 117
ithelp's Avatar
ithelp ithelp is online now Online
Posting Virtuoso
 
0
  #2
18 Days Ago
You need a table with product id , product name , description, price , coupon/discount ,etc .
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 281
Reputation: SKANK!!!!! is an unknown quantity at this point 
Solved Threads: 2
SKANK!!!!! SKANK!!!!! is offline Offline
Posting Whiz in Training
 
0
  #3
18 Days Ago
what would the coupon discont column be for?
Reply With Quote Quick reply to this message  
Join Date: Mar 2004
Posts: 763
Reputation: Phaelax is on a distinguished road 
Solved Threads: 38
Phaelax Phaelax is offline Offline
Master Poster
 
0
  #4
18 Days Ago
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.
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 281
Reputation: SKANK!!!!! is an unknown quantity at this point 
Solved Threads: 2
SKANK!!!!! SKANK!!!!! is offline Offline
Posting Whiz in Training
 
0
  #5
17 Days Ago
im going to eb selling a variety. are attrubutes like inventorys?
Reply With Quote Quick reply to this message  
Reply

Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC