Die deutsche Fassung finden Sie hier.

Why does cobby need it's own filter, when Excel already offers filtering functions?

The answer is easy, cobbys product-filter filters products before they are loaded in excel. If you, for example, want to work with different storeviews at the same time, you need to set the filter accordingly, but more on that later.

When you click "Load Products" in cobby, the default filter is already set.

The default is set up like this:

  1. only the default-value will be loaded,

  2. only active products are in the filter.

How can I set the Filter to also load other products?

The "Load Products"-Button is divided into two parts:

upper part - Load the Products

lower part - open the menu

Inside the menu is an entry "Filter:..."

clicking it opens the Filter-dialog-box.

Here you can see the default filter as described above.

example cases

1. Show all products
To load all products (active and inactive) the tick box "only active products" has to be unchecked, afterwards click the button "apply filter".

2. Translations, setting StoreView-specific values
The StoreView  that we want to make changes in, needs to first be activated in the filter. We simply open up the filter-dialog and tick the checkbox next to the StoreView in the list, in this case "French". So two StoreViews are active.

Once products are loaded, the French StoreView is listed in the table together will All Store Views.

The Short Description in the French store is in English, since its value was inherited from the default value in "All Store Views".

3. Via Attribute filters
If you have very many products in your shop and you want to e.g. update the prices for the products for one particular manufacturer it makes no sense to load all of your shops products in excel. Here we can make use of the filter, the lower part ,"Attribute", houses options to filter using attributes of the type "Select" or "Multi-Select".

Sticking to our example we now filter for "Manufacturer", to do so we simply find it in the dropdown-list and click on it. We then get all existing values for manufacturer in the list on the right side.

Only checked values are filtered for.

After clicking "Apply Filter" and "Load Products", we only see the products of the manufacturer we wanted.

4. Via Text filters
You can filter for specific values of text attributes in the middle of the filter window. So, for example, you can filter for all products whose SKU starts with 00123 or all products whose names start with Adidas. You can also enter multiple filter words, separated with a comma, e.g. Adidas, Nike. All products that match one of these are loaded.

5. Hide empty AttributeSets
It is possible to hide empty attribute sets in your product filter. Please check the "Hide empty AttributeSets".
The unneeded attribute sets are no longer processed by Excel at all. The option accesses the storeview level. If an attribute set is not used in the storeview, it is no longer loaded by cobby. The information which attribute sets are used in the storeviews is determined when the cobby index is created.

Did this answer your question?