I wants to display 'wishlist_item' and 'wishlist' table details on admin panel of magento.


Use this code :

$wishlist = Mage::getModel('wishlist/wishlist');     
$wishlistCollection = $wishlist->getCollection();
$select =  $wishlistCollection->getSelect();
$select->join(array("t1" => 'wishlist_item'),
"main_table.wishlist_id = t1.wishlist_id",array('wishlist_id' => 
  // $select->group('main_table.wishlist_id');
     echo '<pre>';
| improve this answer | |
  • where to add this code? – Neeya Aug 12 '17 at 6:15
  • please specify file path to add this code – Neeya Aug 12 '17 at 6:39
  • You need create a module. I create one module and they print the wishlist using the code of this reply. Module: github.com/reynaldots/magento_ShowWishlist – Reynaldo Nov 17 '18 at 19:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.