- [Case Studies](https://www.mergado.com/category/case-studies)
- [eCommerce tips](https://www.mergado.com/category/ecommerce-tips)
- [Online Store Solutions and Platforms](https://www.mergado.com/category/online-store-solutions-and-platforms)
- [Mergado Pack](https://www.mergado.com/category/mergado-pack)
- [Mergado tips](https://www.mergado.com/category/mergado-tips)
- [Mergado News](https://www.mergado.com/category/mergado-news)
- [eCommerce News](https://www.mergado.com/category/ecommerce-news)
- [How to use Mergado](https://www.mergado.com/category/how-to-use-mergado)
- [Interviews with e‑commerce gurus](https://www.mergado.com/category/interviews-e-commerce-gurus)
- [Extensions](https://www.mergado.com/category/apps-bidding-image-marketing-and-more)
- [Expansion with Mergado](https://www.mergado.com/category/expansion-with-mergado)
- [Mergado Lifestyle](https://www.mergado.com/category/mergado-lifestyle)
1. [ Home ](https://www.mergado.com/)
2. [ Mergado Blog ](https://www.mergado.com/blog)
3. [ How to use Mergado ](https://www.mergado.com/category/how-to-use-mergado)
4. **Keep the values in the elements as needed with the Data File Import rule**
# **Keep the values in the elements as needed with the Data File Import rule**
[  Lukáš Horák ](https://www.mergado.com/blog/lukas-horak) [How to use Mergado](https://www.mergado.com/category/how-to-use-mergado)
8. 1. 2020
2 minutes read
Our support helps daily set up [Mergado](https://www.mergado.com/get-started) 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.
function tableOfContents() {
return {
headings_menu: [],
heading_active: '', // Added to track the active section
shouldBeSticky: false,
generateToC() {
const headings = document.querySelectorAll('.js-article-full-headings h2, .js-article-full-headings h3');
let headingMap = {};
headings.forEach((heading) => { // Use an arrow function to maintain `this` context
// Normalize heading text to remove diacritics, then replace non-alphanumeric characters with dashes
var normalizedText = heading.textContent.normalize("NFD").replace(/[\u0300-\u036f]/g, ""); // Remove diacritics
var id = heading.id ? heading.id : normalizedText.trim().toLowerCase()
.split(' ').join('-').replace(/[^a-z0-9\-]/ig, ''); // Updated regex to replace non-alphanumeric characters
headingMap[id] = headingMap[id] !== undefined ? ++headingMap[id] : 0;
// Use the updated `id` with diacritics removed for the heading id and the TOC
const finalId = headingMap[id] ? `${id}-${headingMap[id]}` : id;
this.headings_menu.push({
id: finalId,
title: heading.textContent,
level: heading.tagName.toLowerCase(), // Track heading level
active: false, // Initially set active to false
});
heading.id = finalId;
});
},
checkStickyNeeded() {
const ul = this.$el.querySelector('ul');
if (ul) {
this.shouldBeSticky = ul.scrollHeight < window.innerHeight;
}
},
setActiveHeading() {
// disabled not working with active state on click
// add @scroll.window="setActiveHeading()" to the parent div
// const headings = document.querySelectorAll('.js-article-full-headings h2');
// let activeHeading = '';
// let closestHeadingDistance = Infinity;
// headings.forEach((heading) => {
// const rect = heading.getBoundingClientRect();
// const offset = rect.top - window.innerHeight / 2; // Consider heading in the middle of the screen as active
// if (offset < 0 && Math.abs(offset) < closestHeadingDistance) {
// activeHeading = heading.id;
// closestHeadingDistance = Math.abs(offset);
// }
// });
// // Update the active state in headings_menu
// if (activeHeading !== this.heading_active) {
// this.headings_menu = this.headings_menu.map(item => ({
// ...item,
// active: item.id === activeHeading,
// }));
// this.heading_active = activeHeading;
// }
},
setActiveItem(clickedId) {
this.headings_menu.forEach(item => {
item.active = (item.id === clickedId);
});
this.heading_active = clickedId; // Optionally update the heading_active property if used
},
};
}
1. —
Our support helps daily set up [Mergado](https://www.mergado.com/get-started) 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](https://www.mergado.com/october-release) 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.
[  ](https://www.mergado.com/sites/default/files/perm/paragraph-image/obr1-eng.png)
We dedicated the [whole article](https://www.mergado.com/csv-import-to-ease-your-work-with-mergado) 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](https://mailto:mergado@mergado.com) us.
### **You could be also interested in:**
[ 
### What should a proper client context look like for performance specialists?
](https://www.mergado.com/blog/master-prompt-eshopy-b2c)
[ 
### How Feed Optimization Unlocked Meta Ads Performance without Increasing Ad Spend
](https://www.mergado.com/blog/feed-optimization-for-meta-ads)
[ 
### How to Sell Successfully on idealo
](https://www.mergado.com/blog/successful-sale-on-idealo)
[  ](https://www.mergado.com/blog/lukas-horak)### [ Lukáš Horák ](https://www.mergado.com/blog/lukas-horak)
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.
## What you *might be interested in next*
[ 
### How We Migrated an E‑Shop from Shoptet to Shopify with Mergado: A Complete Migration Without Data Loss
](https://www.mergado.com/blog/how-we-migrated-e-shop-shoptet-shopify-mergado-complete-migration-without-data-loss)
[ 
### How to open large XML file
](https://www.mergado.com/blog/how-to-open-large-xml-file)
[ 
### Introducing smart value insertion. It will speed up the creation of bulk rules
](https://www.mergado.com/blog/smart-value-insertion)
## Don’t miss *anything*
Sign up for our newsletter
By logging in, you agree that we will process your data by the [terms of personal data protection](https://www.mergado.com/cookies).
Thank you, you have successfully joined our subscriber's list.
function ml_webform_success_5807248() {
var r = ml_jQuery || jQuery
r('.ml-subscribe-form-5807248 .row-success').show(), r('.ml-subscribe-form-5807248 .row-form').hide()
}