Exported products .csv file does not appear

This article provides a fix for the issue where you try to export products to a .csv file in the Commerce Admin, but the file does not appear.

Affected products and versions

• Adobe Commerce on cloud infrastructure, all supported versions.

Issue

Steps to reproduce

Prerequisites: The Add Secret Key to URLs option is set to Yes. The option is configured in the Commerce Admin under Stores > Configuration > Advanced > Admin > Security.

1. In the Admin, navigate to System > Data Transfer > Export.

   

2. Select

   • Entity Type: Products
   • Export File Format: CSV
   • Field Enclosure: leave unchecked.

3. Click Continue.

4. The following message is displayed: “Message is added to queue, wait to get your file soon”.

Expected result

The .csv file with the exported products is displayed in the grid in a couple of minutes.

Actual result

The .csv file with the exported products is not displayed in the grid in 10 minutes or more.

Cause

A known issue with the Export functionality in the Adobe Commerce application part version 2.3.2.

Solution

There are two possible solutions for the issue:

• Disable the Add Secret Key to URL option.
• Run the bin/magento queue:consumers:start exportProcessor command manually, and optionally configure it to be run by cron.

See details for both options in the following paragraphs.

Disable the Add Secret Key to URL option

1. In the Admin, navigate to Stores > Configuration > Advanced > Admin > Security.
2. Set the Add Secret Key to URLs option to No.
3. Click Save Config.
4. Clean cache under System > Tools > Cache Management or by running bash bin/magento cache:clean or in the Admin.

Run the export command manually and optionally add it as cron job

To get the export file, run the bin/magento queue:consumers:start exportProcessor command. After running this, the file should be displayed in the grid.

To add the process as a cron job optionally, you must add the CRON_CONSUMERS variable to the .magento.env.yaml file.

Add process as a cron job (optional)

1. Make sure your cron is setup and configured. See Set up cron jobs for details.

2. Run the following command to return a list of message queue consumers: ./bin/magento queue:consumers:list

3. Add the following to your .magento.env.yaml file in the Magento /app directory, and include the consumers you would like to add. For example, here is the consumer required for export processing:

   stage:
       deploy:
           CRON_CONSUMERS_RUNNER:
               cron_run: true
               max_messages: 1000
               consumers:
                   - exportProcessor
   

   Then push this updated file and redeploy your environment. Also reference Add custom cron jobs to your project in our developer documentation.