I need a osCommerce script to manage records in one of the MySql tables. This will be used in the osCommerce admin.
The sql table with data is inluded with this request. The table is used to store vendor ID, product serial numbers and UPC model number when receiving products from vendor. When an order is completed the table also captures the order ID date etc...
I need the ability to manage this table "orders_products_serial_numbers" from admin.
Search table by -> orders_id, orders_products_serial_number, products_model
These will be individual search fields, I also need a dropdown menu field to filter the search by the vendor, I am inluding the vendor sql table for reference with this request. Please make sure the default is all vendors.
Ability to edit any record, this should be a simple form with all the fields. Please also inlude a icon in the search result list at the begining of each line that will allow the user to click on for edit record just like you see in the [url removed, login to view] listing.
The dit screen will inlude a submit button and a cancel button that will take you back to the search results.
As always I need this done as soon as possible.
I have more work like this one.