Past deleted order details being used by new orders

Question

So in the past we made the mistake of deleting orders from our Magento store.

We had an order today where a UK customer purchased a book. They paid and received all the correct notification via email.

We then logged in to the admin to review the order. It was completely different from the email notification. It had a US address, a different payment method, products were added which no longer exist. These details were from past test orders.

Another thing we noticed is that the confirmation email was also sent to other users, not in any way connected with this order.

I know we made a mistake in deleting past orders and that is undoubtedly the cause of our problem, but does anybody have any advice on how to reset things, without starting afresh.

Answer 1

If you have remember your last order # then, You can change increment id of order to solve this problem. Suppose your last test order # was 100000367 then change it by 100000500 To do this you need to do it by phpmyadmin look for this table

eav_entity_store

And change the value of increment_last_id field where entity_type_id = 5 Please check it on demo to avoide any problem.

Answer 2

Basically Table eav_entity_store storing store wise last increment id of order=5,invoice=6,creditmemo=7,shipment=8:

For Avoiding problem you can check all of increment id you can check it maximum increment id for each above type from admin sales >> orders,sales >> shipment,Sales >> invoice,sales >> credit memo After getting all above info you need to add those increment id entry in eav_entity_store table store wise with corresponding entity type.