Topic: e commerce user/customer database login (Page 1 of 1) Pages that link to <a href="http://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

IP logged posted posted 10-09-2010 17:03 Edit Quote

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

IP logged posted posted 10-09-2010 18:24 Edit Quote

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

IP logged posted posted 11-24-2010 21:37 Edit Quote

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

IP logged posted posted 12-03-2010 07:29 Edit Quote

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: Remember Me On This Computer
 
Your Text:
Loading...
Options: Show Signature
Enable Slimies
Enable Linkwords

« BackwardsOnwards »

Show Forum Drop Down Menu