Keep the values in the elements as needed with the Data File Import rule

Article published 08.01.2020

Our support helps daily set up Mergado for e-shoppers and agencies that manage to advertise large clients. Some time ago, we received an interesting question on how to keep the price in the wholesaler's output feed, even if it changes for the year as part of setting up discounts for individual retail customers. Let's show you how to preserve values in elements in Mergado as needed using the new Data File Import rule.

Set discounts in such a way that the price does not change in the output feed

Wholesaler products have fixed prices for the whole year. But during the year, the prices in the PRICE and PRICE_VAT elements, and the input feed change due to various discounts. The wholesaler doesn't want to change the price at the output feed. The price has to correspond to the fixed price, which is set once a year. Setting the price this way, the wholesale partners don't have to set identical prices in discounts and other attributes (e. g. availability and description) are going to be updated according to the input feed.


Instructions for working with the Data File Import rule in Mergado

1. On the Products page, download products to CSV.

2. Then, edit your CSV to have only the first (pairing) column and the two price columns (PRICE and PRICE_VAT).

3. Add the modified CSV file to the new Data File Import rule.

  • This rule always updates prices according to the CSV file.
  • If there is a reduced (or increased) price at the input, the rule fixes it to the value of the specified price.

4. After a period of time you choose (in this case, in one year), you create a new CSV from the input data, and then update it in the rule.

A preview of the Data File Import rule creation.

We dedicated the whole article to working with the Data File Import rule. It shows you what upload conditions must the CSV file meet and what pairing modes the Mergado rule has to offer.


This way of using the rule is suitable not only for all wholesalers and agencies that manage their advertising but generally for all Mergado users who need to keep values in a specific element that will change later. Do you have questions about setting up the rule? Contact us.


You could be also interested in:

Get the most out of post-Christmas sales

Do not pay attention to sales only until Christmas. More and more people buy goods during post-Christmas discounts time. Prepare thoroughly for sales during this period. If you make your post-Christmas strategies smartly, they will bring additional profit to your e-shop.

Understand customer behavior in detail using

Want to create functional cross-channel marketing campaigns for your store but don't know where to start? Do the length of testing, the cost of work and other obstacles deter you from developing such strategies? Take advantage of


Add new comment