Hi guys. I got some questions today from a client regarding the order ID numbers that get assigned to FoxyCart orders. He was wondering:
1. Why they have gaps in them (e.g., 1, 23, 45... as opposed to 1, 2, 3).
2. Why, even given the gaps, sometimes an order comes in with a lower number than an order that was received an hour before.
I'm guessing order ID numbers are derived from FC session IDs. That would explain the gaps and the fact that they are sometimes out of sequence (if customer A enters the site first but submits his order after customer
The question is, are there alternative ways to generate order numbers? I think the client is less concerned with gaps but is interested in having order IDs reflect the sequence in which orders are actually submitted. He wants to be able to look at two order numbers and know for sure from the numbers which is the most recent.