1. On the Admin sidebar, go to System, Data Transfer, and Export.
2. In the Export Settings section, set Entity Type to one of the following:
Advanced Pricing
Products
Customer Finances
Customers Main File
Customer Addresses
Stock Sources
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.
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.
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.
To omit an attribute from the export, select the Exclude checkbox at the beginning of the row. For example, to export only the
skuandimagecolumns, select the checkbox of every other attribute. The column appears in the export file, but without any values.
7. Scroll down and click Continue in the lower-right corner of the page.
Upon completion of the task, the file is processed through a message queue (make sure that your cron job is running). The exported file is saved in the var/export/ folder.