Qphoria wrote:Of course I understand. But that is my point. You seem to think the customers gives a rats ass about your business and order count. They don't. Even still, in a normal business flow without worrying about order id's, it is normal for people to get to the confirmation page and change their mind, or continue shopping, or have an typo in their credit card, or any other number of causes to reload that page, causing "temp" order ids to generate. So it is highly unlikely you will even see sequential order ids. mysql doesn't support autoincrementing by customizable steps. But as I said you could add some junk at the front or end
Thanks for the tip again Qphoria. The whole reason this was brought up to begin with was because we had a customer actually bring it to our attention that they had ordered 3 different times over 2 weeks and had received the sequential order numbers and started asking if anyone else was shopping our shop. We have not experienced much of the scenarios you describe such as hitting the confirm page and then not checking out, but in our testing we have seen the order numbers jump as you describe.
At this time we are operating about a dozen shops using OC for various artists, which again tends to seek out repeat customers as opposed to large mailing lists of them. The customers tend to come back to the shops regularly and at this stage of the game we are continuing to just process a few dummy orders after each real order so that the order number is jumped. This unto itself is not a huge ordeal to add as part of our processing, but I was just hoping there was an easy solution. It's not necessarily that we are trying to hide anything, it's just one of those things we would rather not have any attention paid to it. With the possibility of sequential order id numbers, it leaves a possible question mark.
I am not sure off hand how I would approach the filler characters you are speaking of as again I think it would still be something noticeable if even in the middle of it there was a consecutive number from order to order. Plus, I want to make sure whatever we do is easy to move or copy to any new upgrades to the software itself.
Since this order number is sent immediately to the customer in the order confirmation, I assume it would be something in the code that generates the email sent to the buyer.
Probably the direction we will look at the most is setting up something that will automatically create a few dummy orders after each real order is placed. Kind of like a cron job, but scheduled/setup to happen after each real order as opposed to a set daily or weekly schedule.
It may not seem like a big deal to most, but in our scenarios and shops it is definitely something that customers have noticed and as well we have noticed and is one of those things that we would just rather not have to even think about in our big picture.