Bad increase ID in orders and customers

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
10 years ago
Hi, is possible change weird increase ID in orders and customers ? Will demonstrate two examples.
We have 3362 customers, not 911859 http://d.pr/i/YdgN and we have 6020 orders, not 15334 http://d.pr/i/ng8T

Or maybe some script that would fix it?

Thank you very much for help.
10 years ago
is there anyone who could give me an answer?
10 years ago
nordic wrote:
Hi, is possible change weird increase ID in orders and customers ? Will demonstrate two examples.
We have 3362 customers, not 911859 http://d.pr/i/YdgN and we have 6020 orders, not 15334 http://d.pr/i/ng8T

Or maybe some script that would fix it?

Thank you very much for help.

The jump in customer Id is by design since guest also get an Id. Check this
Order Id could always be increased in order settings
10 years ago
Hi, would be a suggesties to give carts a guid, and create customers on checkout and not earlier. For customers and orderid a selfdefined number range would be great, including leading zeros and prefix like web00001 for web orders
10 years ago
In all honesty, what does it matter what the ID is?  The max for an int is 2,147,483,647
10 years ago
AndyMcKenna wrote:
In all honesty, what does it matter what the ID is?  The max for an int is 2,147,483,647

Sure, google and other bots Will increase this number every day..also guests not being customers. If architecture would be changed to have shoppingcart with cookie relaxed to guid...and then on checkout create a relationship with new customer entry...then at least query and performance would go up for things relaxed to customers...without having to purge the shoppingcarts....for searchengines i would not even create an entry in customers online...simply they are not customers....
10 years ago
Quantis001 wrote:

Sure, google and other bots Will increase this number every day..also guests not being customers. If architecture would be changed to have shoppingcart with cookie relaxed to guid...and then on checkout create a relationship with new customer entry...then at least query and performance would go up for things relaxed to customers...without having to purge the shoppingcarts....for searchengines i would not even create an entry in customers online...simply they are not customers....


I totally agree. Can we create a work item for this?
10 years ago
rmcsharry wrote:

Sure, google and other bots Will increase this number every day..also guests not being customers. If architecture would be changed to have shoppingcart with cookie relaxed to guid...and then on checkout create a relationship with new customer entry...then at least query and performance would go up for things relaxed to customers...without having to purge the shoppingcarts....for searchengines i would not even create an entry in customers online...simply they are not customers....

I totally agree. Can we create a work item for this?


i'm totally agree too.
9 years ago
I think this is an important issue too. I use the customer Id as a reference in other systems, so to have such wieldy numbers is an not ideal!
9 years ago
nordic wrote:
Hi, is possible change weird increase ID in orders and customers ? Will demonstrate two examples.
We have 3362 customers, not 911859 http://d.pr/i/YdgN and we have 6020 orders, not 15334 http://d.pr/i/ng8T

Or maybe some script that would fix it?

Thank you very much for help.



I know this issues but:

The customer-id its by design that all anonymous user / connection creates an id

For the high order number that's strange, maybe you have issues with a payment method, or a problem that customers leave your site before ending checkout. You must see why that's important.
On the other way there is a small number of orders where customers don't pay or can't pay (refused by bank)
So on a clean site the orders must follow properly.
Last but not least, our govs ask to have in accounting nice invoice-numbers with no missing numbers
so an ordernumber IS NOT an Invoice number for accounting !!
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.