ACE Shipment CSV Upload Feature (ACE Manifest) - Revision history

Admin at 15:59, 11 February 2026

2026-02-11T15:59:45Z

← Older revision		Revision as of 11:59, 11 February 2026
Line 145:		Line 145:

	<div class="bc-2col">		<div class="bc-2col">
	<div>		<div style="flex: 1; min-width: 250px;">
	<table class="wikitable" style="font-size: 0.9em; width: 100%;">		<table class="wikitable" style="font-size: 0.9em; width: 100%; margin-top: 0;">
	<tr><th>Description</th><th>Code</th></tr>		<tr><th>Description</th><th>Code</th></tr>
	<tr><td>Bag</td><td>BAG</td></tr>		<tr><td>Bag</td><td>BAG</td></tr>
Line 167:		Line 167:
	</table>		</table>
	</div>		</div>
	<div>		<div style="flex: 1; min-width: 250px;">
	<table class="wikitable" style="font-size: 0.9em; width: 100%;">		<table class="wikitable" style="font-size: 0.9em; width: 100%; margin-top: 0;">
	<tr><th>Description</th><th>Code</th></tr>		<tr><th>Description</th><th>Code</th></tr>
	<tr><td>Envelope</td><td>ENV</td></tr>		<tr><td>Envelope</td><td>ENV</td></tr>

Admin at 18:39, 9 February 2026

2026-02-09T18:39:09Z

← Older revision		Revision as of 14:39, 9 February 2026
Line 223:		Line 223:
	</div>		</div>
	<div style="text-align: center;">		<div style="text-align: center;">
	[[File:Link-shipments-to-trip-field.png\|thumb\|center\|Linking Shipments to a Master Trip]]		[[File:Link-shipments-to-trip-field.png\|thumb\|center\|800px\|Linking Shipments to a Master Trip]]
	</div>		</div>
	</div>		</div>

Admin at 18:38, 9 February 2026

2026-02-09T18:38:42Z

← Older revision		Revision as of 14:38, 9 February 2026
Line 103:		Line 103:
	* <em>Note: If you do not see this button, ensure you completed Step 1 to enable import buttons in Company Settings.</em>		* <em>Note: If you do not see this button, ensure you completed Step 1 to enable import buttons in Company Settings.</em>
	</div>		</div>
	[[File:Ace-upload-shipments.png\|thumb\|center\|The Import Shipments interface in BorderConnect]]		[[File:Ace-upload-shipments.png\|thumb\|center\|800px\|The Import Shipments interface in BorderConnect]]

	<h3>3. Upload and Process</h3>		<h3>3. Upload and Process</h3>

Admin at 19:47, 5 February 2026

2026-02-05T19:47:34Z

@@ Line 57: / Line 57: @@
 </div>
-<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 3: Field Specifications</h2>
+<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 3: Prepare Your Data</h2>
 <div class="bc-card">
@@ Line 82: / Line 82: @@
 * <strong>Value:</strong> Numeric only. No dollar signs (e.g., <code>1500.50</code>).
 * <strong>Weight:</strong> Whole numbers only (round up).
 </div>
 </div>

Admin at 19:45, 5 February 2026

2026-02-05T19:45:27Z

Show changes

Admin: Undo revision 2960 by Admin (talk)

2026-02-05T19:43:43Z

Undo revision 2960 by Admin (talk)

Show changes

Admin at 19:42, 5 February 2026

2026-02-05T19:42:47Z

Show changes

Admin at 19:14, 28 January 2026

2026-01-28T19:14:24Z

