Sync my shipstation.com sales with my MySQL inventory database
This project received 15 bids from talented freelancers with an average bid price of $720 USD.Get free quotes for a project like this
Project Budget$700 USD
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
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online