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

[DineshRkumar]

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 · Accepted solution]

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]

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