In Progress

Sync my [url removed, login to view] sales with my MySQL inventory database

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.

Requirements

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.

Notes:

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.

Skills: CakePHP, Inventory Management, MySQL, PHP, Shopping Carts

See more: shipstation database, what is sales support, php my inventory, mysql inventory management, incorrect email address, email address is incorrect, ask com, support.live.com, database management skills, about my life, test my skills, sku inventory, shipstation, inventory manage, inventory database, pre live, website shopping without database, php sync, mysql sync api, inventory value, sync mysql database, php sync database, website sync, database connection mysql, sales ongoing project

About the Employer:
( 26 reviews ) Castle Rock, United States

Project ID: #4736903

14 freelancers are bidding on average $720 for this job

designcreative1

Hi AI, Please refer to PM Thanks

$721 USD in 14 days
(99 Reviews)
8.0
softwaredep

Yours requirements + Our effort = Valuable Working solution. That's what we deliver.

$721 USD in 30 days
(98 Reviews)
6.9
kssoftphp

I am ready and expert in PHP and MySQL.

$736 USD in 30 days
(63 Reviews)
6.4
phpprogramming

i am interested in your project, please check pm

$700 USD in 15 days
(89 Reviews)
6.1
techwelfare

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.

$736 USD in 10 days
(54 Reviews)
6.1
akiles99

Hi, i can do this.

$721 USD in 15 days
(124 Reviews)
5.9
itIndia2

Hi, Please see the private message for more details

$700 USD in 12 days
(61 Reviews)
5.9
ModularGuy

Hi, I have experience in API synching. My tasked was to sync email listings between a vbulletin site and Campaign Monitor email marketing website. You task seems straight forward. I'm available right now and for More

$700 USD in 3 days
(36 Reviews)
5.7
mxicoders

Hello sir We are having a team of best designers and developers that are working in the web development field since last 10 years. We would like to grab this opportunity to work in your valuable and most esteemed pro More

$736 USD in 15 days
(11 Reviews)
5.3
on2it

Kia ora! On2itonline are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

$721 USD in 21 days
(6 Reviews)
5.0
evidcomm

Ready to start now..Many thanks..

$700 USD in 16 days
(23 Reviews)
4.9
eclipsian

Hi, We are ready to start with 100% confidence. We are known to give quality assured products within the estimated time. We are very much eager to work on your project. Please check you PMB for more details. Regards, More

$736 USD in 15 days
(4 Reviews)
4.7
infinityinfosys

hello................

$700 USD in 15 days
(7 Reviews)
4.2
ebinarylogix

We have 15 years of experience and we will get it done with quality - Please see PMB for detail.

$700 USD in 14 days
(8 Reviews)
4.1
josh002sl

I am a PHP/MySQL developer with extensive web development experience. Please see my detailed PM.

$777 USD in 3 days
(9 Reviews)
3.3