CSV Import

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
1	UPS	1Z6E36W60390858267	12-06-2025	1
2	USPS	9200190244541430003	12-06-2025	1

📌 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
119	USPS	9200190244541430003	12-06-2025	2	t-shirt	2
119	USPS	9200190244541445651	12-06-2025	1	blue-jeans	2

▶️ Format 2: Split Entries by Item

order_id	tracking_provider	tracking_number	date_shipped	status_shipped	sku	qty
119	USPS	9200190244541430003	12-06-2025	2	t-shirt	1
119	USPS	9200190244541430003	12-06-2025	2	blue-jeans	1
119	USPS	9200190244541445651	12-06-2025	1	t-shirt	1
119	USPS	9200190244541445651	12-06-2025	1	blue-jeans	1

🧾 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.

📥 Download Sample Files

📄 Download Basic CSV Sample

📄 Download Tracking Per-Item CSV Sample