| ||||||||||
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 |
#21
|
|||||||
|
|||||||
yes it does.
__________________
X-Cart v 4.7.8(live) |
|||||||
#22
|
|||||||
|
|||||||
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:
into "Query(ies):" text area and push the "Apply" button. So, the next order will be numbered as order #801220 Hope this is useful. |
|||||||
#23
|
|||||||||
|
|||||||||
Re: First Order ID modifed
Quote:
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 |
|||||||||
#24
|
|||||||
|
|||||||
Re: First Order ID modifed
Quote:
Look in the quote you had highlighted, that is the answer. Admin:patch: enter data... Quote:
__________________
vs 4.1.12 |
|||||||
#25
|
|||||||||
|
|||||||||
Re: First Order ID modifed
Quote:
Duh...thanks, got that implemented, it's great!
__________________
_____________ Capture Your Mini-Me Look! - X-CART Gold (Current Version) V4.6 - Reboot - CDSEO |
|||||||||
#26
|
|||||||
|
|||||||
Works on 4.0.14
This is a great tip.. I just did it on my verison 4.0.14 site.
Nick |
|||||||
#27
|
|||||||||
|
|||||||||
Quote:
yes
__________________
Looking for a reliable X-cart host ? You wont go wrong with either of these. EWD Hosting Hands On Hosting |
|||||||||
#28
|
|||||||
|
|||||||
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 |
|||||||
#29
|
|||||||
|
|||||||
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:
__________________
Robert Uiterwyk www.horseloverz.com xcart version 4.0.17 (Heavily Modified and loaded with custom MySQL scripts) |
|||||||
#30
|
|||||||
|
|||||||
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 |
|||||||
|
|||
X-Cart forums © 2001-2020
|