I am looking to have a program written that can run as a cron job or every day at a specific time that i choose..
The program will filter orders based on specific order details which i specify.
Once the filtering is complete all data (delivery address, name, location, order details etc etc) are exported to a .csv file and EMAILED to an email address that i choose...
The idea is to have an automated system that collects orders that have processed overnight and send them in .csv format to different distribution centers around the world.. Once complete and after the email has been sent the program should update and move the current zen cart order status to 'Delivered'.
Export all orders that have delivery country = Canada AND order status = processing complete.
Export all orders that have PRODUCT ID #123 AND delivery country USA AND order status = processing complete.
Once this is complete the program emails this exported .csv data to an address or 2 that I choose.
Should be able to run as a cron job or via FTP. Must be in .csv format.
Should be able to have unlimited job settings meaning I can have 10 sets of filters for example or 20 or 30 and they all run consequtive maybe seperating each product by product ID and sorting the distribution to different emails/locations...
Please let me know if you can complete this task for Zen Cart.
I have attached a sample of exported data to view in excel form.