I have just placed a test order and noticed that the Order # (44) is much lower than the last sale which occurred on my store Order # 85. How do I correct this?

Edit: Have added screenshot of eav_entity_store table. enter image description here

  • What was the amount of order #85 – Mrunmay Deswandikar Dec 29 '16 at 5:09
  • 1
    $64.90 - my eav_entity_store table has many entries. Is this correct? – bondimedical Dec 29 '16 at 5:15
  • Okay, and what is the amount of order #44 ? – Mrunmay Deswandikar Dec 29 '16 at 5:16
  • 1
    That was the order I just placed $339.90 – bondimedical Dec 29 '16 at 5:17
  • Yes I got the issue. It is of unconverted quotes. Refer my answer. – Mrunmay Deswandikar Dec 29 '16 at 5:21
  1. Reference order Id or increment Id is generated in magento sequentially.

  2. But if your new order is lower than the last placed order, that means it is the order generated by previous un-converted quote.

  3. Uncoverted quote simply means that, when you add to product in cart and do not place order and logout, then after login that product automatically gets added in cart.

  4. And even if you have placed different orders after that, the quote id of that cart remains lower because it was previously created.

  5. So when you place order then only the quote gets converted, and remain lower in the table because it was previously created and you have placed some orders after that.

  • 1
    I do use a delete order extension. What will be the number of the next order? – bondimedical Dec 29 '16 at 5:26
  • Yes even if you delete the order, the magento will automatically generate the next order id wich is greater than one from previous order id. But if that order is of uncvoerted quote i.e old order which could not placed, then order id of that particular order will be same as old. – Mrunmay Deswandikar Dec 29 '16 at 5:28
  • 1
    Order 45 already exists. Will it overwrite this order or go to Order #86 next? – bondimedical Dec 29 '16 at 5:30
  • If you place a new order right now its number will be #86 – Mrunmay Deswandikar Dec 29 '16 at 5:41
  • And if you create a quote right now and do not place the order and logout. And if other customers will give orders after that till number #103 or other. And if you again login your order will be #86 because it is of uncoverted quote. – Mrunmay Deswandikar Dec 29 '16 at 5:43

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.