Tips and Tricks

Tips and tricks dialog is available in your Store Manager. It can be opened through the "Help" section of the main toolbar. In this window, you can enable "Show tips and tricks on Startup" option to get some helpful hints every time you open Store Manager.

1. Advanced Filters

Advanced filters are column filters that can be applied to basically any column of the current page (table). It allows you to show and hide rows based on cell content.

Data filtration can be executed in any table on the base of filter factors. Required factors are specified in the column title drop-down.

"Custom Filter" creates a filter statement that will be applied. You can choose this option even if some filter is already established. In this case, you'll see this filter's structure.

Custom Filter

There are several values for the data filtration you can select, all listed in a column title drop-down with the checkboxes. Filtration is applied as soon as you select a box.

If filter for any column is established, then it will be reflected in a special panel that appears at the bottom of the page.

Filter product by Field

There is a checkbox that allows you to disable current filtration, thus show all products. However, it does not close Advanced Filter panel.

Currect Filtration Row
Disable Filtration

< - If you press this button, this will disable filtration and close panel.

Show Previously Applied Filters

< - When clicking this button, you will see a list of all Advanced filters applied previously. You can change your current filter to any of them.

If you click on the [Customize...] button:

Customize Filter

you will see "Filter builder" form with current filter structure. You can make any changes there: add, edit or remove filter parameters.

Filter builder

You can add filters to a drop-down menu, if you click the [search] button.

Search Product Button

You will get "Products Search" window where you can search among attribute values and set them as new filters.

Select Attributes to search in

After that, you are welcome to choose the relevant filter in the filter menu.

Choose Saved Filter

2. Export to Excel

Almost every page or section in Store Manager has an Export to Excel option. By pressing the corresponding button you can save data into an Excel file immediately.

3. Copy Categories

There may be a reason why you need to copy quite a few categories, which can take a lot of time. Thus you can use category Import/Export Wizard to simplify this task.

Let's say you have 5 parent categories, each of them has to include 30 similar subcategories. You've entered all 30 in Category One. Make sure this is the current(selected) category and click Import/Export button, select Export option. Specify the file you want your subcategories to be exported to (e.g. subcategories) and the path to it. Then select "Only from current category" option on the next page and proceed with the export.

Then select all the subcategories, drug them to Category Two and drop there. Subcategories will be moved to that category automatically. Now perform the import of the file you've created (here we used "subcategories"). Category One will list the Subcategories again. This way you'll have same subcategories in 2 categories.

Now Drag&Drop the subcategories From Category One into Category Three and import them again.

This trick can be used on basically any level of your category tree.

Please, check for some useful articles:

Magento Advanced Filters

Magento Product Filters