Insert data from MySQL into Quickbooks Online using QB API
Budget: $250 – $750 USD
Need to insert data from MySQL tables into QB Online using the QB API. As data is updated in MySQL, QB will need to be updated. Script must be in PHP and able to run as CRON. Data in MySQL is mined from third party software. Proper queries must be generated to collect and insert data into Customers, Vendors, Items, Purchase Orders, etc. including updating of same in the event the data in MySQL is updated.
Records for insertion into QBO will be selected based on date modified. You must be very familiar with QBO API and include error handling and reporting in the event an error occurs at insertion. New Vendors, Customers, Items, Purchase Orders etc. will need to be created if they do not exist in QBO at time of attempted insertion from MySQl
I have included a starting point for the DDL of the MySQL tables - the tables may need additional fields (such as dateModified) added.
Code must be well documented for in-house maintenance and modification.
Records for insertion into QBO will be selected based on date modified. You must be very familiar with QBO API and include error handling and reporting in the event an error occurs at insertion. New Vendors, Customers, Items, Purchase Orders etc. will need to be created if they do not exist in QBO at time of attempted insertion from MySQl
I have included a starting point for the DDL of the MySQL tables - the tables may need additional fields (such as dateModified) added.
Code must be well documented for in-house maintenance and modification.