Hi,
I have configured ZenCart v1.5. I have imported orders from version 1.3.9h, now I have orders from 1 to 47, but don't know why they jumped from 47 to 52, 53, 54, I need these 3 new orders continuing after 47... how can I fix that? Which tables I should touch to make it work.
Regards,
Thread: Orders ID - can I reset?
Results 1 to 5 of 5
-
27 Jul 2012, 08:39 PM #1
New Zenner
- Join Date
- Jul 2011
- Posts
- 24
- Plugin Contributions
- 0
Orders ID - can I reset?
-
28 Jul 2012, 12:18 AM #2
Totally Zenned
- Join Date
- Jan 2004
- Location
- N of San Antonio TX
- Posts
- 9,151
- Plugin Contributions
- 11
Re: Orders ID should change due to legal requirement
You may have to learn to live with this. The order id is interlaced throughout the database in many tables. Once an id has been assigned, it cannot be used again. The missing numbers could have been test orders that were deleted or any other cause. You can set the order number to a number higher than the current id and try going on from there, but it will happen again.
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
-
18 Dec 2013, 09:49 PM #3
New Zenner
- Join Date
- Jul 2013
- Location
- Lakewood, California, United States
- Posts
- 66
- Plugin Contributions
- 0
Re: Orders ID should change due to legal requirement
I would like to set a higher order number so it does not appear to the customer that they are the first hundred or so orders. How can we change the current order number?
-
18 Dec 2013, 11:10 PM #4
Black Belt
- Join Date
- Jul 2005
- Location
- Upstate NY
- Posts
- 22,010
- Plugin Contributions
- 25
Re: Orders ID should change due to legal requirement
Admin > Tools > Store Manager > Set next order number.
-
19 Dec 2013, 09:02 AM #5
New Zenner
- Join Date
- Jul 2013
- Location
- Lakewood, California, United States
- Posts
- 66
- Plugin Contributions
- 0
Re: Orders ID should change due to legal requirement
Perfect, and thank you.
Reply With Quote
Similar Threads
-
v151 Can't log in to admin; can't reset pswd; new user via phpMyAdmin not working
By WhitePhantom in forum General QuestionsReplies: 6Last Post: 4 Dec 2013, 08:02 PM -
Reset store: Delete all orders, customers, etc.
By flix in forum Managing Customers and OrdersReplies: 16Last Post: 31 Oct 2012, 08:04 PM -
I emptied Orders but Numbers didn't reset
By lkzone in forum Managing Customers and OrdersReplies: 8Last Post: 28 May 2008, 10:06 AM -
Reset order numbers, now I'm not getting orders!!
By khadijaorta in forum Managing Customers and OrdersReplies: 0Last Post: 28 Dec 2006, 10:44 AM -
Delete or reset Pending Orders?
By atomage in forum General QuestionsReplies: 1Last Post: 29 Nov 2006, 02:45 AM
Bookmarks