Best Sellers

[Andy-C27]

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

[kobra]

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

[Andy-C27]

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

[kobra]

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.

[Andy-C27]

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

[kobra]

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