Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Resetting customer level

  1. 08-20-2009, 01:27 AM #1
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default Resetting customer level

    Our site has been live for about a month and i noticed that we didnt set the default customer level (it is still at the default '0')....we dont have a '0' id level.

    How can i make all of these customers be reset to the new customer level '1' i have just created ?
    8.0.1.4 W2008R2 64-bit MSSQL2005
  2. 08-20-2009, 02:22 AM #2
    MelanieA is offline Junior Member
    Join Date
    Sep 2008
    Posts
    313

    Default

    The default Customer Level ID is set to 0, it means that this customer is not mapped to any customer level on your site. If you wish to make all your customer mapped to your new customer level '1' simply run this query against your database.
    Code:
    Update Customer Set CustomerLevelID = '1'
    Please make sure you have created a good back up of your database before running the said query.