Install DigThisData
Install this application on your iOS Home Screen for a better experience and easy access. Just tap the Share icon 
and then "Add to Home Screen".
Select any number of CSV, ZIP, XML, or DAT files to upload. Only LCBO (SOD, DDVP, and GMS) or TBS provided DAT/ZIP/XML files and CSV files from provided templates are permitted. Log into your LCBO or TBS account and download the necessary files. Once available on your hard drive, select them for upload. Multiple files supported.
Note: Historical TBS ingestion is currently disabled. Contact support to ingest historical data.
| Filename | Imported |
|---|
| File Type | Required For |
|---|---|
| DDVP CSV Files | Automatically generates orders |
| Option 1a | Year To Date Sales Report |
| Option 1b | Inventory, Weekly Performance, Sales by Store, Sales by Product, Period Sales, Unit & Volume Product Sales |
| Option 5 | All Industry Reports |
| Option 7b | LCBO Licensee Reports |
| Option 8 | LCBO Agency Reports |
| File Type | Required For |
|---|---|
| Transactions XML (BT_TRANSACTIONS_yyyymmdd) | Inventory, Order Management, TBS Reporting |
| Sale of Data (BT_SOD_yyyymmdd) | Industry Reporting |
| File Type | Required For |
|---|---|
| Customers File (Customers.csv) | All Direct functionality. Templates: Google Sheets | XLSX |
| Products File (Products.csv) | All Direct functionality. Templates: Google Sheets | XLSX |
| Orders File (Order.csv) | All Direct functionality. Templates: Google Sheets | XLSX |
| Delivery Settings (Delivery.csv) | Retail locations delivery settings. Templates: Google Sheets | XLSX |
This document will be removed from the system. Are you sure you want to continue? This is irreversible.
Install this application on your iOS Home Screen for a better experience and easy access. Just tap the Share icon and then "Add to Home Screen".