Vendor Import – Error 1048: deleted_flag_timestamp cannot be null on all new vendor creation

Get Help & Support Software Bugs / Issues
1

URL: Admin → Import Data → Vendors

Issue: When importing a vendor CSV into an empty system (all rows are new records), every row fails with:
Error 1048: Column 'deleted_flag_timestamp' cannot be null

The import tool works for UPDATE (existing records) but cannot INSERT new vendor records. The deleted_flag_timestampcolumn is not included in the official vendor import template, yet the database has a NOT NULL constraint on it that the importer fails to satisfy when creating new rows.

Tried:

  • With and without “Update Related Data” checked
  • Adding deleted_flag_timestamp to the CSV with ISO 8601 timestamp (2026-06-25T22:09:16-05:00)
  • Removing the column entirely

None work. The system is currently empty and we cannot populate our vendor list at all.

Expected: Import should be able to create new vendor records.

2

@Nevil

Hey Nevil,

Switch off the new version of the data import page - there’s an issue where that flag is being considered during the import process if you’re using the new version.

Switch over to the old version of the data import tool and run the process - it should push through without issue. We’ll work to get that new version issue resolved, but in the meantime focus on the old version of the data import process.

Thanks!

Cetec ERP Support