I have created an expiry_date attribute in admin. I have chosen expiry date some products 31-12-2017.My requirement is expiry date ending before one month(30-11-2017) products display.I don't know how to implement this task.Can you please help me?
Add a comment
|
1 Answer
Try this in your product collection
$currentDate = Mage::getModel('core/date')->gmtDate('Y-m-d');
$plusOneMonth = date('Y-m-d', strtotime($currentDate . "+1 months"));
$collection = Mage::getModel('catalog/product')->getCollection();
$collection->addFieldToFilter('expiry_date', array('from' => $currentDate, 'to' => $plusOneMonth));
answered Nov 30, 2017 at 6:04
-
Hi @ Dinesh Yadav, Thank you. Where this code added.Please tell me file path?. Commented Nov 30, 2017 at 6:06
-
Where you want to show your products? Do you want to implement this filter on category page? Commented Nov 30, 2017 at 6:07
-
My requirement is to display products expiry date ending before one month. I have a display that products in table format through programmatically.Can you please help me? Commented Nov 30, 2017 at 6:09
-
I have to save the file into Magento root folder .Show my products in the frontend.Can you please help me? Commented Nov 30, 2017 at 6:12
-
I want to display on the table, Product name,sku, Expiry date in the front end.Can you please help me? Commented Nov 30, 2017 at 6:13