Topic: e commerce user/customer database login (Page 1 of 1) Pages that link to <a href="https://ozoneasylum.com/backlink?for=32011" title="Pages that link to Topic: e commerce user/customer database login (Page 1 of 1)" rel="nofollow" >Topic: e commerce user/customer database login <span class="small">(Page 1 of 1)</span>\

 
Hustluz
Bipolar (III) Inmate

From:
Insane since: Jun 2003

posted posted 10-09-2010 17:03

Hi guys i would like to say thanks in advance for your help..

Question:
I'm creating an e commerce site and I wanted to know the best practice. Should i create a separate database for Customers and Users (admins) or should they just be in the same database with different access Levels.

I see the benefit of a separate database. You can require more information then needed for an admin user. But that also creates the problem of separate login Places and adds a bigger load to the navigation. I'm kinda new and just wanted to know the standard procedures of building an e commerce site.

Blacknight
Paranoid (IV) Inmate

From: INFRONT OF MY PC
Insane since: Dec 2001

posted posted 10-09-2010 18:24

Usually u have one table for the users and then add them to usergroups.

User: Username | ID
groups: Groupname | ID
users_to_groups: UserID | GroupID

Or more modern systems prefere roles with
Roles: "can add item", "can add user"...
and then associate the users to there roles.

Im sure there are more ways of handling this, but most of them do keep the all there users in one table. It makes useradmin/login etc more simple.

The navigation is then dynamically created depending on the users Group or Roles

(Edited by Blacknight on 10-09-2010 18:26)

Boudga
Maniac (V) Mad Scientist

From: Jacks raging bile duct....
Insane since: Mar 2000

posted posted 11-24-2010 21:37

Use Magento! It's a very robust ecommerce solution. It will handle users and roles for you if you set it up to do that.

sophielucky
Bipolar (III) Inmate

From: Miami
Insane since: Nov 2010

posted posted 12-03-2010 07:29

You can build different user groups according to the consuming levels.

And give them an authority to join the group.

I'm sure this will bring and attract more customers.

[edit - me make it go bye-bye]

(Edited by WebShaman on 12-03-2010 15:56)



Post Reply
 
Your User Name:
Your Password:
Login Options:
 
Your Text:
Loading...
Options:


« BackwardsOnwards »

Show Forum Drop Down Menu