Pricing Data
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...