Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

How To Search Products By Empty Feature Rate Topic   - - - - -

 
  • teosu
  • Senior Member
  • Members
  • Join Date: 09-Oct 14
  • 623 posts

Posted 25 July 2019 - 01:12 PM #1

hi i want search products  by empty feature  on admin, for eg: my brand feature id 1

i want list products with empty brand feature i try following code but it doesnt work.

any can check ?

 

in get_products hooks

$join .= db_quote(" LEFT JOIN ?:product_features_values ON ?:product_features_values.product_id = products.product_id AND ?:product_features_values.lang_code = ?s", $lang_code);
$condition .= db_quote(" AND NOT ?:product_features_values.feature_id  = ?i", '1');


 

Posted 27 July 2019 - 08:22 AM #2

Please have a look our addon https://store.retail...s/?currency=USD


Only helpful and unique addons https://store.retailfactory.ru


 
  • teosu
  • Senior Member
  • Members
  • Join Date: 09-Oct 14
  • 623 posts

Posted 27 July 2019 - 06:53 PM #3

Thank you for your suggestion, i have fixed my codes, currently working, but yours addon more effective. If i need another ones i will order your addon