Searching by "product_last_modified" date

[armadillo]

Since all of my products have been preloaded with Easy Populate, the new products section does not apply and the search feature cues on date added. Not sure whether the database query can be for product_last_modified dates rather than the product_date_added. I have been looking for a contrib to no avail. Any pointers will be greatly appreciated!!!

[armadillo]

Never mind, it dawned on me that I was looking in the wrong file. I found the needed info in advanced_search_results and changed

 

if (tep_not_null($dfrom)) {

$where_str .= " and p.products_date_added >= '" . tep_date_raw($dfrom) . "'";

}

 

if (tep_not_null($dto)) {

$where_str .= " and p.products_date_added <= '" . tep_date_raw($dto) . "'";

}

 

 

to

 

if (tep_not_null($dfrom)) {

$where_str .= " and p.products_last_modified >= '" . tep_date_raw($dfrom) . "'";

}

 

if (tep_not_null($dto)) {

$where_str .= " and p.products_last_modified <= '" . tep_date_raw($dto) . "'";

}

 

 

Since I do not care when the product was added (just updated), this worked for me!!