On fronted when customer clicks on "Vew my order" he gets URL like this:

when he clicks on "print order" the URL will be: domain.com/sales/order/print/order_id/375/

By looking at the "375" people can know the number of actual orders site has.

  1. How can I boost that order_id/375/ to a longer number for example order_id/1537615/. Where is this info stored in the database?

    or, is it possible to hide this part of URL (view order and print order at customer account) or do something that will hide the actual amount of orders on site.

  2. What file do I need to edit to replace /order_id/" in that URL and use a different word instead , for example "/transaction/

I use Magento

  • Magento checked owner with each order of customer, i think you don't need change order_id
    – LinoPham
    Dec 1, 2015 at 10:51

2 Answers 2


You can run this query on your database:

ALTER TABLE `sales_flat_order` AUTO_INCREMENT = 1537615;

this way your next order will have the number 1537615, the next one 1537616 and so on.
For existing orders the users will still see the old number, but for new ones nobody will know.

  • I'd say this is a easy and elegant solution. Mar 7, 2016 at 0:25

simply overwrite the existing controller and pass the increment_id value rather than order_id and fetch product by that value. Overwrite the controllers wherever you want to change the value.

  • Thank you for reply! At this point I still learning and editing the controller is kinda hard for me. Can I simply edit the database and set next "order_id" value to a larger number? For example "order Increment ID" is stored in table called "eav_entity_store" under "increment_last_id." I changed it to a larger number. Can I do the same thing for "order_id" ? Thanks
    – Val
    Dec 3, 2015 at 1:59
  • No ... don't change that, it will create more problems with association. I'll give the code ASAP. Dec 3, 2015 at 5:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.