I am actually looking for long term php programmers whos tasks would mainly involve OSCommerce modifications.
Please quote a fixed price for this job and also an hourly rate for future work.
Obviously php and mysql is essential. It is useful if you have worked with oscommerce but not essential.
Non Standard fields in orders_products:
Currently we have a form for doing a bulk order despatch
Currently, the operator can select PART DESPATCH by checking a checkbox and the order status is updated appropriately.
The modification is that now we wish to store which individual items have been shipped.
This will be done as follows:
When the user checks the PART checkbox - a new window will popup
The new window will simply list each product name (and option/choice), quantity remaining (products_quantity-qty_shipped) | quantity shipped (default to 0)
An option to preset ALL to the same as the quantity ordered will be available
A checkbox to will be available "Cancel BO Items" at the bottom
Upon submitting the form, the script will update
tmp_qty_shipped to entered value
where Cancel BO Items is true AND (qty_shipped+tmp_qty_shipped) less than products_quantity (all items are not yet shipped)
tmp_cancel_bo=1 (otherwise =0)
window will close
Script will not allow user to ship more than (products_quantity-qty_shipped)
There are some database updates that will also be necessary in the main script but it is simpler for me to code these than to spec them!