Recent Topics

Filter by special price



  • how could i filter by special price?
    I tried in productRepository to do this but it doesn't work

       $qb->where('variants.min_price', '>=', core()->convertToBasePrice($priceRange[0]));
                        $qb->where('variants.min_price', '<=', core()->convertToBasePrice(end($priceRange)));
                        $qb->orWhere('variants.special_price', '>=', core()->convertToBasePrice($priceRange[0]));
                        $qb->orWhere('variants.special_price', '<=', core()->convertToBasePrice(end($priceRange)));
    

    Can I do this:?

    I would like to filter and if the price is low, not just show me the old price



  • Hi @LilD,

    Product flat table already contains special price column, you don't need to join this.



  • @devansh-webkul yes but i put special_price and this not work


Log in to reply