Skip to main content
Administrator Guide
Last Updated: 2026-11-13
Bulk End Work Orders With File Upload

Bulk End Work Orders With File Upload

  • End reasons must exist.
  • You must have at least one of the following permissions:
    • workorder.end
    • workorder.owned.end
    • sow.workorder.end
You can end work orders in bulk using a CSV template upload. The
Bulk Update Work Orders with File
functionality enables you to flag work orders for termination and provide an effective end date and time, a time zone, an end reason, and comments in separate template columns.
  1. From the header, select
    More
    Bulk Updates
    .
  2. Click
    New Bulk Update
    .
  3. Click
    Bulk Update work Orders With File
    .
  4. (Optional) On the
    Select Records
    page, specify criteria for the records you want to update.
    By default, active work orders are selected.
  5. Under
    Update Type
    , select
    Take an Action
    .
  6. Select an
    Update Action
    of
    End Work Order
    .
  7. Click either:
    • Generate Template
      . VNDLY generates and downloads a comma-separated value (CSV) file where you can manually enter the work order IDs and field values for the work orders you want to update.
    • Export # records to file
      . VNDLY generates and downloads a CSV file that’s automatically populated with work order IDs, fields, and field values based on the records you selected. Example: In step 4, you choose to update work orders in the
      Active
      status. You have 111 work orders that meet this criteria, so we display the button as
      Export 111 records to file
      . When you click this button, VNDLY generates and downloads a template that includes the work order IDs for your 111 active work orders.
    As you populate the file, consider:
    • All columns except
      effective_end_datetime
      are required.
    • The
      end_now
      column must be Y or N.
    • If the
      end_now
      column is set to N, then the
      effective_end_datetime
      must be populated or the update shows an error message.
    • If the
      end_now
      column is Y, then you must entered the
      effective_end_timezone
      ,
      end_reason
      , and
      end_comments
      .
  8. Save the CSV file.
  9. On the
    Bulk Update With File
    page, click
    Next
    .
  10. Upload your CSV file.
  11. Click
    Next
    .
  12. Review the information and click
    Next
    .
  13. Preview the first 100 rows for errors.
    If there are errors, correct the CSV file. Save and upload it again.
    In the preview, you can click any work order row to display the before and after values of all the fields that VNDLY will update.
  14. Click
    Confirm Bulk Update
    .
  15. Click
    Confirm
    .