Developer forum

Forum » Feature requests » Monitoring > Ecommerce > Variant Options

Monitoring > Ecommerce > Variant Options

Carolee Schuck Dynamicweb Employee
Carolee Schuck
Reply

Hi,

Can you please add a query to Monitoring > Ecommerce that identifies multiple options within a variant group that have the same name?

Something like this:

select VariantOptionGroupId, VariantOptionName, count(1) 
from EcomVariantsOptions 
group by VariantOptionGroupId, VariantOptionName 
having count(1) > 1

Thanks,
Carolee

 


Replies