OpenCart Community

Looking for a way to change the next order / invoice / credit / return numbers. I would guess I need some MySQL knowledge.

Thanks for your help, hint, ressources or solution

joclip wrote: ↑

Tue Jan 18, 2022 2:55 am

Looking for a way to change the next order / invoice / credit / return numbers. I would guess I need some MySQL knowledge.

What exactly do you want to change?

Tell us in detail what changes you have in mind , which OC version you wanted to apply, might be some solution is already available.

You don't need to change any IDs and it is highly NOT recommended to do so.

Sorry, working with v 3.0.3.8 on PHP 8.0 Hosted at GoDaddy
Used a Themeforest theme over with some add-on extensions (shipping, language,...)
www.lippe.co/cart

I wanted to change/start the order numbers from a larger number like 220001 instead of 1, 2, 3...
I went into the 'order' table in PHPMyAdmin and changed it 'ALTER' to 220001, works fine.
I will look into the other tables to make appropriate changes.

Thanks guys for quick returns and follow through.

I have another topic open, in regards of sent email (newsletter, order confirmations,...) from OC3 to store admin or clients. Email is unreadable (encoded), if ever you have any thoughts or hints on this matter, feel free

Joce

You need to set auto_increment value to achieve this.

Thanks guys, finally after few tests and creating new test orders, the changes made in 'order' table did work. New order numbers are incrementing fine.