Document Tree
Document Properties
Kbid
3F1249
Last Modified
18-Jul-2024
Added to KB
18-Jul-2024
Public Access
Everyone
Status
Online
Doc Type
Guidelines
Product
ICM 12
Guide - 12.0.0 - Improved Product and Catalog Deletion/Unsharing via JDBC/Batch Processing

Table of Contents


Introduction

Removal of products as well as catalogs with subcategories took quite some time for a very large number of objects to be deleted, regardless of whether this was done via bulk operation or product import in delete mode, within BMECat or via manual deletion, respectively. In all these cases an individual treatment based on the business objects has been used so far. To improve performance and enable the removal of large quantities of categories and products, the catalog/categories and product removal now allows for JDBC/batch processing based on direct SQL statements. This approach for deletion can be activated now. However the previous deletion method is still available and will remain the default for now.

The process of unsharing a large number of products required a significant amount of time to complete. To improve performance, several outbound sharing related actions now use JDBC/Batch processing based on direct SQL statements. This approach can be selectively activated. The previous method for unsharing products is still available and remains the default for now.

For further information on how to set properties/preferences, see Concept - Configuration.

Change

The deletion/removal/unsharing operation itself has no recognizable difference apart from the performance improvements. There is only a change in the quoting area: when deleting or unsharing products, quotes containing at least one of the removed products will be automatically set to rejected and a message is added to the seller comment. This behavior can be disabled if needed.

JDBC/batch processing can be enabled for the following operations/areas . For further details, see Concept - Product & Catalog JDBC/Batch Deletion and Unsharing.

  • Product deletion

    • BMECat import (also subcategory deletion)

    • Product bulk deletion

    • Standard product import (XML) in DELETE mode

  • Product unsharing

    • Delete channel sharing assignments

    • Delete sharing groups (from Outbound Product Sharing overview page only)

    • Remove products from a sharing group

    • Delete channel assignments from a sharing group

    • Delete sharing group assignments from a channel

    • Change sharing type of a channel to “share nothing”

  • Catalog/categories deletion

  • Catalog sharing deletion

    • Remove catalog sharing assigned to channels in the master catalog’s Channels tab

Migration

Is only necessary, if the JDBC/Batch deletion is used.

Disclaimer
The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.
The Intershop Knowledge Portal uses only technically necessary cookies. We do not track visitors or have visitors tracked by 3rd parties. Please find further information on privacy in the Intershop Privacy Policy and Legal Notice.
Home
Knowledge Base
Product Releases
Log on to continue
This Knowledge Base document is reserved for registered customers.
Log on with your Intershop Entra ID to continue.
Write an email to supportadmin@intershop.de if you experience login issues,
or if you want to register as customer.