← Older revision		Revision as of 15:14, 28 January 2026
Line 3:		Line 3:
	{{#ev:youtube\|bWwYYqaVZ0k\|960\|center\|How to import shipments into an ACE eManifest}}		{{#ev:youtube\|bWwYYqaVZ0k\|960\|center\|How to import shipments into an ACE eManifest}}

	[[File:Company-pref.jpg\|thumb\|360px\|right\|Selecting ~~'''~~Company Settings~~'''~~ from the Account menu]]		[[File:Company-pref.jpg\|thumb\|360px\|right\|Selecting Company Settings from the Account menu]]

	This guide explains how to import a large number of shipments into an [[ACE_Manifest_Software_User_Guide_(CBP)\|ACE eManifest]] using BorderConnect’s CSV upload feature.		This guide explains how to import a large number of shipments into an [[ACE_Manifest_Software_User_Guide_(CBP)\|ACE eManifest]] using BorderConnect’s CSV upload feature.

	~~This feature is ideal when you have~~ many shipments ~~on one trip and want to avoid entering each shipment manually~~.		BorderConnect also offers a newer, more user-friendly option called the '''[[Import_Wizard_(ACE_and_ACI_eManifest)\|File Import Wizard]]''', which provides a guided import experience in one place. The Import Wizard supports multiple file types (including CSV and Excel formats) and can import many types of data used throughout ACE and ACI eManifests, such as shippers, consignees, vehicles, trailers, drivers, passengers, and shipments.

	=~~= Overview ==~~		{\| class="wikitable"
			! Option
			! Best For
			! File Types
			\|-
			\| [[Import_Wizard_(ACE_and_ACI_eManifest)\|File Import Wizard]]
			\| Most imports and ongoing data maintenance (profiles and shipments)
			\| CSV, XLSX, XLS, XML, Numbers
			\|-
			\| CSV Upload on ACE eManifest
			\| Quick, trip-specific bulk shipment upload directly into one ACE manifest
			\| CSV
			\|}

	~~Using a BorderConnect CSV template, you can~~:		== Step 1: Enable Import Buttons ==

	* Upload shipments in bulk into a new or existing ACE eManifest		By default, some companies have import buttons disabled.
	* Automatically validate shipment data before it is saved
	* Resolve common formatting issues using clear import ~~error messages~~

	~~== Step 1~~: ~~Enable ACE Import Buttons ==~~		To enable imports:

	~~[[File:Display-ace-import.png\|thumb\|360px\|right\|Enabling ACE import buttons in Company Settings]]~~		# Go to '''Account'''

	~~By default, shipment import buttons are disabled for many companies.~~

	~~To enable them:~~

	# Go to '''Account''' ~~on the top menu~~
	# Click '''Company Settings'''		# Click '''Company Settings'''
	# ~~Scroll to~~ '''eManifest Preferences'''		# Under '''eManifest Preferences''', set '''Display ACE Import Buttons''' to '''Yes'''
	~~# Set~~ '''Display ACE Import Buttons''' to '''Yes'''
	# Click '''Save'''		# Click '''Save'''

	Once enabled, import controls will appear when creating or editing an ACE eManifest.		Once enabled, the import controls will appear when creating or editing an ACE eManifest.

	== Step 2: Download the CSV Template ==		== Step 2: Download the CSV Template ==

	Before uploading, download the official ~~BorderConnect~~ template ~~file~~:		Before uploading, download the official template:

	* [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv ACE Shipment CSV Template]		* [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv ACE Shipment CSV Template]
Line 56:		Line 59:
	== Field Specifications ==		== Field Specifications ==

	Use the sections below to confirm ~~data~~ formatting before uploading.		Use the sections below to confirm formatting before uploading.

	=== SCN (Shipment Control Number) ===		=== SCN (Shipment Control Number) ===
Line 95:		Line 98:
	=== Shipment Type ===		=== Shipment Type ===

	Only the values below are valid and ~~are~~ case sensitive.		Only the values below are valid and case sensitive.

	{\| class="wikitable"		{\| class="wikitable"
			\|-
	! Shipment Type		! Shipment Type
	! Value		! Value
Line 129:		Line 133:

	=== Shipper and Consignee ===		=== Shipper and Consignee ===

	~~Use the following limits and formatting.~~

	{\| class="wikitable"		{\| class="wikitable"
Line 327:		Line 329:

	# Start a new ACE eManifest or open an existing one for editing		# Start a new ACE eManifest or open an existing one for editing
	~~# Use the import control near the top of the manifest page~~
	# Click '''Choose File''' and select your CSV		# Click '''Choose File''' and select your CSV
	# Click '''Save'''		# Click '''Save'''
Line 355:		Line 356:
	\|-		\|-
	\| 1		\| 1
	\| Create the original manifest, import the first batch, ~~save~~ and ~~view trip details~~		\| Create the original manifest, import the first batch, then Save and View Trip Details
	\|-		\|-
	\| 2		\| 2
	\| Create a second manifest ~~with~~ a modified trip number (example: add B)		\| Create a second manifest using a modified trip number (example: add B)
	\|-		\|-
	\| 3		\| 3
Line 373:		Line 374:
	\|-		\|-
	\| 7		\| 7
	\| Send each linked manifest to CBP using '''Link Shipments to Trip''' transmission		\| Send each linked manifest to CBP using the '''Link Shipments to Trip''' transmission
	\|}		\|}

Line 428:		Line 429:

	Fix:		Fix:
	* Use the valid value exactly~~, such~~ as ~~'''SECTION_321''' if applicable for your template version, or match~~ the ~~official list shown above~~		* Use the valid value exactly as specified in the Shipment Type table

	=== Shipper Errors ===		=== Shipper Errors ===
Line 453:		Line 454:

	Fix:		Fix:
	* Ensure valid Canadian postal code format~~, example: V5S 1A1~~		* Ensure valid Canadian postal code format

	=== Consignee Errors ===		=== Consignee Errors ===
Line 484:		Line 485:

	Fix:		Fix:
	* Package codes must match exactly, example: ~~'''~~BOX~~'''~~		* Package codes must match exactly, example: BOX

	<pre style="white-space: pre-wrap; word-wrap: break-word;">		<pre style="white-space: pre-wrap; word-wrap: break-word;">

Admin at 16:59, 28 January 2026

2026-01-28T16:59:11Z

Show changes

Admin at 17:30, 4 September 2025

2025-09-04T17:30:33Z

← Older revision		Revision as of 13:30, 4 September 2025
Line 3:		Line 3:
	{{#ev:youtube\|bWwYYqaVZ0k\|960\|center\|How to import shipments into an ACE eManifest.}}		{{#ev:youtube\|bWwYYqaVZ0k\|960\|center\|How to import shipments into an ACE eManifest.}}

	[[File:Company-pref.jpg\|thumb\|360px\|right\|Selecting Company Settings from the Account menu]]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.~~		[[File:Company-pref.jpg\|thumb\|360px\|right\|Selecting Company Settings from the Account menu]]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.

	== Enabling Import Buttons ==		== Enabling Import Buttons ==

Line 34:		Line 33:
	*Only the coded values listed in the table below can be used in this field.		*Only the coded values listed in the table below can be used in this field.

	Below are the valid Shipment Type values~~. E.g. for a Section 321 shipment, the value SECTION_321 must be entered~~.<br>		Below are the valid Shipment Type values.<br>
	(Please note that the shipment type values are '''case sensitive''', and the upload will fail if it is not entered ''exactly'' as specified below.)		(Please note that the shipment type values are '''case sensitive''', and the upload will fail if it is not entered ''exactly'' as specified below.)

Line 44:		Line 43:
	\| PAPS		\| PAPS
	\| PAPS		\| PAPS
	\|-
	~~\| Section 321~~
	~~\| SECTION_321~~
	\|-
	~~\| Section 321 with FDA Considerations~~
	~~\| SECTION_321_FDA~~
	\|-		\|-
	\| QP In-Bond		\| QP In-Bond
Line 140:		Line 133:
	*The value of the commodity, in U.S. Dollars.		*The value of the commodity, in U.S. Dollars.
	*'''Numeric only''', with one decimal allowed. Must not include dollar sign, commas, etc.		*'''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.		*System will round to nearest whole number, or up to 1 if less than 1 before transmitting to customs.

Line 295:		Line 286:
	<u>Country of Origin</u>:		<u>Country of Origin</u>:
	*The country in which the commodity was manufactured, grown or otherwise produced.		*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.		*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].		*The full list of acceptable country codes can be [https://www.borderconnect.com/data/countries.json downloaded here].
Line 311:		Line 301:
	== Importing 10,000 Or More Shipments To a Single ACE Manifest ==		== Importing 10,000 Or More Shipments To a Single ACE Manifest ==

	{{#ev:youtube\|LfbA8W-R9S0\|360\|right\|Importing 10,000 or more shipments into an ACE Manifest}}By default users can only upload 9999 shipments into a single ACE Manifest, which is enough for most users who wish to import ~~Section 321~~ shipments into an ACE for example. However, in some cases more shipments will need to be added to a single ACE Manifest.		{{#ev:youtube\|LfbA8W-R9S0\|360\|right\|Importing 10,000 or more shipments into an ACE Manifest}}By default users can only upload 9999 shipments into a single ACE Manifest, which is enough for most users who wish to import shipments into an ACE for example. However, in some cases more shipments will need to be added to a single ACE Manifest.

	Importing 10,000 or more shipments into a single ACE Manifest involves creating multiple ACE Manifests and importing no more than 9999 shipments into each separate ACE Manifest, then moving the imported shipments from the second (or third) ACE manifest, back to the original manifest using the Link Shipments to Trip feature.		Importing 10,000 or more shipments into a single ACE Manifest involves creating multiple ACE Manifests and importing no more than 9999 shipments into each separate ACE Manifest, then moving the imported shipments from the second (or third) ACE manifest, back to the original manifest using the Link Shipments to Trip feature.
Line 332:		Line 322:

	[[File:Send-link-shipments-to-trip.jpg\|300px]]		[[File:Send-link-shipments-to-trip.jpg\|300px]]

	If these ACE Manifests only contain Section 321 shipments no entry numbers will be provided and three blue bars is the status that will remain on the ACE Manifests until the driver arrives at the border. It’s also important to note that CBP will see all of the shipments on the original ACE Manifest that we created, so be sure to show the driver lead sheet for the original trip only when arriving at the border.

	== Common Import Errors ==		== Common Import Errors ==