Best Sellers Table?

[games4gamers]

Simple question, is there a separate table in the database that holds best sellers information? If so, which table is it. If not, where is this data stored?

Thanks.

[CoolCarPartsOnline]

I think it is automatically generated from order_products table. If you look into the code of the best seller box you would understand how it is generated.

[games4gamers]

I think it is automatically generated from order_products table. If you look into the code of the best seller box you would understand how it is generated.

Ok thanks, I'll try that.

[games4gamers]

Ok thanks, I'll try that.

Okay I looked and found this:

\includes\modules\sideboxes\best_sellers.php
Line 68: $bestsellers_list[$rows]['id'] = $best_sellers->fields['products_id'];
Line 69: $bestsellers_list[$rows]['name'] = $best_sellers->fields['products_name'];
\includes\templates\template_default\sideboxes\tpl_best_sellers.php (4 hits)
Line 14: for ($i=1; $i<=sizeof($bestsellers_list); $i++) {
Line 15: $content .= '<li><a href="' . zen_href_link(zen_get_info_page($bestsellers_list[$i]['id']), 'products_id=' . $bestsellers_list[$i]['id']) . '">' . zen_trunc_string($bestsellers_list[$i]['name'], BEST_SELLERS_TRUNCATE, BEST_SELLERS_TRUNCATE_MORE) . '</a></li>' . "\n";
Line 15: $content .= '<li><a href="' . zen_href_link(zen_get_info_page($bestsellers_list[$i]['id']), 'products_id=' . $bestsellers_list[$i]['id']) . '">' . zen_trunc_string($bestsellers_list[$i]['name'], BEST_SELLERS_TRUNCATE, BEST_SELLERS_TRUNCATE_MORE) . '</a></li>' . "\n";
Line 15: $content .= '<li><a href="' . zen_href_link(zen_get_info_page($bestsellers_list[$i]['id']), 'products_id=' . $bestsellers_list[$i]['id']) . '">' . zen_trunc_string($bestsellers_list[$i]['name'], BEST_SELLERS_TRUNCATE, BEST_SELLERS_TRUNCATE_MORE) . '</a></li>' . "\n";