Increase Order Number increment amount?

Hi, I know how to manually set my next order number, but I'm wondering if I can change it to increment by 3 or something instead of 1 each time. i saw a thread on random numbers, but I'd like to achieve something more basic. Is there a piece of code where I can change a 1 to a 3 somewhere?

Thanks

Quote:

---

Originally Posted by CosmosK

Hi, I know how to manually set my next order number, but I'm wondering if I can change it to increment by 3 or something instead of 1 each time. i saw a thread on random numbers, but I'd like to achieve something more basic. Is there a piece of code where I can change a 1 to a 3 somewhere?

Thanks

---

That's a big deal to change as the incremental status stores the order info in your database. There really isn't a security to gain from this.

Quote:

---

Originally Posted by mprough

That's a big deal to change as the incremental status stores the order info in your database. There really isn't a security to gain from this.

---

How is that a bigger deal than resetting the number manually? Why would the database care if there are skips?

> Is there a piece of code where I can change a 1 to a 3 somewhere?

It's not done in code; it's done by the database. I have read you can modify the auto_increment value but I have never done this myself. Be sure to make a backup first and verify that everything works as expected. *It would be a good idea to verify this on a test site before changing your live database. Be sure to test all relevant payment methods.*

The syntax would be something like this:

ALTER TABLE orders MODIFY COLUMN orders_id int(11) NOT NULL auto_increment=3;

OR perhaps just

ALTER TABLE orders auto_increment=3;

I would not recommend doing this but it's your store.

Hmm, I was hoping it was an integer value somewhere in a php file. Maybe I'll wait, but thank you for the response. I'll use the time I would have spent attempting it to manually update the counter to keep my paranoia at bay. Thanks