Acenda allows you to bulk import order fulfillment details—including tracking numbers—by uploading a properly formatted spreadsheet. While Microsoft Excel (XLS or XLSX) is the preferred format, CSV files encoded in UTF-8 are also accepted. This guide walks you through preparing your file and uploading it using the Fulfillment Tracking import type.
Overview
The Fulfillment Tracking import updates your orders with shipping information, including the carrier, tracking number, and more. Once your file is uploaded, Acenda processes the data and automatically applies the updates to the respective orders.
Note: Certain fields in your file are required. Please ensure these fields are present and correctly formatted to avoid import errors.
Preparing Your File
Before you begin the upload process, ensure your file meets the following requirements:
1. File Format
Preferred Format: Microsoft Excel (XLS or XLSX).
Alternative Format: CSV (Comma Separated Values) encoded in UTF-8.
Max File Size: 10MB.
Max Record Count: 1,000 records per import.
Cleaning: Ensure there are no extraneous characters, hidden formulas, or formatting issues.
2. Supported Columns
Your spreadsheet should include the following columns:
Column Name | Requirement | Description & Example |
external_order_id | Required | The marketplace-generated order number. (e.g., 112-2718387-2593993) |
warehouse_id | Optional | The warehouse identifier found under Admin > Warehouses. (e.g., 1) |
carrier | Required | The shipping carrier used. (e.g., UPS or FedEx) |
method | Optional | The shipping method. (e.g., Ground) |
tracking_number | Required | The tracking number provided by the carrier. (e.g., 1Z123214324325002) |
sku | Required | The SKU value found in the order. (e.g., ELAS7827AZ-H34-2) |
quantity | Required | The quantity of the item being fulfilled. (e.g., 1) |
cost | Optional | The shipping cost for the order. |
Note: Each row should contain only one tracking number. If you have multiple items with the same tracking number, list each on a separate row.
Importing Your Fulfillment Tracking Feed
Follow these steps to upload your file:
Log In to Your Acenda Admin Panel: Access your dashboard using your administrator credentials.
Navigate to the Import Section: From the admin sidebar, select Imports, then choose Fulfillment Tracking from the list of available import types.
Upload Your File:
Click the Select File button.
Browse your computer for your file (XLS/XLSX preferred).
Select the file and confirm your choice.
Review & Confirm: Verify that the correct file and import type are displayed in the summary. Click Import to start the process.
Processing: Acenda will process the data and update the order details. You will receive a confirmation message once the import is complete.
Verifying Your Import
After processing, it is best practice to verify the data:
Check Order Details: Navigate to a specific order included in your import. Confirm that the carrier, tracking number, and other fields display correctly.
Review Import Logs: Check the import logs or notifications for any specific warnings or errors that may have occurred during the process.
Troubleshooting
Formatting Errors: Ensure your file is an XLS/XLSX or a UTF-8 encoded CSV. Verify that all required column headers are spelled correctly.
Data Mismatch: Double-check that the
external_order_idmatches your Acenda system exactly. Ensure thewarehouse_idcorresponds to an existing ID in your Admin settings.Import Errors: Review the specific error messages provided after the attempt. If you cannot resolve the issue, contact Acenda Support with your file and the error details.