HowTo - Import Scheduled Prices
- Updated on 20 Jan 2020
- 2 minutes to read
This tutorial describes how to import schedule prices by importing them into a Spryker project with the Scheduled Prices feature.
Data Import and File Format
In order to schedule a price, you need to upload a
product_price_schedule.csv file to
/project/data/import/ with the following headers:
They are described in the table:
||SKU of the abstract and/or concrete product you wish to schedule a price for.||product-123-color-black|
||Defines the type of the price you wish to schedule: DEFAULT or ORIGINAL.||DEFAULT|
||Defines the currency of the price to be scheduled.||EUR|
||Net price of the product. Since prices are imported, they are in integers (8543 = 85.43)||8543|
||Gross price of the product.
Since prices are imported, they are in integers (9999 = 99.99)
||Starting date of the scheduled price, inclusively.||2019-06-23T23:00:00+01:00|
||Ending date of the scheduled price, inclusively.||2019-12-31T12:21:32-04:00|
You can include multiple entries into the file.
Once uploaded, run
console data:import:product-price-schedule command to import the price schedules from the file.
The imported prices are applied by running a cron job. By default, it runs every day at 00:06:00-00:00. If you want to apply the imported prices right away, you can either run
price-product-schedule:apply command to apply them manually or change the behavior of the cron job. For more information, see HowTo - Schedule Cron Job for Scheduled Prices.