X-Cart forums

[DanUK]

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]

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

find

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

adjust to

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

[DanUK]

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]

Hi Dan,

yeh thats probably more like it.

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

[DanUK]

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]

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