· DataEase · Tutorials · 2 min read
Bulk Hide or Delete Products Without Images
Quickly find products that have no images and either hide them (status = DRAFT) or delete them in bulk.
Steps:
1. Export all products with media
In DataEase → New Export → Products. Include at least: id, handle, status, and the Media field. Enable the option “Group product media into single rows”. Run the export and download the file.
2. Prepare the file in Excel
Keep only products without images: filter the Media column to blanks (or delete all rows where Media is not empty), leaving rows with empty Media only.
3. Choose your action
- Hide: set command = UPDATE and status = DRAFT for the remaining rows.
- Delete: set command = DELETE (id required) for the remaining rows.
4. Import & validate
In DataEase, create a New Import, upload the edited file, map columns, and run Validation. Review the “Validation Status” column and fix issues if needed.
5. Run the import
In DataEase, create a New Import, upload the edited file, map columns, and run Validation. Review the “Validation Status” column and fix issues if needed.
Tips
- Deleting is irreversible—prefer DRAFT if you might need the products later.
- Matching: prefer Product ID; use handle only if ID is missing.
- ARCHIVED is another option (keeps the product in admin but not necessarily visible).
Minimal CSV (example) / Hide (set to DRAFT)
| id | command | status |
|---|---|---|
| 123 | UPDATE | DRAFT |
Minimal CSV (example) / Delete (remove products)
| id | command |
|---|---|
| 456 | DELETE |