Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

First Order ID modifed
 
Reply
   X-Cart forums > X-Cart 4 > Changing and adding new features
 
Thread Tools Search this Thread
  #1  
Old 01-23-2004, 11:28 PM
  B00MER's Avatar 
B00MER B00MER is offline
 

X-Guru
  
Join Date: Sep 2002
Location: Keller, TX (Cart-Lab.com)
Posts: 3,165
 

Default 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!
__________________
Cart-Lab - 100+ Social Bookmarks for X-Cart.
Reply With Quote
  #2  
Old 01-24-2004, 07:21 AM
  leon's Avatar 
leon leon is offline
 

X-Wizard
  
Join Date: Mar 2003
Location: Costa Rica
Posts: 1,213
 

Default Re: First Order ID modifed

Quote:
Originally Posted by B00MER
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!

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....
Reply With Quote
  #3  
Old 01-27-2004, 12:44 PM
 
Taekwondo Taekwondo is offline
 

Advanced Member
  
Join Date: Feb 2003
Posts: 35
 

Default It Works

Works like a champ!

Thanks Boomer.
Reply With Quote
  #4  
Old 05-11-2004, 08:33 AM
 
TonyD TonyD is offline
 

eXpert
  
Join Date: Mar 2004
Location: Okc
Posts: 288
 

Default

Thanks Boomer!



*search works for me.*
Reply With Quote
  #5  
Old 05-12-2004, 02:59 PM
 
JohnA JohnA is offline
 

Member
  
Join Date: Mar 2004
Location: Bedford - UK
Posts: 12
 

Default

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
Reply With Quote
  #6  
Old 07-28-2004, 04:04 PM
 
jcasella jcasella is offline
 

Member
  
Join Date: Sep 2003
Posts: 11
 

Default

Excellent! Worked like a charm for me as well (v3.5.10). Thanks Boomer!
Reply With Quote
  #7  
Old 08-23-2004, 04:57 PM
 
doersam@hotmail.com doersam@hotmail.com is offline
 

Senior Member
  
Join Date: Jul 2004
Location: Snohomish, WA
Posts: 153
 

Default

Works great! Thanks for your input.
__________________
Thanks,
Phil

X-Cart Gold
Version 4.4.5
Reply With Quote
  #8  
Old 09-08-2004, 07:16 AM
 
Zak Zak is offline
 

Member
  
Join Date: May 2004
Posts: 18
 

Default 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)
Reply With Quote
  #9  
Old 10-19-2004, 12:20 PM
 
TonyD TonyD is offline
 

eXpert
  
Join Date: Mar 2004
Location: Okc
Posts: 288
 

Default

Thaks again Boomer.
__________________
X-Cart v 4.7.8(live)
Reply With Quote
  #10  
Old 11-16-2004, 07:39 AM
  aschek's Avatar 
aschek aschek is offline
 

Senior Member
  
Join Date: Sep 2003
Location: Miami Beach, FL
Posts: 152
 

Default 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
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Changing and adding new features


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 05:10 PM.

   

 
X-Cart forums © 2001-2018