Articles on: Tracking & Status

How to Manually Import Orders via CSV Import

Plans: All plans Platforms: All platforms

Overview



AfterShip Tracking’s CSV upload feature allows you to bulk-import orders and shipments from your connected eCommerce platforms to the Orders and Shipments dashboards respectively for additional order fulfillment visibility along with tracking updates. Additionally, you can upload CSV manually or auto-fetch orders and trackings from a CSV file on your server at a specific time.

With the introduction of the Orders dashboard, you can import orders along with trackings to AfterShip. If you wish to import just trackings, you can do so through Shipments dashbaord.

In this article, we will learn how to import orders via CSV import manually.

What you'll learn



In this tutorial, we will introduce:

How to upload CSV
View import logs

How to upload CSV



Upload a CSV file to bulk-import orders to your AfterShip Tracking account.

Go to Orders under Tracking dashboards in the AfterShip Tracking admin
Click on CSV import and select the Import by CSV option



Download the full CSV template.



You will get the following in the downloaded file

A file with all the field definitions
Orders import template
An example template to fill orders with one tracking
An example template to fill orders with multiple trackings

Learn more about order status mapping here

Select the CSV template, and fill it in according to the template format or check the example CSV files
Save the template in the .csv (Comma Separated Values) format
Add the CSV file from your desktop or drop the file onto the designated place to upload it. If you wish to replace the file, select the option to do so.



Click Import file. A bar will appear to display to showcase the progress of the import.

You can close the dialogue box, though the import will keep running in the background.



All the successfully imported orders will appear on the dashboard once you refresh the page. To view if all the orders have been successfully imported, check the View logs .

The import of the new orders file will begin only after the previous import is completed.

We will import all the shipments associated with the orders at the same time as the order information.

Find out how your eCommerce order statuses will be mapped to the AfterShip Tracking order dashboard [here](https://support.aftership.com/en/article/understand-aftership-tracking-order-status-mapping-k8urpi/).

To view

View import logs



The import log dashboard gives a detailed view of your one-time and auto-fetch CSV import logs.

Go to Orders under Tracking dashboards in the AfterShip Tracking admin
Click on CSV import and select the View logs option



If you haven’t imported any order yet, no logs will appear. If you have, the dashboard will display the following information.



Feed URL: The name of the CSV import file
Feed type: The method used to import orders
Import to: The platform where the file was imported
Processed time: The date and time when the fill was processed
Processed: The total number of orders in the file that are meant to be imported
Succeeded: The total number of orders that are successfully imported
Failed: The total number of orders that failed to be imported
Error log: The reason behind the unsuccessful imports which you can see by downloading the log file

Find the failed reason under the reason column, rectify it, and import the file again.

Updated on: 16/01/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!