When a Price List is approved, this template exports its items to a CSV file and stores it on a customer defined FTP server. The template always exports the following fields based on a Price List type:
-
SIMPLE – sku, resultPrice
-
MATRIX – sku, key2, resultPrice
Additional fields can be configured by the customer (see Configuration Steps).
Installation
Go to PlatformManager > Marketplace, find Export Pricefx Price List to CSV via FTP, select Deploy and then select a target integration instance and template version.
Configuration Steps
-
In Integration Initialization step, provide a name of your template installation and select a connection (or add a new one).
-
In the next step select an SFTP connection (or add a new one).
-
In Integration Properties step:
-
Set delay between events fetch (in milliseconds), i.e. how often the template will poll the Pricefx instance for completed calculation events.
-
Set maximum events that can be fetched.
-
Decide which Price List fields will be exported to a file. Multiple fields are separated with comma (for example “typedId,sku,label“).
-
Enter directory path where exported CSV files will be stored (relative to the path defined in SFTP connection).
-
Enter delimiter which should be used in the exported CSV file. If you want to use a tab as delimiter, use
\t. -
Enter name of the exported file. You can use the following tokens that will be replaced with actual values:
[object.id] – ID of the exported Price List
[timestamp] – time of the export
Example: export_[object.id][timestamp].xml
If you leave the field blank, the default file name will be used. -
Define your own timestamp in the exported file. It uses standard Java date and time pattern.
-
Decide if .done file should be used. If Yes is chosen, there will be an empty marker file created with the “.done” suffix added to the actual data file. This .done file is a signal saying that the export was completed.
-
