Hi everyone,
I'm wondering if there's anyone who can help me solve this mystery...
When I'm logged in with my admin account in the backend of our PrestaShop website, I can see that we've got 78 products, 1434 customers and 1397 orders. However, when I'm looking at the SQL database with phpMyAdmin I can only see 659 customers and 612 orders while all the 78 products are all there. The strange thing is that there are no orders in the database of after 03-04-2020 and also no customers of after 13-04-2020.
I checked with our hosting provider. They confirmed that that database is the only database that's connected to our PrestaShop website. So that database is the only source of everything that we can see in the backend of PrestaShop.
So what happened with all the customers and orders since April last year? And how can I see all those customers and orders in the backend when I can't find them in the database?
To me this is a real mystery. And I need an SQL file with all the products, customers and orders.
Does anyone here has any ideas about how this is possible, where I can find the missing data and how I can get a complete SQL file?
Any suggestion is more than welcome. Thank you all in advance!