Can I increase the number of "Customers also bought"...?

[Guest]

Is it possible to increase the number of products shown at the bottom of a product listing where it says "Customers who bought this also bought…"

It seems to default to 3, but I can't find anything in the admin sections to increase it? It looks like five would fit across a standard page?

i.e. here -

[Lastwolf]

Go to

Includes/content/viewProd.inc.php and find

$query = sprintf("SELECT DISTINCT O.productId, I.name, I.image, I.price, I.sale_price FROM %1\$sCubeCart_order_inv AS O, %1\$sCubeCart_inventory AS I WHERE I.disabled = 0 AND I.productId = O.productId AND O.cart_order_id IN (SELECT DISTINCT cart_order_id FROM %1\$sCubeCart_order_inv WHERE productId = %2\$d) AND O.productId <> %2\$d LIMIT 3;", $glob['dbprefix'], $db->MySQLSafe($_GET['productId'], ''));

And change LIMIT 3 to LIMIT whatever you feel like,

Think that should do the trick, haven't tested it though.

[Guest]

Go to

Includes/content/viewProd.inc.php and find

$query = sprintf("SELECT DISTINCT O.productId, I.name, I.image, I.price, I.sale_price FROM %1\$sCubeCart_order_inv AS O, %1\$sCubeCart_inventory AS I WHERE I.disabled = 0 AND I.productId = O.productId AND O.cart_order_id IN (SELECT DISTINCT cart_order_id FROM %1\$sCubeCart_order_inv WHERE productId = %2\$d) AND O.productId <> %2\$d LIMIT 3;", $glob['dbprefix'], $db->MySQLSafe($_GET['productId'], ''));

And change LIMIT 3 to LIMIT whatever you feel like,

Think that should do the trick, haven't tested it though.

Smashing! Thanks "LastWolf" !!!! Will try that later and report back...

Regards

Dave, Bits4Vits

[Guest]

Almost!

Thanks "LastWolf"... there's too "Limit 3" conditions in the code, one a few lines below... but got there in the end -

MANY THANKS for that, it's a good selling tool, so why limit it to three products?

Cheers!

Dave, Bits4Vits

[Robsta]

Recent releases of v4 have an option in the General Settings section.

[Guest]

Recent releases of v4 have an option in the General Settings section.

Hmmm, I'm on 4.3.7 and thought I had a fairly up-to-date version?

[Robsta]

Recent releases of v4 have an option in the General Settings section.

Hmmm, I'm on 4.3.7 and thought I had a fairly up-to-date version?

The latest release is v4.4.2.