Skip to main content
Problem Solver I
October 31, 2024
Solved

Product Feed (Custom Catalog): Only Products on Sale

  • October 31, 2024
  • 5 replies
  • 210 views

Hi there :)

 

Has anyone found a way to create a product feed that only contains discounted products?

 

Thanks!

    This topic has been closed for replies.
    Best answer by TimMartinHarvey

    Hey @Mathilde 

    So the work around for this is to build a sale collection in your store.
    So for Shopify if you wanted to do sale dresses, create a collection where compare at price is not empty, and product type is dresses.

    This collection can the be pulled in to your product feed.

    Then it will just be a case of choosing the smart collection Sale Dresses in the product feed.

    EG:


    Ideally in the future Klaviyo can enable Compare at Price as a field in product feed options.

    If you do not want this collection to be visible on site, you should be able to turn off the Online Store sales channel and still select in Product Feed.

    Hope that helps

     

    5 replies

    stephen.trumble
    Klaviyo Alum
    November 7, 2024

    Hey @Mathilde 

    Unfortunately at this time these items can only be filtered by category from your catalog. I'd be happy to put In a feature request for this though! 

    -Stephen
    stephen.trumble
    Klaviyo Alum
    November 7, 2024

    @retention @DavidV or @bluesnapper 

    Would any of you know of a workaround?

    -Stephen
    MathildeAuthor
    Problem Solver I
    November 7, 2024

    Hi @stephen.trumble

    Thanks for that! It would be a very appreciated feature :)

    TimMartinHarvey
    Problem Solver IV
    2025 Champion
    November 7, 2024

    Hey @Mathilde 

    So the work around for this is to build a sale collection in your store.
    So for Shopify if you wanted to do sale dresses, create a collection where compare at price is not empty, and product type is dresses.

    This collection can the be pulled in to your product feed.

    Then it will just be a case of choosing the smart collection Sale Dresses in the product feed.

    EG:


    Ideally in the future Klaviyo can enable Compare at Price as a field in product feed options.

    If you do not want this collection to be visible on site, you should be able to turn off the Online Store sales channel and still select in Product Feed.

    Hope that helps

     

    Tim Martin-Harvey | Head of E-Commerce | Digital Transformation Specialist | Multi-Brand E-Commerce Expert | 2024 & 25 Klaviyo Community Champion | Luminia Intelligence Top 10 Influential People in UK Wholesale E-Commerce
    MathildeAuthor
    Problem Solver I
    November 8, 2024

    Hi @TimMartinHarvey

     

    Thanks for your answer!

     

    We have a custom integration via Channable, so this would look a bit different. But I will look into something similar.

     


     

    PS Does anybody know whether it’s in the pipeline to update the logic options in the catalog?

     

    I would really appreciate the possibility of including AND/OR.

     

    Example: I want to display Red Lingerie in a feed:

    We use Product Attributes and give each attribute a category in the catalog

    So Lingerie product A would have these categories:

    Prouct_Type: Lingerie

    Coulor: Black

    And Lingerie product B would have these categories:

    Prouct_Type: Lingerie

    Coulor: Red

     

    Currently I will then have to build the product feed like this:

    Show products where Categories

    Include:

    Prouct_Type: Lingerie

    Exclude:

    Colour: Black, Colour: White, Colour: Green, Colour: Blue, Colour: Yellow, etc., etc.

     

    What I would love to do is this logic

    Show products where this is True

    Categories are:

    Prouct_Type = Lingerie

    AND

    Colour = Red