Important

You are browsing the documentation for version 1.6 of OroCommerce, OroCRM and OroPlatform, which is no longer maintained. Read version 5.1 (the latest LTS version) of the Oro documentation to get up-to-date information.

See our Release Process documentation for more information on the currently supported and upcoming releases.

Available in OroCRM Available in OroCommerce

Export Records

You might need to export the necessary information and download it as a .csv file to reuse it in the third-party systems. You can export customer data (accounts, contacts, customers, customer users, business customers), sales data (leads, opportunities, prices in the price list, products), taxes (rates, rules), warehouse, and inventory information (inventory levels and statuses).

Another scenario for using export is when you plan bulk data update that is easily automated in the spreadsheet software (e.g., raise the price by 20%).

To export the necessary records (e.g., customer information) in a .csv format:

  1. In the main menu, navigate to menu item to export the list of the necessary data (e.g., Customers > Customers).

    The following screen opens.

    ../../../../../_images/export_1.png
  2. Click Export on the top right.

  3. Once export is complete, you will receive an email to download the .csv file.

Note

Keep in mind that by clicking Export you download all records of the selected entity regardless of the filters applied to the grid. To export only the list of filtered records, use the Export Grid functionality where it is available.

Highlight the Export Grid button