php mysql programmer for API Project hourly rate

PHP Programmer needed, familiarity with ebay API, Amazon MWS and Shopify API will be a PLUS. Ability to work on Linux Bash command line over SSH, ability to do MySQL on command line, and edit in vim editor is a big plus - We do NOT like to see IDE's that do not handle unix line endings. Also, No Frameworks! No CakePHP, no Zend, nothing. Database queries will be handled by ADODB Database abstraction library, (see [login to view URL]) - Coding style and standards need to be adhered to. #1 If you always put braces of your php code next to the end of the line - Don't bother applying - Curly Braces ( { ) and ( } ) ALWAYS SIT ON THEIR OWN LINES. #2 Detailed commenting and accurate variable and function naming is a requirement. OOP or Procedural variable names must fit the purpose and better yet, the TYPE. (Don't just do $customer, do $customer_number, $customer_id_text, $customer_id_number, etc.) (Comments - should always leave comments detailing the logical process you are following at a given point) Example: Code like this: if($customer_id) {$obj->DoThis();} - is Guaranteed to cut the job short, we'll find someone else. Code like this: if($customer_id !== false) { $verify_result = $data_processing->VerifyCustomer($customer_id); /*here we are verifying customer's data to make sure information is right*/ } - That is the kind of coding we'd be happy with. and finally - Indents are 4 SPACES (NO TABS!) IF you feel you can adhere to these standards (We have a full set of coding standards published on one of our websites as a guideline.) Then we're interested in working with you. ----------- DETAILS OF JOB ------------------- Application will connect to and download orders, and status updates, from ebay transactions (and in the future, amazon, shopify, potentially others) , and process the data for database storage to a custom system. For that reason, we need the API connection code done as a class - which may contain other processing specific to ebay orders. Will work as follows: Connect to ebay, fetch all updated or new orders, and process them in batches (Script will run every 5 minutes) Batch processing involves: 1) check if this is a new order, or an update to an older order (Check sales_record_number to verify) A) If a NEW order: Check customer table (unique identifier, for ebay it is the user ID name) If customer exists in database, get the customer_id from database, or if the customer is not in database, create new entry With customer ID, enter sales record base information to appropriate database table, separating the value amounts (subtotal, tax, shipping, and total) to the appropriate fields. - IF AN INTERNATIONAL SHIPMENT USING EBAY GLOBAL SHIPPING (there's information in the records from ebay API to be checked) Then, the third party shipping fees ARE NOT RECORDED. Once the order's consolidated data is entered, the order_id must be taken and then each line item of the order needs to be entered to a sales_history table (SKU, Sales, Qty, etc.) In total, data may be entered or updated into up to 4 or 5 tables for every sale. B) IF the order is an UPDATE: Determine the type of update (status, return, refund, cancellation, etc.) and adjust the sales record data as appropriate This is only a small portion of the overall planned project. (The database will also support several other sales channels, including Local over the counter sales) Design of the database tables is still in development and not yet entirely finalized. (Suggestions are welcome.) At the moment, very little raw code to work from other than some example code for ebay API connection We will provide for the necessary developer keys and test/development/sandbox users as needed You'll need to be able to read and understand the ebay developer API documentation. Development environment will be a Debian linux with Apache, php5 and mysql5 THERE IS NO CONTROL PANEL (Cpanel, Plesk, Etc.) There IS phpmyadmin available