The Import Postpone Data module of the Import Tool allows you to bulk schedule future price changes. It helps you plan promotional campaigns and schedule price adjustments in advance for seasonal demand or anticipated supplier cost increases. Automating price changes minimize the risk of manual entry mistakes, ensuring consistency and control over your pricing strategy.
Preparing a price update schedule
Future price change schedule is provided in form of Microsoft Excel (.XLSX) file containing item prices with specified future start dates. The file must have the following data structure.
| Field Name | Mandatory | Description |
|---|---|---|
| SKU | Yes |
Item code in one of supported formats:
|
| SKU type | Yes |
Сode type for the SKU code in the previous column. Must be one of following numbers: 0 – UPC-A 1 – UPC-E 2 – EAN-8 3 – EAN-13 4 – PLU |
| Item description | Yes | Item name as it appears in the CStoreOffice® Price Book. Must be no longer than 250 characters. |
| Postpone Retail, $ | Yes | New retail price. |
| Postpone Start Date | Yes | The date in the future on which the price change should take effect in {Month}/{Date}/{Year} format. For example, 10/22/2025
for October 22, 2025. |
Click Download Example to get the template for the price update schedule file.
You can schedule multiple price adjustments for the same item, each with its own start date.
Bulk-import postponed price updates
To import item name translations:
- In the Import Tool, go to Price Book > Import Tool.
- In the Quick Operations section, select Postpone Retail.
- Select one or more locations to which the imported price updates should be applied.
- Click Browse and select the price update schedule file.
- Specify whether all SKU codes in a file have a check digit. Leave Autodetect to let the Import Tool automatically detect the check digit.
- Click the Next button to import the file.
Reviewing import results
After the import is complete, a summary of the applied changes will be displayed, allowing you to verify that your scheduled price updates have been successfully processed. The list will contain the following data:
- GTIN: Global Trade Item Number of an item.
- Description: Item name as it appears in the CStoreOffice® Price Book.
- Postpone Retail, $: Scheduled retail price.
- Postpone Start Date: The date in the future on which the price change should take effect.
- Existing Postpone Retail: An indicator whether an item already has a retail price update scheduled. Click the Report link to navigate to the Postpone Retail Change report, which will be automatically filtered by the selected location and item.
If the import was successful, the number of items listed in the import summary should match the number of rows in your uploaded file, minus the header. If you see a mismatch, Select the Invalid filter is the right pane to show the rows that contain errors.
Hover the Report link in the Existing Postpone Retail column to see import errors. Click the link to navigate to the Postpone Retail Change report, which will be automatically filtered by the selected location and item.
