Zen Cart Logo
Forums / Customization from the Admin / Can I change the customer number in admin?

Can I change the customer number in admin?

Locked

Views: 2,478

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
25 Sep 2007, 4:26 AM
#1
buyperformanceparts avatar

buyperformanceparts

New Zenner

Join Date:
Nov 2005
Posts:
20
Plugin Contributions:
0

Can I change the customer number in admin?

I want to change the customer start number from 1. How do I do this?

25 Sep 2007, 6:10 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Can I change the customer number in admin?

If this is a fresh shop with no customers - Backup the DB before doing anything.

Create one customer as normal then use your mysql DB Tool - phpmyadmin for many.

browse the customers table and customers_info table and edit the customer id for this customer to a higher number.

The next customer will increment from this value

25 Sep 2007, 2:11 PM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can I change the customer number in admin?

Be careful on changing customer_id ...

The following tables and fields for:
customers - customers_id
customers_info - customers_info_id
address_book - customers_id

all need to be updated so that the match properly with the new value ...

25 Sep 2007, 10:27 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Can I change the customer number in admin?

Thanks Ajeh...I missed the one for address_book - customers_id

11 Feb 2008, 12:02 PM
#5
minas avatar

minas

New Zenner

Join Date:
Dec 2007
Posts:
8
Plugin Contributions:
0

Re: Can I change the customer number in admin?

Maybe this is a stupid question but when I delete al test customers zen cart keeps counting as if they still exist. Can I change to a lower number if there are no customers?

11 Feb 2008, 12:05 PM
#6
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Can I change the customer number in admin?

Yes, you can
The question is: why do you want to do that, does it bother you that much?
If not, leave it as is to avoid wasting your time or messing up something.

12 Feb 2008, 8:02 AM
#7
minas avatar

minas

New Zenner

Join Date:
Dec 2007
Posts:
8
Plugin Contributions:
0

Re: Can I change the customer number in admin?

My client wants to merge his store store customers with those form his future webshop. there are no clients in the webshop so its easy to do now. But it doesnt work when I try to change it:oops:.

26 Feb 2008, 5:38 AM
#8
neon_phoenix avatar

neon_phoenix

New Zenner

Join Date:
Dec 2007
Posts:
34
Plugin Contributions:
0

Re: Can I change the customer number in admin?

In phpMyAdmin after you select your table in the left hand frame by clicking, there will be a tab at the top of the right hand frame labeled OPERATIONS. On that page it contains the auto_increment value that will be the next assigned customer id.

At least in phpMyAdmin version 2.8.0.1 used by my host.

Karl