Reset Order ID

Author	« Topic »
thorniteer Starting Member United Kingdom 43 Posts Pre-sales questions only (More Details...)	Posted - 11/02/2017 : 08:17:05 Hi, I have just taken over a site and want to have my order Ids starting at 18712. I have looked high and low - is there a way to reset this number? Thanks
thorniteer Starting Member United Kingdom 43 Posts Pre-sales questions only (More Details...)	Posted - 11/02/2017 : 16:30:43 Anyone?
Sinbad ECT Moderator USA 65937 Posts	Posted - 11/02/2017 : 17:07:06 Hi Thorniterr, it depends on what version the site is on PHP or ASP ? Winners never quit, quitters never win CSS and Responsive Designs User Manual for Ecommerce Templates
insight ECT Moderator USA 4479 Posts	Posted - 11/02/2017 : 17:36:12 If you have access to phpMyAdmin at your host, open up the orders table in your database, click on the Operations tab, find the auto_increment field and change the number there to the value you want for the next order. That'll do it. Peter ServeLink Professional ecommerce web hosting for ASP & PHP https://servelink.com Take a look at our image upload/resize tool for the ASP cart https://servelink.com/clients/cart?gid=7
thorniteer Starting Member United Kingdom 43 Posts Pre-sales questions only (More Details...)	Posted - 11/03/2017 : 02:10:37 It is PHP version
thorniteer Starting Member United Kingdom 43 Posts Pre-sales questions only (More Details...)	Posted - 11/03/2017 : 02:18:12 Hi Peter, Followed your instructions - seems to have worked. Many thanks
Andy ECT Moderator 95440 Posts	Posted - 11/03/2017 : 02:18:47 I would follow the advice above but make sure that the order number you are changing to isn't lower than the current order number. Andy Please feel free to review / rate our software
	« Topic »