Catalogue Daily Maintenance Tool

This tool allows to identify, report and remediate integrity issues in Product Catalogue.

When enabled, the tool will run overnight and check the catalogue for integrity issues. The identified issues will be reported in the Reports section, if the tool is not running in "Report Only" mode, a remedy will be applied.

It is strongly recommended to use the maintenance tool in "Report Only" mode for the first time to see if the reported issues are intended to be fixed.

Tool	Issue	Remediation
Detach unused option lists from products	An option list is linked to a product, but no variants are linked to this option list in the context of the product. A product is linked to the option list which no longer exists (unpublished or deleted).	Unused, unpublished and deleted option lists will be removed from products.
Detach orphaned options from variants	A product is linked to two option lists (e.g. "Colour" and "Size"). A variant is linked to an option from each of these lists (e.g. "Blue" and "XL"). Then one option list ("Colour") has been detached from the product, or deleted. Some variants will be still linked to that option list, though the links will not be shown in the DXP.	Orphaned options belonging to unused option lists will be removed from the variants
Fix permissions on pricing options	A variant has at least one (but can have many) Pricing Option associated with it. Sometimes, as result of a bad import or copy, the Pricing Option may have insufficient default permission (Authority) or be unpublished. This may cause integration issues.	Publish all pricing options associated with the variant and set default authority to "All"

Tool

Issue

Remediation

Detach unused option lists from products

An option list is linked to a product, but no variants are linked to this option list in the context of the product.

A product is linked to the option list which no longer exists (unpublished or deleted).

Unused, unpublished and deleted option lists will be removed from products.

Detach orphaned options from variants

A product is linked to two option lists (e.g. "Colour" and "Size"). A variant is linked to an option from each of these lists (e.g. "Blue" and "XL"). Then one option list ("Colour") has been detached from the product, or deleted. Some variants will be still linked to that option list, though the links will not be shown in the DXP.

Orphaned options belonging to unused option lists will be removed from the variants

Fix permissions on pricing options

A variant has at least one (but can have many) Pricing Option associated with it. Sometimes, as result of a bad import or copy, the Pricing Option may have insufficient default permission (Authority) or be unpublished. This may cause integration issues.

Publish all pricing options associated with the variant and set default authority to "All"

Sample Report Output

Cleanup process started for Centre: Sample Centre

'Report Only' option is enabled. No action/cleanup will be performed.

Checking variants attached to option lists which are not connected to underlying products...

Option lists to be detached from variants:

- Optionlists 'Power Supply' to be detached from variant 'Black' for product 'Andiamo'

Checking products attached to option lists which have no corresponding variants...

Option lists to be detached from products:

- Optionlists 'Color' to be detached from product 'ORB' (ORB-EU)

- Optionlists 'Color' to be detached from product 'CUBE' (CUB-EU)

- Optionlists 'Remote' to be detached from product 'PAL BT' (PALBT-EU)

- Optionlists 'Color' to be detached from product 'Model Sub' (ARTSUB-EU)

Checking pricing options to fix permission issues such as authority setting and publishing status...

Permission issues to be fixed on pricing option:

- Permission issues to be fixed on pricing option for Variant 'Black Ash / Black' (CUB-1720-EU) from Product 'CUBE' (CUB-EU)

Cleanup process finished for Centre Sample Centre