Using ProductCart - Jumping Order Numbers

Print Page | Close Window

Jumping Order Numbers

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=5777
Printed Date: 05-October-2024 at 12:10am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Jumping Order Numbers

Posted By: patschraier
Subject: Jumping Order Numbers
Date Posted: 02-January-2014 at 5:24pm

Has anyone noticed order numbers jumping (in my case by 900) recently? This has happened twice in December and we are not seeing enough abandoned orders to account for the jumps.

-------------
Pat Schraier
www.patriciaschraier.com

Replies:

Posted By: ProductCart
Date Posted: 02-January-2014 at 5:49pm

Hi Pat - this is not caused by ProductCart, but rather by a change introduced by Microsoft in SQL 2012. Specifically, the one described on these pages:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a471e304-1160-4a27-aa9b-6c72ba7fbacc/sql-server-2012-identity-problem-huge-gaps-after-restarting-server?forum=sqldatabaseengine" rel="nofollow - http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a471e304-1160-4a27-aa9b-6c72ba7fbacc/sql-server-2012-identity-problem-huge-gaps-after-restarting-server?forum=sqldatabaseengine

http://stackoverflow.com/questions/14162648/sql-server-2012-column-identity-increment-jumping-from-6-to-1000-on-7th-entry" rel="nofollow - http://stackoverflow.com/questions/14162648/sql-server-2012-column-identity-increment-jumping-from-6-to-1000-on-7th-entry

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software