Timeline for Magento 2 : Change Order # Formatting for M2 Orders
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 8, 2021 at 5:54 | comment | added | Shoaib Munir | If you need just number as prefix, then you just need to change auto_increment otherwise see other answer of Rakesh Varma | |
| Apr 8, 2021 at 5:40 | comment | added | devhs | Change "AUTO_INCREMENT" edit to desired order number. like 30000526 - I am trying to add prefix to the order id's you answer will work for that ? | |
| Apr 8, 2021 at 5:34 | comment | added | devhs | I don't to change credit memo id , just want to change order id. changing just order id will managed everywhere in magento like credit memo invoice shipment etc? | |
| Apr 8, 2021 at 5:32 | comment | added | Shoaib Munir | I'ts up to you, if you need to change credit memo id, then update it's sequence, and other tables likewise. for just order numbers you need to update sequence_order_1 | |
| Apr 8, 2021 at 5:04 | comment | added | devhs | ok so i need to change there in those table also ? | |
| Apr 8, 2021 at 4:56 | comment | added | Shoaib Munir | For invoice shipment, credit memo you have other tables like this. sequence_creditmemo_0, sequence_creditmemo_1, sequence_invoice_0, sequence_invoice_1 etc | |
| Apr 8, 2021 at 4:55 | comment | added | Shoaib Munir | For multiple stores you will find multiple sequences like _1, _2 etc | |
| Apr 8, 2021 at 4:45 | comment | added | devhs | Also would like to ask if it will work for multiple stores ? | |
| Apr 8, 2021 at 4:45 | comment | added | devhs | Thanks for the answer, That's it ? Everything else would be managed automatically by magento ? For credit memo, invoice, shipment ? | |
| Apr 8, 2021 at 4:43 | history | answered | Shoaib Munir | CC BY-SA 4.0 |