Magento. Change order/invoice/shipment/creditmemo increment.
UPDATE `eav_entity_store` SET `increment_last_id` = {{NEW_LAST_INCREMENT_ID}} WHERE `entity_type_id` = {{ENTITY_TYPE_ID}} AND `store_id` = {{STORE_ID}};- {{NEW_LAST_INCREMENT_ID}} - any number what will be new last increment
- {{ENTITY_TYPE_ID}} - entity type id from table
eav_entity_typelike order, invoice etc - {{STORE_ID}} - store id for what need change increment