Increase Order Numbers by Three

[Ken Joy]

Actually, I think there is an argument to be made for changing the order numbers so it doesn't look like you've JUST opened your store, and the customer is placing order NUMBER ONE!

What I did, is enter a number like 703909 as a starting number. The next order number will be 703910, then 703911, etc. It doesn't then look like you're just starting out. I used 7 for 2007, and 03 to indicate March then just a random number on the end to make it look like I've already processed a lot of orders when, in fact, I'm just starting.

As a reminder, you get to this by going to ADMIN/TOOLS/STORE MANAGER, and then entering a new number in the box called Reset Current Order ID, then click "RESET"

[enigma777]

Why are you all scaring the child.

This is definately doable without breaking the database or zencart.

1) You need to modify the MySQL DB so that ORDER_ID is not auto-incementing field and just a primary key.
2) Create a BEFORE_INSERT trigger that generates a custom ORDER_ID based on your rule, i.e max(order_id) + 3 or whatever and then complete the insert.
3) Ta da! everything should work without breaking anything.

How to write your own trigger... read MYSQL documentation at http://dev.mysql.com/doc/refman/5.0/en/triggers.html

Arios,
Jeff.

Send gifts to loved ones in Pakistan at http://pakistangiftsemporium.com

[scottb]

You are over simplifying this.

The trigger needs to be the confirm order button. The order number needs to be sent to the payment gateway and entered in more than one table.

Yes, it could be done. I would write it if someone paid me enough money for my time and waived any liability against me if the SQL database broke or the primary keys got out of sync.

[davee]

Hi !

This is a strange problem for me too.
The concurrency can spy our sales quantity.No chance to change the order ID to randomly order ID?( In another shops isin't probelm like ecommerce or virtuemart. ).

Thanks

[Merlinpa1969]

no this number can not be made random,
its auto incrementing,
if your worried about low order numbers you can change the starting number of invoices, to a higher number,
this is done in admin -> tools -> manager

[DrByte]

This is a strange problem for me too.
The concurrency can spy our sales quantity.No chance to change the order ID to randomly order ID?( In another shops isin't probelm like ecommerce or virtuemart. ).

Many months ago you said you were going to work around it a different way. What has been your experience with that?
http://www.zen-cart.com/forum/showthread.php?t=50074