Update Shipments

Bulk update shipment records using CSV file import. Add tracking numbers, update dates, and modify shipment details.

Update multiple shipment records at once by uploading a CSV file. This is commonly used for adding tracking numbers, updating shipment dates, or modifying shipment status.

📘

Key Takeaways

  • Updates existing shipment records only
  • The Internal ID field is required to identify records
  • Only works on incomplete shipments
  • Ideal for bulk adding tracking numbers from fulfillment systems
  • Download the template to ensure correct column headers

Template

Download CSV Template


Required Fields

FieldDescription
Internal IDThe ID of the shipment to update

Include additional columns only for the fields you want to change.

⚠️

Important

Shipment import only works on incomplete shipments. Completed shipments cannot be modified via import.


Editable Fields

CSV HeaderDescriptionFormat
Internal IDRequired - Shipment IDInteger
Tracking NumberCarrier tracking numberText
Date ScheduledScheduled ship dateYYYY-MM-DD HH:MM:SS or ---- for empty
Date PostedDate posted to fulfillmentYYYY-MM-DD HH:MM:SS or ---- for empty
Date ShippedActual ship dateYYYY-MM-DD HH:MM:SS or ---- for empty
Date DeliverDelivery dateYYYY-MM-DD HH:MM:SS or ---- for empty
Date ReturnReturn dateYYYY-MM-DD HH:MM:SS or ---- for empty

To Update Shipments

  1. Navigate to Search > Shipments

  2. Click the Bulk Update button

  3. Download the template and fill in your data

  4. Upload your CSV file

  5. Click Preview to review the changes

  6. Click Looks Good Submit Now to apply updates


Common Use Case: Adding Tracking Numbers

To bulk add tracking numbers from your fulfillment system:

  1. Export shipments needing tracking from Vrio
  2. Match with tracking data from your fulfillment provider
  3. Create a CSV with Internal ID and Tracking Number columns
  4. Import to update all shipments at once
📘

Tip

When you add a tracking number via import, the shipment will be marked as shipped if it wasn't already. If a Date Shipped is provided, that date will be used; otherwise, the current date/time will be used.


FAQ

Q: How do I find shipment IDs?

A: Shipment IDs (Internal ID) are displayed in the Shipments search results and on individual shipment records.

Q: Will updating tracking trigger customer notifications?

A: If you have shipment notification responders configured on the campaign, they may be triggered when tracking information is added.

Q: Can I update shipments that have already been delivered?

A: No, only incomplete shipments can be updated via import.

Q: What date format should I use?

A: Use YYYY-MM-DD HH:MM:SS format (e.g., 2024-01-15 14:30:00). Use ---- to clear a date field.