Increase Order Numbers by Three

Hello,

I searched the past posts about order numbers. I saw that a few buddies are complaining about order numbers begining from one and increase by one. This makes the customer know how many order did the shop got. But i didn't found any solution for this problem. I read about some solutions but none of them finished and send as contrib.

I want to ask that if anybody have a solution other than order numbers increase by one. Maybe it can be a timestamp+random number (i read about this solution in a post but have problems about sending order mails) or increase the order number by x or anything else.

Thanks for replys from now.

You can set the START number to anything you want:-

ADMIN>TOOLS>STORE MANAGER

Set it to start at 100120 if you like...

...your next order will be numbered 100121 .

The order number plays a part in the functioning of your zen store, so it's not advisable to change the way it auto increments.

Thanks for your reply schoolboy,

But i know this solution and asked clearly

Quote:

---

if anybody have a solution other than order numbers increase by one

---

Because i don't want my customers to be able to track my order numbers and how many orders did i get..

The order number cannot be changed to increment by more than 1 as that is generated by an auto-incrementing field in the DB. Changing the numbering to not be consecutive could also cause problems with the taxation departments in some countries.

Besides which, the most a customer could know is how many orders were placed between their last order and their current one... why is that bad for them to find out?

Only *repeat* customers will ever be able to get this info, and if they're repeating, you have them.

If your order rate is so low that order numbers matter, you can always place some "dummy" orders now & then - for a free/ free shipping product so it won't mess with your bookkeeping.

Thanks Kim,

Actually i didn't think about modifying order_id. I better think about inserting a new field like ""order_number" in orders table. And make the order_number field random generated or increase by three and customers see this number for the orders. But my php and MySQL knowledge is not good enough to make this type of modification. Can it be done ?

Tasmania... I really think this is a non-issue.

Customers could not care less whatr order number they have. We have built over 50 zenshops and never had a client complain about the order number. This number is just a reference point. If yoiu set the base number to a higher value, there may be a customer out there who will be "impressed" that you "appear" to have had ten zillion orders...

...but most people won't care - at all.:smile:

Tas,
as Kim stated the order ID that you are refering to is the invoice number,

you cant change one without changing the other,

Tasmania,

SQL databases increment by 1. It is an inherent function of the database structure, core, and operations.

To change it, is asking for a disaster like the total loss of all information.

Thanks everyone.

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! :D

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"

:lamo:

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

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.

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

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

Quote:

---

Originally Posted by davee

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