Post by wittypets » Wed Mar 19, 2014 4:17 am

After deleting customers and orders via the Dashboard, I backed up the database and looked at it only to find entries under "oc_order" and "oc_order_product" and "order_total". Using phpMyAdmin I manually deleted these left-over entries.

Why would entries remain after deleting them through the OpenCart interface?
Also, did I miss anything (or screw anything up) by manually deleting the entries?

Thank you.

Newbie

Posts

Joined
Wed Mar 19, 2014 4:05 am

Post by butte » Thu Mar 20, 2014 2:52 am

Version?

When you had deleted them but had not yet removed them from the db, did they appear "gone" in admin? Having a record of orders (sales) and customers relating to those is actually a routine business practice, for the same reasons that accountants cringe when their clients figure out how to cheat certain popular accounting programs and tax auditors look for holes.

You probably didn't shoot an arrow through OC but if the deletions appeared gone in admin, then you might be best off reinstating the db backup.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by wittypets » Thu Mar 20, 2014 3:32 am

Thank you for your reply. Yes, they were "gone" in admin. We are still testing our site. We purged Braintree Paytments Sandbox and (tried to) delete all orders in OpenCart before going live (soon). I manually deleted these orders but would like to understand how they were left behind after using admin to delete other orders.

Newbie

Posts

Joined
Wed Mar 19, 2014 4:05 am

Post by butte » Thu Mar 20, 2014 12:00 pm

Since they were visibly gone, deletion effectively took them out of play. Accounting chicken tracks and residual dependencies among ID numbers or order status (even with sandbox) probably explain why they were still in the shadows.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by wittypets » Thu Mar 20, 2014 12:17 pm

Okay. Thanks. I see if it happens again when we delete test orders before we go live.

Newbie

Posts

Joined
Wed Mar 19, 2014 4:05 am
Who is online

Users browsing this forum: No registered users and 45 guests