Page History

...

Staging database is necessary to setup along with SkuVault and QuickBooks connectors. This staging database acts as an intermediate system to map Sales Order and Purchase Order between SkuVault and QuickBooks. By this This process , eliminates duplication of transactions are eliminatedtransactions.

Please provide the following credentials to connect MySQL:

MySQL Host Address: Host name or IP address of the database server.

Username: Database username.

Password: Database password.

Port: The port used to connect to database server.

Once connected to MySQL, please use the following database script in Query tab and then, execute .

/*
SQLyog Ultimate v8.71
MySQL - 5.6.27-log : Database - skuvault_quickbooks
*********************************************************************
*/

...

Once the above script is executed, a database named skuvault_quickbooks is created with sku_to_qb_relation Table with the following columns:

1. sno: Serial Number of a record.
2. type: Signifies whether the transcation transaction is Sales Order or a Purchase Order.
3. vendor_customer: stores name of the Customers and Vendors.
4. sku_id: stores Sales Order number or Purchase Order number for the corresponding transaction.
5. qb_id: stores unique id generated by QuickBooks.