Hello,
I have extensive experience in performing similar functions to those you are requesting in your project and do so on a daily basis.
I have established projects using a combination of shell, PHP and MySQL to update inventories very large datasets.
For your project, just to confirm if my understanding is correct, you want to run a 30 minute scheduled job (cron or event) to import stock levels from a csv file into an existing MySQL table instance (RSRgroupstocklevel), with a default value in the StockLevel field of 0 and max 3, updated from the imported csv file, and matched by SKU, then export all records to a csv file for upload to an ftp server.
Can you confirm some additional points:
- What version of MySQL are you currently running?
- Do you currently have the process in place for the receiving of and sending of the csv stock level file to the FTP server?
- What platform (OS) is your server running on?
Can you send through some sample files and so I can look at the formatting etc.
Thank you and I look forward to working with you.
Darren