Sold New Products display Sold Out instead of price on index and products_new pages

[presh]

:) ok ... so I did a search for all products and tried to find a relevant place to remove my category for "sold products"
you sent me this information in response to it

"Then, to prevent those Products from showing in the All Products ... you would need to customize the SQL statement for the All Products to exclude the categories_id for the Sold Out Products ... "

Can you please help to which php file that I can change to remove my category. cheers and thanks again presh.

[Ajeh]

You would need to customize the file:
/includes/modules/pages/products_all/header_php.php

  $products_all_query_raw = "SELECT p.products_type, p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
                                    p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
                                    p.product_is_always_free_shipping, p.products_qty_box_status,
                                    p.master_categories_id
                             FROM " . TABLE_PRODUCTS . " p
                             LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             WHERE p.products_status = 1
                        AND p.master_categories_id != 70
                             AND p.products_id = pd.products_id
                             AND pd.language_id = :languageID " . $order_by;

again, change the 70 to your categories_id ...

NOTE: there is no override for this file ...

[presh]

YES!! :) Thank you so much :) I think my queries are slowly disapearing :) Thank you! I really really could not do it without you guys, Presh.

[Ajeh]

You are most welcome ... thanks for the update that this worked for you ...

[pricediscrimination]

Want to say thanks for this thread and let everyone know it still works in 2016 with v1.5.5.

For anyone who wants more control over what is displayed, you can use this code to add text.

// return sold out vs price
  $products_quantity = zen_get_products_stock($products_id);
  if ($products_quantity <= 0) {
    return 'ADD ANY TEXT HERE';
  }

To make it only show on the product listing pages and not on the product info pages, had to wrap the text in a span and then add an inline style to tpl_product_info_display.php to hide the span.

Was wondering if there is a cleaner way to do this without having to use the inline style?

[mc12345678]

Want to say thanks for this thread and let everyone know it still works in 2016 with v1.5.5.

For anyone who wants more control over what is displayed, you can use this code to add text.

// return sold out vs price
  $products_quantity = zen_get_products_stock($products_id);
  if ($products_quantity <= 0) {
    return 'ADD ANY TEXT HERE';
  }

To make it only show on the product listing pages and not on the product info pages, had to wrap the text in a span and then add an inline style to tpl_product_info_display.php to hide the span.

Was wondering if there is a cleaner way to do this without having to use the inline style?

Probably a cleaner way by using css. See the guidance on css files in includes/templates/template_default/css for file naming to apply the desired css to the "structure" to be modified.

[pricediscrimination]

Will do, thank you.

Probably a cleaner way by using css. See the guidance on css files in includes/templates/template_default/css for file naming to apply the desired css to the "structure" to be modified.