Get familiar with the product grid

Summary

Where is the product grid?

To access your products: click on the Products menu. You will land on the product grid.

This page contains all information you need to start working on your catalog: your products, your categories, some filters, your scopes and locales.

In the following sections, we will see how to set up your work environment.

Locale & channel context

Select a locale context

By default, you will find all your products on the product grid page. You can choose your working locale, if several locales have been activated. The locale selection will impact the following information on the page:

  • The category labels (on the left panel)
  • The attribute labels that can be used as filters (on the filters section in the left panel)
  • The labels of attribute groups
  • The attribute option labels used as values (on the product grid)
  • The completeness displayed (its percentage in the Complete grid column)
  • The product or attribute values in the product grid

The locale selected in the dropdown menu is your working locale. Every time it will be changed, product information will be updated in the product grid.

  1. The locales displayed are those added to at least one channel. If you do not see your working locale, it is more likely that you do not have the appropriate access rights to view or edit products for this working locale (Enterprise version). In this case, then please contact your administrator. Or the locale is not required by any channel, therefore it is not activated. To add a locale to a channel, please refer to “Manage channels” in the PIM Catalog Settings Guide
  2. The working locale selected on the product grid’s page is also applied when you edit or view a product form
  3. The working locale is different from the user interface locale of the user
 

Select a channel context

On the left side of the grid, you have a drop down menu to select your channel.

The selected channel or scope will be your working channel (or working scope). Selecting a channel impacts values displayed on the product grid, especially if your attribute information differ depending on the channel.

This will also impact the completeness displayed, since there can be one completeness percentage per channel/locale combination. Therefore the product grid is updated whenever the working channel changes.

The available channels are those concerned with the locale selected higher up on the page. If you don’t find your channel, it means the locale selected is not required for the channel you want, so it is not proposed. To add a locale to a channel, refer to “Manage channels” section in the PIM Catalog Settings Guide.

Like the locale, the channel selected on the product grid’s page is applied when editing a product form.

 

Product grid display

To highlight the products' images, a Gallery display of the product grid is available. This display can be used to quickly find products by their images and update them.

With the Gallery display, the following properties are displayed in the grid (you cannot choose them, there is no Columns button available):

  • Identifier for a product (attribute defined as product identifier) or code for a product model
  • Label: attribute used as "label" in the product family
  • Image: attribute used as "main picture" in the product family.
  • Completeness for a product
  • Number of complete variant products out of the number of variant products for a product model (ex: "2/3" means that 2 variants out of 3 for the product model are complete)

Other grid features also apply to this display (channel, locale and categories selection, filters, pagination, products selection, etc.).

 

To use the Gallery display:

  1. Click on List to change the display 
  2. Select the display Gallery 

The context of the chosen display for the product grid is kept.

 

Product grid pagination

The product grid displays 25 products per page. To browse product’s pages, click on the number of the page you want to reach.

The grid can display up to 400 pages (10000 results). However, you can use the filters in the grid, to optimize the results displayed.

 

Category panel

Browse products’ categories

On the left side of the page, you will see the category panel. Thanks to this panel, you can easily navigate between category trees or between categories. It displays all categories you have access to.

In the Enterprise Edition, you can define specific rights on categories and category trees, in order to define which user group can see, edit or own products of these categories or category trees. You may not see some specific trees or categories. It's a normal behavior: we hide the categories or category trees of products you don't have view permission on. Click on a category name to expand it or to display its products in the grid.

Click on the higher dropdown menu to select another category tree, Master Catalog in our screenshot above.

View unclassified products

Below the category tree, you will see an additional category: Unclassified products. Click on this category to see all unclassified products. this category is added automatically by the PIM and cannot be removed or edited.

Remember that unclassified products are not exported.

View all products

Click on All products to see all products (categorised and uncategorised) of the selected category tree.

Product counter

Akeneo displays you the number of products available in each category and category tree. You will see a number into brackets nearby each category, this figure represents the total number of products classified in this category or sub-category. In the Enterprise Edition, this figure represents the total number of products you are allowed to view and that are classified in this category or sub-category.

At the bottom of the category tree, you will see a Yes/No option: Include sub-categories.

This option takes into account the number of products classified in sub-categories. By default, this option is set to Yes, hence subcategories are included. If you do not want to take into account products classified in subcategories, select No. The tree will be then updated accordingly.

