Author Topic: Products AND items show up on search  (Read 6671 times)

theopus

  • Beginner
  • *
  • Posts: 10
Products AND items show up on search
« on: March 22, 2010, 18:53:27 pm »
I've added child products to products, to be able to have stock control on the items.

When a user does a search in the front end, the parent product + all the items are shown.

How can I change it, so that only the parent product shows up?

mlipscomb

  • Contributing Developer
  • Beginner
  • *
  • Posts: 24
  • US-Based Development
    • US-Based Joomla and Virtuemart Design and Development
Re: Products AND items show up on search
« Reply #1 on: March 31, 2010, 22:10:51 pm »
Open the file administrator/components/com_virtuemart/html/shop_browse_queries.php
and around line 44 you'll see this:
Code: [Select]
$where_clause = array();
change it to this:

Code: [Select]
$where_clause = array();
$where_clause[] = "`product_parent_id`=0 ";

theopus

  • Beginner
  • *
  • Posts: 10
Re: Products AND items show up on search
« Reply #2 on: April 01, 2010, 13:36:58 pm »
Thank you so much!

goretex34

  • Beginner
  • *
  • Posts: 37
    • Zeesl web design · diseño web Zeesl
Re: Products AND items show up on search
« Reply #3 on: July 05, 2011, 12:39:17 pm »
Thank you very much!
Simple& Easy & Effective!!
------------------------------------
Zeesl.com @zeesl
@chartcon
------------------------------------
www.Zeesl.com  @Zeesl
www.chartconsulting.net @chartcon
@goretex34

kimmo

  • Beginner
  • *
  • Posts: 10
Re: Products AND items show up on search
« Reply #4 on: May 30, 2012, 21:52:15 pm »
Thanks you MUCH!!! I try to find this 2 evenings, and now it's solved!!!

KKimi