↑↓ selectEnter openEsc close

    1. Elbuz

    How to create many ignore rules: from the product grid and from a file

    8 min readUpdated

    Elbuz creates ignore rules where you see unwanted items: in the price list product grid, the supplier category tree, and, for a long list, from an Excel file. Selected rows leave the price list in the same action.

    When you need this:

    • Unwanted items in the price list product grid — right-click, “Add to ignore list” → “Product” or “Category”.
    • A hundred items selected — each gets a rule by name and, depending on a setting, by SKU too.
    • Your rule list is in Excel — import it from a file; export existing rules to a workbook.

    Where to start: in the price list product grid, right-click the unwanted row.

    What bulk rule creation can do

    How to add items to the ignore list from the price list product grid

    “Ignore rules” isn't the only place that writes to the ignore list. So do the price list product grid, the supplier category tree, AI category and product matching, the price list product matching window, and website parser settings (the “Add to ignore list” item). The easiest way to create rules is from the price list product grid.

    From the price list product grid

    Right-click a product row and choose “Add to ignore list”, which has two sub-items: “Product” and “Category”. Elbuz asks “Add to ignore list?” and, once you confirm, does two things at once: it creates the rule and immediately deletes the rows from the price list.

    A product rule is created by the product name; if there's no name, by the manufacturer SKU; and if there's no manufacturer SKU either, by the supplier SKU. The partial match checkbox isn't selected.

    If you select several rows rather than one product, each selected product can produce three rules: by name, by manufacturer SKU, and by supplier SKU. This is how the “Ignore list includes the SKU” setting works, and it's on by default. Select a hundred rows and up to three hundred rules can appear in the list.

    A rule created from the grid remembers not only the value but also the price list row itself — and matches both. So it can remove an item you wouldn't expect based on the rule's value.

    The main fork is whether rows are selected in the grid: with no selection there's one rule; with a selection, a rule by name is created for each row, and with the “Ignore list includes the SKU” setting, rules by SKU are added to it. The “Category” sub-item always takes the category of the row you clicked.
    “Category”“Product”noyesyesnoRight-click a row“Add to ignore list” and confirmWhich sub-item?Rule by this row's price category;rows in this category are deleted.Row without a category — nothinghappensRows selected in the grid?One rule — by name, or withoutone, by manufacturer or supplierSKU. This row and rows with thesame value are deleted. No nameand no SKUs — nothing happensA rule by name for each selectedrow“Ignore list includes the SKU” on?Plus rules by manufacturer SKU andsupplier SKUSelected rows are deleted from theprice listPrice list counters are recalculated
    • Action or result
    • Decision: the path depends on the answer

    From the category tree and AI matching

    In the “Price list category matching” window, you drop a supplier category with the “Add to ignore list” button, and dozens of categories at once from AI matching. The tree node and its subcategories disappear along with the products. More: how to remove categories you don't carry from a price list.

    All these entry points write to one list, and you can see it in full only in the “Ignore rules” window. They don't take back what they added — you can remove ignoring only there.

    How to export and import rules with a file

    The “Additional operations” menu in the toolbar has up to five items: “Refresh”, “Clear filter”, “Delete all rules”, “Export to file”, and “Import from file”. Two of them may be missing: “Delete all rules” is visible only to users with the delete right, and “Import from file” appears only in the window of a specific price list.

    The Ignore rules window with the “Additional operations” menu expanded in the toolbar
    1Delete all rules
    2Export to file
    1. Delete all rules — removes every ignore rule of the selected source; do not click it unless you mean it.
    2. Export to file — downloads the rules to a file so they can be reused or edited offline.

    Export produces an Excel workbook with five columns: field name, value to ignore, partial match flag, contact ID, and price list ID. From the window of a specific source, only its rules are exported; from the general window, the rules of all price lists together.

    Import opens a separate window with the “Column addresses to import data from” group: you enter the column numbers in your file for “Field name”, “Value to ignore”, and “Flag: match by substring” — by default, the first, second, and third.

    The “Default field name (if not set in the file)” list is set to “Name”: this field is used in rows where the field name column is empty.

    The “Delete old entries” checkbox in this window is selected by default: existing rules are removed before the new ones are imported. To append rules to the existing ones, clear it before choosing the file.

    “Import from file” exists only in the window of a specific price list: rules from a file are tied to a source, so it isn't available in global mode.

    Scenarios

    Drop one supplier's “Discounted” section

    In this price list's product grid, right-click any product from the section → “Add to ignore list” → “Category” → confirm. A rule on the “Price category” field with an exact match appears, and rows with this category disappear from the price list after you confirm; the price list counters are recalculated.

    What won't happen: this item doesn't remove the “Discounted” node itself from the supplier category tree — the next import removes it, when the rule fires in the chain of operations. Products you already added to your catalog from this section stay there.

    Remove a batch of items selected in the grid

    Select the rows you need in the price list product grid, right-click → “Add to ignore list” → “Product”. Each selected row gets a rule by name and, if “Ignore list includes the SKU” is on in the settings, rules by manufacturer SKU and supplier SKU too. The selected rows are deleted from the price list in the same action.

    What won't happen: the “Partial match” checkbox isn't selected in these rules, so similar names with other words won't be caught. A row without a name gets no rule by name — only rules by SKU, and only if the setting is on and the SKUs in the row are filled in.

    What to do when there are too many rules

    Rules that appeared in the wrong place or in the wrong number
    What you seeWhyWhat to do
    A product disappeared from the price list, but there seems to be no rule for it The rule came from another window: from the price list product grid, it's created not only by name but also by SKU, and it also remembers the row itself. In the rules grid, all of this goes into the shared Search the rules grid by the product's SKU rather than by name, and check the general rules too (rules from other windows)
    After adding a few products to the ignore list, three times as many rules appeared The “Ignore list includes the SKU” setting is on by default: each selected product gets a rule by name plus two more by SKU Delete the extra rows in the grid; if you don't need this mode at all, turn the setting off in system settings (rules from the product grid)

    FAQ

    Can I turn off creating rules by SKU?

    Yes: turn off the “Ignore list includes the SKU” setting in system settings. Then each selected product gets one rule — by name.

    Why did importing from a file erase my rules?

    In the import window, “Delete old entries” is selected by default. To append rules to the existing ones, clear the checkbox before choosing the file.

    Why is there no “Import from file” item?

    It exists only in the rules window of a specific price list: rules from a file are tied to a source. Open the window from the price list card.

    Does a rule from the grid select the “Partial match” checkbox?

    No, such rules look for an exact value. They won't catch similar names with other words (exact match or partial match).

    How do I see what the rules from the grid deleted?

    In the price list card, turn on “Log deleted products (ignore rules)” and import the price list — the deleted products log shows each item and its rule.

    Where to find it and who has access

    From the product grid
    price list card → products → right-click a row → “Add to ignore list”
    With a file
    “Ignore rules” → “Additional operations” menu → “Export to file” / “Import from file”
    Access right
    the “Ignore rules” window; “Delete all rules” requires the delete right
    Prepare
    for a file — an Excel workbook with the field name, the value, and the partial match flag

    How to open the rules window is covered in the main article.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free