How to: Enable QuickBooks Online integration

How to: Enable QuickBooks Online integration

Follow the below step to configure QuickBooks (QBO) integration with DigThisData. For other accounting integrations, please follow the appropriate guides as minor differences are typically encountered. For custom integrations, please contact support.


  1. Log in to DigThisData as an Admin or Manager
  2. If you’re putting your orders through the system already, make sure all are posted before enabling QuickBooks.
  3. From your Account Settings, enable Accounting Integration and select QuickBooks.
  4. Select "DTD Defined Pricing" (recommended) for Authoritative Pricing. DTD Defined Pricing will push configured prices to QBO. If you prefer that QBO assign prices, use "Integration Pricing"
  5. Refresh the page
  6.  A new menu item under your name in the main navigation will appear called QuickBooks Connect (should be the last option)
  7. Click Connect to authenticate with QuickBooks 
  8. Once authenticated, you’ll be redirected back to Dig and another menu item will now be visible under Operations called “Product Sync”
  9. Click on Product Sync to synchronize your LCBO/TBS/Direct products with QBO Items. - This is important. Once you have enabled QuickBooks integration, the products available in Order Forms are ONLY the products that you have synced. If no products have been synced, your order forms will be empty. This is because Order Forms will now use QuickBooks Items (SKUs) and not LCBO/TBS/Direct SKUs. The system needs to compile QuickBooks Items so it knows pricing to create an invoice.
  10. Select your LCBO/TBS/Direct products on the left, assign the packaging size you sell them in and the desired tax rate, and start typing in the right column the name of the QuickBooks product to associate it with. DTD autocompletes QuickBooks Items from your QuickBooks account. You can additionally add a Bundle Item (typically used for Can Deposits here with Zero-Rated Tax). Please note: the Bundle Item quantity is multiplied by the configured Number of Containers in an associated Direct Product or the number of containers defined by the retailer if no Direct Product is associated. Click “Sync” when done.
  11. Now when orders are placed, DTD will reference QuickBooks item numbers in the Order. 
  12. Sales staff now can create Orders WITHOUT being connected to QuickBooks - they do not need to log in to QuickBooks.
  13. Back office staff will now need to Connect to QBO (as in step #5) before they post an order.
  14. Opening up an order in the View Orders page will now have a green “Post to QuickBooks” button next to “Post Manually”
  15. Clicking on “Post to QuickBooks” will generate an invoice in QuickBooks and mark the order as posted.
  16. You can also generate a Packing Slip by selecting the checkbox next to the Order and then clicking on the Packing Slips button on the left. You can choose multiple orders to generate one large PDF.


Please note: 

  • QuickBooks Integration is not available for the desktop or enterprise versions.
  • QuickBooks imposed restrictions: Only QuickBooks users who have master and company admin privileges in the QuickBooks Online company will be able to subscribe to a connected application. Once enabled, any DigThisData user with appropriate permissions can use the QuickBooks connection using their own credentials.
    • Related Articles

    • How to: Enable Xero Accounting integration

      Log in to DigThisData as an Admin or Manager If you’re putting your orders through the system already, make sure all are posted before enabling Xero. From your Account Settings, enable Accounting Integration and select Xero. Refresh the page A new ...
    • How to: Setup Shopify Integration

      The DigThisData Shopify App provides seamless integration from Shopify to DigThisData. Orders are automatically sent from Shopify to DigThisData for processing. Once within the DigThisData platform, modules such as warehouse management, accounting ...
    • How to: Enable Sage Business Cloud Accounting integration

      Log in to DigThisData as an Admin or Manager If you’re putting your orders through the system already, make sure all are posted before enabling Sage. From your Account Settings, enable Accounting Integration and select Sage. Refresh the page A new ...
    • FAQ: Is there any integration with the LCBO DDVP [DEPRECATED]?

      DigThisData supports uploading CSV files downloaded from the LCBO DDVP (Direct Delivery Vendor Portal) AND automatically ingesting them using your credentials. Once ingested, the data included in the CSV file will be converted into individual ...
    • How to: Enable Slack Notifications

      DigThisData now supports Slack Notifications for Orders placed. To enable Slack notifications: Navigate to you Account Settings under your name in the main navigation; Expand the Order Notifications tab; Make certain that the Order Notifications ...