X-Cart forums - Change Order ID

Page 2 of 2

Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Change Order ID (https://forum.x-cart.com/showthread.php?t=4709)

groovico

10-15-2003 12:30 PM

Look through the email tpl/s you can just add whatever you want infront of the productID part.

You need to change all the subject lines and places where it mentions the order ID.

Doing it in the tpl's means it doesn't affect the real numbers in the database.

You can also change this in the order history display templates too.

funkydunk

10-15-2003 12:56 PM

just run this patch in admin:

Code:

INSERT INTO `xcart_orders` VALUES (

'12345', '', '0.00', '0.00', '', '0.00', '0.00', '', '0.00', '0', '', '0.00', '0.00', '0.00', '0.00', '0.00', 'G', '0', 'Q', '', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'US', ''

);

where 12345 is replaced by the number of your choice.

The next order id produced by the system will be 12346

Once you have had an order you can delete this entry by running the following patch:

Code:

DELETE FROM `xcart_order` WHERE orderid = '12345'

midori

10-15-2003 01:05 PM

Great! Thanks to you both for your help. I really appreciate it!

-Midori

concepts

11-16-2003 11:48 AM

I just went through PHPadmin, found the last order and changed the value. Since it is on auto appending, it goes to the next value after the last one.

30000 = 30001 next

bluecat

11-17-2003 03:07 PM

sounds good. :)

All times are GMT -8. The time now is 10:57 PM.

Page 2 of 2

Show 40 posts from this thread on one page