We need a script to retrieve an external CSV data feed which has the incorrect header fields, and recreate it with the correct header fields and perform a simple change on one field.
The script will be Cron triggered daily.
Approx lines of data to process: 2500
This is the process of the script.
1. Fetch an external source file url which is a CSV file with one header line.
2. To rewrite, copying the content of the source file, saved locally as a CSV. Rename the column headers into Virtuemart table names.
3. Perform a calculation to increase the price value by a predefined % markup
Source Header example: