Extract Pricing data from R2 into SFTP via file transfer
The format followed is R2_Price_YYYYMMDD_HH24MISS.csv
The header row of the CSV file has following columns.
Column Name
|
Description
|
|
Product ID |
Product's unique ID as configured/saved in R2. |
|
PriceGroupID |
Product's specific Pricing Group ID as configured/saved in R2. |
|
PriceGroupDescription |
Description of the Pricing Group as configured/saved in R2. |
|
EffectiveDate |
Date from which the price change is effective. |
|
Unit |
Per unit in which the product has to be counted. |
|
Price |
Per unit Price (the value to be billed to customer) of the product. |
|
Cost |
Per unit procurement cost of the product. |
|
OverHeadCost |
Per unti overhead cost of associated with the product. |
|
MinPrice |
Minimum retention price per unit of the product. |
All the pre-requisite for this step are explained here...
The standard process of Exporting data is explained here...