- 1. Introduction
- 2. Creating Deliveries
- 3. LionWheel Delivery Management Guide
- 4. Plan Drivers Routes
- 5. Import an Excel file to LionWheel
- 6. Status Descriptions
- 7. Settings
- 8. Edit Geolocation
- 9. Flexible import: import from any Excel layout
- 10. Logging in and resetting a password
Import an Excel file to LionWheel
Create multiple deliveries with the click of a button, simply upload an Excel file.
Updated
Through the Import tab, download your template, insert the deliveries’ details and LionWheel will create them accordingly. After importing, you can view the import history, access the original imported file, and review a summary of the deliveries created based on that file.
Instructions for importing an Excel file
-
It’s important to download and use only the template provided in the system!
-
Please do not change or delete columns from the table! If you haven’t entered data in them, leave them empty. Have a file in a different layout? Try the flexible import, which works with any column layout (flexible import guide).
-
The destination city is mandatory; otherwise, the delivery won’t be loaded into the system.
-
When uploading a file with a large number of deliveries, wait a few minutes for the loading process to complete before uploading another file.
-
The Order ID can be left blank. By default, rows whose Order ID already exists are skipped. To allow duplicates, turn on Allow import tasks with the same Order Id under Settings => General => Advanced.
-
Don’t have Excel on your computer? Use Google Sheets - it’s free and can save files as Excel (.xlsx) when you’re done.
-
If the system shows an error, do not immediately try to upload the Excel file again! Sometimes the system shows an error but uploads all deliveries in the background - uploading again will create duplicate deliveries and waste your time and energy. To check this, click the “Import History” button!
-
On the “Import History” button, you’ll see the history of Excel file imports into the system - details of deliveries uploaded from each file separately, times, how many deliveries were successfully uploaded and how many weren’t (due to an Order ID already existing in the system), and the option to change the date and assign a courier to each delivery.
Import preview
After you choose the file and click Import, a preview screen opens. It shows the deliveries in a table, lists the errors in the file with their row numbers, and lets you fix a value by clicking it. Use Show All / Show Only Invalid to switch between all rows and the rows with errors, then click Approve Import.
Note: The destination city is mandatory; the file can’t be imported while a row is missing a city.
