{"id":3403,"date":"2025-02-11T09:20:53","date_gmt":"2025-02-11T08:20:53","guid":{"rendered":"https:\/\/eturia.co\/?p=3403"},"modified":"2025-02-11T11:51:55","modified_gmt":"2025-02-11T10:51:55","slug":"data-maintenance-sap-commerce","status":"publish","type":"post","link":"https:\/\/eturia.co\/es\/blog\/mantenimiento-datos-sap-commerce\/","title":{"rendered":"Estrategias de Limpieza y Mantenimiento de Datos en SAP Commerce"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-center\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-1\"><p>Maintaining and cleaning up accumulated data in large-scale SAP Commerce Cloud projects is crucial for ensuring high performance and system scalability. Over time, data growth from customer transactions, product catalogs, and system logs can slow operations if left unmanaged. This data accumulation will lead to lower performance, higher storage costs, and more wasted time by developers and support specialists. Hence, keeping a clean SAP hybris instance will save you money, so addressing it should be a no-brainer for any SAP Commerce team.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-0{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-0 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-0{width:100% !important;order : 0;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-0{width:100% !important;order : 0;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_2 1_2 fusion-flex-column fusion-flex-align-self-center\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-2\"><p id=\"129325cf-5e77-808b-9450-e09c6c48a0b5\" class=\"\"><span style=\"font-family: var(--body_typography-font-family); font-size: var(--body_typography-font-size); font-style: var(--body_typography-font-style,normal); letter-spacing: var(--body_typography-letter-spacing);\">This article outlines best practices and key cleanup strategies to optimize your SAP Commerce Cloud environments.<\/span><\/p>\n<p id=\"129325cf-5e77-80a8-9cf9-fef1199ca18d\" class=\"\">The platform provides two ways to clean up unused data:<\/p>\n<ul id=\"129325cf-5e77-80b4-83b3-c739031e4ad2\" class=\"bulleted-list\">\n<li><a href=\"https:\/\/help.sap.com\/docs\/SAP_COMMERCE_CLOUD_PUBLIC_CLOUD\/aa417173fe4a4ba5a473c93eb730a417\/8b9ba2218669101483e7f2ca38a2de96.html?locale=en-US\" target=\"_blank\" rel=\"noopener\">Maintenance Framework<\/a>: This older approach requires significant implementation effort. Developers must create custom strategies to fetch and process items and write code to define the logic for data cleanup.<\/li>\n<\/ul>\n<ul id=\"129325cf-5e77-8042-90dd-c2f3f03640af\" class=\"bulleted-list\">\n<li><a href=\"https:\/\/help.sap.com\/docs\/SAP_COMMERCE_CLOUD_PUBLIC_CLOUD\/aa417173fe4a4ba5a473c93eb730a417\/2268d55f40c94c5e8c43fa47f3b609a4.html?locale=en-US\" target=\"_blank\" rel=\"noopener\">Data Retention Framework<\/a>: A newer, more streamlined solution that addresses most use cases through configuration alone. It enables you to define retention rules specifying the logic for retrieving and removing items using queries and standard removal actions. Additionally, it supports injecting custom logic for processing items when needed.<\/li>\n<\/ul>\n<p id=\"17b325cf-5e77-80e2-9ad8-ede6b55d3f4a\" class=\"\">The following sections will focus on examples utilizing the Data Retention Framework.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-1{width:50% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-1 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 3.84%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 3.84%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-1{width:100% !important;order : 0;}.fusion-builder-column-1 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-1{width:100% !important;order : 0;}.fusion-builder-column-1 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_2 1_2 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\" style=\"border-radius:10px;\"><picture><source srcset=\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance-200x192.jpg.webp 200w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance-400x383.jpg.webp 400w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance-600x575.jpg.webp 600w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg.webp 795w\" sizes=\"auto, (max-width: 1024px) 100vw, (max-width: 640px) 100vw, 600px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" width=\"795\" height=\"762\" alt=\"Data Maintenance\" title=\"Data Maintenance\" src=\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg\" class=\"img-responsive wp-image-3537 webpexpress-processed\" srcset=\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance-200x192.jpg 200w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance-400x383.jpg 400w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance-600x575.jpg 600w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg 795w\" sizes=\"auto, (max-width: 1024px) 100vw, (max-width: 640px) 100vw, 600px\"><\/picture><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-2{width:50% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-2 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 3.84%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 3.84%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-2{width:100% !important;order : 0;}.fusion-builder-column-2 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-2{width:100% !important;order : 0;}.fusion-builder-column-2 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-1{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-1{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-1{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-1 fusion-title-text fusion-title-size-two\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h2 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:65;line-height:1.0;\">Key Cleanup Areas and Strategies<\/h2><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-2{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-2{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-2 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Cronjobs<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-3\"><p id=\"129325cf-5e77-80ac-b3b8-e30e9efd6555\" class=\"\">Cronjobs automate essential tasks but, over time, can bloat the system. Regularly clearing outdated cronjob records ensures smooth operations. The most common types of jobs include:<\/p>\n<ul id=\"129325cf-5e77-8098-bfda-e85495f042e7\" class=\"bulleted-list\">\n<li>Impex Import\/Export<\/li>\n<\/ul>\n<ul id=\"129325cf-5e77-80c4-a3da-f26d9e18318c\" class=\"bulleted-list\">\n<li>Catalog Synchronization<\/li>\n<\/ul>\n<ul id=\"129325cf-5e77-801d-af76-f421d09b7e66\" class=\"bulleted-list\">\n<li>Solr Jobs<\/li>\n<\/ul>\n<p id=\"129325cf-5e77-804e-bcd5-ceca41bd3dfc\" class=\"\">To clean up these cronjob instances, you can set up a retention job using the ImpEx below:<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-1 > .CodeMirror, .fusion-syntax-highlighter-1 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-1 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-1 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-1 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_1\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_1\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">$twoWeeks = 1209600\n\nINSERT_UPDATE FlexibleSearchRetentionRule; code[unique = true]; searchQuery; retentionTimeSeconds; actionReference;\n; cronjobCleanupRule ; \"SELECT {c.pk}, {c.itemType}\n FROM {CronJob as c join ComposedType as t on {c.itemtype} = {t.pk} LEFT JOIN Trigger AS trg ON {trg.cronjob} = {c.pk} }\n WHERE\n   {trg.pk} IS NULL AND\n   {c.code} LIKE '00______%' AND\n   {t.code} IN ( 'ImpExImportCronJob', 'CatalogVersionSyncCronJob', 'SolrIndexerCronJob' ) AND\n   {c.endTime} < ?CALC_RETIREMENT_TIME\" ; $twoWeeks ; basicRemoveCleanupAction ;\n\nINSERT_UPDATE RetentionJob; code[unique = true]; retentionRule(code); batchSize\n; cronjobRetentionJob ; cronjobCleanupRule ; 1000\n\nINSERT_UPDATE CronJob; code[unique = true]; job(code); sessionLanguage(isoCode)[default = en]\n; cronjobRetentionCronJob ; cronjobRetentionJob ;<\/textarea><\/div><div class=\"fusion-text fusion-text-4\"><p>*<strong>NOTE<\/strong>: Another method for deleting these cronjobs is to use the <a href=\"https:\/\/help.sap.com\/docs\/SAP_COMMERCE_CLOUD_PUBLIC_CLOUD\/aa417173fe4a4ba5a473c93eb730a417\/8b9ce4868669101499b2f0f25ef9395f.html?locale=en-US#cronjob-technicalguide-cleaningupcronjobs\" target=\"_blank\" rel=\"noopener\">CleanupCronJobStrategy<\/a> from the legacy Maintenance Framework. However, this approach requires customization to fine-tune\u00a0the selection of cronjobs it handles.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-3{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-3 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-3{width:100% !important;order : 0;}.fusion-builder-column-3 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-3{width:100% !important;order : 0;}.fusion-builder-column-3 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-2{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-3 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-4 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-3{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-3{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-3 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Cronjob Logs<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-5\"><p id=\"129325cf-5e77-8029-9f5a-e881d1bf392f\" class=\"\">As time passes, cronjob logs will also accumulate. To clean up old cronjob log files, you must set up a cronjob and a trigger specifically for log deletion.<\/p>\n<p id=\"129325cf-5e77-80e1-93bd-e2a1cd0132bf\" class=\"\">It\u2019s important to note that the platform does not automatically remove old log files.<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-2 > .CodeMirror, .fusion-syntax-highlighter-2 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-2 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-2 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-2 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_2\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_2\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">INSERT_UPDATE CronJob; code[unique = true]; job(code); sessionLanguage(isoCode)[default = en]\n; cronjobLogCleanupCronjob ; cleanUpLogsJobPerformable ;\n\nINSERT_UPDATE Trigger; cronJob(code)[unique = true]; cronExpression\n# every hour\n; cronjobLogCleanupCronjob ; 0 0 0\/1 * * ?<\/textarea><\/div><div class=\"fusion-text fusion-text-6\"><p>If you have cronjobs that run frequently, it&#8217;s recommended that you schedule log file cleanups more often. This helps prevent an excessive accumulation of log files that need to be deleted later.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-4{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-4 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-4{width:100% !important;order : 0;}.fusion-builder-column-4 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-4{width:100% !important;order : 0;}.fusion-builder-column-4 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-3{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-4 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-5 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-4{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-4{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-4 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Cronjob Histories<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-7\"><p id=\"129325cf-5e77-8029-9f5a-e881d1bf392f\">Like cronjob logs, cronjob histories can accumulate for jobs that run very frequently. SAP Commerce comes with <code>cronJobHistoryRetentionCronJob<\/code>, which limits the number of CronJobHistory entries per cronjob. This cronjob is enabled by default; you just need to make sure it&#8217;s enabled and set up a trigger.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-5{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-5 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-5{width:100% !important;order : 0;}.fusion-builder-column-5 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-5{width:100% !important;order : 0;}.fusion-builder-column-5 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-6 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-5{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-5{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-5 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Impex Import\/Export Media<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-8\"><p id=\"129325cf-5e77-80de-9470-c183f692a624\" class=\"\">Each ImpEx import or export results in the creation of at least one ImpexMedia object. These media files remain in the system even after the associated ImpEx jobs are deleted, as the platform does not automatically remove them. A retention job can be created to clean up old media.<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-3 > .CodeMirror, .fusion-syntax-highlighter-3 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-3 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-3 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-3 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_3\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_3\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">$twoWeeks = 1209600\n\nINSERT_UPDATE FlexibleSearchRetentionRule; code[unique = true]; searchQuery; retentionTimeSeconds; actionReference;\n; impexMediaCleanupRule ; \"SELECT {i.pk}, {i.itemtype}\n   FROM {ImpexMedia as i}\n   WHERE\n   {i.code} LIKE '00______' AND\n   {i.modifiedTime} < ?CALC_RETIREMENT_TIME\" ; $twoWeeks ; basicRemoveCleanupAction ;\n\nINSERT_UPDATE RetentionJob; code[unique = true]; retentionRule(code); batchSize\n; impexMediaCleanupJob ; impexMediaCleanupRule ; 1000\n\nINSERT_UPDATE CronJob; code[unique = true]; job(code); sessionLanguage(isoCode)[default = en]\n; impexMediaCleanupCronJob ; impexMediaCleanupJob ;\n\nINSERT_UPDATE Trigger; cronJob(code)[unique = true]; cronExpression\n; impexMediaCleanupCronJob ; 0 0 0 * * ?<\/textarea><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-6{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-6 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-6{width:100% !important;order : 0;}.fusion-builder-column-6 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-6{width:100% !important;order : 0;}.fusion-builder-column-6 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-4{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-5 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-7 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-6{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-6{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-6 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Saved Values<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-9\"><p>The Backoffice utilizes Saved Values to monitor changes made to items by business users, displayed under \u201cLast Changes\u201d in the Administration tab. If your project has been running for an extended period or has undergone multiple upgrades, your database has likely accumulated millions of <code>SavedValues<\/code>\u00a0and\u00a0<code>SavedValueEntry<\/code>\u00a0records.<\/p>\n<p>You can configure how many entries per item are stored using the following property:<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-4 > .CodeMirror, .fusion-syntax-highlighter-4 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-4 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-4 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-4 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_4\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_4\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">hmc.storing.modifiedvalues.size=10<\/textarea><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-7{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-7 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-7{width:100% !important;order : 0;}.fusion-builder-column-7 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-7{width:100% !important;order : 0;}.fusion-builder-column-7 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-8 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-10\"><p>The very last change (if available) is always displayed. Also, to free up space in the database, we can set up retention rules to delete old entries:<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-5 > .CodeMirror, .fusion-syntax-highlighter-5 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-5 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-5 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-5 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_5\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_5\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">INSERT_UPDATE FlexibleSearchRetentionRule; code[unique = true]; searchQuery; retentionTimeSeconds; actionReference;\n; savedValuesDeleteRule ; \"SELECT {s.pk}, {s.itemtype}\n   FROM {SavedValues as s}\n   WHERE {s.modifiedItem} IS NULL AND {s.modifiedtime} < ?CALC_RETIREMENT_TIME\" ; $twoWeeks ; basicRemoveCleanupAction ;\n; savedValueEntryRule   ; \"SELECT {e.pk}, {e.itemtype}\n   FROM {SavedValueEntry AS e LEFT JOIN SavedValues AS s ON {e.parent} = {s.pk} }\n   WHERE {s.pk} IS NULL\"                              ; 0         ; basicRemoveCleanupAction ;\n\nINSERT_UPDATE RetentionJob; code[unique = true]; retentionRule(code); batchSize\n; savedValuesDeleteCleanupJob ; savedValuesDeleteRule ; 1000\n; savedValueEntryCleanupJob   ; savedValueEntryRule   ; 1000\n\nINSERT_UPDATE CronJob; code[unique = true]; job(code); sessionLanguage(isoCode)[default = en]\n; savedValuesDeleteCleanupCronJob ; savedValuesDeleteCleanupJob ;\n; savedValueEntryCleanupCronJob   ; savedValueEntryCleanupJob   ;<\/textarea><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-8{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-8 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-8{width:100% !important;order : 0;}.fusion-builder-column-8 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-8{width:100% !important;order : 0;}.fusion-builder-column-8 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-9 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-11\"><p>To make it more convenient, we can create an instance of\u00a0<code>CompositeCronJob<\/code> to have both cronjobs run in the desired order by having to run only one cronjob.<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-6 > .CodeMirror, .fusion-syntax-highlighter-6 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-6 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-6 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-6 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_6\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_6\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">INSERT_UPDATE CompositeCronJob; code[unique = true]; job(code); sessionLanguage(isoCode)[default = en]\n; savedValuesCleanupCompositeCronJob ; compositeJobPerformable ;\n\nINSERT Trigger; cronJob(code)[unique = true]; cronExpression\n; savedValuesCleanupCompositeCronJob ; 0 0 0 * * ?\n\nINSERT_UPDATE CompositeEntry; code[unique = true]; executableCronJob(code); compositeCronJob(code)[default = 'savedValuesCleanupCompositeCronJob']\n; savedValuesDeleteCleanupCronJobEntry ; savedValuesDeleteCleanupCronJob ;\n; savedValueEntryCleanupCronJobEntry   ; savedValueEntryCleanupCronJob   ;\n\nUPDATE CompositeCronJob; code[unique = true]; compositeEntries(code)\n; savedValuesCleanupCompositeCronJob ; savedValuesDeleteCleanupCronJobEntry,savedValueEntryCleanupCronJobEntry<\/textarea><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-9{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-9 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-9{width:100% !important;order : 0;}.fusion-builder-column-9 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-9{width:100% !important;order : 0;}.fusion-builder-column-9 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-5{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-6 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-10 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-7{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-7{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-7 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">HTTP Sessions<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-12\"><p>For Accelerator-based storefronts, HTTP Sessions can be stored in the database using the\u00a0<a href=\"https:\/\/help.sap.com\/docs\/SAP_COMMERCE_CLOUD_PUBLIC_CLOUD\/aa417173fe4a4ba5a473c93eb730a417\/5da5660b2a3f4263ac3095d900d07f88.html\" target=\"_blank\" rel=\"noopener\">HTTP Session Failover<\/a> feature. To prevent performance issues, it\u2019s critical to clean up obsolete sessions. You can accomplish this by setting up another retention rule:<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-7 > .CodeMirror, .fusion-syntax-highlighter-7 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-7 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-7 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-7 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_7\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_7\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">$oneDay = 86400\nINSERT_UPDATE FlexibleSearchRetentionRule;code[unique=true];searchQuery;retentionTimeSeconds;actionReference;\n;storedSessionRule;\"SELECT {s.pk}, {s.itemtype}\n   FROM {StoredHttpSession AS s}\n   WHERE\n   {s.modifiedTime} < ?CALC_RETIREMENT_TIME\"; $oneDay; basicRemoveCleanupAction;\n \nINSERT_UPDATE RetentionJob;code[unique=true];retentionRule(code);batchSize\n; storedSessionCleanupJob; storedSessionRule; 1000\n\nINSERT_UPDATE CronJob;code[unique=true];job(code);sessionLanguage(isoCode)[default=en]\n; storedSessionCleanupCronJob; storedSessionCleanupJob;\n\nINSERT_UPDATE Trigger; cronJob(code)[unique = true]   ; cronExpression\n# every 30 minutes\n; storedSessionCleanupCronJob ; 0 0\/30 * * * ?<\/textarea><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-10{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-10 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-10{width:100% !important;order : 0;}.fusion-builder-column-10 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-10{width:100% !important;order : 0;}.fusion-builder-column-10 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-6{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-7 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-11 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-8{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-8{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-8 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Transactional Data<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-13\"><p>This is the data that SAP hybris creates when customers use the storefront. To speed things up, some of this unused data can be removed. Let&#8217;s examine it in more detail.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-11{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-11 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-11{width:100% !important;order : 0;}.fusion-builder-column-11 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-11{width:100% !important;order : 0;}.fusion-builder-column-11 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-7{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-8 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-12 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-9{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-9{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-9 fusion-title-text fusion-title-size-four\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h4 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:30;line-height:1.4;\">Carts<\/h4><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-14\"><p>For removing old abandoned carts, SAP Commerce provides the following cronjob Out of the Box: <a href=\"https:\/\/help.sap.com\/docs\/SAP_COMMERCE_CLOUD_PUBLIC_CLOUD\/e1391e5265574bfbb56ca4c0573ba1dc\/8c3a6caf866910148cd58d649958d7e2.html\">Removing Old Carts with Cronjob<\/a><\/p>\n<p>We only need to configure it as we need it, as it&#8217;s pretty straightforward.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-12{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-12 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-12{width:100% !important;order : 0;}.fusion-builder-column-12 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-12{width:100% !important;order : 0;}.fusion-builder-column-12 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-8{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-9 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-13 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-10{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-10{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-10 fusion-title-text fusion-title-size-four\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h4 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:30;line-height:1.4;\">Business Processes<\/h4><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-15\"><p>Most user actions in the Accelerator initiate Business Processes, such as resetting passwords, placing orders, and managing order fulfillment. These processes accumulate over time and must be regularly removed to maintain system efficiency.<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-8 > .CodeMirror, .fusion-syntax-highlighter-8 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-8 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-8 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-8 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_8\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_8\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">$twoWeeks = 1209600\nINSERT_UPDATE FlexibleSearchRetentionRule;code[unique=true];searchQuery;retentionTimeSeconds;actionReference;\n;businessProcessRule;\"SELECT {p:pk}, {p:itemtype}\n   FROM {BusinessProcess AS p JOIN ProcessState AS s ON {p:state} = {s:pk} }\n   WHERE\n   {s:code} in ('SUCCEEDED') AND\n   {p:modifiedTime} < ?CALC_RETIREMENT_TIME\"; $twoWeeks; basicRemoveCleanupAction;\n \nINSERT_UPDATE RetentionJob;code[unique=true];retentionRule(code);batchSize\n; businessProcessCleanupJob; businessProcessRule; 1000\n\nINSERT_UPDATE CronJob;code[unique=true];job(code);sessionLanguage(isoCode)[default=en]\n; businessProcessCleanupCronJob; businessProcessCleanupJob;\n\nINSERT_UPDATE Trigger; cronJob(code)[unique = true]   ; cronExpression\n; businessProcessCleanupCronJob ; 0 0 0 * * ?<\/textarea><\/div><div class=\"fusion-text fusion-text-16\"><p>If you have customised business processes, clean up any related data. For instance, <strong>EmailMessages<\/strong> are automatically removed at the end of a business process if sent successfully. However, those that fail to send will remain in the database and should be addressed during regular maintenance.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-13{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-13 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-13{width:100% !important;order : 0;}.fusion-builder-column-13 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-13{width:100% !important;order : 0;}.fusion-builder-column-13 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-9{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-10 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-14 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-11{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-11{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-11 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Type System Cleanup<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-17\"><p>To maintain an optimized SAP Commerce Cloud system, cleaning up unnecessary data and configurations in the type system is essential for ensuring optimal performance and database health. The type system can accumulate unused or redundant entities over time, such as <strong>Orphan Types<\/strong>\u00a0and\u00a0<strong>Orphan Attributes<\/strong>. This section will cover how to identify and remove these orphaned elements from your SAP Commerce Cloud system.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-14{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-14 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-14{width:100% !important;order : 0;}.fusion-builder-column-14 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-14{width:100% !important;order : 0;}.fusion-builder-column-14 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-10{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-11 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-15 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-12{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-12{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-12 fusion-title-text fusion-title-size-four\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h4 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:30;line-height:1.4;\">Orphan Types<\/h4><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-18\"><p>Orphan types refer to records in the database that no longer have valid references. These typically occur when a parent entity is deleted from the items.xml, but the associated child entities remain in the database. Orphaned records can clutter your database, slowing query performance and increasing storage costs.<\/p>\n<p>The <strong>Hybris Administration Console (HAC)<\/strong> is the primary tool for identifying and removing orphan types in SAP Commerce Cloud. According to SAP&#8217;s recommendations, orphan types should be manually cleaned using the HAC. This can be achieve from Maintenance -&gt; Cleanup -&gt; Type system.<\/p>\n<\/div><div style=\"text-align:center;\"><style>.fusion-imageframe.imageframe-2{ margin-top : 25px;}<\/style><span class=\" fusion-imageframe imageframe-none imageframe-2 hover-type-none\" style=\"border-radius:10px;\"><picture><source srcset=\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console-200x167.png.webp 200w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console-400x335.png.webp 400w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console-600x502.png.webp 600w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console.png.webp 649w\" sizes=\"auto, (max-width: 1024px) 100vw, (max-width: 640px) 100vw, 649px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" width=\"649\" height=\"543\" alt=\"Orphaned types in the hybris console\" title=\"Orphaned types in the hybris console\" src=\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console.png\" class=\"img-responsive wp-image-3512 webpexpress-processed\" srcset=\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console-200x167.png 200w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console-400x335.png 400w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console-600x502.png 600w, https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/Orphaned-types-in-the-hybris-console.png 649w\" sizes=\"auto, (max-width: 1024px) 100vw, (max-width: 640px) 100vw, 649px\"><\/picture><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-15{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-15 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-15{width:100% !important;order : 0;}.fusion-builder-column-15 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-15{width:100% !important;order : 0;}.fusion-builder-column-15 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-11{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-12 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-16 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-13{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-13{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-13 fusion-title-text fusion-title-size-four\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h4 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:30;line-height:1.4;\">Orphan Attributes<\/h4><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-19\"><p>In addition to orphan types, another common issue is\u00a0<strong>Orphan Attributes<\/strong>. These attributes are typically left behind after code refactoring or removing unused features. While they no longer serve a purpose in the system, they still exist in the database, potentially confusing data model queries and impacting performance.<\/p>\n<p>The recommended approach for removing orphan attributes is to run <strong>Impex<\/strong> scripts that explicitly remove them from the database. However, it is important to note that orphan attributes can only be removed from the original item type where they were defined. The Impex script will not work on subclassed or extended item types.<\/p>\n<p>For example, the following Impex script removes the orphaned attribute <code>defaultPaymentMode<\/code> from the <code>BaseStore<\/code> itemtype:<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-9 > .CodeMirror, .fusion-syntax-highlighter-9 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-9 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-9 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-9 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_9\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_9\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">REMOVE AttributeDescriptor; qualifier[unique = true]; enclosingType(code)[unique = true]\n                          ; defaultPaymentMode      ; BaseStore<\/textarea><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-16{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-16 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-16{width:100% !important;order : 0;}.fusion-builder-column-16 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-16{width:100% !important;order : 0;}.fusion-builder-column-16 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-12{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-13 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-17 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-14{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-14{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-14 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Generic Audit<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-20\"><p>The Generic Audit feature records all persistence actions, such as creating, modifying, and deleting specified items. It maintains a change log that tracks how an item evolves. However, the rapid generation of this data can quickly accumulate, potentially impacting the performance of both your database and overall solution.<\/p>\n<p>By default, it is enabled for a wide range of types. Therefore, the recommendation is to carefully review and consider turning off any type you don\u2019t need for the Production Environment. You can turn on\/off the auditing of a type by setting the following property for a specific <em>typecode<\/em>:<\/p>\n<\/div><style type=\"text\/css\" scopped=\"scopped\">.fusion-syntax-highlighter-10 > .CodeMirror, .fusion-syntax-highlighter-10 > .CodeMirror .CodeMirror-gutters {background-color:var(--awb-color1);}.fusion-syntax-highlighter-10 > .CodeMirror .CodeMirror-gutters { background-color: var(--awb-color2); }.fusion-syntax-highlighter-10 > .CodeMirror .CodeMirror-linenumber { color: var(--awb-color8); }<\/style><div class=\"fusion-syntax-highlighter-container fusion-syntax-highlighter-10 fusion-syntax-highlighter-theme-light\" style=\"opacity:0;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:14px;border-width:1px;border-style:solid;border-color:#6239bd;\"><div class=\"syntax-highlighter-copy-code\"><span class=\"syntax-highlighter-copy-code-title\" data-id=\"fusion_syntax_highlighter_10\" style=\"font-size:14px;\">Copy to Clipboard<\/span><\/div><textarea class=\"fusion-syntax-highlighter-textarea\" id=\"fusion_syntax_highlighter_10\" data-readOnly=\"nocursor\" data-lineNumbers=\"1\" data-lineWrapping=\"\" data-theme=\"default\" data-mode=\"text\/x-sh\">audit.<typecode>.enabled=true|false<\/textarea><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-17{width:100% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-17 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-17{width:100% !important;order : 0;}.fusion-builder-column-17 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-17{width:100% !important;order : 0;}.fusion-builder-column-17 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-13{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-14 fusion-flex-container has-pattern-background has-mask-background nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#edeef2;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-center\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-18 fusion_builder_column_2_3 2_3 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1024px) {.fusion-title.fusion-title-15{margin-top:0px!important; margin-right:0px!important;margin-bottom:31px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-15{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-15 fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-right:0px;margin-bottom:31px;margin-left:0px;\"><div class=\"title-sep-container title-sep-container-left fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><span class=\"awb-title-spacer fusion-no-large-visibility fusion-no-medium-visibility fusion-no-small-visibility\"><\/span><h3 class=\"title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:42;line-height:1.3;\">Boost your SAP Commerce Performance<\/h3><span class=\"awb-title-spacer\"><\/span><div class=\"title-sep-container title-sep-container-right\"><div class=\"title-sep sep-\" style=\"border-color:#edeef2;\"><\/div><\/div><\/div><div class=\"fusion-text fusion-text-21\"><p>Regular data cleanup maintains SAP Commerce Cloud\u2019s performance and scalability. Implementing the strategies mentioned above ensures your system runs efficiently and remains prepared for future growth. If you need a hand with the clean up and performance of your SAP Commerce Solution, you can also reach out to us through our <a href=\"https:\/\/eturia.co\/services\/sap-commerce-development\/\">SAP hybris Development Services<\/a>, and the E-Turia engineers will fine-tune your solution to maximize its potential.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-18{width:66.666666666667% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-18 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 2.88%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 2.88%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-18{width:100% !important;order : 0;}.fusion-builder-column-18 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-18{width:100% !important;order : 0;}.fusion-builder-column-18 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-19 fusion_builder_column_1_3 1_3 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-3 hover-type-none\" style=\"max-width:50%;\"><picture><source srcset=\"https:\/\/eturia.co\/wp-content\/uploads\/2024\/06\/ETuria-square-logo-500-200x200.png.webp 200w, https:\/\/eturia.co\/wp-content\/uploads\/2024\/06\/ETuria-square-logo-500-400x400.png.webp 400w, https:\/\/eturia.co\/wp-content\/uploads\/2024\/06\/ETuria-square-logo-500.png.webp 500w\" sizes=\"auto, (max-width: 1024px) 100vw, (max-width: 640px) 100vw, 400px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"500\" alt=\"ETuria square logo\" title=\"ETuria square logo 500\" src=\"https:\/\/eturia.co\/wp-content\/uploads\/2024\/06\/ETuria-square-logo-500.png\" class=\"img-responsive wp-image-3182 webpexpress-processed\" srcset=\"https:\/\/eturia.co\/wp-content\/uploads\/2024\/06\/ETuria-square-logo-500-200x200.png 200w, https:\/\/eturia.co\/wp-content\/uploads\/2024\/06\/ETuria-square-logo-500-400x400.png 400w, https:\/\/eturia.co\/wp-content\/uploads\/2024\/06\/ETuria-square-logo-500.png 500w\" sizes=\"auto, (max-width: 1024px) 100vw, (max-width: 640px) 100vw, 400px\"><\/picture><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-19{width:33.333333333333% !important;margin-top : 0px;margin-bottom : 0px;}.fusion-builder-column-19 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 5.76%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 5.76%;}@media only screen and (max-width:1024px) {.fusion-body .fusion-builder-column-19{width:100% !important;order : 0;}.fusion-builder-column-19 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-19{width:100% !important;order : 0;}.fusion-builder-column-19 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-14{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":3537,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3403","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Maintenance and Cleanup Strategies in SAP Commerce<\/title>\n<meta name=\"description\" content=\"Optimize SAP Commerce Cloud with efficient data cleanup strategies for better performance and scalability.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/eturia.co\/es\/blog\/mantenimiento-datos-sap-commerce\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Maintenance and Cleanup Strategies in SAP Commerce\" \/>\n<meta property=\"og:description\" content=\"Optimize SAP Commerce Cloud with efficient data cleanup strategies for better performance and scalability.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eturia.co\/es\/blog\/mantenimiento-datos-sap-commerce\/\" \/>\n<meta property=\"og:site_name\" content=\"E-Turia\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-11T08:20:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-11T10:51:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"795\" \/>\n\t<meta property=\"og:image:height\" content=\"762\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"E-Turia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"E-Turia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/\"},\"author\":{\"name\":\"E-Turia\",\"@id\":\"https:\/\/eturia.co\/#\/schema\/person\/5427b81726cf3a81ca0d6aacc1850870\"},\"headline\":\"Data Maintenance and Cleanup Strategies in SAP Commerce\",\"datePublished\":\"2025-02-11T08:20:53+00:00\",\"dateModified\":\"2025-02-11T10:51:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/\"},\"wordCount\":11220,\"publisher\":{\"@id\":\"https:\/\/eturia.co\/#organization\"},\"image\":{\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/\",\"url\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/\",\"name\":\"Data Maintenance and Cleanup Strategies in SAP Commerce\",\"isPartOf\":{\"@id\":\"https:\/\/eturia.co\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg\",\"datePublished\":\"2025-02-11T08:20:53+00:00\",\"dateModified\":\"2025-02-11T10:51:55+00:00\",\"description\":\"Optimize SAP Commerce Cloud with efficient data cleanup strategies for better performance and scalability.\",\"breadcrumb\":{\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#primaryimage\",\"url\":\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg\",\"contentUrl\":\"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg\",\"width\":795,\"height\":762,\"caption\":\"Data Maintenance\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eturia.co\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Maintenance and Cleanup Strategies in SAP Commerce\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/eturia.co\/#website\",\"url\":\"https:\/\/eturia.co\/\",\"name\":\"E-Turia\",\"description\":\"Crafting SAP Commerce Experiences\",\"publisher\":{\"@id\":\"https:\/\/eturia.co\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/eturia.co\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/eturia.co\/#organization\",\"name\":\"E-Turia\",\"url\":\"https:\/\/eturia.co\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/eturia.co\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/eturia.co\/wp-content\/uploads\/2022\/08\/E-Turia-Color.png\",\"contentUrl\":\"https:\/\/eturia.co\/wp-content\/uploads\/2022\/08\/E-Turia-Color.png\",\"width\":2103,\"height\":1881,\"caption\":\"E-Turia\"},\"image\":{\"@id\":\"https:\/\/eturia.co\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/eturia.co\/#\/schema\/person\/5427b81726cf3a81ca0d6aacc1850870\",\"name\":\"E-Turia\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/eturia.co\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1eafc775d6e852d525aae91a5f6a9a7fc89f2a2ddb74dfc15622460ee86f065c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1eafc775d6e852d525aae91a5f6a9a7fc89f2a2ddb74dfc15622460ee86f065c?s=96&d=mm&r=g\",\"caption\":\"E-Turia\"},\"sameAs\":[\"https:\/\/eturia.co\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Estrategias de Limpieza y Mantenimiento de Datos en SAP Commerce","description":"Veamos c\u00f3mo optimizar SAP Commerce Cloud con estrategias de limpieza de datos eficientes para un mejor rendimiento y escalabilidad.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/eturia.co\/es\/blog\/mantenimiento-datos-sap-commerce\/","og_locale":"es_ES","og_type":"article","og_title":"Data Maintenance and Cleanup Strategies in SAP Commerce","og_description":"Optimize SAP Commerce Cloud with efficient data cleanup strategies for better performance and scalability.","og_url":"https:\/\/eturia.co\/es\/blog\/mantenimiento-datos-sap-commerce\/","og_site_name":"E-Turia","article_published_time":"2025-02-11T08:20:53+00:00","article_modified_time":"2025-02-11T10:51:55+00:00","og_image":[{"width":795,"height":762,"url":"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg","type":"image\/jpeg"}],"author":"E-Turia","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"E-Turia","Tiempo de lectura":"19 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#article","isPartOf":{"@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/"},"author":{"name":"E-Turia","@id":"https:\/\/eturia.co\/#\/schema\/person\/5427b81726cf3a81ca0d6aacc1850870"},"headline":"Data Maintenance and Cleanup Strategies in SAP Commerce","datePublished":"2025-02-11T08:20:53+00:00","dateModified":"2025-02-11T10:51:55+00:00","mainEntityOfPage":{"@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/"},"wordCount":11220,"publisher":{"@id":"https:\/\/eturia.co\/#organization"},"image":{"@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#primaryimage"},"thumbnailUrl":"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg","articleSection":["Blog"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/","url":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/","name":"Estrategias de Limpieza y Mantenimiento de Datos en SAP Commerce","isPartOf":{"@id":"https:\/\/eturia.co\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#primaryimage"},"image":{"@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#primaryimage"},"thumbnailUrl":"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg","datePublished":"2025-02-11T08:20:53+00:00","dateModified":"2025-02-11T10:51:55+00:00","description":"Veamos c\u00f3mo optimizar SAP Commerce Cloud con estrategias de limpieza de datos eficientes para un mejor rendimiento y escalabilidad.","breadcrumb":{"@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#primaryimage","url":"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg","contentUrl":"https:\/\/eturia.co\/wp-content\/uploads\/2025\/02\/eturia_data_maintenance.jpg","width":795,"height":762,"caption":"Data Maintenance"},{"@type":"BreadcrumbList","@id":"https:\/\/eturia.co\/blog\/data-maintenance-sap-commerce\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eturia.co\/"},{"@type":"ListItem","position":2,"name":"Data Maintenance and Cleanup Strategies in SAP Commerce"}]},{"@type":"WebSite","@id":"https:\/\/eturia.co\/#website","url":"https:\/\/eturia.co\/","name":"E-Turia","description":"Crafting SAP Commerce Experiences","publisher":{"@id":"https:\/\/eturia.co\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eturia.co\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/eturia.co\/#organization","name":"E-Turia","url":"https:\/\/eturia.co\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/eturia.co\/#\/schema\/logo\/image\/","url":"https:\/\/eturia.co\/wp-content\/uploads\/2022\/08\/E-Turia-Color.png","contentUrl":"https:\/\/eturia.co\/wp-content\/uploads\/2022\/08\/E-Turia-Color.png","width":2103,"height":1881,"caption":"E-Turia"},"image":{"@id":"https:\/\/eturia.co\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/eturia.co\/#\/schema\/person\/5427b81726cf3a81ca0d6aacc1850870","name":"E-Turia","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/eturia.co\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1eafc775d6e852d525aae91a5f6a9a7fc89f2a2ddb74dfc15622460ee86f065c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1eafc775d6e852d525aae91a5f6a9a7fc89f2a2ddb74dfc15622460ee86f065c?s=96&d=mm&r=g","caption":"E-Turia"},"sameAs":["https:\/\/eturia.co\/"]}]}},"_links":{"self":[{"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/posts\/3403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/comments?post=3403"}],"version-history":[{"count":29,"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/posts\/3403\/revisions"}],"predecessor-version":[{"id":3543,"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/posts\/3403\/revisions\/3543"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/media\/3537"}],"wp:attachment":[{"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/media?parent=3403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/categories?post=3403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eturia.co\/es\/wp-json\/wp\/v2\/tags?post=3403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}