This is a simple job for any programmer that's familair with oscommerce.
I have a row in "orders_products" called " products_stock_detail" whose default is '0'.
I want to be able to change this field from a 0 to a 1 when needed, via the oscommerce order details page.
So when I am viewing a customer's order via the admin panel, I want to see a checkbox for every product. When I tick a checkbox, the row for that item in products_stock_detail is changed to a 1.
This has to take place ONLY when I hit "update" on the order comments box or change the status via the pull down menu. If I un-tick the box and hit update again, I want the field changed back to a 0.
I do not need any testing environment, when you're done with the script I will test the code on my live shop.
Basically, all I need you to do is create a snippet of script that can make this happen when I update a product's status via the order details page. The table creation, etc. is already complete.
I am using the default oscommerce script, so all I need from you is to give me a find, add / replace installation. NOT a full file with the changes already made! (Similar to that of oscommerce's contributions.)
If you cannot complete this within a maximum of a week - please do not bid!