DocumentationCommerceGetting Started

Admin grid controls

Last update: Mon Mar 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • Leader
  • User

Admin pages that manage data display a collection of records in a grid. The controls at the top of each column can be used to sort the data. The current sort order is indicated by an ascending or descending arrow in the column header. You can specify which columns appear in the grid, and drag them into different positions. You can also save different column arrangements as views that can be used later. The Action column lists operations that can be applied to an individual record. In addition, date from the current view of most grids can be exported to a CSV or XML file.

Orders page - grid display

Sort the list

  1. Click any column header.

    The arrow indicates the current order as either ascending or descending.

  2. Use the pagination controls to view additional pages in the collection.

    Grid display - page controls {width="300"}

Paginate the list

  1. Set the Pagination control to the number of records that you want to view per page.

  2. Click Next and Previous to page through the list, or enter a specific Page Number.

Filter the list

  1. Click Filters.

  2. Complete as many filters as necessary to describe the record you want to find.

  3. Click Apply Filters.

    Orders list - filter controls {width="700" modal="regular"}

Export data

  1. Select the records that you want to export.

    note note
    NOTE
    Product data cannot be exported from the grid. To learn more, see Export.

  2. On the Export ( Menu selector ) menu in the upper-right corner, choose one of the following file formats:

    • CSV
    • Excel XML

    Orders list - export options {width="700" modal="regular"}

  3. Click Export.

  4. Look for the downloaded file of exported data at the location used for downloads by your browser.

Grid Layout

The selection of columns and their order in the grid can be changed according to your preference, and saved as a view. You can control which attributes show in the grid under the individual attribute configuration. Having many attributes displayed in the product grid may affect admin load time and performance.

Order Grid Columns

Change the selection of columns

  1. In the upper-right corner, click the Columns ( Columns control ) control.

  2. Change the column selections:

    • Select the checkbox of any column that you want to add to the grid.
    • Clear the checkbox of any column that you want to remove from the grid.
    • To return the default grid view, click Reset.

Make sure to scroll down to see all available columns.

Move a column

  1. Click the header of the column and hold.

  2. Drag the column to the new position and release.

Save a grid view

  1. Click the View ( View control ) control.

  2. Click Save Current View.

  3. Enter a name for the view.

  4. To save all changes, click the Arrow ( Save all changes ).

    The name of the view now appears as the current view.

Change the grid view

  1. Click the View ( View icon ) control.

  2. Do one of the following:

    • To use a different view, click the name of the view.
    • To change the name of a view, click the Edit ( Edit icon ) icon and update the name.
    • To delete a view, click the Edit ( Edit icon ) icon and then click the Delete ( Delete icon ) icon.
recommendation-more-help
31746fd0-1ead-45b5-9192-1aaf582c5f66