Reading Merchandising Evar from post_product_list of Data feeds data using SQL query | Adobe Experience League Community
Skip to main content
DineshRkumar
DineshRkumar
Level 3
February 10, 2025
Solved

Reading Merchandising Evar from post_product_list of Data feeds data using SQL query

  • February 10, 2025
  • 2 replies
  • 547 views

Hi Team,  can you please help me to read  Merchandising Evar(v198) from post_product_list of Data feeds data in SQL query

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Harveer_SinghGi1

Hi @dineshrkumar ,

Based on Merchandising eVar instances lookup documentation, you can lookup for value 1297 is post_product_list column for eVar198's merchandising instances.

So, for a give product_list values the post_product_list shows as below,

product_list = "testCat;testSKU;1;100;;eVar198=testVal" post_product_list = "testCat;testSKU;1;100;;1297=testVal"

In your SQL query you can add a where clause to check for records where post_product_list either contains ";1297=" (i.e. eVar198 is first eVar in merchandising variables) or "|1297=" (i.e. eVar198 is not the first eVar in merchandising variables).

Cheers!

2 replies

Harveer_SinghGi1
Adobe Champion and Community Advisor
Harveer_SinghGi1Adobe Champion and Community AdvisorAccepted solution
Adobe Champion and Community Advisor
February 10, 2025

Hi @dineshrkumar ,

Based on Merchandising eVar instances lookup documentation, you can lookup for value 1297 is post_product_list column for eVar198's merchandising instances.

So, for a give product_list values the post_product_list shows as below,

product_list = "testCat;testSKU;1;100;;eVar198=testVal" post_product_list = "testCat;testSKU;1;100;;1297=testVal"

In your SQL query you can add a where clause to check for records where post_product_list either contains ";1297=" (i.e. eVar198 is first eVar in merchandising variables) or "|1297=" (i.e. eVar198 is not the first eVar in merchandising variables).

Cheers!

    Jennifer_Dungan
    Adobe Champion and Community Advisor
    Jennifer_DunganAdobe Champion and Community Advisor
    Adobe Champion and Community Advisor
    February 11, 2025

    As @harveer_singhgi1 mentioned, in the Post Product List, you will see the backend Event ID (rather than the "readable name".

     

    You should also be aware that all merchandising eVars will be listed, even if they aren't used in that context.

     

    Empty eVars will show ::hash::0

      Terms & ConditionsAccessibility statement

      Loading footer...