Photo Cart is retired. Check out Sytist.

Missing Approx 300 Orders From May To Aug?

 
Please log in or Create an account to post or reply to topics.
 
Luke Trottier
4 posts
Wed Oct 04, 17
11:32 AM
We lost approx. 300 orders from the past few months. We can not pull accurate sales reports, manually searching for the missing order numbers shows "That Order Does Not Exist" We can see new orders now, but the block of 300 orders from May to Aug are missing.
Tim - PicturesPro.com
10310 posts
admin
Thu Oct 05, 17
6:22 AM
The only way that could really happen is if a database backup was restored from an old backup. Photo Cart won't just delete orders. Has there been any backups restored?
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Luke Trottier
4 posts
Thu Oct 05, 17
6:54 AM
No, but we did have to run a repair on a few tables that crashed in MySQL. Apparently the repair is not lossless.
Tim - PicturesPro.com
10310 posts
admin
Thu Oct 05, 17
8:47 AM
I don't think a repair would cause data loss, but I don't know for sure.

If you have received orders that ended up being duplicate order numbers from the past, that is a telltale sign the database had been restored from an older backup,
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Luke Trottier
4 posts
Thu Oct 05, 17
8:54 AM
The missing orders are from May to Aug however the events we added between May and Aug are still there. Everything except the orders from May to Aug is there. The order numbers missing are 24958-25232. In Sept we pick up at 25233, there are no duplicate order numbers. The events we added from May-Aug as stated are there but they show zero sales which is inaccurate as the missing 300 orders account for the sales from those events. Had the database been restored I would have thought more then the orders would be missing.
Tim - PicturesPro.com
10310 posts
admin
Thu Oct 05, 17
12:36 PM
I don't have any idea then what happened to them. You can go into the PHPMyAdmin in your hosting control panel and look in the pc_orders table in your Photo Cart database and search the order id field for one of those order numbers and see if they are there.
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2018 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close