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 [url removed, login to view] 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.
[url removed, login to view] 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 [url removed, login to view] website API details are available for review at [url removed, login to view]
You will need to research the [url removed, login to view] API as I will ask you questions on how you will manage it
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.
14 freelancers are bidding on average $720 for this job
Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.