Is there a way to change the order number?

[Stuff4Toys]

We have been in business for 20 years, it's sort of embarrassing to have a customer get an online order with the number 0000017 when in fact we have processed this year 23,000 orders via telephone and over 1,000 internet orders with our old software.

When we used Zen-Cart there was actually a feature to change an existing order number, then all orders following just incremented from the new number.

Can I go into PHPmyAdmin and change the last order number?  Which table and field?

Thanks 
JOhn ><>

[DeeCee]

phpmyadmin -> jos_vm_orders

order_id is the primary key and is auto increment.

chuck through a dummy order, it will assign an order number
then in phpmyadmin, change it to what ever number invoice you are at and it will auto increment afterwards.

Also check jos_vm_order_item_id as order_item_id auto increments with order_id

[Virtual101]

The information from DeeCee's post has been quite helpful as I'm also trying to change my order numbers. One question, you mentioned the changing of values and whatnot within phpmyadmin - I'm not quite sure as to where to go to make the change as I obviously don't work with phpmyadmin often and I am having trouble locating this particular function.
I've found the actual location of all the tables etc. I'm just not sure how to edit them.
Thanks

Edit: Found it!

[treybraid]

someone please help me out here... i am clueless as to what to do...client just told me he wants a starting number other than " 0 "... what do i do to edable this feature... confused as to what you are saying above...
trey

[jacks88]

This is way late, but it might help someone else.  
1.You go into phpMyAdmin and find the database name you created for your site.  
2.Click it open and go to jos_vm_orders (or use whatever prefix you used if it's not jos_).
3.Click that open, then click Browse at the top.
You'll see the dummy order (as suggested in above post).  Click the edit button.
4.One of the boxes will be labeled order_id and have a low number like 1 in the box next to it.
5.Change that number to whatever number you want the count to start from.
6.Click Go or Save and the numbering now automatically increments from there.
You can always go back and change that number if you want.

[urbandriftwood]

Thanks everyone worked perfectly!

I would like to add that the dummy order will no longer show up in Virtue Mart but the next order that is placed will increment correctly and appear in VM

VirtueMart 1.1.3
Joomla 1.5.10
My SQL 4.1.22
 

[quilthug]

That actually didn't work for me on VM 1.1.4, I had to go to the jos_vm_orders and go to the operations tab and change the auto_increment value there, then it worked!

[Gambalunga]

<quote>That actually didn't work for me on VM 1.1.4, I had to go to the jos_vm_orders and go to the operations tab and change the auto_increment value there, then it worked!</quote>
You can put the next order number that you wish to use in this field but all of the order related tables contain the order number (order_id) for cross reference purposes. If you have existing orders (hopefully a small number) and want to update the existing order numbers you will have to do it in all the order related tables.

[renemorissette]

I succeed to change the order ID once just by changing order_ID in jos_vm_orders table to start at 100000 but now, I would like to set it to 100 and it's always coming back to 100000+, not 100, 101 etc.

I deleted all database entries related to orders but it doesn't work. Does Virtuemart store data in a .ini file somewhere or what???

Thanks for helping me.

[beachy]

You need to enter a test order and then change that order id to 100. Enter a second test order and that should now be 101!

[fibobaby]

This is way late, but it might help someone else. 
1.You go into phpMyAdmin and find the database name you created for your site. 
2.Click it open and go to jos_vm_orders (or use whatever prefix you used if it's not jos_).
3.Click that open, then click Browse at the top.
You'll see the dummy order (as suggested in above post).  Click the edit button.
4.One of the boxes will be labeled order_id and have a low number like 1 in the box next to it.
5.Change that number to whatever number you want the count to start from.
6.Click Go or Save and the numbering now automatically increments from there.
You can always go back and change that number if you want.

Thanks a lot. I did as you indicated. Now my order id works as I expected.

[delroyp]

sorry but how do you get to phpadim to make the above changes

[beachy]

phpAdmin is accessible through cPanel but it will depend upon your host if you have access to it!

I tend to use navicat but you will have to configure remote sql in order to access it through a desktop application.

If not contact your host for advice on how to access your SQL DB.

[JanJ]

Hello. I was very happy when I saw this post, because this is extactlly what I need. But I have a problem with that operation.

Because of virtuemart system testing I have already 137 orders in mysql. So first thing I tried was editing my last order id from 137 to 1. Then I made test order and the order id was 138 instead of 2.
Then I saw the other way with operation and changing auto increment number. So I change auto increment number from 137 to 1 and click save the number changes back to 137.

I would really appriciate if someone have a solution.

Jan

[JanJ]

Anyone please??