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 – Thao Pham Dec 1 '15 at 10:51

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. – rabbit.aaron Mar 7 '16 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 '15 at 1:59
  • No ... don't change that, it will create more problems with association. I'll give the code ASAP. – Aman Srivastava Dec 3 '15 at 5:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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