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
Thanks for your help, hint, ressources or solution
Last edited by joclip on Wed Jan 19, 2022 11:26 pm, edited 1 time in total.
What exactly do you want to change?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Tell us in detail what changes you have in mind , which OC version you wanted to apply, might be some solution is already available.
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
You don't need to change any IDs and it is highly NOT recommended to do so.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
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
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.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Who is online
Users browsing this forum: OSWorX, paulfeakins and 413 guests