I've cleaned my db from the test orders, following this instructions here


But the order increment id, still remains the same.

Which table do I to alter to reset the order increment id? I see the sequence is incremented in sequence_order_1 table but I'm not sure if this would be the correct place

1 Answer 1


You can rollback order increment_last_id, stored in eav_entity_store associated with order entity type.

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.