marissen / magento2-module-better-order-incrementing
Increment order ids manually, instead of relying on auto increment.
Installs: 761
Dependents: 0
Suggesters: 0
Security: 0
Stars: 2
Watchers: 6
Forks: 0
Open Issues: 0
Type:magento2-module
Requires
- magento/framework: *
- magento/module-sales-sequence: *
Suggests
- fooman/sameorderinvoicenumber-m2: Persist increment ID between Order, Invoice, Shipment and Creditmemo
This package is auto-updated.
Last update: 2021-09-03 10:31:32 UTC
README
Increment order ids manually, instead of relying on auto increment.
When MySQL rollbacks happen, auto increment IDs do not rollback to their previous value. In many cases this isn't a bad thing, but it is for Order IDs. Order IDs need to be sequential for better organization and bookkeeping.
Installation
composer require mooore/magento2-module-better-order-incrementing bin/magento setup:upgrade
Uninstallation
The auto_increment for the following tables probably are not in sync with the content of said tables:
sequence_creditmemo_X
sequence_invoice_X
sequence_order_X
sequence_shipment_X
Please verify this and make sure it is in sync, because if they are not and you disable/uninstall this module, you'll run into MySQL constraints.