In the narrow window where I was rebuilding the site at a test location and still running the live store, I somehow had a customer find the test site and place an order near the same time another customer placed an order on the live site. The result is two orders with the same order number - number 130.
I have fixed this so it will not happen again, but is there some way I can renumber the latest order from 130 to 131 in the database? I have already reset the store numbering so that there is a gap in the numbers and the next order will be 132?
Thread: Duplicate Orders During Upgrade
Results 1 to 3 of 3
-
28 Jan 2013, 11:04 AM #1
Zen Follower
- Join Date
- Dec 2010
- Posts
- 108
- Plugin Contributions
- 0
Duplicate Orders During Upgrade
-
28 Jan 2013, 10:39 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: Duplicate Orders During Upgrade
You'd have to go into ALL the orders_xxxxx tables and change the orders_id accordingly.
BE CAREFUL!!!!!!!!!!!!!
http://www.zen-cart.com/wiki/index.p...#Order_History.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
29 Jan 2013, 12:25 AM #3
Zen Follower
- Join Date
- Dec 2010
- Posts
- 108
- Plugin Contributions
- 0
Re: Duplicate Orders During Upgrade
Thank you. I only want to change order 130 to 131... If I have to mess with many records in the database to make this change, I will leave it alone though.
Reply With Quote
Similar Threads
-
[duplicate post] Duplicate Orders
By chris1974 in forum Bug ReportsReplies: 2Last Post: 3 May 2011, 07:28 PM -
[Duplicate] Product Descriptions/Titles Erased During Edits
By animateclay in forum Bug ReportsReplies: 5Last Post: 20 Feb 2011, 07:19 AM -
Import Customers & Orders During Upgrade
By DVDTitan in forum Upgrading from 1.3.x to 1.3.9Replies: 3Last Post: 16 Aug 2010, 05:48 PM -
error during upgrade
By colemanpa in forum Upgrading from 1.3.x to 1.3.9Replies: 5Last Post: 17 Dec 2007, 03:51 AM
Bookmarks