Search code examples
mysqlquickbooks

Consolibyte QuickBooks Desktop import tables for Customers, Item and invoices only

I am using QuickBooks PHP Dev kit for quickbooks desktop syncing with a MySQL database. I want to sync Customers, Item and invoice data only. Currently, I have executed the example_mysql_mirror.php script file. It created 139 tables in the MySQL database and synchronised data between QuickBooks desktop and MySQL successfully.

The problem is that I want to synchronise only three entities named "customer", "item", and "invoice". I investigated code so that the script creates tables for customer, item and invoice only, but I didn't find anything. I have found that I can specify in PHP script to synchronise data of customer, invoice and item, but I didn't find out how to create tables only for three entities.

Can anybody mention table names which are required for customer, item and invoice syncing so that I don't have 139 tables in the database?

Solution

  • The scripts always create all of the tables. There is no way to turn off creating all of the tables.

    If you'd like, you can drop any tables that you don't need afterwards.