Reset Customer Id

4 Sep 2008, 5:41 PM

#1

Totally Zenned

Join Date:: Apr 2007
Posts:: 632
Plugin Contributions:: 0

Reset Customer Id

Is there any way to reset the customer id #? I duplicated one of my websites and failed to completely empty the database from addresses and now my 2nd site is transferring names and addresses from the original site. I realize I could just start over, but really do not want to have my customers start over by recreating accounts and such. Is there any way of either clearing only the non primary addresses, or increasing the customer id # to a higher number?

Thanks!

15 Sep 2008, 5:36 PM

#2

helpme

Totally Zenned

Join Date:: Apr 2007
Posts:: 632
Plugin Contributions:: 0

Re: Reset Customer Id

anyone??? I really hate to start over on a website that is successful!!! PLEASE???

16 Sep 2008, 12:25 AM

#3

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Reset Customer Id

helpme:

Is there any way of ... increasing the customer id # to a higher number?
Use phpMyAdmin and alter the auto-increment value on the customers table to the new number.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

16 Sep 2008, 11:45 AM

#4

helpme

Totally Zenned

Join Date:: Apr 2007
Posts:: 632
Plugin Contributions:: 0

Re: Reset Customer Id

Awesome THANKS!!!!!

Is there any way of deleting the non primary addresses without intrupting the accounts???

16 Sep 2008, 2:07 PM

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Reset Customer Id

sure - delete the entries in address_book where there's no matching customers_default_address_id in the customers table

Always make backups before deleting data.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

16 Sep 2008, 2:40 PM

#6

helpme

Totally Zenned

Join Date:: Apr 2007
Posts:: 632
Plugin Contributions:: 0

Re: Reset Customer Id

never mind, got it!

Thank you so SO SO Much!!!!! You saved me a LARGE headache!!!