Free Android CakePHP GMaps Articles by Bali Web Design

May 21, 2012

How to change order id running number on prestashop

Filed under: prestashop — admin @ 8:41 pm

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.


  1. THANK YOU! was very simple and helpful :)

    Comment by uhuh — April 7, 2013 @ 12:58 pm

  2. Hello :)

    Just wondering if this will still work on the newer shop versions?

    Comment by Andrea Shell — October 13, 2013 @ 10:35 am

  3. Hi, ya i guess so still work

    Comment by admin — October 13, 2013 @ 9:10 pm

  4. 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

  5. Hi there I found this post of yours and was wondering how to do the same thing you did in PS ?

    Comment by Joe — November 12, 2014 @ 12:42 am

RSS feed for comments on this post. TrackBack URL

Leave a comment