Return to previous page

BestSellers shortcode not picking best sellers

This topic has 6 replies, 2 voices, and was last updated 9 years, 6 months ago ago by Michael

Michael

Participant

May 16, 2015 at 03:55

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.

#64271 Copied

5 Answers

Michael

Participant

May 16, 2015 at 13:20

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

#64313 Copied

Eva Kemp

Support staff

May 18, 2015 at 10:36

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.

#64490 Copied

Michael

Participant

May 18, 2015 at 11:30

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.

#64504 Copied

Eva Kemp

Support staff

May 18, 2015 at 11:37

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.

#64509 Copied

Michael

Participant

May 18, 2015 at 13:32

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.

#64541 Copied
Viewing 6 results - 1 through 6 (of 6 total)

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

BestSellers shortcode not picking best sellers

Recent Topics

Helpful Topics

Useful links WooCommerce & WordPress

Browse by popular tags:

Explore our best WordPress WooCommerce Themes collection