cayugadan Posted March 15, 2006 Posted March 15, 2006 Does anyone know how I can change the next order number? It starts out with order #1. That does not look good. We'd prefer to start, for example, with #20001. We already have had a number of orders. If it's just going into phpmyAdmin, that's no problem, but I've tried to find that field and so far been unsuccesful, so if you can include which table/field I'd appreciate it
♥Vger Posted March 15, 2006 Posted March 15, 2006 http://www.oscommerce.info/kb/osCommerce/G...s_and_Tricks/31 Vger
schnauzer Posted March 15, 2006 Posted March 15, 2006 http://www.oscommerce.info/kb/osCommerce/G...s_and_Tricks/31 Vger I tried to use the trick you referenced and i didn't have the row "osc_orders" that the query referenced so it didn't work. Is it possible that the trick is outdated?
♥Vger Posted March 15, 2006 Posted March 15, 2006 No, actually it's updated, because the Knowledge Base has been given over to MS3 which hasn't been released yet. Sorry about that - the corresponding table in MS2 is just 'orders' Vger
cayugadan Posted March 15, 2006 Author Posted March 15, 2006 Thanks for pointing me there. :thumbsup: I figured out that the field needed to be changed to orders. For those who don't understand the SQL syntax the command should be alter table orders auto_increment = 26100 (if you were to increment by 26100)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.