How to change order id running number on prestashop
Sometime we need to change the order id running number for new installed prestashop. The reason probably to make transaction on our website shop is more trusted for new customer. For new online shop, it is hard to get trust at the beginning except we do branding a lot at launch. There is probably another reason to change order id running number, one that come to my mind is hiding our statistic data from competitor.
In my opinion we need to change order id running number and customer id running number. This way the customer are trust us as a popular web shop. So how do i change running number for order id on prestashop?
It is easy, but you need to have access to database, specifically phpmyadmin interface. And then run this query on prestashop database
ALTER TABLE `ps_orders` AUTO_INCREMENT =255344;
255344 is the next order id.
And then for customer running number also same. Change through phpmyadmin by running this query
ALTER TABLE `ps_customer` AUTO_INCREMENT =104;
104 is the next customer id
Please make sure to backup database first before running query and after query run please test once again the website order flow.
I recommend to use new logical running number, nowdays people are able to check if your website new or not.
THANK YOU! was very simple and helpful :)
Comment by uhuh — April 7, 2013 @ 12:58 pm
Hello :)
Just wondering if this will still work on the newer shop versions?
Comment by Andrea Shell — October 13, 2013 @ 10:35 am
Hi, ya i guess so still work
Comment by admin — October 13, 2013 @ 9:10 pm
Hello dear Admin and thanks a lot for this tricky solution :D
It still works on presta 1.6x :)
thank you very much dear
Comment by Mehran — November 4, 2014 @ 7:07 pm
Hi there I found this post of yours and was wondering how to do the same thing you did in PS 1.5.6.2 ?
Comment by Joe — November 12, 2014 @ 12:42 am