In the Enterprise Edition, only the products on which you have rights to view and publish are counted. The other products are not taken into account.

 

Hide or expand the category panel

In order to allow you to display the product grid widely, you can hide the category panel. To do so, click on the left arrow on the bottom right corner of the panel:

The category panel will be reduced automatically to the left side.

To expand the panel, click again on the arrow, the panel will be displayed.

Customise the grid

Use filters

The product grid includes a filter management. By default, the PIM displays System attributes (Family, Groups...):

You can use the filters displayed or add new filters: click on the + icon and select the new attributes you want to use as filters. The new filters will appear in the left panel. You can now filter your products displayed in the grid.

If an attribute or an attribute option is not translated in the active locale, its code will be displayed into brackets like [name] and only the attributes having the property «usable as grid filter» enabled are available to be used as filters.

The filters can be applied on the following product information:

  • Product information managed by the PIM: Family, Groups, Status, Complete, Creation date, Updated date, product identifier, Permissions
  • Product information managed via the attributes

You can define your own default product grid filters in your user account, refer to the section “Change your default preferences”.

If no default filters are set in your user account, the PIM will use the system attributes as default product grid filters: family, groups, status, complete, complete product, creation date, updated date, product identifier and permissions.

 

If you are missing an attribute in the Filters menu check if it is well activated as «usable as grid filter».

 

Only the attributes that you can view or edit are available in the list of filters on the product grid.

 

Search by label and identifier

To quickly find products, a search bar is available in the product grid. The search is only on the identifier (product identifier or product model code) and the label (attribute used as "label" in the product family).

The behavior of the search is a "contains" filter. For example, if you type in "can", it will display all the products or product models with an identifier/code or a label which contains "can".

You don't need to press enter to search, just enter a few characters and it automatically searches.

 

If the label is localizable or scopable, the search takes into account the locale and the channel selected in the grid.

 

Cofigure grid columns

Now you’re set up with your filters, you can select which columns you would like to see in the grid. By default, Akeneo displays the System attributes as columns.

By default, the grid displays the following columns:

  • ID (our product identifier)
  • Label (the product’s display name in Akeneo)
  • Family
  • Status (Enabled/Disabled)
  • Complete (the completeness percentage)
  • Created at (the creation date of the product)
  • Updated at (the product last updated date)
  • Groups (if the product belongs to groups)
  • Complete product

CONFIGURE THE COLUMNS

Click on Columns on the right side of the grid to display the column selection window:

On the left side of the window, you will see your attribute groups.

Nearby each group, you will see the number of attributes belonging to this group that can be used as columns in the grid. Click on a group to display its attributes in the middle column.

If you want to display all attributes, click on «All groups». On the right side, you will see your current grid’s columns.

Like for filters, only attributes having the property «usable as grid filter» activated can be used as columns.

And like for categories and locales, if you are an Enterprise Edition client and if you cannot see an attribute this is more likely that you do not have the permission to view it.

 

ADD ATTRIBUTES AS COLUMNS

Select an attribute group on the left side or select All groups. Drag your attribute in the mid-column and drop it in the right column. Use the search tool to look for a specific attribute. Move your attribute up and down to reorder them.

REMOVE ATTRIBUTES AS COLUMNS

Click on Clear top of the screen to remove all current grid’s attributes, or use the “trash” icon to remove a specific attribute from the grid. You need to have at least one attribute as a column.

Click on Apply to save your changes. Your customised grid will be displayed.

Sort values within the grid

You can also sort on some columns headers, for instance you can sort products on sku, family, status, complete, created and updated at and on some other attributes (text, text area, number, simple select attributes).

You can not sort values on price, media, asset, metric, multiselect attributes and on Label and Groups system attributes. To check if you can sort on a column simply hover your mouse over the column’s header.

Action shortcuts on single products

There is a set of actions available for each product. They are available on the right side of the product grid when you mouse over the product’s line:

Depending on your Akeneo version (Enterprise or Community) and your rights, you might not see all these shortcut actions: edit the product information, edit its category/ies, delete it or change its status.

You will be then able to edit the product information by clicking on the small pencil icon, edit its categories by clicking on the small folder icon, delete it with the trash bin icon and change its status thanks to the 2 arrows icon.

The shortcut actions are displayed if you have the appropriate rights, or as if you are working with the Enterprise Edition or the Community Version of the Akeneo PIM