Order numbers

[bubblegumgoods]

Hello,

I was wondering if anybody knew a way for me to have the next person to be order No. 7 without me having to change it back from 8 to 7 in the store admin everytime somebody ordered? Because I did a test order before the orders came into my store which turned out to be order #1 and forgot to reset all the products ordererd after I did it. So is there any way I can fix that?

Thank you so much.

[DrByte]

No. You can set the order numbers "forward", but not "backward".
You can do this in Admin->Tools->Store Manager.

Maybe you want to reset it to 1007 instead?

[bubblegumgoods]

Darn. I typed in the wrong number and now I can't fix it...eek. Now I wish I didn't type that number in.

[bubblegumgoods]

1 last question....

If at the end of the month I was to reset all products ordered back to 0, would when somebody logs into there account lose the info on what they ordered in the past?

Also, seeing as how I put the numbers forward way to where I wanted them, is there a way I can fix that? I know you can't set the numbers "backward", but is there a way I can fix that or would I have to reset all products ordered back to 0?

[DrByte]

If at the end of the month I was to reset all products ordered back to 0, would when somebody logs into there account lose the info on what they ordered in the past?

To reset it all back to 0, you'd have to totally delete all orders and all order history from your site. Thus, all customer orders will be gone.
That's a pretty harsh loss of data.

Also, seeing as how I put the numbers forward way to where I wanted them, is there a way I can fix that? I know you can't set the numbers "backward", but is there a way I can fix that or would I have to reset all products ordered back to 0?

You're messing with database automatic incrementing values when you do this. If you've already had orders to increase the number again, the resetting to a lower number will be moot. If you don't understand how databases work, you should not be playing in them. Nevertheless, to reset it back to "7", do this:
1. Admin->Tools->Install SQL Patches
2. Type this in the big text box, and click Send:

ALTER TABLE orders AUTO_INCREMENT = 7;