I'm curious about the logic behind how magento increments it's order numbers, especially regarding orders from different stores within the same website.
We have four stores and have received orders on three of them, all of which are incrementing up from a different point.
US store: 100000001
UK store: 1000000001
IE store: 300000001
Is there any logic behind how these numbers start, why would the UK store order numbers begin from 1 billion, the US from 100 million and IE 300 million. I would have thought the UK would be 200 million or something.
Interestingly the first UK order was made less than a minute after an order on the US store.
I should also mention that before going live we deleted some test orders with the SiteClue_Delete_Orders module.
Why are they in a different sequence at all?
Can I edit that order numbers directly in the eav_entity_store table? Would that effect how Magento connects with our Payment Gateways, Braintree & Paypal?