Set up Mergado effectively #2: How to create rules correctly

Article published 24. 04. 2019
| 2 minutes read

Do you run an export with a large number of products in Mergado? Have you encountered a slowdown in the process of applying the rules? By setting up your Mergado export correctly, you can process the rules faster. In the second part of our miniseries, we’ll show you how to create the rules correctly.

Correctly created rules speed up their processing by Mergado

In the first part of this guide, we’ve described the benefits of making queries to input values. As far as possible, creating rules for queries to the input helps you to speed up the process as well. Their results can be reused within one application of rules.

For example, you have an “A” rule and a “B” rule in one group which is not discontinued by any rule for a query to the output, and both rules are applied to the input query. After the ‘A’ rule has been processed by the query, Mergado “stores” it and does not need to process it again for the ‘B’ rule.

Practical example

Our support consultants encountered a case where a client had a hiding rule applied to 100 queries in the export of over 300,000 products. In Mergado, this setting is normally possible and works for smaller feeds, but a feed of over 300,000 items requires a different setting.

What was it about:

When applying the rules, between 300,000 lines in the database, Mergado had to select the products hundreds of times. As a result, the application process has slowed down.

How we solved it:

There is an effective solution that leads to faster processing (data regeneration) by Mergado. All you have to do is make as few as possible queries and apply a rule to them. For example, if you put 100 queries into one, Mergado would check your products only once (though a more complex query).

If you have a larger number of products in the feed (tens or hundreds of thousands), apply the rules to as few queries as possible. If the situation allows, also try to create as many rules as possible for queries to the input values — and not on output. This eliminates the slowdown in applying rules.

Watch our mini-series to help you set Mergado to work as quickly and efficiently as possible. If you have any questions, do not hesitate to contact our support.

You could be interested in:

Author / Lukáš Horák / 24. 04. 2019

Lukáš takes care of most of the Czech and English communication in Mergado. Through blogs, e‑mail, and social networks, he regularly supplies readers with e‑commerce news and news and tips from Mergado. In his time off, he enjoys simple things like badminton, digging the hidden gems of the 80’s, and seafood served with red wine.

Add new comment

The content of this field is kept private and will not be shown publicly.
By submitting a comment, you agree to the processing of personal data.