BestSellers shortcode not picking best sellers

Solved5 replies2 participantsUpdated by Michael

  • Avatar: snoowy
    Michael
    Participant

    Hi,
    I’ve installed the LayerSlider and put the shortcode [etheme_bestsellers title=" "] on the home page.

    That’s producing a slider OK but the products it is showing doesn’t include our bestsellers.

    I’m assuming that the shortcode calculates the best sellers or do I actually need to select them somehow?

    Also, are there any other parameters to the short code – eg number of products displayed.

    Thanks,
    Mike.

    Please, contact administrator
    for this information.

    5 Answers

    Avatar: snoowy
    Michael
    Participant

    I should have included a bestseller example earlier. It should be including the Essentials product as it is our biggest seller by far.

    Avatar: Eva
    Eva Kemp
    Participant

    Hello,

    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.

    Avatar: snoowy
    Michael
    Participant

    Hi 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.

    Avatar: Eva
    Eva Kemp
    Participant

    Hello,

    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.

    Avatar: snoowy
    Michael
    Participant

    Hi Eva,
    I ran the sql select prodid, count(prodid) as prodnum, name from wp_wpsc_cart_contents group by prodid order by prodnum desc and 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.

The issue related to '‘BestSellers shortcode not picking best sellers’' has been successfully resolved, and the topic is now closed for further responses