stabes Posted November 27, 2009 Share Posted November 27, 2009 I've installed a new shop, but before I go live I would like the order numbers to start at 1642 instead of 1. Where can I change that? Mart Link to comment Share on other sites More sharing options...
Mort-lemur Posted November 27, 2009 Share Posted November 27, 2009 I've installed a new shop, but before I go live I would like the order numbers to start at 1642 instead of 1. Where can I change that? Mart Hi, No Guarantees that this will work - and BACK UP before trying it, but try running the following SQL query alter table orders auto_increment = 1642; Good Luck Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
stabes Posted November 27, 2009 Author Share Posted November 27, 2009 Well, I guaranteed that it worked :-) Thanks Heather! Mart Link to comment Share on other sites More sharing options...
Danny74 Posted November 27, 2009 Share Posted November 27, 2009 Where exactly do you plug that code in. Thanks. Link to comment Share on other sites More sharing options...
Mort-lemur Posted November 27, 2009 Share Posted November 27, 2009 Where exactly do you plug that code in. Thanks. Go to your hosting Cpanel - Select Phpmyadmin - select your database - select the sql tab - paste the code in the box - press go. You should get a success message telling you that the database was changed. But Back up first :-) Thanks Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
Danny74 Posted November 28, 2009 Share Posted November 28, 2009 It worked. Thank you. Would I be able to go back and change it again? I just remembered that I should have put a "0" in front of the quantity. Thanks for taking the time to help. Link to comment Share on other sites More sharing options...
Mort-lemur Posted November 28, 2009 Share Posted November 28, 2009 It worked. Thank you. Would I be able to go back and change it again? I just remembered that I should have put a "0" in front of the quantity. Thanks for taking the time to help. Yes you should be able to. Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.