I need 2 scripts
1. Insert Script (Runs Once)
I need the attached "[url removed, login to view]" inserted into my shop. I tried using "CSV Improved" but can't get the records inserted.
2. Update Script (Runs every 8 hours via cron)
This script needs to run every 8 hours. It is to update the price and availability for each product.
The attached [url removed, login to view] file is an example of the file to insert except the actual file is ',' comma delimited verses the '^' delimited file I've attached.
There are 6 fields I only need the first 4 field with the second field being a calculated field
The price you insert into the database with be the calculated value of?