X-Cart forums - Stopping free product showing up in Recommends list

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Stopping free product showing up in Recommends list (https://forum.x-cart.com/showthread.php?t=8728)

DanUK

08-02-2004 04:55 AM

Stopping free product showing up in Recommends list

I have some zero priced items (free products) that I have in a hidden category that are only made available on checkout. This works fine apart from the free products are turning up on the Recommends lists. Is there a way to block specific products from the Recommends lists?

Thanks

Dan

shan	08-02-2004 05:31 AM

you could have a look at customer/recommends.php and edit as follows

find

Code:

    $query_condition .= ")";

    $query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' AND avail>0".$query_condition;

}

else

adjust to

Code:

    $query_condition .= ")";

    $query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' AND price>0 AND avail>0".$query_condition;

}

else

DanUK

08-02-2004 06:21 AM

Thanks Shan,

Is the price meant to be called something else as I'm getting:

INVALID SQL: 1054 : Unknown column 'price' in 'where clause'

Just had a look at the xcart_products table and there is no price field as such (unless I'm blind!). All I can see is the list_price which is different to the "our price" value.

Thanks

Dan

shan	08-02-2004 06:25 AM

Hi Dan,

yeh thats probably more like it.

i posted that on off the top of my head. give list_price a go

DanUK

08-02-2004 06:31 AM

Thanks Shan,

list_price works so long as list price is 0.00 but I was hoping to have the list price of the figure it originally was (so the cutsomer can see it has a value!) and a price of 0.00 i.e. free. Whereabouts is the price stored then?

Thanks

Dan

shan	08-02-2004 06:34 AM

the original price is market price if Im not mistaken and list price is your price

All times are GMT -8. The time now is 01:23 PM.