| ||||||||||
![]() |
Shopping cart software Solutions for online shops and malls | |||||||||
![]() |
![]() |
|
X-Cart Home | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
First Order ID modifed | ||||
![]() |
|
|
Thread Tools | Search this Thread |
#1
|
|||||||||
|
|||||||||
![]() Code:
Enter this SQL query into Patch/Upgrade SQL Queries box and your next new order # will be 15001. Happy X-Carting! ![]() |
|||||||||
#2
|
|||||||||
|
|||||||||
![]() 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 doesn\'t matter what is done... it is how it is done. ============================= XCart Version: 3.5.3 -> Dmcigars.com XCart Version: 4.1.3.... |
|||||||||
#3
|
|||||||
|
|||||||
![]() Works like a champ!
Thanks Boomer. |
|||||||
#4
|
|||||||
|
|||||||
![]() Thanks Boomer!
*search works for me.* ![]() |
|||||||
#5
|
|||||||
|
|||||||
![]() Yep works for me as well on 3.5.6!
Thanks Boomer
__________________
X-Cart version 3.5.6 +++ PHP 4.3.4 MySQL server 4.0.18-standard MySQL client 3.23.49 Web server Apache/1.3.29 (Unix) Operation system Linux Perl 5.008001 XML parser (expat) 1.95.6 |
|||||||
#6
|
|||||||
|
|||||||
![]() Excellent! Worked like a charm for me as well (v3.5.10). Thanks Boomer!
|
|||||||
#7
|
|||||||
|
|||||||
![]() Works great! Thanks for your input.
__________________
Thanks, Phil X-Cart Gold Version 4.4.5 |
|||||||
#8
|
|||||||
|
|||||||
![]() 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) |
|||||||
#9
|
|||||||
|
|||||||
![]() Thaks again Boomer.
![]()
__________________
X-Cart v 4.7.8(live) |
|||||||
#10
|
|||||||||
|
|||||||||
![]() 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
__________________
http://www.genpi.com <-- My classic ! 4 Years with X-Cart and still alive! http://www.partsforchefs.com <-- Simple, ugly but selling like crazy! http://www.floridascents.com <-- New! Just launched ! X-Cart 4.1.3 Apache/2.0.54 (Fedora) PHP/5.0.4 |
|||||||||
|
|||
X-Cart forums © 2001-2020
|