Magento Commerce, 2.0.11

Magento 2.0.18 is the final 2.0.x release. After March 2018, Magento 2.0.x will no longer receive security patches, quality fixes, or documentation updates. To maintain your site's performance, security, and PCIPayment Card Industry: Refers to debit and credit cards and their associated businesses. compliance, upgrade to the latest version of Magento.

Export

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.

To export data:

1. On the AdminThe password-protected back office of your store where orders, catalog, content, and configurations are managed. sidebarThe right or left column of a two-column page layout., tap System. Then under  Data Transfer, choose Export.
2. In the Export Settings section, specify the following:
a. Set Entity Type to one of the following:
  • Products
  • Customers Main File
  • Customer Addresses
b. Accept the default Export File Format of “CSVComma Separated Values: A type of file used to store data values which are separated from each other by commas..”

Export Settings
3. 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.

Filtered Entity Attributes
4. To filter the exported data based on attributeA characteristic or property of a product; anything that describes a product. Examples of product attributes include color, size, weight, and price. value, do the following:
5. Scroll down and tap  Continue  in the lower-right corner of the page.

Look for the download prompt in the lower-right corner of your browser. The exported CSV file can be saved or opened in a spreadsheet. You can edit the data and import it back into your store.