If u r planning to design a e – commerce site , u have to take extra care for ur database design because site users can be both supplier and buyers, so it is complex to get a decent and simple view for that.
For every data base design first step is to make a entity relationship model, i think below model could give u a good idea
user could be buyer and seller both so a relationship must be maintained discreetly . Sellers provide products and buyers bought so products and buyers create order table. To complete successful order we need shippers and transaction from users. users and transaction records need to be connected.
hope, this effort will help you, to design an effective e commerce database
diagram courtesy by Ariful haque shisir