Searching products and variants

Struct PIM allows you to search all products or variants independently through the Search products page. If you click a category in one of your catalogues, you will get the same search interface, but you will only be searching products and variants within that category and its children.

Global list values can be searched by accessing the global list to search within. The search functionality works exactly the same across products, variants and global lists.

The search engine allows for several different types of searches. By default the search engine searches for entities where the field value starts with the text you have written.

By using operators, you can make more complex searches. Below you can see different types of searches you can make:

• Search for: struct - Search will return all entities where the value starts with struct
• Search for: *struct - Search will return all entities where the value contains struct
• Search for: "struct" - Search will return all entities where the value equals struct
• Search for: !struct - Search will return all entities where the value does not start with struct
• Search for: !*struct - Search will return all entities where the value does not contain with struct
• Search for: !"struct" - Search will return all entities where the value does not equal struct
• Search for: "" - Search will return all entities where the value is empty
• Search for: !"" - Search will return all entities where the value is not empty

Combining operators with searches across different fields allow you to find pretty much anything.

Date/date time fields

For date or datetime fields you can search for distances from the current date in the following ways

• If you search for: >-30d - Search will return all items where the date is larger than now - 30 days
• If you search for: <30d - Search will return all items where the date is smaller than now + 30 days

y = years, M = months, w = weeks, d = days, h = hours and m = minutes

Multiple queries in same field

The search engine supports making multiple queries in the same fields. You can either make OR queries, where just one of your criterias must be met or AND queries where all you criterias must be met in order to yield a match

• (AND) If you search for: [query1]&&[query2] - Search will return all items where the value is included in both query1 and query2
• (OR) If you search for: [query1]||[query2] - Search will return all items where the value is included in both query1 or query2

You can still use the operators for each query as stated above

The search interface allows you to show any field that exist on the entities you are searching, whether it be products, variants og global lists.

Clicking the columns button in the top right corner of the search interface allows you to select exactly the fields you want displayed in your search table.

Note that the order of the selected fields can be changed by dragging and dropping the Shown data fields

If you work with multiple different fieldsets, you can save a field setup and recall it later using the Choose view setting dropdown

If you for example have a list of SKU's that matches a range of variants in your PIM system, you can use the filter feature to find them.

Click the icon in the top right corner to open the filter menu.

In the filter menu, select the field you want to filter on (SKU in this example), add the SKU's you want to find either as a semicolon separated list or with linebreak between each SKU and press OK.

Your search will now be filtered to show only those variants whose SKU matches any of the provided SKU's in the filter.