The Effective Date Pricing SuiteApp enables you to set a schedule for specific price changes in advance. You can select the start date and end date when you expect the price changes to take effect. A scheduled script runs in the background to automatically update the item prices on the scheduled period. On the specified end date, the item price reverts to its original price.
You can also set the price as a permanent change. The permanent change in the item price takes effect on the date you selected as the start date for the price update.
For optimal performance, you should run each script daily at midnight in the time zone specified in Company Preferences.
Price updates can be applied on an item or a customer. The Effective Date Pricing SuiteApp includes the following update types:
- Item for single item updates
- Item Category for updating a group of items
- Customer for single customer updates
- Customer Group for updating a group of customers
The Effective Date Pricing SuiteApp is a managed and shared SuiteApp that is automatically updated whenever enhancements or new features are added.
To use the Effective Date Pricing SuiteApp, you must start by creating a price update record. Select the Update Type and the corresponding item, customer, item category, or customer group for the update type.
You must also specify the start date upon which the new item price should take effect. If applicable, specify the end date when the item price reverts to its original price. If you want to set the new item price as a permanent price, check the Permanent Price Change box.
You must then create a price detail update that contains the following details:
- For item price updates – currency, quantity pricing level, price level, and modified price
- For item category price updates – currency, quantity pricing level, price level, and category price % increase
- For customer and customer group updates – currency and modified price
A script runs in the background to automatically update the item price on the specified start date.
Note: Any price update without a price detail update is not processed.
When the specified end date of the price update occurs, a script runs to automatically revert the price to the original item price.
If the price update or price revert fails, you can check the error details in the Error Messages subtab of the price update record.
Note:
- Default discounts are not taken into account. If a scheduled update changes an item’s base price and that item has default discounts on other price levels, those price levels also change. Changes due to default discounts are not recorded in the Price Update logs.
- Effective Date Pricing does not work unless the following features are enabled:
- Multiple Currencies
- Pricing Level
- Multiple Prices
- Effective Date Pricing supports two decimal places. If the original price of an item has more than two decimal places, on the reversal date, the reverted price rounds to two decimal places. For example, the item price 1.29876 is rounded to 1.30 on the reversal date.