Adobe Commerce status column missing exported products CSV file

This article provides a solution for the issue when you cannot locate the status column (i.e., indicating whether the product is enabled or disabled) in the CSV file containing exported products. The status of the product is indicated by the product_online column.

Affected products and versions

Adobe Commerce (all deployment methods) all supported versions

Issue

You are unable to locate the status column in the CSV file containing exported products. So, for example, you export a CSV of all SKUs, with their status, but the table appears to be missing the status column.

Steps to reproduce:

  1. In the Adobe Commerce Admin, select System, under Data Transfer select Export.
  2. In the Export Settings section, select on the Entity Type drop down Products.
  3. Search for status, listed under Attribute Code. You see that attribute code in the list of available attributes (Enable Product).
  4. Click on Export.

Expected result:

In the CSV file that you just exported, you see a column labeled status.

Actual result:

You do not see a column labeled status in the exported csv file.

Cause

The product’s status attribute has been renamed in the CSV file. It is now the product_online column.

Solution

  1. Select System, under Data Transfer select Import.
  2. Click Download Sample File.
  3. You can see the product_online column in the CSV file.
recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a