How to import Excel file

How to import Excel file

Importing Excel using SolBox Excel template.

SolBox platform only allows the SolBox Excel template to be processed. 

Green columns are mandatory. 


1. Import from Dashboard

Import file from dashboard > click 3 dots from unassigned orders > Imports > Import XLS/CSV file > Select your file to upload into the system 


Processing the file > wait till it is done. > Close


To see orders, make sure you select the right date for the order(See dates on Processing file page above)

For example, these orders are on 04/10/2022. 

You are ready to drag and drop unassigned orders to create manifests

2. Import from Orders

Click Import XLS/CSV to import file 

Processing the file… / Check the date that orders will be on to view later > close


Select date range to see orders


Orders are ready

You can import file from Manifests menu which will work as same as from the orders menu as shown above.

    • Related Articles

    • How to Import from Ordermentum

      Follow instructions on how setup Ordermentum integration here: 1. Go to ORDERS menu and on the top right click on Import and select Import from Ordermentum 2. If you wish to automatically create a manifest during the import, tick Create Manifests ...
    • New customer

      Customers are an essential part of the SolBox platform. Customer profiles can be created individually as explained below, or automatically created as part of an order import to the SolBox platform. A customer in SolBox means that a new or existing ...
    • Zones Optimisation

      Create Zones and allocate imported orders to zones You can create new zones within "Zone" menu. Then you can import orders from Excel file which will be automatically grouped into your zones. See Add zones for more information After importing excel ...
    • Importing/Exporting Customers

      Importing bulk customer details (name, location, contact info, default order notes) can be done from the customer menu (image below). The import template can be found here. The export icon can be found within the customer menu also, this allows all ...
    • New orders

      Orders are the most important feature within the SolBox platform. Orders can be manually created as displayed below or imported, via a spreadsheet template  or any third-party API/Software. Order types There are 3 types of orders that SolBox can ...