2022
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 process, duplication of transactions are eliminated.
Panel | ||||||
---|---|---|---|---|---|---|
|
Please provide the following credentials to connect MySQL
...
Port: The port used to connect to database server
Panel | ||||||
---|---|---|---|---|---|---|
|
Once connected to MySQL, use the following database script in Query tab and 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 */;
Panel | ||||||
---|---|---|---|---|---|---|
|
Once the above script is executed, a database named skuvault_quickbooks is created with sku_to_qb_relation Table with the following columns
...