BorderConnect Wiki

ACE Shipment CSV Upload Feature (ACE Manifest)

Revision as of 15:42, 5 February 2026 by Admin (talk | contribs)

🔖 This article is part of the BorderConnect ACE Manifest Guide and the BorderConnect Software User Guide

ACE Shipment CSV Upload Feature

A comprehensive guide to bulk importing shipments into ACE eManifests using CSV files.

Type: Data Import Tool Feature: Bulk Shipment Creation

Overview

The ACE Shipment CSV Upload Feature allows carriers to import large volumes of shipments directly into a specific ACE eManifest using a standardized CSV template. This is ideal for trips with hundreds of shipments, such as courier loads or consolidated freight.

BorderConnect also offers the File Import Wizard, a broader tool for importing permanent company data (drivers, trucks, profiles).

Which Tool Should I Use?

  • CSV Upload (This Guide): Best for quick, trip-specific bulk shipment uploads directly into one manifest.
  • Import Wizard: Best for importing standing data like driver profiles, truck lists, or maintaining customer databases.

Step 1: Enable Import Buttons

By default, the import controls may be hidden. To enable them:

1. Go to Account > Company Settings. 2. Scroll to the eManifest Preferences section. 3. Set Display ACE Import Buttons to Yes. 4. Click Save.

Enabling Import Buttons in Company Settings

Step 2: Download the Template

You must use the official template to ensure your data maps correctly.

  • Download: ACE Shipment CSV Template.
  • Format Rule: Do not rename, remove, or reorder the column headers. Always save as .csv (Comma Separated Values).

Step 3: Field Specifications

Shipment Control Number (SCN)

  • Format: Must be 8-16 alphanumeric characters. No spaces or special characters.
  • Autofill: To let BorderConnect generate numbers, use your SCAC followed immediately by "AUTOFILL" (e.g., ABCDAUTOFILL).
  • Rule: Do not mix manual SCNs and AUTOFILL in the same file.

Shipment Type

Values must match exactly (case-sensitive):

TypeValue
PAPSPAPS
Section 321SECTION 321
IntangiblesINTANGIBLES
Free of DutyATTACHED_CF7523

Commodity & Units

  • Quantity Unit: Must use a valid 3-letter package code (e.g., BOX, CTN, PLT, SKD).
  • Weight: Whole numbers only. Round up if necessary.
  • Weight Unit: Use L, LB, LBS for pounds or K, KG, KGM for kilograms.

Importing 10,000+ Shipments

For manifests exceeding 9,999 shipments, use the Link Shipments to Trip feature.

Workflow

1. Master Manifest: Create the first manifest and import the first ~5,000 shipments. 2. Linked Manifests: Create additional manifests (e.g., Trip 123B, 123C). 3. Link Field: In the new manifests, set Link Shipments to Trip to the original Trip Number (123). 4. Transmit: Send the master manifest first. Then, send the linked manifests using "Link Shipments to Trip" transmission.

Linking Shipments to a Master Trip

Common Import Errors

Troubleshooting Guide

Error Message Solution
SCAC Code [AAA] is invalid. SCAC must be exactly 4 characters.
Shipment Type [SECTION321] is invalid Check spacing. It must be SECTION 321 with a space.
Unknown packaging unit [box] Package codes are case-sensitive. Use uppercase BOX.
Consignee State [California] is invalid Use 2-letter codes (e.g., CA) for states and provinces.
📱

eManifesting in your pocket. Process ACE & ACI eManifests, track shipments in real-time, and upload documents instantly—anytime, anywhere.

Download on theApp Store GET IT ONGoogle Play

References


Retrieved from "https://wiki.borderconnect.com/index.php?title=ACE_Shipment_CSV_Upload_Feature_(ACE_Manifest)&oldid=2960"