Importing orders in ShipAccel

You can import a spreadsheet of orders into the Ship Orders tab as a CSV or XLSX file. You can either download a template to use, or use your own format and map your data after import.

The features and options you see may vary depending upon your role and subscription. If you have any questions regarding your permissions, please contact your administrator.

Note: Orders that are marked as Already in Process are orders that were imported by someone else. Only the user who imported an order can edit or print a label for it.

1. From the Home screen or the Shipping & Mailing menu, select Ship Orders.
2. Select Upload File.
3. Select the Download link for Download carrier and sub-carrier account information. You will use the information from this file to fill in the Carrier Code, Sub Carrier ID, and Service fields in the template.
4. Input your orders into the template spreadsheet and save it as a CSV or XLSX file. See the list of required fields:
   • Required Fields for Importing Orders
5. When you are ready to upload your file, select Click to select .csv or .xlsx or drag and drop them here, select your file, and select Open. You can also drag your file onto that box.
6. Select Upload.
7. In the Map your file column headers to our field names window, match your CSV file fields in the Your File section with the ShipAccel fields in the Field Names section.
   • The Overrides section allows you to override the data in your file with a single value for all of the imported records. For example, you could select Small Flat Rate Box for the Package Type for all of the packages in your file.
   • For Order ID, any value entered in the Overrides field will be added to the beginning of the Order ID with an underscore, for example, OrderNum_11200.
     
8. If you want to save these mapping choices for future imports, select Save mapping for future imports.
9. Select Confirm Mapping.
10. If prompted for address verification, select either Use Suggested Address or Use Original and select Apply to All Addresses & Import. Use Suggested Address is recommended.
11. Once the file has been loaded, select Load File.
    
12. Edit the orders and print the labels for them as needed.

Related topics

• Editing orders
• Printing labels for orders