Jump to content
🚛
Streamline your cross-border operation. From ACE & ACI eManifests to PARS tracking and U.S. In-Bond filing, BorderConnect is the fastest way to cross.
Start Free Trial

ACE Shipment CSV Upload Feature (ACE Manifest): Difference between revisions

From BorderConnect Wiki
← Older edit
No edit summary
 
(32 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{note|This article is part of the [[ACE_Manifest_Software_User_Guide_(CBP)|BorderConnect ACE Manifest Guide]]|info}}
{{note|This article is part of the [[ACE_Manifest_Software_User_Guide_(CBP)|BorderConnect ACE Manifest Guide]] and the [[BorderConnect_Software_User_Guide|BorderConnect Software User Guide]]|info}}


{{#ev:youtube|bWwYYqaVZ0k|960|center|How to import shipments into an ACE eManifest.}}
<div class="bc-wrap">


This guide provides '''instructions on how to upload a large volume of shipments into an ACE Manifest''', using BorderConnect's CSV upload feature in an [https://www.borderconnect.com/ace-e-manifest/index.htm ACE Manifest]. The CSV upload feature is designed for users who have a significant amount of shipments on a single trip and would like to avoid entering data separately for each shipment. A common use case in ACE is used for Section 321 shipments.
<div class="bc-article-hero">
<h1>ACE Shipment CSV Upload Feature</h1>
<p>A comprehensive guide to bulk importing shipments into ACE eManifests using CSV files.</p>
<div class="bc-article-meta">
<span class="bc-article-pill"><i class="fas fa-file-csv"></i> Type: Data Import Tool</span>
<span class="bc-article-pill"><i class="fas fa-cubes"></i> Feature: Bulk Shipment Creation</span>
</div>
</div>


== Enabling Import Buttons ==
<div class="bc-card">


The first step is to enable the ability to upload shipments. By default, companies will have this option disabled. To enable this option, once logged into BorderConnect, navigate to the top right corner and hover over the menu option '''Account''', and select '''Company Settings'''.
<div class="bc-float-video" style="margin-top: 0;">
  <div class="bc-video-trigger" data-video-id="bWwYYqaVZ0k">
    <div class="bc-play-icon"><i class="fas fa-play-circle"></i></div>
  </div>
</div>


[[File:Company-pref.jpg]]
<h2 style="margin-top: 0;">Overview</h2>
<p>The <strong>ACE Shipment CSV Upload Feature</strong> 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.</p>


Within the '''Company Settings''' page navigate down to '''Display ACE Import Buttons''' under the section '''eManifest Preferences'''. Once the option is selected to 'Yes', click 'Save' on the top left and your company has now enabled the ability to upload shipments.
<p>BorderConnect also offers the <strong>[[Import_Wizard_(ACE_and_ACI_eManifest)|File Import Wizard]]</strong>, a broader tool for importing permanent company data (drivers, trucks, profiles).</p>


[[File:Display-ace-import.png|800px]]
<div class="bc-did-you-know" style="margin-top: 15px;">
<strong>Which Tool Should I Use?</strong><br>
* <strong>CSV Upload (This Guide):</strong> Best for quick, trip-specific bulk shipment uploads directly into one manifest.<br>
* <strong>Import Wizard:</strong> Best for importing standing data like driver profiles, truck lists, or maintaining customer databases.
</div>


== CSV File Format ==
<div style="clear: both;"></div>
</div>


Before uploading your .csv file, you will need to download the .csv template file that [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv BorderConnect provides here]. The headers in this file must remain intact and un-modified as they are required for the upload to be successful.
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 1: Enable Import Buttons</h2>


When saving your file, you will need to make sure that it is saved in CSV format, even if you are using a spreadsheet program to edit the file. Only CSV file format can be used for this feature.
<div class="bc-card">
<p>By default, the import controls may be hidden. To enable them:</p>
<div class="bc-cleanlist">
1. Go to <strong>Account</strong> > <strong>Company Settings</strong>.
2. Scroll to the <strong>eManifest Preferences</strong> section.
3. Set <strong>Display ACE Import Buttons</strong> to <strong>Yes</strong>.
4. Click <strong>Save</strong>.
</div>
[[File:Company-pref.jpg|thumb|center|Enabling Import Buttons in Company Settings]]
</div>


== Field Specifications ==
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 2: Download the Template</h2>


=== SCN (Shipment Control Number) ===
<div class="bc-card">
<p>You must use the official template to ensure your data maps correctly.</p>
<div class="bc-cleanlist">
* <strong>Download:</strong> [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv ACE Shipment CSV Template]
* <strong>Format Rule:</strong> Do not rename, remove, or reorder the column headers. Always save as <strong>.csv</strong> (Comma Separated Values).
</div>
</div>


*Unique identifier assigned to this shipment by the carrier.
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 3: Prepare Your Data</h2>
*Starts with carrier's 4 letter SCAC code followed by unique reference number.
*Must be alpha-numeric with no spaces or special characters, '''letters must be upper case'''.
*Minimum length: 8 characters.
*Maximum length: 16 characters.


When entering Shipments Control Numbers into the CSV document, you can enter them manually OR you have the option to use BorderConnect's system to automatically generate SCNs. To import shipments with automatically generated shipment control numbers in sequential order enter your SCAC + the word AUTOFILL (ex. ZZZZAUTOFILL). Using the autofill feature means that all SCNs must use the autofill feature. You cannot have a mix of autofill and non-autofill SCNs.
<div class="bc-card">
<h3>Shipment Control Number (SCN)</h3>
<div class="bc-cleanlist">
* <strong>Format:</strong> Must be 8-16 alphanumeric characters. No spaces or special characters.
* <strong>Autofill:</strong> To let BorderConnect generate numbers, use your SCAC followed immediately by "AUTOFILL" (e.g., <code>ABCDAUTOFILL</code>).
* <strong>Rule:</strong> Do not mix manual SCNs and AUTOFILL in the same file.
</div>


=== Shipment Type ===
<h3>Shipment Type</h3>
<p>Values must match exactly (case-sensitive):</p>
<table class="wikitable" style="width: 100%;">
<tr><th>Type</th><th>Value</th></tr>
<tr><td>PAPS</td><td><code>PAPS</code></td></tr>
<tr><td>Section 321</td><td><code>SECTION 321</code></td></tr>
<tr><td>Intangibles</td><td><code>INTANGIBLES</code></td></tr>
<tr><td>Free of Duty</td><td><code>ATTACHED_CF7523</code></td></tr>
</table>


*The type of U.S. Customs clearance for this shipment.
<h3>Commodity Data</h3>
*Only the coded values listed in the table below can be used in this field.
<div class="bc-cleanlist">
* <strong>Description:</strong> Plain language description of goods (max 45 chars).
* <strong>Value:</strong> Numeric only. No dollar signs (e.g., <code>1500.50</code>).
* <strong>Weight:</strong> Whole numbers only (round up).
</div>
</div>


Below are the valid Shipment Type values. E.g. for a Section 321 shipment, the value SECTION_321 must be entered.<br>
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 4: Importing into BorderConnect</h2>
(Please note that the shipment type values are '''case sensitive''', and the upload will fail if it is not entered ''exactly'' as specified below.)


{| class="wikitable"
<div class="bc-card">
|-
<p>Once your file is ready, follow these specific steps to upload it into the system.</p>
! Shipment Type
! Value
|-
| PAPS
| PAPS
|-
| Section 321
| SECTION_321
|-
| Section 321 with FDA Considerations
| SECTION_321_FDA
|-
| QP In-Bond
| QP_IN_BOND
|-
| Intangibles
| INTANGIBLES
|-
| Free of Duty (Customs Form 7523)
| ATTACHED_CF7523
|-
| Returned American Products (Customs Form 3311)
| ATTACHED_CF3311
|-
| Personal Shipment (Customs Form 3299)
| ATTACHED_CF3299
|}


=== Province Of Loading ===
<h3>1. Create or Open the Manifest</h3>
<div class="bc-cleanlist">
* Navigate to <strong>ACE eManifest</strong> > <strong>Start New ACE eManifest</strong>.
* Enter the required Trip details (Trip Number, Port of Entry, Estimated Arrival).
* Click <strong>Save</strong>. You must save the trip header before you can add shipments.
</div>


*The Canadian Province or Mexican State in which the shipment was picked up by the carrier.
<h3>2. Locate the Import Tool</h3>
*Must use the 2 letter code of the Canadian province or 3 letter code of the Mexican state.
<div class="bc-cleanlist">
* On the <strong>ACE eManifest Details</strong> page, scroll down to the <strong>Shipments</strong> section.
* Look for the button labeled <strong>Import Shipments via CSV</strong> (sometimes labeled <strong>Upload Shipments</strong>).
* <em>Note: If you do not see this button, ensure you completed Step 1 to enable import buttons in Company Settings.</em>
</div>
[[File:Ace-upload-shipments.png|thumb|center|800px|The Import Shipments interface in BorderConnect]]


E.g. For a shipment loading in British Columbia, you must use BC. For a shipment loading in Guerrero, you must use GRO. State or province codes must be '''upper case'''.
<h3>3. Upload and Process</h3>
<div class="bc-cleanlist">
* Click <strong>Choose File</strong> and select your prepared <code>.csv</code> file from your computer.
* Click <strong>Save</strong> or <strong>Import</strong>.
* The system will process the file immediately.
</div>


=== Shipper ===
<h3>4. Verify Results</h3>
<div class="bc-cleanlist">
* <strong>Success:</strong> You will see a green confirmation message, and your shipments will appear in the list below.
* <strong>Failure:</strong> A red error box will appear at the top of the page. It will list the specific row numbers and the exact error (e.g., "Row 4: Invalid SCAC"). Correct these errors in your CSV file and try uploading again.
</div>
</div>


<u>Name</u>:
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Reference Codes</h2>
*The name of the shipper for this shipment.
*Minimum length: 1
*Maximum length: 60


<u>Address</u>:
<div class="bc-card">
*The street number and street name of the shipper for this shipment.
<h3><i class="fas fa-balance-scale"></i> Weight Unit Codes</h3>
*Minimum length: 1
<p>Only the following codes are accepted for the <strong>Weight Unit</strong> column:</p>
*Maximum length: 55
<table class="wikitable" style="width: 100%;">
<tr>
<th style="width: 30%;">Unit</th>
<th>Accepted Codes</th>
</tr>
<tr>
<td><strong>Kilograms</strong></td>
<td><code>K</code>, <code>KG</code>, <code>KGM</code></td>
</tr>
<tr>
<td><strong>Pounds</strong></td>
<td><code>L</code>, <code>LB</code>, <code>LBS</code>, <code>LBR</code></td>
</tr>
</table>
</div>


<u>City</u>:
<div class="bc-card" style="margin-top: 20px;">
*The city name of the shipper for this shipment.
<h3><i class="fas fa-box"></i> Package Type Codes</h3>
*Minimum length: 1
<p>The <strong>Quantity Unit</strong> column must use one of the specific 3-letter codes below. (Case-sensitive).</p>
*Maximum length: 30


<u>State</u>:
<div class="bc-2col">
*The Canadian Province or Mexican State of the shipper for this shipment.
<div style="flex: 1; min-width: 250px;">
*Must use the 2 letter code of the Canadian province or 3 letter code of the Mexican state.
<table class="wikitable" style="font-size: 0.9em; width: 100%; margin-top: 0;">
*State or province codes must be '''upper case'''.
<tr><th>Description</th><th>Code</th></tr>
<tr><td>Bag</td><td>BAG</td></tr>
<tr><td>Bale</td><td>BLE</td></tr>
<tr><td>Barrel</td><td>BBL</td></tr>
<tr><td>Basket</td><td>BSK</td></tr>
<tr><td>Bin</td><td>BIN</td></tr>
<tr><td>Box</td><td>BOX</td></tr>
<tr><td>Bucket</td><td>BKT</td></tr>
<tr><td>Bundle</td><td>BDL</td></tr>
<tr><td>Can</td><td>CAN</td></tr>
<tr><td>Carboy</td><td>CBY</td></tr>
<tr><td>Carton</td><td>CTN</td></tr>
<tr><td>Case</td><td>CAS</td></tr>
<tr><td>Chest</td><td>CHS</td></tr>
<tr><td>Coil</td><td>COL</td></tr>
<tr><td>Crate</td><td>CRT</td></tr>
<tr><td>Cylinder</td><td>CYL</td></tr>
<tr><td>Drum</td><td>DRM</td></tr>
</table>
</div>
<div style="flex: 1; min-width: 250px;">
<table class="wikitable" style="font-size: 0.9em; width: 100%; margin-top: 0;">
<tr><th>Description</th><th>Code</th></tr>
<tr><td>Envelope</td><td>ENV</td></tr>
<tr><td>Keg</td><td>KEG</td></tr>
<tr><td>Lift Van</td><td>LVN</td></tr>
<tr><td>Liquid Bulk</td><td>LBK</td></tr>
<tr><td>Logs</td><td>LOG</td></tr>
<tr><td>Package</td><td>PKG</td></tr>
<tr><td>Pail</td><td>PAL</td></tr>
<tr><td>Pallet</td><td>PLT</td></tr>
<tr><td>Pieces</td><td>PCS</td></tr>
<tr><td>Reel</td><td>REL</td></tr>
<tr><td>Roll</td><td>ROL</td></tr>
<tr><td>Sack</td><td>SAK</td></tr>
<tr><td>Sheet</td><td>SHT</td></tr>
<tr><td>Skid</td><td>SKD</td></tr>
<tr><td>Tank</td><td>TNK</td></tr>
<tr><td>Tote Bin</td><td>TBN</td></tr>
<tr><td>Tube</td><td>TBE</td></tr>
</table>
</div>
</div>
</div>


<u>Zip</u>:
<div class="bc-card" style="margin-top: 20px;">
*The postal code of the shipper for this shipment.
<h3><i class="fas fa-globe"></i> Common Country of Origin Codes</h3>
*For Canadian postal codes, must be in the format "A1A1A1" or "A1A 1A1".
<p>Use the 2-letter ISO code for the <strong>Country of Origin</strong> column. Common codes include:</p>
*For Mexican postal codes, must be in the format "12345".
<table class="wikitable" style="width: 100%;">
*Letters must be '''upper case'''.
<tr><th>Country</th><th>Code</th><th>Country</th><th>Code</th></tr>
<tr><td>Canada</td><td><code>CA</code></td><td>United States</td><td><code>US</code></td></tr>
<tr><td>Mexico</td><td><code>MX</code></td><td>China</td><td><code>CN</code></td></tr>
<tr><td>Germany</td><td><code>DE</code></td><td>Japan</td><td><code>JP</code></td></tr>
<tr><td>United Kingdom</td><td><code>GB</code></td><td>France</td><td><code>FR</code></td></tr>
<tr><td>India</td><td><code>IN</code></td><td>Italy</td><td><code>IT</code></td></tr>
<tr><td>South Korea</td><td><code>KR</code></td><td>Taiwan</td><td><code>TW</code></td></tr>
</table>
<p style="font-size: 0.9em;"><em>Note: For a complete list of all world country codes, refer to the <a href="https://www.borderconnect.com/data/countries.json" target="_blank">BorderConnect Data JSON</a>.</em></p>
</div>


=== Consignee ===
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Importing 10,000+ Shipments</h2>


<u>Name</u>:
<div class="bc-card">
*The name of the consignee for this shipment.
<p>For manifests exceeding 9,999 shipments, use the <strong>Link Shipments to Trip</strong> feature.</p>
*Minimum length: 1
*Maximum length: 60


<u>Address</u>:
<div class="bc-2col">
*The street number and street name of the consignee for this shipment.
<div>
*Minimum length: 1
<h3>Workflow</h3>
*Maximum length: 55
<div class="bc-cleanlist">
1. <strong>Master Manifest:</strong> Create the first manifest and import the first ~5,000 shipments.
2. <strong>Linked Manifests:</strong> Create additional manifests (e.g., Trip 123B, 123C).
3. <strong>Link Field:</strong> In the new manifests, set <strong>Link Shipments to Trip</strong> to the original Trip Number (123).
4. <strong>Transmit:</strong> Send the master manifest first. Then, send the linked manifests using "Link Shipments to Trip" transmission.
</div>
</div>
<div style="text-align: center;">
[[File:Link-shipments-to-trip-field.png|thumb|center|800px|Linking Shipments to a Master Trip]]
</div>
</div>
</div>


<u>City</u>:
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Common Import Errors</h2>
*The city name of the consignee for this shipment.
*Minimum length: 1
*Maximum length: 30


<u>State</u>:
<div class="bc-card">
*The American State of the consignee for this shipment.
<h3>Troubleshooting Guide</h3>
*Must use the 2 letter code of the American state code.
<table class="wikitable" style="width: 100%;">
*State codes must be '''upper case'''.
<tr>
<th style="width: 30%;">Error Message</th>
<th>Solution</th>
</tr>
<tr>
<td><code>SCAC Code [AAA] is invalid.</code></td>
<td>SCAC must be exactly 4 characters.</td>
</tr>
<tr>
<td><code>Shipment Type [SECTION321] is invalid</code></td>
<td>Check spacing. It must be <code>SECTION 321</code> with a space.</td>
</tr>
<tr>
<td><code>Unknown packaging unit [box]</code></td>
<td>Package codes are case-sensitive. Use uppercase <code>BOX</code>.</td>
</tr>
<tr>
<td><code>Consignee State [California] is invalid</code></td>
<td>Use 2-letter codes (e.g., <code>CA</code>) for states and provinces.</td>
</tr>
</table>
</div>


<u>Zip</u>:
{{AppPromo}}
*The zip code of the consignee for this shipment.
*Must be in the format "12345" or "12345-6789"


=== Commodity ===
== References ==
<references />


<u>Description</u>:
</div>
*A description of the goods in this shipment.
*Should use plain language and be sufficient to give officer good idea of what is being shipped.
*Generic descriptions such as "freight of all kinds" are not allowed by customs.
*Minimum length: 1
*Maximum length: 45
 
<u>Value</u>:
*The value of the commodity, in U.S. Dollars.
*'''Numeric only''', with one decimal allowed. Must not include dollar sign, commas, etc.
*Only required when Shipment Type is Section 321 or Section 321 with FDA Considerations
*For Section 321 or Section 321 with FDA Considerations, the maximum value is 800.
*System will round to nearest whole number, or up to 1 if less than 1 before transmitting to customs.
 
<u>Quantity</u>:
*The quantity of the lowest external packaging unit. (e.g. if shipments consists of 100 pieces packaged in 5 boxes sitting on 1 skid, the quantity should be entered as 5, because boxes are the lowest external packaging unit.)
*Numeric only, with no spaces or special characters. Decimal values not allowed.
 
<u>Quantity Unit</u>:
*The type of packaging for the commodity.
*Must use a 3 letter Package Type code from the table provided.
 
Below are the valid package types for the commodity. E.g. for Cartons, CTN must be entered.<br>
(Please note that the package type values are case sensitive, and the upload will fail if it is not entered exactly as specified below.)
 
{| class="wikitable"
|-
! Package Type
! Value
! Package Type
! Value
! Package Type
! Value
! Package Type
! Value
|-
| Bag
| BAG
| Carton
| CTN
| Heads of Beef
| HED
| Roll
| ROL
|-
| Bale
| BLE
| Case
| CAS
| Keg
| KEG
| Sack
| SAK
|-
| Barrel
| BBL
| Cask
| CSK
| Lift Van
| LVN
| Sheet
| SHT
|-
| Basket
| BSK
| Chest
| CHS
| Liquid Bulk
| LBK
| Sides of Beef
| SID
|-
| Bin
| BIN
| Coil
| COL
| Logs
| LOG
| Skid
| SKD
|-
| Bing Chest
| BIC
| Container Bulk Cargo
| CBC
| Lugs
| LUG
| Tank
| TNK
|-
| Box
| BOX
| Cord
| COR
| Package
| PKG
| Tin
| TIN
|-
| Bucket
| BKT
| Crate
| CRT
| Pail
| PAL
| Tote Bin
| TBN
|-
| Bundle
| BDL
| Cylinder
| CYL
| Parcel
| PCL
| Tube
| TBE
|-
| Can
| CAN
| Drum
| DRM
| Pieces
| PCS
| Unit
| UNT
|-
| Can Case
| CCS
| Dry Bulk
| DBK
| Private Vehicle
| POV
| Van Pack
| VPK
|-
| Carboy
| CBY
| Gallon
| GAL
| Quarters of Beef
| QTR
| Vehicle
| VEH
|-
| Carcass
| CAR
| Hamper
| HMP
| Reel
| REL
| Wooden Case
| WDC
|}
 
<u>Weight</u>:
*The gross weight of the commodity.
*Numeric only, with no spaces or special characters. Decimal values not allowed, should be rounded to the nearest whole number.
 
<u>Weight Unit</u>:
*The weight unit for the commodity.
*For Pounds, acceptable values are: "L", "LB", "LBS", "LBR"
*For Kilograms, acceptable values are: "K", "KG", "KGM"
 
<u>Country of Origin</u>:
*The country in which the commodity was manufactured, grown or otherwise produced.
*Only required when Shipment Type is Section 321 or Section 321 with FDA Considerations.
*Must use the 2 letter country code for the country, in upper case letters.
*The full list of acceptable country codes can be [https://www.borderconnect.com/data/countries.json downloaded here].
 
== Importing Shipments ==
 
Once you have the CSV file populated with data in the correct format and your company has enabled the ACE shipment import buttons, you can then import the shipments.<br><br>
 
To import the CSV file you must first start a new ACE Manifest or edit an existing ACE Manifest. Then, click the button "Choose File" to navigate locally and select the .csv file you would like to upload. Once the file is selected, click 'Save' on the top left. You will be brought to the ACE Manifest details page where a notice will let you know if the upload was successful, and/or if any errors in the import were found.
 
Next to the import button you will see that this button is for JSON files, but CSV files will also be accepted.
 
[[File:Ace-upload-shipments.png|800px]]
 
== Common Import Errors ==
 
Listed below are some of the common errors users receive when trying to upload their .csv file into BorderConnect.<br><br>
 
'''Shipment Control Number Errors'''
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Can't perform import since AUTOFILL shipment numbers are combined with explicitly stated shipment control numbers.
</pre>
 
Some of the Shipment Control Numbers in your file are using your SCAC plus AUTOFILL, and some are not. To use the Autofill feature, all Shipment Control Numbers must be filled in as SCAC plus AUTOFILL.
 
It is currently also possible to get this error because there are blank rows at the bottom of your CSV file. You may want to use a plain text editor to check your file for rows consisting of only commas and remove those rows from the file.
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
SCAC Code [AAA5] is invalid. Must be 4 alphanumeric characters. [AAA5459071]
</pre>
 
The SCAC code has an incorrect amount of characters. SCAC should be four letters.
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Shipment Control Number is invalid, it must be 8-16 alphanumeric characters with no spaces and letters must be uppercase. [AAAA545907321321321131]
</pre>
 
The Shipment Control Number has too many characters. SCN must be between 8-16 characters.
 
 
'''Shipment Type Errors'''
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Shipment Type [SECTION 321] is invalid [AAAA5459071]
</pre>
 
The Shipment Type value is incorrect and should be "SECTION_321". Double check acceptable shipment type values and try to upload again.
 
 
'''Shipper Errors'''
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Province of Loading code [BX] unrecognized. [AAAA5459071]
OR
Province of Loading code [British Columbia] unrecognized. [AAAA5459071]
</pre>
 
The Province of Loading for the shipper is not recognized. Format must use the acronym "BC". (ex. "ON", "MB", "NS", etc.)
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Shipper Name [Demo Business Incorporated CO Steven Stevenson Incorporated of Vancouver bla bla] invalid. Must be between 1 and 60 characters, with no accents or other invalid characters. [AAAA5459091]
</pre>
 
The Shipper Name has too many characters. It must be between 1 and 60 characters.
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Shipper Canadian Postal Code [VSS 1A1] invalid. [AAAA5459219]
</pre>
 
The shipper postal code is invalid. Should be (letter-number-letter number-letter-number)
 
 
'''Consignee Errors'''
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Consignee State [California] is invalid or does not match with country [US]. [AAAA5459219]
</pre>
 
The state of the consignee is not recognized. Format must use the acronym "CA". (ex. "NY", "WA", "FL", etc.)
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Consignee U.S. Zip Code [4321] invalid. [AAAA5459219]
</pre>
 
The consignee address has a zip code that is invalid. Zip codes must be five character numbers or ten character numbers (ex. 45180-6789 and must include the dash if the ten character format is used).
 
<u>Note</u>: It is common for spreadsheet programs to strip leading zeroes from fields. E.g. zip code beginning with a zero such as 04321 might be saved as 4321 by the spreadsheet program, which would be an unacceptable zip code for upload to BorderConnect.
 
It may be necessary to look for solutions within the program that you're using to generate the CSV file to remedy this issue. For some spreadsheet programs, saving the number as ''="04321"'' instead of just ''04321'' works.
 
'''Commodity Errors'''
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Unknown packaging unit [box]. [AAAA5459219]
</pre>
 
The package type is in the incorrect format. The correct variable for the box package type is "BOX". Remember that values are case-sensitive.
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Shipment commodity weight is invalid. It must be numeric [0.63]
</pre>
 
Commodity weight must be listed in whole numbers only. Should be rounded to the nearest number, or up to 1 if less than 1.
 
<pre style="white-space: pre-wrap;
white-space: -moz-pre-wrap;
white-space: -pre-wrap;
white-space: -o-pre-wrap;
word-wrap: break-word;">
Commodity weight unit [POUNDS] is invalid. [AAAA5459219]
</pre>
 
The unit of measure for the weight is incorrect. It must follow the value guidlines for import. In this case if pounds was the unit of weight, the correct value is "LB", "L", "LBS" or "LBR"


[[Category:ACE Manifest Guide]]
[[Category:ACE Manifest Guide]]
[[Category:BorderConnect Software User Guide]]

Latest revision as of 11:59, 11 February 2026

🔖 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: Prepare Your Data

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 Data

  • Description: Plain language description of goods (max 45 chars).
  • Value: Numeric only. No dollar signs (e.g., 1500.50).
  • Weight: Whole numbers only (round up).

Step 4: Importing into BorderConnect

Once your file is ready, follow these specific steps to upload it into the system.

1. Create or Open the Manifest

  • Navigate to ACE eManifest > Start New ACE eManifest.
  • Enter the required Trip details (Trip Number, Port of Entry, Estimated Arrival).
  • Click Save. You must save the trip header before you can add shipments.

2. Locate the Import Tool

  • On the ACE eManifest Details page, scroll down to the Shipments section.
  • Look for the button labeled Import Shipments via CSV (sometimes labeled Upload Shipments).
  • Note: If you do not see this button, ensure you completed Step 1 to enable import buttons in Company Settings.
The Import Shipments interface in BorderConnect

3. Upload and Process

  • Click Choose File and select your prepared .csv file from your computer.
  • Click Save or Import.
  • The system will process the file immediately.

4. Verify Results

  • Success: You will see a green confirmation message, and your shipments will appear in the list below.
  • Failure: A red error box will appear at the top of the page. It will list the specific row numbers and the exact error (e.g., "Row 4: Invalid SCAC"). Correct these errors in your CSV file and try uploading again.

Reference Codes

Weight Unit Codes

Only the following codes are accepted for the Weight Unit column:

Unit Accepted Codes
Kilograms K, KG, KGM
Pounds L, LB, LBS, LBR

Package Type Codes

The Quantity Unit column must use one of the specific 3-letter codes below. (Case-sensitive).

DescriptionCode
BagBAG
BaleBLE
BarrelBBL
BasketBSK
BinBIN
BoxBOX
BucketBKT
BundleBDL
CanCAN
CarboyCBY
CartonCTN
CaseCAS
ChestCHS
CoilCOL
CrateCRT
CylinderCYL
DrumDRM
DescriptionCode
EnvelopeENV
KegKEG
Lift VanLVN
Liquid BulkLBK
LogsLOG
PackagePKG
PailPAL
PalletPLT
PiecesPCS
ReelREL
RollROL
SackSAK
SheetSHT
SkidSKD
TankTNK
Tote BinTBN
TubeTBE

Common Country of Origin Codes

Use the 2-letter ISO code for the Country of Origin column. Common codes include:

CountryCodeCountryCode
CanadaCAUnited StatesUS
MexicoMXChinaCN
GermanyDEJapanJP
United KingdomGBFranceFR
IndiaINItalyIT
South KoreaKRTaiwanTW

Note: For a complete list of all world country codes, refer to the <a href="https://www.borderconnect.com/data/countries.json" target="_blank">BorderConnect Data JSON</a>.

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=3287"