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

Article published 24.04.2019

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).

Make as few as possible queries and apply a rule to them.

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:

Set up Mergado effectively #1: Queries to input values

In the Mergado team, we see our platform as a Swiss pen-knife for data feeds. Thanks to a large number of functionalities and experience of solving the cases on our support, we have realized over time that Mergado has entered a new era. To an era where we need to teach our users how to work with this Swiss knife effectively.

New features in Mergado accelerate advertising management

Our development team has prepared another batch of improvements and changes that accelerate Mergado processes and improve some of the applications. See what news will help you manage your advertising.

Automatic item updates to Google Shopping will increase the traffic to your ads

Delays in updating your product data may cause customers to receive inaccurate information. Such inconsistencies affect the degree of their satisfaction and their desire to shop in your online store. On Google Shopping you can get rid of these delays by automatic item updates.


Add new comment