· DataEase · Tutorials · 1 min read
Bulk Update Product Status
Change the status of many products at once by updating the status field to ACTIVE, DRAFT, or ARCHIVED via CSV/Excel and DataEase.
Steps:
1. Export Products
In DataEase, create a New Export → Products. Include at least: id, handle, status. Use filters (tag, vendor, collection, status) to target the right items.
2. Edit the file
For rows to change, set command = UPDATE and set status to one of: ACTIVE, DRAFT, ARCHIVED. Save the file.
3. Import & validate
In DataEase, create a New Import, upload the file, map columns, and run Validation. Review the “Validation Status” column and fix any issues.
4. Verify
After completion, download the result file and spot-check products in the admin/storefront.
Tips
- Matching: prefer Product ID; use handle only if ID is missing.
- Meanings: ACTIVE = for sale and visible (subject to channel/publication settings); DRAFT = hidden; ARCHIVED = stored away.
- Publication per channel/market is separate—changing status doesn’t set channel publication.
Minimal CSV (example)
| id | command | status |
|---|---|---|
| 123 | UPDATE | ACTIVE |
| 456 | UPDATE | DRAFT |
| 789 | UPDATE | ARCHIVED |