If the related product is 'Available for Sale' and the 'Quantity in stock' = 0 the link is there on the Product page. If the related product is 'Disabled' the Related Products link disappears. I could just set all products with 'Quantity in stock = 0' to 'Disabled', but then I would have to remember to enable them again once stock is replenished.
Isn't there some query to check if the quantity in stock is greater than 0 so that I could add an 'if' statement to the related_products.tpl to determine whether to display the link or not? What I am looking for is the syntax of this query.
__________________
Two Separate X-Cart Stores
Version 4.4.4 Gold - X-AOM - Vivid Dreams Aquamarine (modified) - Linux
Mods - Newest Products - View All -, and a few others. Numerous upgrades from 4.0.x series.
Integrated with Stone Edge Order Manager + POS
Version 4.1.12 Gold (fresh install) - X-AOM - Linux
Mods - XCSEO free
|