Originally Posted by
Ajeh
You would edit the products table via phpMyAdmin and change the products_date_added to be older than your New Products Limit on date ...
On skipping the product in the listings, you can alter that by customizing the code for the listing to check either the master_categories_id or the products_id to know when a product should be skipped or excluded from the output ...
The cleanest method is to alter the select statement so that it excludes the products_id(s) or master_categories_id when the list of products to be displayed is generated ...
One place to start is the /includes/modules/pages/products_all/header_php.php file ...
NOTE: there is no override for this file ... be sure to maintain backups of both the original file and your custom file for future upgrades ...
This would be great for my shop, but I am not clear what select to alter here, when I deleted p.products_id, all products displayed as sold out:
PHP Code:
$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
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.products_id = pd.products_id
AND pd.language_id = :languageID " . $order_by;
Bookmarks