I should have included a bestseller example earlier. It should be including the Essentials product as it is our biggest seller by far.
BestSellers shortcode not picking best sellers
Solved5 replies2 participantsUpdated by Michael
-
5 Answers
#64313 CopiedHello,
The shortcode
[etheme_bestsellers title=""]should display best seller products. Unfortunately there are no other parameters. As I see some products are shown on the homepage. Aren’t they bestsellers?Regards,
Eva Kemp.#64490 CopiedHi Eva,
The products displayed are not our best selling products.
The best sellers would definitely include Essentials and probably BiOmega and Active Calcium Plus.If you can provide me with details of the sql query the short code runs I can try running it manually on the DB and see if I get the same or different results as the shortcode.
Regards,
Mike.#64504 CopiedHello,
The code for bestseller products can be found in the file wp-content/themes/blanco/code/shortcodes.php (lines 2-30).
Thank you.
Regards,
Eva Kemp.#64509 CopiedHi Eva,
I ran the sqlselect prodid, count(prodid) as prodnum, name from wp_wpsc_cart_contents group by prodid order by prodnum descand got a totally different result from what the shortcode produces. I added “name” to the query which wasn’t in the shortcode query so I could identify the products.The 1st bestselling product shown by the manual method was correct but it and some products below that probably aren’t right because the volume of each product sold seems wrong. The volumes seem too low.
I’m wondering if a mysql query run from myphpadmin is limited to searching a small number of rows or short query execution time which would lead to the low volume numbers I see.
Regards,
Mike.#64541 Copied -
The issue related to '‘BestSellers shortcode not picking best sellers’' has been successfully resolved, and the topic is now closed for further responses















