Acenda allows you to update order fulfillment details—including tracking numbers—by importing a properly formatted CSV file. This guide walks you through preparing your file and uploading it using the Fulfillment Tracking import type.
Overview
The Fulfillment Tracking import is designed to update your orders with shipping information such as 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 CSV file are required. Please ensure that these fields are present and correctly formatted.
Preparing Your CSV File
Before you begin the upload process, ensure your CSV file meets the following requirements:
1. File Format:
• The file must be saved as a CSV file encoded in UTF-8.
• Ensure there are no extraneous characters or formatting issues that might prevent a successful import.
2. Supported Columns:
Your CSV file should include the following columns:
Column Name | Requirement | Description & Example |
external_order_id | Required | The marketplace-generated order number. Example: 112-2718387-2593993 |
warehouse_id | Optional | The warehouse identifier. Find this value on the Admin > Warehouses page (reference the ID column). Example: 1 |
carrier | Required | The shipping carrier used. Example: UPS or FedEx |
method | Optional | The shipping method (e.g., Ground). |
tracking_number | Required | The tracking number provided by the carrier. Example: 1Z123214324325002 |
sku | Required | The SKU value found in the order. Example: ELAS7827AZ-H34-2 |
quantity | Required | The quantity of the item being fulfilled. Example: 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 fulfillment tracking file:
1. Log In to Your Acenda Admin Panel:
• Access your Acenda dashboard using your administrator credentials.
2. Navigate to the Import Section:
• From the admin sidebar, select the Imports option.
• Choose the Fulfillment Tracking import type from the list of available import options.
3. Upload Your CSV File:
• Click the Select File button.
• Browse your computer for the CSV file that you prepared (ensure it is saved in CSV UTF-8 format).
• Select the file and confirm your choice.
4. Review & Confirm:
• Once the file is selected, review the import summary to verify that the correct file and import type are chosen.
• Click Import to start the process.
5. Processing the File:
• Acenda will process the file and update the order details based on the information provided.
• You will receive a confirmation message once the import is complete.
Verifying Your Import
After your file has been processed, it’s a good idea to verify that the fulfillment and tracking information has been correctly applied:
• Check Order Details:
Navigate to an order that was included in your import and confirm that the carrier, tracking number, and any other updated fields display as expected.
• Review Import Logs:
If available, review the import logs or notifications for any errors or warnings that might require attention.
Troubleshooting
If you encounter issues during the import process, consider the following troubleshooting steps:
• CSV Formatting Errors:
• Ensure that your file is encoded in UTF-8 and does not contain any formatting issues.
• Verify that all required columns are present and populated with valid data.
• Data Mismatch:
• Double-check that the external_order_id in your CSV exactly matches the order numbers in your Acenda system.
• Confirm that the warehouse_id corresponds to an existing warehouse in your Acenda admin.
• Import Errors:
• Review any error messages provided after the import. These messages can help pinpoint missing or incorrectly formatted data.
• If the issue persists, contact Acenda Support with your CSV file and error details for further assistance.