Developer forum

Forum » Ecommerce - Standard features » Ecommerce data health?

Ecommerce data health?

E-mail notifications
Anders Ebdrup
Anders Ebdrup
Reply
Posted on 06/03/2020 12:19:26

Dear Dynamicweb,

 

Has this feature: "Ecommerce data health" been released yet? I see it in the roadmap here: http://doc.dynamicweb.com/downloads/releases/roadmap/roadmap-9-8

 

Best regards,

Anders


Replies

 
Nicolai Pedersen
Posted on 06/03/2020 12:42:17
Reply

Hi Anders

No - it did not make it. But it is being developed as we speak.

Attached find a zip with some SQLs that is part of the health checks. They are designed to find data that is not as expected (errors) and things like missing translations (warnings).

If you have other good ideas for checks, we will be glad to receive them!

BR Nicolai

 
Anders Ebdrup
Anders Ebdrup
Posted on 30/04/2020 08:46:24
Reply

Dear Nicolai,

 

Yesterday we used this query to find groups without a parent in the same language which messed up the group navigation:

 

SELECT
    Parent.GroupName,
    EcomGroupRelations.GroupRelationsParentId,
    EcomShops.ShopId,
    EcomShops.ShopName,
    G1.*
FROM EcomGroups AS G1
LEFT JOIN EcomGroupRelations ON EcomGroupRelations.GroupRelationsGroupId = G1.GroupId
LEFT JOIN EcomShopGroupRelation ON EcomShopGroupRelation.ShopGroupGroupId = G1.GroupId
LEFT JOIN EcomShops ON EcomShopGroupRelation.ShopGroupShopId = EcomShops.ShopId
LEFT JOIN EcomGroups AS Parent ON Parent.GroupId = EcomGroupRelations.GroupRelationsParentId AND Parent.GroupLanguageId = G1.GroupLanguageId
WHERE
    EcomGroupRelations.GroupRelationsAutoId IS NOT NULL
    AND
    Parent.GroupAutoId IS NULL
 
Nicolai Pedersen
Posted on 30/04/2020 09:00:14
Reply

Great, thanks!

Will get it added.

 

You must be logged in to post in the forum