Skip to main content

Manually Import Orders via CSV

Bulk import orders into AfterShip Shipping using a CSV file, including required fields and limits.

Written by Harneet Kaur

Plans: All plans | Platforms: All platforms

Overview

AfterShip Shipping's CSV import feature lets you bulk-import orders into your Fulfillments dashboard to streamline order management. This article covers how you can manually upload a CSV file to import orders for shipping.

Manually import orders by CSV

Step 1: Download the CSV template

  1. Go to Fulfillments > Awaiting shipment in the AfterShip Shipping admin.

  2. Click CSV import and select Import by CSV.

  3. In the dialog, download the sample CSV template. It shows how orders with single and multiple shipments should be filled in, and which fields are required for a successful import. For a full breakdown of every field, open the importing CSV files help article linked in the dialog.

    • Orders sharing the same order_number as an existing order will overwrite that record.

    • Files must not exceed 10 MB.

Step 2: Fill in the CSV template

Fill in the CSV template according to the format. The following fields are required for Shipping.

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

  • Shipping requires the following fields, grouped by section:

    Order information

Field

Format

Description

order_number

Up to 64 characters. Letters, numbers, hyphens, and # only.

Your order number, used as the unique key for orders. Orders with the same order_number will overwrite the existing record.

status

One of open, closed, or canceled (case-sensitive). Default: open.

The status of the order.

fulfillment_status

One of unfulfilled, partially_fulfilled, or fulfilled. Default: fulfilled.

The fulfillment status of the order.

order_total

Decimal number.

The total price of the order.

shipping_total

Decimal number.

The total shipping fee applied to the order.

tax_total

Decimal number.

The sum of all taxes applied to the order.

customer_locale

Language code (ISO 639-1) + region code (ISO 3166-1 alpha-2), e.g. en-US. Default: en-US.

The customer's language and region.

currency

3-letter ISO 4217 code, e.g. USD. Default: USD.

The currency used at checkout.

created_at

ISO 8601 date and time, e.g. 2026-01-01T15:12:33+08:00. Default: current time.

The date and time the order was created.

Ship to address

Field

Format

Description

ship_to_first_name

Up to 256 characters.

The customer's first name.

ship_to_street_1

Up to 256 characters.

The customer's mailing address.

ship_to_postal_code

Up to 256 characters.

The customer's postal code (zip, postcode, Eircode, etc.).

ship_to_city

Up to 256 characters.

The customer's city, town, or village.

ship_to_state

Up to 256 characters.

The customer's state, province, or prefecture.

ship_to_country_region

3-letter ISO 3166-1 alpha-3 code, e.g. USA.

The customer's country.

ship_to_email

Up to 256 characters.

The customer's email address.

Order item

Field

Format

Description

item_id

Up to 256 characters.

The order item's ID. You can use an incrementing number starting from 1.

item_title

Up to 1024 characters.

The title of the product variant.

item_sku

Up to 256 characters.

The item's SKU (stock keeping unit).

item_quantity

Whole number.

The number of units of this item purchased.

  1. Save the template in .csv (comma-separated values) format.

  2. Click Upload CSV file and select your file, or drag-and-drop it onto the upload area. To use a different file, upload it again before clicking Import.

  3. Click Import. (This button stays inactive until a file is selected.) A progress bar shows the import's status, you can close the dialog and the import will keep running in the background.

  4. Refresh the page to see successfully imported orders in the shipment list: Awaiting shipment or Shipped.

  5. Check the import logs to confirm every order imported successfully.

A new import only starts once the previous one finishes. All shipments linked to an order are imported together with the order information.

View CSV import logs

The logs page gives a detailed view of your CSV import history.

  1. Go to Fulfillments > Awaiting shipment in the AfterShip Shipping admin.

  2. Click CSV import and select View logs.

  • If you haven't imported any orders yet, no logs will appear. Otherwise, the log lists:

Column

Description

Feed URL

The name of the manually uploaded file, or the source URL for an auto-fetched feed.

Feed type

The method used to import orders.

Import to

The platform the file was imported to.

Processed time

The date and time the file was processed.

Processed

The total number of orders in the file.

Succeeded

The number of orders successfully imported.

Failed

The number of orders that failed to import.

Error log

The reason an import failed. Download the log to view it.

  • Find the failure reason under the Reason column, fix it, and re-import the file.

Key takeaways

  1. CSV import lets you bulk import orders into your Awaiting shipment list, either by manual upload or scheduled auto-fetch from a server URL.

  2. It's accessed from Fulfillments > Awaiting shipment > CSV import in the Shipping admin.

  3. CSV files can't exceed 10 MB, and orders sharing an existing order_number get overwritten.

  4. Twenty fields are required while importing order via CSV files, covering order details, the ship to address, and item information.

  5. After importing, check View logs to confirm every order succeeded, and download the error log for details on anything that failed.

Did this answer your question?