Bulk Import
Somebody sends you a spreadsheet with 300 deliveries for tomorrow. Typing them into a dispatch panel one at a time is not a job anyone should have. Bulk Import takes a CSV, checks it against the template for that order type, and creates every order in one go, from the dispatcher panel or from your customer’s own portal.
Deliveries Optimized
Courier Companies Served
Countries Supported Worldwide
Hundreds of Orders in a Few Clicks
The Import button sits next to the + button in the top right of the dispatcher panel. Click it, drop your CSV onto the page or open it from your computer, and start the import. Every import you run is listed on the same page with its status, so you can tell at a glance whether last night’s batch went through or needs a second look.
A Sample File for Every Order Type
Onro ships a downloadable sample CSV for each order type: on-demand, pickup only, delivery only, and pickup and delivery, plus a multi-drop on-demand sample for orders with more than one stop. Fill in the sample and upload it. Or keep the file you already have. As long as the column names match the ones in our template, Onro reads it, and you can leave every optional column empty or delete it from the sheet.
Six Columns Are Required, the Rest Are Up to You
A row needs a customer phone number, a pickup address, a drop-off (or delivery) address, a payment method and a payment side. On-demand files also carry a row number, which is how multi-drop orders group their stops. That is the whole list. COD amount, contact names, floor and unit, notes for the driver, schedule windows and the rest are there when you want them, and ignored when you do not.
Plain Values, Easy to Get Right
Payment method is cash or wallet. Payment side is sender or receiver, and a wallet order always bills the sender. Yes/no columns like Is Scheduled, Pickup Now and Draft take a lowercase yes or no, or nothing at all. Dates follow one pattern, YYYY-MM-DD HH:MM. Leave a COD cell empty and Onro treats it as zero. You can hand these rules to a customer on a single line and they will get the file right the first time.
Everything a Dispatcher Would Type, as Columns
The templates carry the same details a dispatcher enters by hand. Pickup and drop-off contact names and numbers, email addresses, floor, block and unit, a note for the driver at each stop, coordinates if you have them, and time windows for pickup and delivery. Pickup and delivery files add a reference ID and a Draft flag, so an imported batch can wait as drafts until you confirm it. Scheduled orders land on the right date with their window intact.
Let Your Customers Import Their Own
Business customers do not have to email you a spreadsheet. The customer web portal has its own Import button next to + New on the home page, with the same sample files for on-demand, multi-drop and pickup and delivery orders. A retailer with 80 parcels a day uploads one file and the orders arrive in your dispatch panel already created, priced and ready to assign.
Your Own Fields Come Along for the Ride
If you have added custom fields to orders, they import too. Name a column CustomField plus the field key for creation-stage fields, Pickup CustomField for pickup fields, and Dropoff CustomField (Delivery CustomField on pickup and delivery orders) for drop-off fields. Drop-down fields take the option key, and date fields take a timestamp. Delivery methods and service points have a slug for the same reason, so a file can say which one each order uses.
Start Your Free Demo Today
See how Bulk Import turns a customer’s spreadsheet into dispatch-ready orders in a few clicks.