X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)
-   -   First Order ID modifed (https://forum.x-cart.com/showthread.php?t=6181)

B00MER 01-23-2004 11:28 PM

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! ;)

leon 01-24-2004 07:21 AM

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

Taekwondo 01-27-2004 12:44 PM

It Works
 
Works like a champ!

Thanks Boomer.

TonyD 05-11-2004 08:33 AM

Thanks Boomer!



*search works for me.* :D

JohnA 05-12-2004 02:59 PM

Yep works for me as well on 3.5.6!

Thanks Boomer

jcasella 07-28-2004 04:04 PM

Excellent! Worked like a charm for me as well (v3.5.10). Thanks Boomer!

doersam@hotmail.com 08-23-2004 04:57 PM

Works great! Thanks for your input.

Zak 09-08-2004 07:16 AM

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)

TonyD 10-19-2004 12:20 PM

Thaks again Boomer. 8)

aschek 11-16-2004 07:39 AM

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 01:54 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.