Lowest price history

Introduction

The Lowest Historical price functionality tracks and updates the lowest valid price for a product or variant over a defined time period (e.g., the last 30 days).

Setup

Add Scheduled Task

To enable the Lowest Historical Price functionality, a scheduled task must be added.

1. Navigate to:
   Configuration → Advanced → Scheduled Task
2. Click the three-dot menu and select Add
3. Set the following:
   • Implementation type: Product lowest price
   • Schedule: Run regularly, e.g., daily or every 30 minutes (*/30 * * * *)

This task ensures that the lowest historical prices are checked and updated automatically.

Set historical threshold

Define how far back in time prices should be considered:

1. Navigate to:
   Configuration → Products
2. Under Lowest Price, set the threshold (e.g., 30 days)

Only prices within this time window will be used when calculating the lowest historical price.

Logic overview

The logic ensures that only relevant prices are evaluated and that historical records remain accurate.

Filter valid prices

Prices are considered valid if they meet all of the following criteria:

• Assigned to the relevant market
• Active and within the defined date range
• Not linked to a specific CustomerId or CustomerGroupId
• Greater than 0
• Start date is today or earlier (future-dated prices are excluded)

Only valid prices are used in the evaluation.

Check existing historical record

If a historical record exists for a product or variant, its validity is verified:

• It must fall within the defined threshold period
• It must reflect the correct lowest price

Outdated or inaccurate records are marked for removal.

Identify current valid lowest price

Among the valid prices, the lowest one is identified and treated as the current lowest price.

Evaluate past prices

All valid past prices within the threshold period are reviewed:

• The current valid price is excluded from this step
• The lowest historical price is identified from the remaining entries

Update historical record

Depending on the evaluation:

• A lower historical price updates the existing record
• Outdated or incorrect records are removed
• Valid and accurate records remain unchanged