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

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

Harveer_SinghGi1
Harveer_SinghGi1Accepted solution
New Participant
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!

View reply

2 replies

Jennifer_Dungan
Jennifer_Dungan
Level 2
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

Translate
    Harveer_SinghGi1
    Harveer_SinghGi1Accepted solution
    New Participant
    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!

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...