| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
First Order ID modifed | ||||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||||
|
|||||||||
First Order ID modifed
Code:
Enter this SQL query into Patch/Upgrade SQL Queries box and your next new order # will be 15001. Happy X-Carting!
__________________
Cart-Lab - 100+ Social Bookmarks for X-Cart. |
|||||||||
#2
|
|||||||||
|
|||||||||
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 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
|
|||||||
|
|||||||
It Works
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
|
|||||||
|
|||||||
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) |
|||||||
#9
|
|||||||
|
|||||||
Thaks again Boomer.
__________________
X-Cart v 4.7.8(live) |
|||||||
#10
|
|||||||||
|
|||||||||
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
__________________
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
|