We are in need of an osCommerce expert for ongoing osC work. You will start with two more simple projects and they will grow from there.
The first opening project will be a simple addition to an all search page. The page already queries the db for item number and displays [url removed, login to view] with that item, for the order number and displays [url removed, login to view] and for the customer and displays customers.php.
Your job will be adding in the same search fields but this time querying the orders tables and displaying orders from that customer, with that number or containing that item (item field needs to be products_id, products_model, products_name and manufacturer_item (all from products table - only manufacturer_item is missing from orders_products table - it is your choice if you would like to change the code to write to that table upon order completion or do a join). See order_search image attached.
The second project is to create a new report based on the stock report we currently have working on the site (see [url removed, login to view]). This report shows number of products ordered but does not break out products by attributes. You will be creating a NEW report based on this one (we still need to use this one) that will break out sales by size as shown in the stock_report_attri.jpg.
Please quote for these two projects as you would everyday projects. This will give me a feel for how you will charge in the future for other projects and be a deciding factor in who I choose. I know these are simpler projects but please only bid on them if you are an osC expert- future projects will get more complicated.
The site you will be working with is heavily modified. You will
be working in a staging environment and I will require an outline of changes (including mysql if any) to take the changes live.