Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Searching by "product_last_modified" date


armadillo

Recommended Posts

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!!!

www.djscollectables.com

Link to comment
Share on other sites

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!!

www.djscollectables.com

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...