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 > Dev Questions
 
Thread Tools Search this Thread
  #21  
Old 02-11-2005, 10:15 AM
 
TonyD TonyD is offline
 

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

Default

yes it does.
__________________
X-Cart v 4.7.8(live)
Reply With Quote
  #22  
Old 02-13-2005, 06:17 PM
 
jorval jorval is offline
 

Newbie
  
Join Date: Apr 2004
Posts: 2
 

Default Alternative

Hi there

My first post here, so please dont kill me

Here is an alternative to increasing the order id.

Make a fake order and keep in mind the order id of this order (let it be '6').

Execute the MySQL patch thru the 'APPLY MYSQL PATCH' SECTION of the 'Upgrade/Patch' part of the 'Adminiatration' menu in admin area:

1. Scroll down the "Patch/Upgrade center" page and find the "Apply SQL patch" section.
2. Enter the patch text:
Code:
update xcart_orders set orderid=801219 where orderid=6;

into "Query(ies):" text area and push the "Apply" button.

So, the next order will be numbered as order #801220

Hope this is useful.
Reply With Quote
  #23  
Old 05-12-2005, 01:16 PM
  MythNReality's Avatar 
MythNReality MythNReality is offline
 

X-Adept
  
Join Date: Mar 2005
Location: S. Cali
Posts: 403
 

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!

Boomer,

Sorry for asking...Do I do this through the MYsqldatabase or apply patch?

thanks
__________________
_____________
Capture Your Mini-Me Look!

- X-CART Gold (Current Version) V4.6
- Reboot
- CDSEO
Reply With Quote
  #24  
Old 05-12-2005, 06:44 PM
 
markwhoo markwhoo is offline
 

X-Adept
  
Join Date: Nov 2003
Posts: 799
 

Default Re: First Order ID modifed

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

Boomer,

Sorry for asking...Do I do this through the MYsqldatabase or apply patch?

thanks

Look in the quote you had highlighted, that is the answer.

Admin:patch: enter data...


Quote:
Enter this SQL query into Patch/Upgrade SQL Queries box and your next new order # will be 15001.
__________________
vs 4.1.12
Reply With Quote
  #25  
Old 06-21-2005, 06:52 PM
  MythNReality's Avatar 
MythNReality MythNReality is offline
 

X-Adept
  
Join Date: Mar 2005
Location: S. Cali
Posts: 403
 

Default Re: First Order ID modifed

Quote:
Originally Posted by markwhoo

Look in the quote you had highlighted, that is the answer.

Admin:patch: enter data...


Quote:
Enter this SQL query into Patch/Upgrade SQL Queries box and your next new order # will be 15001.

Duh...thanks, got that implemented, it's great!
__________________
_____________
Capture Your Mini-Me Look!

- X-CART Gold (Current Version) V4.6
- Reboot
- CDSEO
Reply With Quote
  #26  
Old 07-11-2005, 04:35 PM
 
aostuff aostuff is offline
 

Member
  
Join Date: Oct 2002
Location: Atlanta, GA, USA
Posts: 22
 

Default Works on 4.0.14

This is a great tip.. I just did it on my verison 4.0.14 site.

Nick
Reply With Quote
  #27  
Old 07-12-2005, 03:39 AM
  shan's Avatar 
shan shan is offline
 

X-Guru
  
Join Date: Sep 2002
Location: Birmingham, UK
Posts: 6,163
 

Default

Quote:
Originally Posted by TL408
Would this "Order ID" mod work for the newest version of X-cart, 4.0.10 ?

Thanks
-Tuan

yes
__________________
Looking for a reliable X-cart host ?
You wont go wrong with either of these.

EWD Hosting
Hands On Hosting
Reply With Quote
  #28  
Old 03-02-2006, 05:33 PM
 
timbrrr timbrrr is offline
 

eXpert
  
Join Date: Feb 2006
Posts: 277
 

Default

How about taking this one further, and figuring out a way to increase the order by x number of orders for each order? That way if a store was doing just a few sales a day, the returning customer wouldnt think he/she was the only customer.. something to think about for the people out there who are just starting out as we all have done
__________________
X-Cart Gold 4.6.3
Codero dedicated server
Reply With Quote
  #29  
Old 03-03-2006, 05:32 AM
 
uiterwyk uiterwyk is offline
 

Member
  
Join Date: Sep 2005
Location: Pennsylvania, United States
Posts: 15
 

Default

If you are running MySQL 5.0 or above, they introduced a new varaible with that called auto_increment_increment that does just what you want. The MySQL command to change it is:
Code:
SET @@auto_increment_increment=10;
(Or whatever other value besides 10 you might want.
__________________
Robert Uiterwyk
www.horseloverz.com
xcart version 4.0.17
(Heavily Modified and loaded with custom MySQL scripts)
Reply With Quote
  #30  
Old 07-15-2006, 12:32 PM
 
TL408 TL408 is offline
 

X-Adept
  
Join Date: Jan 2005
Posts: 549
 

Default

Anyone happen to know if this will still work in version 4.1.2 release?

Thanks
-Tuan
__________________
Win2003 IIS6, PHP 5.2.3, MySQL 5.0.45 and X-Cart 4.1.9
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


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 02:38 PM.

   

 
X-Cart forums © 2001-2020