Document Properties
Kbid
2955G0
Last Modified
16-Feb-2023
Added to KB
09-Jul-2020
Public Access
Everyone
Status
Online
Doc Type
References
Product
  • ICM 7.10
  • ICM 11
Job - Delete Orders

Name

Delete Orders

Domain

root / <Organization>

Job Dependencies

none

AcquiredResources

none

Cartridge

bc_order_orm

Pipeline

DeleteOrdersJob-Start

Affected Domain Objects

Order and all POs with relation to orders

Affected Tables

All tables with foreign key references to table Order.UUID.

Additionally all hierarchical 'child' tables referencing the order table.

(isorder, staticaddress, contractrevenueassignment, servicelineitem, frimservicelineitem, bundledproductlineitem, productlineitem, deliverynote, paymenthistory, paymenttransaction, lineitemgroup, ordercostobjectassignment, promotioncodeorderassignment, promotionorderassignment)

Stored Procedure

sp_deleteOrders

Default State

Disabled

Is Site Specific

False

Edit State

Disabled

Live State

Disabled

Description

Triggers order deletion with all according references.

By default it deletes orders where the toBeDeleted flag is set to true and with a status other than PENDING, MANUAL_INTERVENTION_NEEDED or EXPORTFAILED.

The status selection can be overwritten by defining the attribute ExcludedStatuses (data type: String), with comma separated values (e.g., ExcludedStatuses=NEW,EXPORTFAILED). If set to NONE no statuses are excluded.

It is also possible to define the maximum number of orders that are to be deleted during a run (default 10,000). Larger values are not recommended due to possible database problems/locks. The value can be overwritten by the attribute MaxNumberOfOrders (data type: Integer).

Scheduling

Manually after orders were marked for deletion

What Happens Switched Off

Old orders marked as to be deleted (potentially mass data) still exist.

Trouble Shooting

Manual deletion is quite complex.

Comments

Introduced for GDPR.

Product Version

7.9

Product To Version


Status
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.