Post by joclip » 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.

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.

Newbie

Posts

Joined
Tue Jan 18, 2022 2:12 am
Location - Montreal, Quebec, CANADA

Post by paulfeakins » Tue Jan 18, 2022 10:20 pm

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?

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by khnaz35 » Tue Jan 18, 2022 11:42 pm

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 ;) :) :-*


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia

Post by thekrotek » Wed Jan 19, 2022 1:02 am

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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by joclip » Wed Jan 19, 2022 3:44 am

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

Newbie

Posts

Joined
Tue Jan 18, 2022 2:12 am
Location - Montreal, Quebec, CANADA

Post by thekrotek » Wed Jan 19, 2022 4:12 am

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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by joclip » Wed Jan 19, 2022 11:24 pm

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.

Newbie

Posts

Joined
Tue Jan 18, 2022 2:12 am
Location - Montreal, Quebec, CANADA
Who is online

Users browsing this forum: No registered users and 90 guests