Document Properties
Kbid
2T9722
Last Modified
13-Jul-2023
Added to KB
01-Dec-2020
Public Access
Everyone
Status
Online
Doc Type
References
Product
  • ICM 7.10
  • ICM 11
Job - ProcessProductPriceRefresh

Name

ProcessProductPriceRefresh

Domain

<Organization>-<Channel>

Job Dependencies

None

Acquired Resources

None

Cartridge

bc_pricing

Pipeline

ProcessProductPriceRefresh-Start

Affected Domain Objects


Affected Tables

  • Price
    productpricechangeevent
  • 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

Disabled

Description

This job processes product price change events to update cached product prices.

There are attributes (in attributes tab) that determine the processing of price change events:

  • AgeOfOutdatedItemsInDays (available from 7.10.26.4-LTS) - This attribute is automatically created by the job if it does not exist. It reflects the age of items that are to be treated as outdated in days. These outdated events are automatically deleted during the job execution in order to cleanup the database table. The default value is "30" (days) and can be changed. If the attribute value is set less than or equal to "0", the deletion of outdated items will be skipped. In this case all items will be processed regularly instead of being deleted.
  • BatchSize (available from 7.10.26.4-LTS) - If a large number of items are to be processed, it is useful to divide the task into smaller steps with a limited number of items. The BatchSize defines the maximum number of items to be processed within one step. This attribute is automatically created by the job if it does not exist. If the attribute has a value less than "1", it will be overwritten and reset to the default BatchSize (10.000) after the next run of the job.
  • CleanupEvents - Flag that determines whether the consumed events should remain in the database or not. The recommended value is "true".

Scheduling

Depends on price list usage. Default is once every 60 minutes.

What Happens Switched Off

Product prices will not be up to date.

Trouble Shooting

The CleanupEvents attribute specifies if the events should be deleted after processing.
The ReasonCode attribute specifies which events should be processed.

Comments

Product Version

7.10

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