soscomputers Posted March 9, 2004 Share Posted March 9, 2004 I need to change the invoice and order number counter to a larger number. I recently moved an ecommerce site to oscommerce and the operator would like to have the invoice/order counter reflect the fact that he has been in operation for a few years. I see that the variable is (I think) oID. I have tried setting it to a larger number, but it has not been succesful. I am using osCommerce 2.2 MS2. Any help will be greatly appreciated. Bryan Broussard Link to comment Share on other sites More sharing options...
voided Posted March 9, 2004 Share Posted March 9, 2004 how about you append your number 'xxxxxxxx' just before the order number variable in the invoice page or wherever you want .... ex: 'xxxxxxxx' . $oID Designrfix.com | Graphic Design Inspiration & Web Design Resources - @designrfix Link to comment Share on other sites More sharing options...
harborsales Posted March 9, 2004 Share Posted March 9, 2004 you can change the starting # all you have to do is go to your control panel and click on phymyadmin then select your data base from the dropdown box and then find orders from the list and click on browse. Next find the last order that was placed and click on the edit button. Find Orders_id under the Fields list (should be the first one listed) and then change the order # under Values to any # you want the next order to start at. Hope this helps Mike Link to comment Share on other sites More sharing options...
paulm2003 Posted March 9, 2004 Share Posted March 9, 2004 Probably the same as the above, maybe a bit easyer. Use phpMyAdmin and execute the following query on your shop's database: alter table orders auto_increment="insert_new_orderid_here" "insert_new_orderid_here" must be a number higher than any existing ordernumber, the next order will be "insert_new_orderid_here+1" Don't remember where I got it from, but it works. :) Link to comment Share on other sites More sharing options...
soscomputers Posted March 10, 2004 Author Share Posted March 10, 2004 Thank you paulm2003, I used your suggestion and it worked. It was the easier of the two. Bryan Broussard Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.