Post by tuncaksoy » Mon Jan 08, 2018 8:36 am

Hi
I want to change order ID but I couldnt. I try to delete order_history but rdoesnt change ID.
OC 3.0.2.0 What can I do?
Thanks

New member

Posts

Joined
Sun Dec 17, 2017 11:21 pm

Post by straightlight » Tue Jan 09, 2018 8:03 am

More information would be needed regarding the reported issue.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by tuncaksoy » Wed Jan 10, 2018 2:41 am

First time I did it and it started right number (for example) but now I cant restore order ID. I try to delete orders and change last order ID but when I take order it continue from old ID (for wxample 3, 4 5) but I want to restart it from 1 again

New member

Posts

Joined
Sun Dec 17, 2017 11:21 pm

Post by straightlight » Wed Jan 10, 2018 7:51 am

Older versions of mySQL did not previously allowed to store auto incremented values next to its previous ID. It was simply incrementing as it goes. Which mySQLi version are you using?

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by fegdeed » Fri Jul 05, 2019 5:08 am

Is it possible to make Opencart generate random order id numbers using this format YYMMDD-HHMNSS-ID, WHERE YY=LAST TWO DIGITS OF YEAR, MM=TWO DIGIT MONTH, DD=DAY, HH=HOURS, MN=MINUTES, SS=SECONDS, ID=ORIGINAL ID eg. 1.
So instead of having lets say an order id of 1, it could be 190704-050610-1?

Image
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.


Active Member

Posts

Joined
Fri Sep 21, 2018 12:01 am

Post by straightlight » Fri Jul 05, 2019 5:11 am

Either look on the Marketplace or submit a new service request in the Commercial Support section of the forum to get this done as a custom job.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: NicNie, shanghua and 387 guests