Sync my sales with my MySQL inventory database

Avg Bid (USD)
Project Budget (USD)
$700 - $700

Project Description:
This project requires that you have very specific API management skills. Please do NOT bid on this project unless you are competent in this area of coding.

1. When we confirm a shipment or mark an order shipped on then our MySQL inventory database must be adjusted for the quantities of items shipped. This should be driven by SKU value. So if an order is shipped that has 3 different items in that order and 1 of each, then our inventory database must be reduced by 1 for each of those items.

2.If for any reason an order is shipped and the items in the inventory database can not be found or updated for any reason, then an exception email must be sent to my email address notifying me of the failure. It could be because of an incorrect SKU or another reason. This is extremely important as I need to know if the inventory database is not updating as our stock levels will immediately become incorrect.

3. Proper sandbox type testing and demonstration that the functionality is working, before it is turned on life. For this you may want to load a test MySQL for the testing and pre-live demo.

4. Testing and ongoing support of the connection. I need to be very satisfied that the inventory sync is running perfect before switch to live as my live inventory must reflect my stock on hand, otherwise I will be in a mess and not know what to purchase or what I have without doing a major count of everything, and we have an inventory of about 3,200 different items.

The website API details are available for review at
You will need to research the API as I will ask you questions on how you will manage it

Additional Project Description:
07/17/2013 at 18:06 MDT
Please note. ONLY bids that provide clear evidence of work references that cover API work will be considered. This is NOT a web design project, it is specifically API sync work. You need do demonstrate you can do this sort of work with references so that I can look at your bid seriously. Any bids without this will NOT be considered.

Skills required:
CakePHP, Inventory Management, MySQL, PHP, Shopping Carts
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 721
in 14 days
$ 721
in 30 days
$ 736
in 30 days
$ 700
in 15 days
Hire techwelfare
$ 736
in 10 days
Hire akiles99
$ 721
in 15 days
$ 700
in 12 days
$ 700
in 3 days
$ 736
in 15 days
$ 721
in 21 days