Recently I upgraded an OpenCart store from 188.8.131.52 to 184.108.40.206. What I did is an export of most of the vital tables in the database (customers, orders, products, categories, etc.) and migration of the data after some corrections where necessary to a fresh 220.127.116.11 installation. Most of the stuff worked fine this way - one thing that causes issues though is the statistics in the main menu column on the left in the admin panel. They are quite off, showing 93% for completed orders, 96% for orders in progress and 4% for other orders. The statistics in the old store worked fine and added up to 100% as expected.
I tried looking through order statuses and the code for the model (admin/controller/common/column_left.php) but the code looked fine. I tried to regenerate the statistics a couple of times through the admin interface but the values there didn't change. I thought this might be due to wrong order statuses but I confirmed that these are the same as in the old website.
I am at a loss on how to debug and fix this, any ideas? Thank you in advance
EDIT: The issue has been resolved. The setting for config_processing_status contained order statuses 12, 3, 2, 5 and 1 (in that order) and the config_complete_status contained order statuses 3 and 5. Correcting this so config_processing_status has values different than config_complete_status according to the store's workflow resolved the issue.
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus
Thanks for the reply, fortunately that won't be needed. The new installation's settings table had some weird misconfiguration. The setting for config_processing_status contained order statuses 12, 3, 2, 5 and 1 (in that order) and the config_complete_status contained order statuses 3 and 5. The total percentage in the main menu is now 99% instead of 100% but still much better than before.
I mean, why are processing statuses also completed statuses in an out-of-the-box experience? Doesn't make any sense at all. Anyway, problem is solved if anyone else is looking for this.
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Programmer / Opencart Tester
Users browsing this forum: No registered users and 8 guests