How to: Enable Xero Accounting Integration

  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 Xero.
  3. From your Account Settings, enable Accounting Integration and select Xero.
  4. Refresh the page
  5. A new menu item under Data will appear called Xero Connect (should be the last option)
  6. Click Connect to authenticate with Xero
  7. Once authenticated, you’ll be pushed back to DTD and another menu item will now be visible right under the Connect option called “Product Sync”
  8. Click on Product Sync to synchronize your LCBO/TBS/Direct products with Xero Items. - This is important. Once you have enabled Xero 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 Xero Items (SKUs) and not LCBO/TBS/Direct SKUs. The system needs to compile Xero Items so it knows pricing to create an invoice.
  9. Select your LCBO/TBS/Direct products on the left, assign the packaging size you sell them in, and start typing in the right column the name of the Xero SKU you would normally use. DTD autocompletes Xero Items from your Xero account. Click “Sync” when done.
  10. Now when orders are placed, DTD will reference Xero item numbers in the Order.
  11. Sales staff now can create Orders WITHOUT being connected to Xero - they do not need to log in to Xero.
  12. Back office staff will now need to Connect to Xero (as in step #5) before they post an order.
  13. Opening up an order in the View Orders page will now have a blue “Post to Xero” button next to “Post Manually”
  14. Clicking on “Post to Xero” will generate an invoice in Xero and mark the order as posted.
  15. 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: 
  • Xero Integration is not available for the desktop or enterprise versions.
  • Xero imposed restrictions: Xero connections will only remain active for 30 minutes. Once expired, you will need to re-connect to Xero. Once connected, any DigThisData user on the account with appropriate permissions can use the Xero connection using their own credentials.

Feedback and Knowledge Base