How to: Bulk ingest logistics delivery schedules

How to: Bulk ingest logistics delivery schedules

To ingest logistics schedules in bulk, you'll need to download the provided spreadsheet templates, copy and paste data, save the file as a Comma Separated file, and upload to DigThisData. The following steps will accomplish ingesting your logistics schedule.


Ingesting Logistics Delivery Schedules
  1. Download a spreadsheet template from DigThisData
    Google Sheets | Microsoft Excel
  2. Open the spreadsheet template - the first sheet is the template that will need to be filled in with your delivery information. The second sheet contains instructions detailing what each field is and the type of data required.
  3. Complete the template by copying column by column from any preexisting delivery spreadsheet you may have - your logistics partner most likely supplies one.
  4. Once complete, save the file as a comma-separated text file (.CSV) with a filename of Delivery.csv.
  5. In DigThisData, open up the Data Ingestion Widget under Operations  → Data Management → Import Data File. Upload the Delivery.csv file you just filled out.

Please note: Exporting to CSV from Microsoft Excel may add additional empty columns that will result in a failed upload to DTD. If you encounter an error uploading, please try uploading your spreadsheet to Google Sheets and saving a CSV from there.

    • Related Articles

    • How To: Work with FIL for Delivery

      DigThisData offers a light integration with FIL Logistics to make processing orders faster and more efficient. To ingest logistics schedules in bulk, you'll need to download the provided spreadsheet templates, copy and paste data, save the file as a ...

    • How to: Configure sales rep territories and store details

      Configuring Stores For all account locations, you can define Sales Reps, Supply Warehouses, Low Inventory Thresholds (where applicable), Delivery Days, Cut Off Times, and more. To assign variables to a specific store, click on the edit icon to open ...

    • Welcome to DigThisData - Our Handy Guide to Getting Started

      Here is our guide to getting started with DigThisData with links to the support articles you will need for a smooth and seamless onboarding experience. We are always here to help though. If anything comes up please reach out to our support line and ...

    • How to: Ingest TBS Purchase Orders to create DTD Pre-Orders

      DigThisData supports automatic ingestion of TBS Purchase Orders from standard XML files delivered via your SFTP account. If XML Purchase Orders are located, each one is downloaded and ingested automatically into DigThisData and individual Pre-Orders ...

    • FAQ: What are the benefits of using DigThisData for order processing?

      DigThisData supports order management for LCBO, TBS, Grocery & Convenience, and Licensee sales. It is a robust and highly configurable system that offers numerous benefits. Importing of LCBO DDVP Orders (CSV) [DEPRECATED] - Available for all plans, ...