Staging Database Setup Guide

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. This process eliminates duplication of transactions.

Please provide 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 NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`skuvault_quickbooks` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `skuvault_quickbooks`;

/*Table structure for table `sku_to_qb_relation` */

DROP TABLE IF EXISTS `sku_to_qb_relation`;

CREATE TABLE `sku_to_qb_relation` (
`sno` bigint(20) NOT NULL AUTO_INCREMENT,
`type` varchar(15) DEFAULT NULL,
`vendor_customer` varchar(100) DEFAULT NULL,
`sku_id` varchar(45) DEFAULT NULL,
`qb_id` varchar(45) DEFAULT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;

/*!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.