After July 2021, the 2.3.x release line no longer received quality updates or user guide updates. PHP 7.3 reached end of support in December 2021, and Adobe Commerce 2.3.x reached end of support in September 2022. We strongly recommend upgrading to Adobe Commerce 2.4.x to help maintain PCI compliance.

Export

This site contains archived merchant documentation for a version of Adobe Commerce and Magento Open Source that has reached end-of-support. The documentation available here is intended for historical reference only and is not maintained. The Adobe Commerce Merchant Documentation for current releases is published on the Adobe Experience League.

The best way to become familiar with the structure of your database is to export the data and open it in a spreadsheet. Once you become familiar with the process, you’ll find that it is an efficient way to manage large amounts of information.

Special characters—such as the equal sign, greater and less than symbols, single and double quotes, backslash, pipe, and ampersand symbols—can cause problems during data transfer. To ensure that such special characters are correctly interpreted, they can be marked as an “escape sequence.” For example, if the data includes a string of text such as code=”str”, code=”str2”, choosing to enclose the text in double quotes ensures that the original double quotes are understood to be part of the data. When the system encounters a double set of double quotes, it understands that the outer set of double quotes is enclosing the actual data.

Data export is an asynchronous operation, which executes in the background so that you can continue working in the Admin without waiting for the operation to finish. The system displays a message when the task is complete.

Export Data

  1. On the Admin sidebar, go to System > Data Transfer > Export.

  2. In the Export Settings section, set Entity Type to one of the following:

    • Products
    • Customers Main File
    • Customer Addresses

  3. Accept the default Export File Format of CSV.

  4. If you want to enclose any special characters that might be found in the data as an escape sequence, select the Fields Enclosure checkbox.

    Data export settings Export Settings

  5. If needed, change the display of the entity attributes.

    By default, the Entity Attributes section lists all the available attributes in alphabetical order. You can use the standard list controls to search for specific attributes and to sort the list. The Search and Reset Filter controls control the display of the list, but have no effect on the selection of attributes to be included in the export file.

    Data export filtered entity attributes Filtered Entity Attributes

  6. To filter the exported data based on attribute value, do the following:

    • To export only records with specific attribute values, enter the required value in the Filter column. The following example exports only a specific SKU.

      Data export - product based on SKU Export Product Based on SKU

    • To omit an attribute from the export, select the Exclude checkbox at the beginning of the row. For example, to export only the sku and image columns, select the checkbox of every other attribute. The column appears in the export file, but without any values.

      Data export - exclude attributes Exclude Attributes

  7. Scroll down and click Continue in the lower-right corner of the page.

  8. Upon completion of the task, look for the file in the download location for your web browser.

    You can save or open the exported CSV file as a spreadsheet, then edit the data and import it back into your store.

© 2024 Adobe. All rights reserved.