The CSV Import feature allows you to bulk upload tracking information for orders in your WooCommerce store using a properly formatted .csv file. This is ideal when fulfilling multiple orders at once or when using third-party shipping systems to export tracking data.
🔧 Step-by-Step Import Process
1. Upload CSV File
To begin, go to:
WooCommerce > Shipment Tracking > CSV Import
Upload your file and configure import options:
- Upload a CSV file – Choose your .csv file from your local computer.
- Choose the Shipped Date format – Select between the two supported formats:
DD-MM-YYYY
MM-DD-YYYY
- 📌 The selected date format must match the format used in your CSV file.
- Replace tracking information? – Check this box if you want to replace any existing tracking numbers for the order.
2. Import in Progress
Once you upload and continue, the import process begins and progress is shown live.
- ✅ Success entries will show the order ID and confirmation.
- ❌ Errors (e.g., invalid carrier or order ID) will also be listed.
3. Import Completed
After the process completes, you’ll see a summary of all successful and failed entries.
📂 Sample CSV Format
Here is the expected structure of the CSV file:
| order_id | tracking_provider | tracking_number | date_shipped | status_shipped | shipping_note |
|---|---|---|---|---|---|
| 1 | UPS | 1Z6E36W60390858267 | 12-06-2025 | 1 | Order shipped via express service |
| 2 | USPS | 9200190244541430003 | 12-06-2025 | 1 | Final shipment for this order |
📌 Date Format must be in either:
- DD-MM-YYYY
- MM-DD-YYYY
- ⚠️ Make sure this matches the date format selected during the upload process.
📦 CSV Format for Tracking Per Item
If you want to assign tracking per order item, use the format below:
▶️ Format 1: Grouped by Item
| order_id | tracking_provider | tracking_number | date_shipped | status_shipped | sku | qty | shipping_note |
|---|---|---|---|---|---|---|---|
| 119 | USPS | 9200190244541430003 | 12-06-2025 | 2 | t-shirt | 2 | Partial shipment – remaining items will ship soon |
| 119 | USPS | 9200190244541445651 | 12-06-2025 | 1 | blue-jeans | 2 | Final shipment |
▶️ Format 2: Split Entries by Item
| order_id | tracking_provider | tracking_number | date_shipped | status_shipped | sku | qty | shipping_note |
|---|---|---|---|---|---|---|---|
| 119 | USPS | 9200190244541430003 | 12-06-2025 | 2 | t-shirt | 1 | Partial shipment |
| 119 | USPS | 9200190244541430003 | 12-06-2025 | 2 | blue-jeans | 1 | Partial shipment |
| 119 | USPS | 9200190244541445651 | 12-06-2025 | 1 | t-shirt | 1 | Final shipment |
| 119 | USPS | 9200190244541445651 | 12-06-2025 | 1 | blue-jeans | 1 | Final shipment |
🧾 CSV Field Descriptions
| Field | Description |
|---|---|
order_id | ID of the WooCommerce order. |
tracking_provider | Name of the shipping carrier (must match your enabled carriers). |
tracking_number | Tracking code from your shipping carrier. |
date_shipped | Date when the item was shipped (match selected format: DD-MM-YYYY or MM-DD-YYYY). |
status_shipped | 0 = Do not change order status, 1 = Mark as Shipped, 2 = Partially Shipped. |
sku (optional) | Product SKU to link tracking to specific order items. |
qty (optional) | Quantity of the SKU shipped with that tracking number. |
shipping_note (optional) | Customer-visible note shown with tracking details |