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
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
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
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....
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?
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?
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.
Hai ancora qualche domanda o hai bisogno di aiuto?