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 shipstation.com 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 shipstation.com website API details are available for review at http://api.shipstation.com
You will need to research the shipstation.com 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.