First Order ID modifed
Code:
ALTER TABLE xcart_orders AUTO_INCREMENT = 15000; Enter this SQL query into Patch/Upgrade SQL Queries box and your next new order # will be 15001. Happy X-Carting! ;) |
Re: First Order ID modifed
Quote:
Are you sure about that ? Isnt it the orderid field that needs to be altered directly, not a global attribute ? Im not an expert, but I thought fields could be altered, or attributes, but not directly affect an attributes numbering. If so, let me know, could be handy for other CMS's |
It Works
Works like a champ!
Thanks Boomer. |
Thanks Boomer!
*search works for me.* :D |
Yep works for me as well on 3.5.6!
Thanks Boomer |
Excellent! Worked like a charm for me as well (v3.5.10). Thanks Boomer!
|
Works great! Thanks for your input.
|
A step further...
Great fix! Now, taking all this a step further, I hava client who wishes to have the date included in his order number. On top of that, he wants the order numbers to restart daily. Example, the second order placed on 9-4-04 would appear as: 9-4-04-02... Any suggestions on how the query code could be written to accomplish any or all of this greatly appreciated.
X-Cart version 4.0.2 PHP 4.3.4 Details MySQL server 4.0.18 MySQL client 3.23.49 Web server Apache/1.3.27 (Unix) |
Thaks again Boomer. 8)
|
Can I include alpha ?
Hey Boomer,
I am not an expert, but need to ask you please... is it possible to include ALPHA on this ? Let's say, start the order as ABC1000 then ABC1001 and let only the numbers increase ? Thanks a lot !! Alex |
All times are GMT -8. The time now is 06:49 AM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.