| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Change Order ID | ||||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
Change Order ID
Is there a way to change the Order ID number so that my first customer doesn't get "Order ID #1"?
Thanks! -Midori |
|||||||
#2
|
|||||||||
|
|||||||||
Go to your MySQL control panel Select browse xcart_orders then edit order ID 1 to anything you want.
__________________
Dedicated Server provided by EWD Hosting X-Cart version 4.1.12 PHP 5.3.2 MySQL server 5.0.87-community Operation system Linux Perl 5.008008 dogbytecomputer.com |
|||||||||
#3
|
|||||||
|
|||||||
What if you have about 30 orders but want to change that? Can I just change the last entry to say 1322 for example without messing up my database?
|
|||||||
#4
|
|||||||||
|
|||||||||
I believe so. If I'm not mistaken the Order ID is auto indexed using the last entry. All entries before that should remain unchanged.
__________________
Dedicated Server provided by EWD Hosting X-Cart version 4.1.12 PHP 5.3.2 MySQL server 5.0.87-community Operation system Linux Perl 5.008008 dogbytecomputer.com |
|||||||||
#5
|
|||||||
|
|||||||
Let me ask this (as I get scared tinkering with my database), if it "doesn't" work, can it be easily corrected by changing the number back to 30 for example?
|
|||||||
#6
|
|||||||||
|
|||||||||
Here is the only way to do it
BACKUP YOUR DATABASE! Then try it.... If it does not work.... RESTORE YOUR BACKUP DATABASE!
__________________
Dedicated Server provided by EWD Hosting X-Cart version 4.1.12 PHP 5.3.2 MySQL server 5.0.87-community Operation system Linux Perl 5.008008 dogbytecomputer.com |
|||||||||
#7
|
|||||||
|
|||||||
I guess I should of thought of that, lol. Thanks.
|
|||||||
#8
|
|||||||||
|
|||||||||
Also change the same value in xcart_order_details
I don't see a way to just change next value, but there may be a way.
__________________
Dedicated Server provided by EWD Hosting X-Cart version 4.1.12 PHP 5.3.2 MySQL server 5.0.87-community Operation system Linux Perl 5.008008 dogbytecomputer.com |
|||||||||
#9
|
|||||||
|
|||||||
Thanks for the help! I should've figured that out on my own.
-Midori |
|||||||
#10
|
|||||||
|
|||||||
Wait a second...what do I do if I don't have a MySQL control panel???
|
|||||||
|
|||
X-Cart forums © 2001-2020
|