Build an OSCommerce Module

Hi there, Please let me start by saying that that generic bids/offers without reading the brief will not be considered. I need a new OSCommerce module written to allow my Point of Sales software to talk to my web shop. I have already written an “API” for OSCommerce which allows my Point of Sales software to keep inventory up to date, get open web orders (with the customer details), get lists of products from the site, etc. and I would like it to be re-done properly by someone who knows what they’re doing. The current API is very basic, accepting URL parameters with no type of authorisation, and simply executes commands on the OSCommerce database and is a bit of a mess. The current API has individual methods to: Update item stock level, price, item active and weight Update item stock level and whether to disable the item Update item stock level Update item active Update item stock level, price and item active Update item stock level and active status Get all open (status 1 and 4) web orders (with customer details) Get a single web order by its order number (with customer details) Update a web order status (and add an order status history entry) Get all products on the web shop The current API is badly written as I can’t code in PHP and I pulled parts from the web to get it to work. The DB access details are currently in the API in plain text and are hard coded. You’ll also notice that there are a lot of methods that are similar, etc. That’s because I’ve thrown this together quickly and not done a very good job at maintaining it. What I need from the new API will be methods to: Update item stock, weight, price, description, active status, brand/manufacturer, etc. (all fields or only some) Create a new item (if the brand/manufacturer doesn’t exist it should create it) Check if an item exists or not (by model number) Get all open web orders (at status 1 or 4) (with customer details) Get a single web order (by order number) (with customer details) Get customer details Update a web order (set a pre defined status and add an order status history entry) The new API should be written as a module which should be installed via the admin section and should use the shared OSCommerce DB connection (not have one hardcoded in the API). It should need to accept some sort of user ID/password combination (perhaps as a URL parameter) when a call is made (maybe those details are pre-set in the admin section?). The output should also be similar to how the current API works, simply rendering the result on the page (allowing my software to scrape the details from the page and use them). I will supply the current PHP code file as reference for you to see what I’ve done. If you have previous experience with other eCommerce sites (such as Megento, wordpress, etc.) please also let me know how much it would cost to build this same module (with same methods, etc.) for those platforms as well. Thanks very much! Sincerely, Paul