Best Sellers

I have google searched this problem and can't find anything about my issue..

Hi
I recently upgraded to 1.5.1 from 1.3.9 and as I was wanting to rebuild my site from scratch....(Cart had had a few issues I could never get round)
I took a full sql & site backup + notes on settings etc , easy populate
Anyway I have managed to get back just about everything except best sellers list and can't find anything in the sql that comes close..

Is there a way I can return my best sellers or is it something I just have to start again with..

thanks

How much from scratch did you build from??

Did you apply your current DB in total to the new shop??
Then upgrade it as outlined

Hi ...
Complete rebuild from scratch(deleted old database which was an error on my part ,I see that now ) and only added sql's of customer details and orders and a few other things I needed. Although did have a problem with orders not showing up in admin, I had to use super orders to get them to show up

only added sql's of customer details and orders and a few other things I needed
There in lies your problem - you most likely did not include the cross indexed tables for who bought what and who knows what else???

http://www.zen-cart.com/content.php?148

See this section

If the last backup you made of your data is older than the last order that might have been processed or customer registration, make a fresh database backup.
Restore your database from the backup in step #1 earlier into your NEW database just created......

Run /zc_install/index.php and choose "Upgrade" when prompted.

Thanks for the replies .Judging by what needs to be done I think I will skip best sellers then and start again ..
Least I can stop searching for a fix and move on and remember it for the next time I need to rebuild a site.

Thanks for taking the time answering my question

Andy

If you follow the link I provided you will have all data to also allow best sellers