Viewing Content on Sales Layer and Excel Mode


There are three ways to view your uploaded content on Sales Layer. By default, when you select categories, they will be displayed in List Mode, whereas Products are shown in Image mode. However, you can easily switch between views using the three buttons in the top right corner.

Let’s look at the information we can see when we select Image Mode, one of the first things that might catch your eye is the Quality Score, a percentage given to each product to show its completeness, that is, how many of its fields have been filled with data. This is a very important area of Sales Layer which we will go into further in the Quality Report section.

Examples of Product Quality Scores
Examples of Product Quality Scores

In addition to this, we can also see the status of each product and set it to three options: visible, invisible or draft. Basically, draft status should be used for products which don’t have all of their information ready yet, visible for those that are ready to go online, and then invisible can be used for various other reasons, such as for products that have been temporarily discontinued. The status of a product can have important consequences when it comes time to configure your output connectors, for example if you’ve set a connector to only export visible items, only those products with their status set to visible will be exported.

Options for changing the status of a product
Options for changing the status of a product

When viewing the content in Image Mode, we can also see if a product has any variants as well as accessing them directly from here. We can also select multiple products, using the green tick box in the top-right hand corner of each image, and perform operations on them all in one go.

Warning: be aware that if you perform a bulk operation without having applied any filters or selected any items, this bulk operation will be applied to every item.

There are also several ways of sorting your content, such as by alphabetical order, by order of Quality Score, or by the user who imported the products, as well as various other options.

Having seen both these modes, let's look at the final one, known as Edit, or Excel mode. This mode has two main advantages: firstly it allows us to filter the data we see on each product by permitting the selection of which columns we want shown, secondly it also facilitates the process of editing the content of several products at once.

 Looking at Products in Edit/Excel mode
Looking at Products in Edit/Excel mode

To make Excel mode more comfortable, Sales Layer gives you the option to create customized views which you can save and use whenever it is needed. You do not have to filter again by column: simply select your view and start working. To do this, click on the Default button and choose Modify Columns.

Here you can choose which columns you want to display, simplifying the content view by filtering the columns you need. This will make your work process much faster and efficient.

Select Columns

It is also possible to select a fixed column to filter in alphabetical order and to choose the size of the whole table thanks to the Expand / Reduce button.

The Excel Views are customizable by the user. Each user can see and access those that they have personally saved, but not those of others. This allows independent users to work without interference.

Note: it is possible to create a maximum of 10 views, per table and per user.

As well as filtering the data displayed on each product via the column selection, you can also filter using the Search Bar or with Tags. We will look at both of these in more detail in the corresponding sections.

Warning: the search bar returns only results included within the same table from which you are performing the search. In other words, you will not be able to use the search function to access data from another table. For example, if you are in the Variants table, you cannot search for data belonging to the Product table.

Tip: please note that the cells in the Edit Mode might change colour as follows: a/ Yellow: when you fill or edit the category, image or file fields using an invalid value. The system will delete or correct the information in the field and will mark the cell in yellow. b/ Red: in the case of an error in the reference field, for example, when you create or edit a record using an existing code.