· 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)

idcommandstatus
123UPDATEACTIVE
456UPDATEDRAFT
789UPDATEARCHIVED

References