A client's site has been running for three years with order IDs being consistent with sales_order table's entity_id. A month ago, three order IDs were skipped all on the same day but hasn't happened again since.

I've read that missing/skipped order IDs is no cause for alarm though as I understand it, they should still appear in the quote tables. They were not there.

There weren't any changes to the step value, unless Magento can change them on its own and then revert back.

Is there any other reason for order IDs to get skipped?

1 Answer 1


It is actually a Behavior of Magento that some of Order Are changed from Quote to Order but not Recorded in Order Table

Read Description of this extension you will get answer

FME Missing Orders

Magento Community Questions

Another Link

  • All the reserved_order_id values from quote are also in sales_order. I've already tried searching for them in both tables but didn't find anything.
    – jsalita
    Oct 18, 2019 at 5:13
  • you can show you problem to this extension support the will tell you what actually problem is
    – Waqar Ali
    Oct 18, 2019 at 5:16
  • Waqar did you guys manage to resolve this issue ?
    – sodhancha
    Oct 20, 2020 at 12:07
  • there are extension avaible to resolve this issue you can check them
    – Waqar Ali
    Oct 20, 2020 at 12:10

Your Answer

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

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