# Articles not showing up on search

**URL:** <https://forum.shopware.com/t/articles-not-showing-up-on-search/35137>\
**Category:** Allgemein\
**Created:** [9. März 2016 um 09:55 UTC](https://forum.shopware.com/t/articles-not-showing-up-on-search/35137 "2016-03-09T09:55:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![oakrudi](https://avatars.discourse-cdn.com/v4/letter/o/779978/32.png) [@oakrudi](https://forum.shopware.com/u/oakrudi)\
**Post date:** [9. März 2016 um 09:55 UTC](https://forum.shopware.com/t/articles-not-showing-up-on-search/35137/1 "2016-03-09T09:55:30Z")

</div>

Hey 🙂

I’ve got a situation here and I would like to ask opinions: "I have an article with 4 variants (like size variants). The configurator type is “selection”. What is happening is that, if I disable the preselected article, that article is not showed up on search results event another variants are active. Is that the right behavior of shopware?

Thanks

---

<div class="post-metadata">

**Author:** ![DanielNogel](https://avatars.discourse-cdn.com/v4/letter/d/96bed5/32.png) [@DanielNogel](https://forum.shopware.com/u/DanielNogel)\
**Post date:** [9. März 2016 um 18:18 UTC](https://forum.shopware.com/t/articles-not-showing-up-on-search/35137/2 "2016-03-09T18:18:59Z")

</div>

Hi,

this behaviour results from&nbsp;\Shopware\Bundle\SearchBundleDBAL\QueryBuilderFactory::createQuery:&nbsp;

```
            ->innerJoin(
                'product',
                's_articles_details',
                'variant',
                'variant.id = product.main_detail_id
                 AND variant.active = 1
                 AND product.active = 1'
            )

```

I guess one could argue about this behaviour - but generally Shopware does need an active main variant / preselected variant, so you shouldn’t try to trick it in that regard 🙂

Best regards,

Daniel&nbsp;

---

<div class="post-metadata">

**Author:** ![oakrudi](https://avatars.discourse-cdn.com/v4/letter/o/779978/32.png) [@oakrudi](https://forum.shopware.com/u/oakrudi)\
**Post date:** [10. März 2016 um 09:49 UTC](https://forum.shopware.com/t/articles-not-showing-up-on-search/35137/3 "2016-03-10T09:49:48Z")

</div>

> [@Daniel Nögel schrieb:](https://forum.shopware.com/profile/4010/Daniel%20N%C3%B6gel "Daniel%20N%C3%B6gel")
> 
> Hi,
> 
> this behaviour results from&nbsp;\Shopware\Bundle\SearchBundleDBAL\QueryBuilderFactory::createQuery:&nbsp;
> 
> -\>innerJoin(  
> ‚product‘,  
> ‚s\_articles\_details‘,  
> ‚variant‘,  
> ‚variant.id = product.main\_detail\_id  
> AND variant.active = 1  
> AND product.active = 1‘  
> )
> 
> I guess one could argue about this behaviour - but generally Shopware does need an active main variant / preselected variant, so you shouldn’t try to trick it in that regard ![:)](https://dub1.discourse-cdn.com/flex013/resources/emoji/smile.png ":)")
> 
> Best regards,
> 
> Daniel&nbsp;

I understand, but here it would make sense to set preselected variant as the next active one. Do you agree?

---

<div class="post-metadata">

**Author:** ![DanielNogel](https://avatars.discourse-cdn.com/v4/letter/d/96bed5/32.png) [@DanielNogel](https://forum.shopware.com/u/DanielNogel)\
**Post date:** [10. März 2016 um 18:47 UTC](https://forum.shopware.com/t/articles-not-showing-up-on-search/35137/4 "2016-03-10T18:47:31Z")

</div>

Hi,

perhaps at least a message / hint might be helpful. You can create new issues at [issue.shopware.com](http://issue.shopware.com) any time - so it doesn’t get lost here in our forums

Best regards,

Daniel