We have recently made a new smart collection, and sorted it in the admin section by Best Sellers. It's been going for a few weeks now, but it does not seem to be updating; Some products are not listed at the top which we know we've sold, and some we know we have not sold for a while are listed near the top.
We've tried to change the sort option (e.g. to A-Z) and then back to Best Sellers, however it's still displayed the same way.
Anyone got any ideas or had similar problems?
Also, when is the best sellers refreshed? (real time/daily/weekly/monthly?) and can it be changed?
btw - Our other collections (1 smart the rest not) are sorted by date which works fine.