Articles on: Uploads

How to Manually Import Orders via CSV Import

Plans: All plans Platforms: All platforms

Overview



AfterShip Shipping's CSV upload feature allows you to bulk import orders from your connected eCommerce platforms to the Orders dashboard from your linked eCommerce platforms to streamline order management. Moreover, you can manually upload a CSV file or automatically retrieve orders and trackings from a CSV file stored on your server at a designated time.

This article will guide you through manually importing orders via CSV.

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 Shipping account.

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



Download the sample CSV template.



In the sample CSV template, you can view how the orders with single and multiple shipments must be filled and what fields are required to import the file successfully.

You can check these resources for more information on CSV fields and definitions.

A file with all the field definitions


Fill the CSV template according to the format.

Below fields are required for Shipping purpose:

FieldExplanation
order_numberYour order number, used as unique key for orders. The orders with the same order_number will overwrite the existing record.
item_idUnique id of item. Can always set to 1.





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. 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.


View import logs



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

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



No logs will appear if you haven’t imported any orders yet. 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 order import which you can see by downloading the log.

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

Updated on: 06/06/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!