I need someone to create a php cron script for magento which will update order status's for me, following a set of rules which I will specify, for example:
Check all new orders in the system.
If the delivery address post code = x, y or z then update the orders status to "status2"
If the amount paid for shipping < x then update status to "status3"
If the amount paid for shipping > x then update status to "status4"
The script also needs to look at the attributes for the product they have ordered and update an order attribute depending on what they have ordered. ie there's a product attribute called "number of labels", so look at that attribute and multiply the "number of labels" by the quantity purchased of that item and then save the result back to the database as an order attribute.
The script should output its results as it goes so when it's run in a browser you can see what's happening to each order, ie:
Order ID 123 weight = 2kg therefore status updated to x etc etc
This script is to replace one that I've been using for years that was coded for oscommerce, but now we're upgrading to magento it needs rewriting.
I have uploaded two text files explaining the requirements in more detail. One of which is effectively some rough pseudo code for what needs to be created.
The code should be fully commented so that I can edit it later on if changes need making.
This can be a totally stand alone system that just updates the database , and is run by cron every 10 mins or so.