Transfer settings and data from one export to another in Mergado
Do you want to transfer already created queries and rules in one export to another in Mergado. Or be able to create a new export from the output URL of another export? All this is possible in our tool. In this article, we are going to describe several features that can make these tasks easier for you.
Learn all types of imports
Mergado offers several import and export options that simplify the internal transfer of settings and data.
The function for importing queries is available on the Products -> Import Queries button.
- First, you need to select the online store and export from which you want to import the queries into the current export in which you are located.
- Then an overview of all queries for import is displayed. Here, you can select in bulk or click on any of them before importing and check for the query condition.
- Use the “Import selected queries” button to import the queries you want.
Do not forget
Immediately after the import, informative numbers of products will not be available in the newly imported queries (in the list of saved queries on the Products page). Later it is set automatically when the feed is refreshed or after clicking a specific query.
The function for importing rules is available on the Rules page -> the Import Rule button is hidden under the arrow next to the Add a new rule button.
- As with the import of queries, you must first select the online store and export from which you want to import the rules into the current export where you are located.
- Then an overview of all import rules is displayed, which can be imported one by one. The option of bulk marking of rules is not available here.
- It is necessary to check each rule before importing and set queries for it, for they are not automatically transferred.
If you need to transfer more rules, we recommend opening individual links to import the rule into a new browser tab to speed it up. It will keep the page with the selected online store and export from which we are transferring the rules open.
Typical use case:
“In Mergado, we have two exports, one for GLAMI and the other for Google Shopping. At GLAMI export, we have detailed information about the material of the products, and we need to add these parameters to Google Shopping export.”
If we need to add values from another export in Mergado, we can import them with the Data File Import rule. This type of rule can import data by uploading or from a URL address, i. e. easily from some other export output feed.
The condition is that the imported data must be in the form of a CSV file. It can be set in Mergado by selecting the Plain CSV format for the output feed.
The principle of importing values can be ensured in three steps:
- Prepare an export that will have the output data as a CSV file. Use the Plain CSV format here or create your CSV format (Custom format function). Note: Unnecessary elements can be hidden. Keep only the ones you want to import for output and add an element for pairing (e. g., product number, ITEM_ID, EAN, etc.).
- In the export into which you want to import data, there must be elements with the same name as the column names in the CSV. If you don’t have them there, create them on the Elements page.
- In the export into which you want to import data, add a Data File Import type rule, and in it, set the import from the URL for which you already have a CSV file.
You can find more information about this type of rule in the articles at our blog:
To make our work easier, we have a macros function in Mergado. You can find out what macros can do and how to create them in articles on our blog:
Macros can be easily shared using a link to them. You can find it in the macro detail under the share icon.
- If you receive a link to a new macro that you do not already have under your user account, you will see the option to import that. It will add it to your user account, where you can edit it if necessary.
- If you want to track changes in the “original” macro, e. g. if the author would improve it, check the option to track changes before importing the macro.
This function is suitable for testing as a backup. Or to speed up work with complete export duplication. You can find this function in Export settings -> Duplicate link.
Duplicating will create a new, separate export with the selected name and transfer almost everything from the original export:
- address and format of the input feed
- output feed format (output address will be different, see below)
- all created queries (created by user and apps)
- user-added rules as well as some created by apps
- all created elements and variables (however, app-created elements will not be filled with values until the apps are activated on the new export)
What will not be transferred or will be different:
- apps and some app rules
- manual changes to products
- the original export edits and actions History
- the export gets a new output URL
Note: Users will have the same access rights to the new export as to the original one because the user rights are tied to the entire online store and thus apply to all its exports.
If you need to change the output format for duplicating exports, contact our technical support. We will arrange everything in a short time.
You can freely chain exports in Mergado. It means that you can create a new export from the output address of one export, where you use the output URL from the first export as an input feed.
In practice, this is useful, for example, when you need to use already modified data of export for further exports.
See the article Create a master feed and get rid of the need to edit each export separately.
Another example where the chaining exports option for yourself may be useful is the duplicate product variants elimination.
If you chain the output URL of the feed again to the input to Mergado, you will see this link for both exports in Settings -> General settings -> for the output or input address of the feed.
We described this in more detail in the article Create a master feed.
With the tips from this article, you will move your knowledge of working with Mergado a little further again.
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.