osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Change the order numbers

This is a discussion on Change the order numbers within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; Hi, On latest oscmax2.0.15, how can I change the order numbers to start from xxx? With older versions I could ...



Find us on Facebook
Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Connect with Facebook Register FAQDonate Members List Calendar Mark Forums Read


Reply

 

LinkBack Thread Tools
  #1  
Old 03-16-2010, 12:13 PM
Active Member
 
Join Date: Mar 2004
Posts: 100
Thanks: 67
Thanked 1 Time in 1 Post
Rep Power: 0
altenter is an unknown quantity at this point
Default Change the order numbers

Hi,

On latest oscmax2.0.15, how can I change the order numbers to start from xxx?

With older versions I could change the first order number in the database, and the consequent orders would follow from that number. now, on v2.0.15 changing the order number in the database makes all my orders and customers disappear from admin.

Thanks for any suggestion.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 03-17-2010, 12:09 PM
Active Member
 
Join Date: Mar 2004
Posts: 100
Thanks: 67
Thanked 1 Time in 1 Post
Rep Power: 0
altenter is an unknown quantity at this point
Default Re: Change the order numbers

here's the solution if anyone is interested:
alter table orders auto_increment = 1000
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
UPS tracking numbers in order update smartwork osCMax v2 Customization/Mods 2 12-09-2009 07:11 AM
can I delete credit card numbers from orders without deleting the order itself?? mohawk osCommerce 2.2 Discussion 1 05-27-2009 12:15 PM
How to start your order numbers at 9 Digits jamesanderson2 osCMax v2 Customization/Mods 2 03-19-2009 12:47 AM
Creating order numbers nana osCMax v2 Features Discussion 1 02-17-2009 08:17 AM
Order numbers being skipped? countingsheep osCMax v2 Installation issues 2 10-04-2006 05:29 AM


All times are GMT -8. The time now is 07:41 PM.


Powered by vBulletin®
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2010 osCmax
Inactive Reminders By Icora Web Design