Detrack
  • Features
  • Who uses Detrack
    • Logistics service providers
    • Retailers
    • Medical and Pharmaceutical
    • Furniture & home appliance distributors
    • Construction material distributors
    • Food & beverage distributors
    • 3PL providers
    • Businesses with delivery vehicles
  • Case Studies
  • Integrations
  • FAQs
  • Pricing
  • Log in
  • Try it free
Try it free
Select Page
Tutorials // Deliveries - Admins // How To Import Deliveries For Different Groups With Different Excel / CSV Templates

How To Import Deliveries For Different Groups With Different Excel / CSV Templates

In your admin dashboard, click on the Users tab. Next, click on the Groups tab and then under Groups. Select the group you wish to customize in order to match the header in Excel / CSV file.

Next, select Import Settings tab and switch on Use Group Custom Settings to enable matching of headers. Under the Date Format, select the format of the Date column in your Excel file. Then, match the headers by entering the customized header name and click save.

In your admin dashboard, click on the Jobs tab and select Calendar. Next click on the delivery date on the calendar and then under the Deliveries tab, click the green Import Deliveries button.

Drop file to upload or click on the box. Select file then click save. The full list of deliveries for the day will be shown.

Select the Group that you are importing for the customised header.

Import button lets you add on the deliveries from your CSV or Excel (.xlsx) file to the deliveries that are already added for the day.

Delete All and Import button lets you delete all existing deliveries for the day before importing the new deliveries from your CSV or Excel (.xlsx) file.

There is no fixed order for the headings in the CSV or Excel (.xlsx) file. The only requirement is that the first row must be a header row specifying which field the column represents and the mandatory fields Date, D.O. No. and Address must all be present. You can position the columns freely i.e. Address field can be the first column or the second or last column as long as the first row reflects the Address header correctly.

The available fields are:

  • D.O. No. (required field)
  • Date (required field)
  • Deliver to
  • Address (required field)
  • Delivery time
  • Tracking No.
  • Phone No.
  • Notify email
  • Webhook URL
  • Instructions
  • Assign to
  • Zone
  • SKU (optional, only required for items)
  • Description (optional, only required for items)
  • Qty (optional, only required for items)

Always include country name in the Address field, preferably at the end, for accurate results.

Specify Notify Email only if you wish to send a delivery update to the external (customer-facing) email address.

The Assign To field must match your vehicle’s Name / Vehicle no. field exactly so that our system can assign the deliveries to the correct vehicle.

SKU, Description and Qty are only required if you are providing item details for the delivery. To specify more than one item, simply repeat the row with the same D.O. No. with different SKU, Description and Qty.

The headers (first row) must be spelled exactly as above for our system to be able to match the respective fields.

Once the deliveries have been imported, they will appear in the Detrack app of the respective assigned drivers’ phones. The Detrack app must be started and newly imported deliveries may take up to two minutes to appear.

Back to all tutorials
  • Start your free trial

WHO USES DETRACK

  • WHO USES DETRACK
  • Logistics Service Providers
  • Retailers
  • Medical and Pharmaceutical Companies
  • Furniture & Home Appliance Distributors
  • Construction Material Distributors
  • F&B Distributors
  • 3PL Providers
  • Businesses with Delivery Vehicles

CASE STUDIES

  • CASE STUDIES
  • PAN Logistics’ customers get real-time proof of deliveries with Detrack
  • Teak & Mahogany solved its logistics problems with Detrack
  • Mansco’s deliveries went paperless with Detrack
  • SGS Logistics improved the customer experience using Detrack

DISCOVER DETRACK

  • DISCOVER DETRACK
  • High speed route optimization
  • Tap to track
  • Contactless Delivery
  • Who We Are
  • Countries & languages
  • Reviews
  • Security
  • App data usage

GET IN TOUCH

  • GET IN TOUCH
  • Schedule a call
  • Support overview
  • Tutorials
  • General enquiry
  • Ask us anything via chat
  • The Detrack Blog
  • FAQs
App store
Google play
  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
  • © Detrack Systems Pte Ltd
  • Anti-spam
  • Privacy
  • Terms Of Use
  • Payment Terms
  • Data Retention
  • SLA
  • SaaS Agreement
Detrack is powerful delivery management software that lets you track your vehicles live on a map and capture electronic proof of delivery (e-POD) using our iOS or Android apps and an easy to use web dashboard for admins. Our apps have been translated into 26 languages and are being used daily around the world to complete millions of deliveries. Whether you’re looking for Delivery Management Software, a TMS System, Courier Software, Dispatch Software, or just an excellent Proof Of Delivery App, Detrack is the one to try. Sign up for a free Detrack account to get started. Or speak with our sales team today and we will get you up and tracking in no time.

The Capterra logo is a service mark of Gartner, Inc. and/or its affiliates and is used herein with permission. All rights reserved.