Thread: Change Order ID
View Single Post
  #12  
Old 10-15-2003, 12:56 PM
 
funkydunk funkydunk is offline
 

X-Man
  
Join Date: Oct 2002
Location: Cambridge, UK
Posts: 2,210
 

Default

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'
__________________
ex x-cart guru
Reply With Quote