Increase Order Number increment amount?

[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

[mprough]

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.

[CosmosK]

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?

[swguy]

> 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.

[CosmosK]

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