Build a Quick Books / MySQL database connection that synchronizes QB & a web Server database.

Cancelled Posted Aug 19, 2014 Paid on delivery
Cancelled Paid on delivery

We have a client with QuickBooks (latest version) running on Windows Server 2012 OS. We also have an on-line application that allows customers to schedule appointments, pay invoices & update customer data (like phone number, etc.). The client in-house staff also uses the online system to create new customers and make appointments.

Once a day, a Windows scheduled process runs of the client server. This process accepts changes made to customer data on the web server, updates Quick Books & then totally replaces the on-line equivalents of the Customer, Invoice Header & Invoice Detail tables on the web server. The process uses An Access database that interconnects with the Quick Books database via “External” (to Access) tables. The process uses an Access Macro & a number of Access Queries. It uses command line ftp to upload files and initiates several web server php programs that offload or upload QB data from/to the on-line MySQL database.

We want to replace this process with a process that synchronizes the two databases “on the fly” and does not require an Access intermediary. We would like to use php because that is the language used on the web server now. We found this reference on-line: [login to view URL]

We require that the Customer table on the web server be kept synchronized with the QB Customer Table (note; web table has fewer fields, they are NOT an exact match). Also, invoice records (Header & Detail) need to be synchronized if a payment is made (either on web or manually entered into Quick Books) or if a new invoice is entered into QB.

Note, the appointments part of this is web only, no QB interface.

MySQL PHP Software Architecture

Project ID: #6345609

About the project

18 proposals Remote project Active Aug 26, 2014

18 freelancers are bidding on average $984 for this job

meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub More

$773 USD in 10 days
(173 Reviews)
9.3
rajeshsonisl

Hello, With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wron More

$2631 USD in 14 days
(970 Reviews)
8.7
pan09

Worked with QB sync before . You can check my feedback regarding to this . Ready to start right away .

$631 USD in 15 days
(313 Reviews)
8.7
Aloknano

A proposal has not yet been provided

$1000 USD in 14 days
(274 Reviews)
7.6
prashushinde9

Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu More

$721 USD in 20 days
(55 Reviews)
7.1
acronymsolutions

Hi, I have gone through your requirements .I am a Database developer at CMMI-5 Level company since August 2010.I am working on MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Intereste More

$736 USD in 15 days
(36 Reviews)
5.9
seomaster212

!!! We will provide service until you satisfied our quality work !!! <<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards seomaster

$526 USD in 10 days
(25 Reviews)
4.5
kingent

Quickbooks is a very detailed program to write in. The online version of quickbooks is a good bit easier to program with and would allow for real time updates. I can write to the software version as well if you like More

$500 USD in 15 days
(6 Reviews)
3.7