Over the Christmas holidays, a number of updates and bugfixes have accumulated. We hope you like them!
Top new features
Product tracking
This new tool allows you to easily analyze a product and track the changes throughout the rulesâ application process. Thanks to this feature you will know what happens to the attributesâ values for a given product as rules are applied.
How to use this tool?
On the Products page, a new icon was added to each product allowing you to activate tracking for the following 24 hours.
When rules are being applied, Mergado will track and save changes made by those rules to products that have the tracking enabled.
There are two ways to preview the results:
By clicking the icon for a given product on the Products page you can preview changes from the last rulesâ application.
All changes are available to preview by clicking a particular record from the rulesâ application on the History page.
24 hours after activation, the tracking is automatically disabled. However, you are free to enable it again.
Bulk import of queries
A new button was added on the Products page. It allows you to bulk import queries from other export that you have access to.
The old way of importing queries (âone-by-oneâ) was canceled.
Custom format update
The form for mapping attributes is now colored. Now you can easily distinguish embedded attributes.
A new âResetâ button was added.
You can now preview an example of an attribute value.
General improvements that are visible âat first glanceâ, but make life easier both to the user as well as to our admins.
Feed audit was optimized and is now faster.
It should now cope better with larger feeds.
Other updates and bugfixes.
Rulesâ application process was optimized to make it faster.
Evaluating the queries on the input was optimized to make it faster.
Pairing rule for the Heureka Watchdog app was optimized to make it faster.
Mergado Store: A new filter was added to the list of exports for which you can enable or disable an app.
Deleting saved queries on the Products page was improved. When deleting a query, the page does not reload so you donât lose your current query settings.
The system for suggesting values of an attribute was improved.
The bug causing a UI failure in exports with ~ 100 000+ different attributes was fixed.
The transfer of the AVAILABILITY attribute for the Google Shopping attribute was fixed and improved.
In the import tool, you can filter by queryâs name .
Editing custom format has been moved two levels above. Weâve also added paging for better orientation.
We have optimized the compilation of MQL (a language which defines product query) with a large number of parameters (thousands or more).
In tests, for such large queries (e.g., a query with an IN operator, where 10000+ values ââare present), weâve recorded an acceleration from minutes to seconds .
This optimization affects the speed of making queries on the Products page as well as the speed of preparation before applying the rules.
At the user instigation from our forum, we now show the icon for downloading the CSV with a list of products as well in the product listing page.
In the Heureka Watchdog app, we have fixed a bug that caused fault product counts in different situations.
In the rules list, the Rename Categories in Bulk rules now display the element name for the categories according to the current output format.
Format Shoptet.cz is renamed to ShoptetSupplier . We also made the same changes in the Slovak version of the format.
We have updated the Feed Audit forZbozi.cz format according to its current specification.
We have updated and fixed the Stileo.es and Stileo.it 1 formats according to their current specifications.
We have fixed an error in paging on the main export overview page.
We have corrected the error for Scontofacile.it, which caused the PREZZO price element not to be correctly matched during the conversion.
We have corrected the product card link atHeureka.cz if the product has such an address available.
We have taken further steps with the goal of preventing the occasional cancellation of the Keychain-Google Analytics connection.
If you have any questions, donât hesitate to contact us.
We have added supportforblockcommentsinMQL (product selection query language) in format /
⌠comment ⌠*/` .
For better protection against accidental deletion, you will now need a double confirmation when deleting the online store.
XML
We have released validation of element names before the final export of XML feeds - now it is possible to export parameters whose names end with a colon .
Weâve accelerated the XML import process if the input XML file is valid.
Exporting XML files has also undergone slight optimization. On test data, we tracked up to 50% acceleration in the final data feed export.
Rules
The Overwrite in Bulk rule on the right side now tells values that are already used on the right.
For the Rename Categories in Bulk rule, the names of the input and output elements for the categories are also displayed on the Rules page.
If a rule applying process is in progress for a given export, its progress is shown at the top of the page in Mergado - with a click-through icon for detailed information . This feature is in the test phase and weâre fine-tuning it.
We fixed a bug in the Biano.cz shipping pricing rule.
Custom format
We fixed a bug that occurred when a Custom format was used as input and output as one export .
We fixed a bug when exporting nested elements to a Custom format if more than one was defined for that format.
For custom formats, parameter and carrier names can now include a vertical character.
For some very common formats - Heureka, ZboĹžĂ.cz, GLAMI, and Mergado XML - we have added support for multiple parameters in the form of PARAM | Color, PARAM | Color | 1, PARAM | Color | 2, etc.
This makes it possible, for example, to specify more colors or materials in these formats: [PARAM | Material | 1] = âCotton 62%â, [PARAM | Material | 2] = âPolyester 38%â.
With this rule, you can import edits to existing items using a CSV file.
In the Mergado Store, we have improved the sorting of entities where the app can be managed to match the sorting of e-shops and exports elsewhere in Mergado.
When converting Google Shopping prices, we now take the value of the G: SALE_PRICE element correctly into consideration when available.
Googleformats have been updated. Weâve added a lot of new elements and fixed some minor flaws. Make sure everything is fine in the Google Merchant Center for your Google Ads!
For Shopalike CSV format , we tuned the audit and added support for the IN STOCK element.
Weâve improved the BluePanel , where you can access all your Online stores in one place. It will now be faster and easier to find.
We have prepared a new Mergado function - Macros! The goal is to automate the work you do in Mergado.
For example, you set up queries and rules that you can then use on other projects.
Where to find out more
Read this article on Macros for all the information you need. Find out how Macros work and how they can help you.
Weâve added support forthe new formatArtikul.cz 1 .
Weâve added the ability to create attribute elements into the user interface ( up to now, it was created by Mergado itself based on the content of the feed ). An attribute element can be specified in the following forms:
ELEMENT(id=123) with one attribute.
ELEMENT(id=123;dalsi_atribut=hodnota) with multiple attributes.
On the page listing element values, we introduced a line that represents all the empty values of the element.
Now one can immediately see how many productâs elements have no value . The user can make a query for that product set and hide them.
The Data File Import rule now supports inserting a data feed over the specified URL .
The rules can now be applied to onlya sample of items ( âmonitoredâ products ).
Thanks to this new option, the export settings ( querries, rules functionality, values of variables and output elements, etc. ) can be checked in a much shorter time .
This tool is available on theRules page in the clickable button to start applying the rules.
A new e-shop can be created separately in Mergado.
This new option is useful in situations where a user has trouble uploading his feed to Mergado and create a new e-shop in a standard way.
Weâve improved the Google Shopping 1exporter, which can nowproperly export attribute elements.
We have fixed a bug that caused the Heureka.cz and Heureka.sk fotmats didnât embed the RATING element to output.
In the Skrz.cz format, multiple elements (TAGS| x, IMAGES| y and CITIES| z) are now exported correctly.
Other minor fixes and improvementsâŚ
What features weâre planning to add
For a small (internal) group of people, we launch a new feature: the rule planner - for testing and tuning
Platform News
The list of submitted webhooks on the Webhooks page in the administration of your app in Developers will now display longer payloads. In the past, when logging a weblog, the JSON payload has often been cut off due to length. Now it should happen not that often.
You may notice minor outages of Mergado at that time. Thank you for your understanding and patience in deploying the new version.
The data import rule now supports non-standard delimiters for CSV files. The user can now choose from:
, comma (default)
; semicolon (new)
| vertical bar (new)
For the Favi.hu format we have added support for the shipping pricing rule. The following carriers are currently available:
DHL
DPD
GLS
In the custom format settings, you can now save a definition without specifying a ârootâ element. As a result, you can now import feeds into Mergado that do not have this top-level element.
For imported CSV files we improved the processing of correctly escaped quotes.
E.g. "text in quotation marks containing additional ""double quotation marks with , (a delimiter)"" reads correctly."
We have fixed the query form (product search) for read-only users.
For the Google Shopping format, we fixed the export of the G: SUBSCRIPTION_COST element.
When establishing a connection with Heureka via the Mergado Keychain app we are now displaying the correct message if the given account on Heureka exists but does not have any stores.
⌠and other minor updates and fixes.
Platform News
We will no longer display the top yellow notifications (downtimes, releases, etc.) on the app preview page, thus covering your IFRAME content.
During the release, you may notice minor downtimes of Mergado. Thank you for your understanding and patience.
The data import rule now forces the rules to be fully applied when external data changes.
By default, Mergado applies rules only to products whose input values have changed during the last import. Now we will detect this âchange of external dataâ for the data source of this rule.
The data import rule for element names is now case-insensitive.
In Mergado we work with element names as case-insensitive. For us, the element <Some_Element> is the same as <some_element> or <SOME_ELEMENT>. Thus, it makes no sense for the data import rule to distinguish the font size.
Now data input (eg):
:xid,Product_Name,price_VAT 1,"Stroller",123.45
âŚwill also affect elements called PRODUCT_NAME and PRICE_VAT.
Improvements: For exports there is a new option âDuplicate exportâ in the
menu.
This action will create a copy of the export (it will be included in the same ecommerce). The copy will be created with all selections, rules, elements, and variables.
Attention: Any application running under the original export will not be turned on for a new export - and it is up to the user whether he wants to turn it on.
Improvements: The rule for setting transport prices now supports the use of variables.
We now support the DSA Google Ads format for 26 other countries. Including support for audits.
Google and Facebook formats have added support for Croatia and Slovenia.
We now support Biano format for Brazil, the Netherlands, and Romania.
In Audit, we have added support for a number of language versions of the Glami and Stileo formats.
Improvements: For rules that support regular expressions, we now show help on how to use back references. We have customized the workflow to work with custom formats to make it more user-friendly.
On the export history page, the skipped import (Because the input file has not changed in any way) now displays the correct number of items (instead of the previous zero).
We fixed a bug for bulk import of rules. Because of this bug no rules were showed for import.
To create an export, we displayed as existing e-shops even those to which the user had read-only access - and the new export could not be assigned to them anyway. We fixed this.
In process of creating exports we showed to user all existing ecommerces even those for which he only has the right to read. And the new export couldnât be assigned to them anyway. Now itâs fixed.
On the Products page, we fixed a product display bug. This error occurred in specific combinations of display settings.
Due to a bug in the blue bar, ecommerce that had no export were not shown during the searching. We fixed this.
We have unified the names of the different processes and their phases on the export history page.
We have added translations for missing country and currency names.
Other fixes and minor improvementsâŚ
Platform News
In MQL, we now support a âspecial elementâ called @MERGADO_ID, which can be used to select specific products by their internal (our) ID (eg, the ID used at the endpoint https://api.mergado.com/products/ 123456789, or is shown in the URL for products in the interface).
Applications can now use this to make selections for specific products (and then in the app, for example, make a link to Mergado for that selection).
Examples of use:
@MERGADO_ID = "123456789"
@MERGADO_ID NOT IN (123456789; 123456780)
PRODUCTNAME ~ @MERGADO_ID AND @MERGADO_ID ~ "3" OR @MERGADO_ID IN ("123";"321")
We have changed the time that we keep webhook log entries accessible in Mergado Developers to 7 days.
You may notice minor outages of Mergado at that time. Thank you for your understanding and patience in deploying the new version.
If you have any questions, please donât hesitate contact us.
was added to each product allowing you to activate tracking for the following 24 hours.
New rule type - Copy Values in Bulk 
.
- the ability to highlight lines with absent categories:
For a small (internal) group of people, we launch a new feature: the rule planner 
- for testing and tuning
For the 
In the custom format settings, you can now save a definition without specifying a ârootâ element. As a result, you can now import feeds into Mergado that do not have this top-level element.
For imported CSV files we improved the processing of correctly escaped quotes.
We have fixed the query form (product search) for read-only users.
via the Mergado Keychain 
app we are now displaying the correct message if the given account on Heureka exists but does not have any stores.
The data import rule now forces the rules to be fully applied when external data changes.
The data import rule for element names is now case-insensitive.
Improvements: For exports there is a new option âDuplicate exportâ in the
Any application running under the original export will not be turned on for a new export - and it is up to the user whether he wants to turn it on.
Improvements: The rule for setting transport prices now supports the use of variables.
Improvements: For rules that support regular expressions, we now show help on how to use back references.
We have customized the workflow to work with custom formats to make it more user-friendly.
You are now able to select the decimal separator (comma, period) and thousands separator (nothing, period, comma, space) in the Rounding rule.
We have reworked Creating a new export to make this process easier and clearer.
