Reading Merchandising Evar from post_product_list of Data feeds data using SQL query | 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
  • 508 views

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

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
Community Advisor
Harveer_SinghGi1Community AdvisorAccepted solution
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
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    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...