Related group by sku

Submitted by henk on Tue, 2012-11-20 15:49 in HTML Design

Hi david,

One thing left ...:)

Where can I find the peace script for related products, it's not grouped by sku.

Thx
Henk

Hi Henk, It's in

Submitted by support on Tue, 2012-11-20 15:53

Hi Henk,

It's in pto_product.php at line 167 - replace "GROUP BY name" with "GROUP BY sku" as required!

Cheers,
David.
--
PriceTapestry.com

Worked :) Sometimes the

Submitted by henk on Tue, 2012-11-20 16:06

Worked :)

Sometimes the product and the related product are the same?

Thx
Henk

Hi Henk, Ah - the exclusion

Submitted by support on Tue, 2012-11-20 16:12

Hi Henk,

Ah - the exclusion (to make sure same product isn't in related products) is only based on name - so this needs to be made by SKU also. At line 160 you will find:

  $where = "MATCH name AGAINST ('".$wpdb->escape($product->name)."') AND name <> '".$wpdb->escape($product->name)."'";

...REPLACE with:

  $where = "MATCH name AGAINST ('".$wpdb->escape($product->name)."') AND name <> '".$wpdb->escape($product->name)."' AND sku <> '".$wpdb->escape($product->sku)."'";

Cheers,
David.
--
PriceTapestry.com