# Linnworks Orders to QuickBooks Online

## Introduction

DBSync for Linnworks Orders and QuickBooks Online Integration is a user-friendly application that seamlessly integrates key data between Linnworks and QuickBooks Online. It synchronizes Linnworks Customers, Products, Processed Orders, Purchased Orders, and Suppliers with QuickBooks Online’s Customers, Item Inventory, Invoices, Sales Receipts, Estimates, Vendors, Purchase Orders, and Bills.

This solution offers unidirectional synchronization with pre-built field-to-field mapping, along with the flexibility for custom, dynamic mapping to meet complex business needs. DBSync’s automatic online updates ensure users always have access to the latest product features and enhancements with every new release.

### Data Flow

Data flow of Bi-directional integration between Linnworks Orders & QuickBooks Online is shown in the table below.

<table><thead><tr><th width="322.18524169921875">Linnworks</th><th>QuickBooks Online</th><th data-hidden></th></tr></thead><tbody><tr><td>Customer</td><td>Customer</td><td></td></tr><tr><td>Products</td><td>Item Inventory</td><td></td></tr><tr><td>Processed Orders</td><td>Invoice, Sales receipts &#x26; Estimates</td><td></td></tr><tr><td>Suppliers</td><td>Vendors</td><td></td></tr><tr><td>Purchase Orders</td><td>Purchase Order, Bills</td><td></td></tr></tbody></table>

## **DBSync Profile and Application Setup** <a href="#salesforce-and-quickbooksonline-bidirectionalintegration-_toc381191462dbsyncprofilesetup" id="salesforce-and-quickbooksonline-bidirectionalintegration-_toc381191462dbsyncprofilesetup"></a>

1. Click the <img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FstyaFZL7B0JHaDCr1mO1%2Fimage.png?alt=media&#x26;token=02a29dd2-eb2e-4cb7-ac76-e20ae2573569" alt="" data-size="line"> Apps icon from the left navigation tool bar.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FGH2LHUFrGutIbQeIRUzM%2Fcw6.JPG?alt=media&#x26;token=d3dceadc-a78e-44fa-abbe-eb2bfd292968" alt=""><figcaption><p>Home Screen</p></figcaption></figure>

2. Click on Linnworks Connector and choose **Login to Linnworks.**

{% hint style="info" %}
Click [here](https://docs.mydbsync.com/cloud-workflow/connectors/linnworks/creating-the-dbsync-application-on-linnworks-developer-instance) to know more about creating the DBsync application on Linnworks Developer instance.
{% endhint %}

3. You will get a pop-up to confirm your Linnworks account. Enter the credentials, accept the **T\&C** by enabling the checkbox and click **Login** as shown below.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FHqo6CC47AYLYLfbmfBiy%2Fimage.png?alt=media&#x26;token=eb9aa977-9043-42b6-bda8-dbaf43de0a5c" alt="" width="295"><figcaption><p>Connect to Linnworks Application</p></figcaption></figure>

4. Click on QuickBooks Online Connector. Then, click on the link **Connect to QuickBooks.** Sign into QuickBooks online to authorize DBSync Salesforce Integration for QuickBooks to connect to Intuit.
5. Click **Save** and **Test Connection**.

You are now ready to run the integration using pre-built forms.

## Process to Run the Integration

To utilize the pre-built **Linnworks Orders to QuickBooks Online** template, follow the steps given below.

1. Click on **Add Template** from the home screen.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FoKeBDbVVEfCYPld8WWoV%2FLinnworks%20orders%20to%20QBO.png?alt=media&#x26;token=b509743b-ba80-458c-aea6-79b5364e6d41" alt=""><figcaption></figcaption></figure>

2. Select the template: **Linnworks Orders to QuickBooks Online** which allows for running multiple workflows and integration between the two applications.
3. The template will be added to **Your Projects**.
4. Select the template and you will be redirected to the **Task Screen**.
5. Click **Configure** to access various workflows pre-built for the integration.
6. Select the desired flow, click configure and activate the **Enable Flow** option for any worklfow you want to run.

## Pre-built Template and Workflows

The template downloaded from the library contains various workflows which can be enabled to run the sync between **Linnworks Orders and QuickBooks Online**.&#x20;

{% hint style="info" %}
**Enable the Initial Setup** and Run the Sync to enable QuickBooks Accounts set up as displayed in the image. Also note, the following accounts are created in QuickBooks Online post Initial Setup Sync:

1. Income Account
2. Expense Account
3. Assets Account
   {% endhint %}

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FflJQjOIb6BoEECA8LKGu%2Fimage.png?alt=media&#x26;token=8781c9ba-8392-43f8-b75b-72751bd55a89" alt=""><figcaption><p>Run Initial Setup</p></figcaption></figure>

{% hint style="warning" %}
Ensure you TURN OFF the check box to 'Enable Flow' for the Initial Set up (After first Sync) before you run the workflow to sync Linnworks Purchase Orders or Processed Orders to QuickBooks Online using the other two workflows. The first success run is considered for the sync.

Make sure you ENABLE the required workflows before you run the sync.
{% endhint %}

1. Navigate to the Task Screen and click **Setup**.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2F24KyRelqgJ935Z5i5jVA%2Fimage.png?alt=media&#x26;token=4c7c8bcb-ab4e-4e40-b91c-5375aa917558" alt=""><figcaption><p>DBSync Setup Wizard</p></figcaption></figure>

2. You will be redirected to the **Setup Screen**.
3. Verify the connections of your applications and click **Next**.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FflxsxsMwTJG5F7XYQjC2%2Fimage.png?alt=media&#x26;token=42979ae0-446a-436e-ac98-c1fe3be05513" alt=""><figcaption><p>Verify Application Connection</p></figcaption></figure>

Configure the following in the **Setup tab**.

**a. Linnworks Processed Orders to QuickBooks Online Transaction**

If you would like to push transactions into QuickBooks Online and choose the type of transaction: Invoice, Sales Receipt or Estimate.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FbHiYPGRP2VdB8hSkhQsE%2Fimage.png?alt=media&#x26;token=8f47bd9c-12cd-450f-a44a-add938c59c27" alt=""><figcaption><p><strong>Linnworks Processed Orders to QuickBooks Online Transaction</strong></p></figcaption></figure>

**b. Linnworks Purchase orders to QuickBooks Online Transaction**

If you would like to create purchase orders in QuickBooks Online such as bills or purchase orders, use this workflow.&#x20;

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FA00LNqBCYVDznuhkHGjc%2Fimage%201.PNG?alt=media&#x26;token=ee2805c3-4eef-4687-9c81-ecc9c3a26001" alt=""><figcaption></figcaption></figure>

4. Click **Next** and **Run Now** to complete the sync.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FWgO5aaj3QVwpwTi80B37%2Flan%2011.PNG?alt=media&#x26;token=5f82d60e-2852-4ce3-9c1b-efa26afa24ef" alt=""><figcaption><p>Run Now</p></figcaption></figure>

{% hint style="info" %}
You can also choose to set a schedule to your sync: Update the task, start and end time along with frequency which ensures that both the applications are in common sync at all times.
{% endhint %}

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FKfk9eud5q8mm67jdFuyY%2Flan%2012.PNG?alt=media&#x26;token=26661932-5271-4dd3-8760-8e6282465475" alt=""><figcaption><p>Scheduler</p></figcaption></figure>

5. Click **Finish to** complete your sync.