Select any number of TSV, ZIP, XML, or DAT files to upload. Only LCBO or TBS provided DAT/ZIP/XML files and TSV 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: TBS ingestion is currently disabled. Contact support to ingest historical data.
| Filename | Imported |
|---|
| File Type | Required For |
|---|---|
| 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.tsv) | All Direct functionality. Templates: Google Sheets | XLSX |
| Products File (Products.tsv) | All Direct functionality. Templates: Google Sheets | XLSX |
| Orders File (Order.tsv) | All Direct functionality. Templates: Google Sheets | XLSX |
| Delivery Settings (Delivery.tsv) | Retail locations delivery settings. Templates: Google Sheets | XLSX |