Hi,
We deleted websites/data that we did not need on a brand new Rapido installation. A few days/weeks later we were debugging a few things and noticed A LOT of stale data. For example:
- ItemType_WebsiteSettingsTabs
Contained all of the deleted website tabs
- This then trickles down to
- ItemType_Ecommerce
- ItemType_Custom
- ItemType_Layout
- ItemType_ProductList
- ItemType_ProductPage
- Which then trickles down to other Items like
- ItemType_Font
- ItemType_ProductListView
- ItemType_ProductGridView
- ItemType_ProductDetailView
- ItemType_ProductListFacets
- ItemType_Header
- ItemType_Icons
- ItemType_Button
- ItemType_FooterColumn
- ItemType_Emails
- ItemType_MobileTop
- ItemType_MobileNavigation
- ItemType_MiniCart
- ItemType_Checkout
- ItemType_Sticker
- ItemType_ CustomWebsiteSettings
- Which also affects some ItemRelations
- ItemType_SocialLinks
- ItemType_CardTypeAndVerifiedPayment
I noticed the same when removing some items that had ItemRelationList (not associated with deleting a website). Not all of the relationId and associated records were deleted.
I know Nicolai was putting together some "Health Reports" associated with Ecommerce. Maybe these type of ItemType validations could be added too, although I realize how complex that might be since ItemType_WebsiteSettingsTabs is associated to an Area by convention. If the table was called ItemType_MySiteProperties it would almost be impossible to determine the usage.
Hope at least this helps someone have a better idea and/or a next step into finding stale data.
Best Regards,
Nuno Aguiar