Simplii Web

I would also to see this feature working with WP-Ecommerce categories. Any updates on this yet?

I’m have the same issue with Ajax disabled/enabled.

chrome console error-
Uncaught SyntaxError: Unexpected number

I was able to fix this on my own. here is how to do it.

WP eCommerce Version: 3.8.4

find file wp-ecommerce/wpsc-include/display.functions.php

around line 80 or serch for “$also_bought = $wpdb->get_results”

and replace the following:

$also_bought = $wpdb->get_results( "SELECT” . $wpdb->posts . “.* FROM” . $wpdb->posts . “WHERE” . $wpdb->posts . “.idIN (SELECT” . $wpdb->posts . “.post_parentFROM” . WPSC_TABLE_ALSO_BOUGHT . “,” . $wpdb->posts . “WHEREselected_product='" . $product_id . "' AND” . WPSC_TABLE_ALSO_BOUGHT . “.associated_product=” . $wpdb->posts . “.idAND” . $wpdb->posts . “.post_statusIN('publish','protected','inherit') ORDER BY” . WPSC_TABLE_ALSO_BOUGHT . “.quantityDESC) LIMIT $also_bought_limit", ARRAY_A );

with this:

$product_variation_ids = $wpdb->get_results("SELECT ID FROM” . $wpdb->posts . “WHEREpost_parent= " . $product_id . " ANDpost_type` = ‘wpsc-product'” , ARRAY_A);
$variation_ids = ”;
foreach ($product_variation_ids as $ids)
$variation_ids = $ids[‘ID’] . “,” . $variation_ids;

$variation_ids= $variation_ids . $product_id;

$also_bought = $wpdb->get_results( “SELECT " . $wpdb->posts . ".* FROM " . $wpdb->posts . " WHERE " . $wpdb->posts . ".id IN (SELECT " . $wpdb->posts . ".post_parent FROM " . WPSC_TABLE_ALSO_BOUGHT . ", " . $wpdb->posts . " WHERE selected_product IN ($variation_ids) AND " . WPSC_TABLE_ALSO_BOUGHT . ".associated_product = " . $wpdb->posts . ".id AND " . $wpdb->posts . ".post_status IN(‘publish’,’protected’,’inherit’) ORDER BY " . WPSC_TABLE_ALSO_BOUGHT . ".quantity DESC) LIMIT $also_bought_limit”, ARRAY_A );`

Im using the same set-up as you. have you tried using the chrome developer console (press f12) and check the console tab for errors.

All Fixed on my end, thanks Zack!