Grid Controls

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 Orders Grid

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.

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.

    Grid display - page controls Next and previous

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 Filter controls

Export data

  1. Select the records that you want to export.

    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 Export Control

  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. By default, only nine of twenty available columns are visible in the grid.

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 you want to add to the grid.
    • Clear the checkbox of any column you want to remove from the grid.
    • Click Reset to return the default grid view.

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. Click the arrow (Save all changes) to 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.