Page History

Connect To Host
Script
Tables

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 following database script in Query tab and then, execute .

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

...

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

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 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.