yes it does.

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:

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

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

Hope this is useful.

Re: First Order ID modifed
 

Boomer,

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

thanks

Re: First Order ID modifed
 

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

Admin:patch: enter data...

Re: First Order ID modifed
 

Duh...thanks, got that implemented, it's great! :lol:

Works on 4.0.14
 

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

Nick

yes

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

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:
(Or whatever other value besides 10 you might want.

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

Thanks
-Tuan