Document Properties
Kbid
29H509
Last Modified
08-Jul-2020
Added to KB
09-Jul-2020
Public Access
Everyone
Status
Online
Doc Type
References
Product
  • ICM 7.10
  • ICM 11
Job - ProductPrice Cleanup

Name

ProductPrice Cleanup

Domain

<Organization>-<Channel>

Job Dependencies

none

AcquiredResources

none

Cartridge

bc_pricing

Pipeline

ProcessProductPriceCleanup-Start

Affected Domain Objects

ProductPriceBO, ProductPriceScaleBO

Affected Tables

  • Pricelists
    pricescaleentry
    pricescaleentry_av
    pricescaletable
    pricescaletable_av
    pricescaletableassignment
  • Jobs
    jobconfiguration
    jobconfiguration_av
  • Locking
    acqlogentry
    acqlogentryresourceassignment
    acqlogentry_av
    isresource
    isresource_av
    jobresourceassignment
    process
    process_av
    resourcelock
    staginggroupresourceassignment

Stored Procedure


Default State

Enabled

Is Site Specific

True

Edit State

Globally Enabled

Live State

Locally Enabled

Description

Removes price list prices older than the configured number of days.

Scheduling

Depends on usage of price lists. The more price lists and price scale tables with specified valid-to dates, the more often the job should be called.

What Happens Switched Off

PriceScaleTable, PriceScaleTable_AV, PriceScaleEntry, PriceScaleEntry_AV, PriceScaleTableAssignment tables grow.

Trouble Shooting

The LifeTime attribute specifies the number of days in the past in which obsolete prices will be searched for.

Comments

Product Version

7.0

Product To Version


StatusNew Labels
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.