News and Releases in Mergado

A new version of Mergado

Release date and time

Wednesday 30/01/2019 3 pm

News and repairs in Mergado

  • 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 Shoptet S upplier . We also made the same changes in the Slovak version of the format.

  • We have updated the Feed Audit for Zbozi.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 at Heureka.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.

A new version of Mergado

Release date and time

monday 08/04/2019 3 p.m.

Major changes

  • We have added support for block comments in MQL (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.

Send us your ideas to our technical support.

A new version of Mergado

Deployment date and time

May 6, 2019

News and improvements

Newly supported formats Glami.hr and Glami.si 1.

A new version of Mergado

Deployment date and time

May 20, 2019

News and improvements

New Products page design.

  • The product information component has been completely rewritten .

  • There are three display options : Preview , Elements , and Images .

  • The global way of displaying all products can be set by the switch above the block with displayed products .

  • The display mode can also be set individually for each product, depending on the user’s current needs .

The rule form now includes a button to cancel the display of the current query .

A new version of Mergado

Deployment date and time

May 30, 2019

News and improvements

New formats:

A new version of Mergado

Deployment date and time

June 10, 2019
News and improvements
• We have expanded the list of formats.

  • Google Shopping SK
  • Glami.BG
  • Stileo.UA
  • Favi.PL and Favi.HU

A new version of Mergado

Deployment date and time

June 26, 2019

News and improvements

  • The store clickable info box now displays the length of the selected billing period on the export report.
  • In the export history, we also show when and who turned apps on and off .
  • We have improved the export of products to CSV for the XML audit .
  • We have fixed the detection of the image element for all Stileo versions, and now we can display them in our interface.

A new version of Mergado

Deployment date and time

July 11, 2019

News and improvements

For GLAMI 1 format, we are adding support for defining materials , which GLAMI will require directly from August 1, 2019 .

We newly support other Kelkoo languages :

A new version of Mergado

Deployment date and time

August 1, 2019

News and improvements

Deployed facelift of Export Summary page .

Added support for the new format : Shopalike CSV 1.

  • 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%”.

A new version of Mergado

Deployment date and time

August 22, 2019

News and improvements

New rule type - Data File Import:

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

Mergado can process new formats:

A new version of Mergado

Deployment date and time

September 5, 2019

News and improvements

  • Added support for the new format : Sravni.bg
  • Google formats 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 Blue Panel , where you can access all your Online stores in one place. It will now be faster and easier to find.

A new version of Mergado

Deployment date and time

September 16, 2019

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.

A new version of Mergado

Deployment date and time

September 30, 2019

News and improvements

We’ve added support for the new format Artikul.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.

A new version of Mergado

Deployment date and time

October 16, 2019

News and improvements

The Data File Import rule now supports inserting a data feed over the specified URL .
The rules can now be applied to only a 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 the Rules 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 1 e xporter, which can now properly export attribute elements .

A new version of Mergado

Deployment date and time

November 11, 2019, 15:30

News and improvements

  • :sunflower: New rule type - Copy Values in Bulk :open_file_folder:.
    • With this rule, you can simply and collectively copy values from multiple elements to other elements.
      1
  • The Rename Categories in bulk rule has a new feature :new: - the ability to highlight lines with absent categories:
    2
  • We have updated the format for Mall.cz marketplace to match current specification .
  • We’ve added support for brand new formats :
    1. The :hungary: Argep.hu for Hungary.
    2. The :greece: Snif.gr for Greece.
  • 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

  • :sunny: For a small (internal) group of people, we launch a new feature: the rule planner :spiral_calendar: - 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.

If you have any questions, please contact us.

A new version of Mergado

Deployment date and time

November 21, 2019, 15:30

News and updates

  • :sunflower: The data import rule now supports non-standard delimiters for CSV files. The user can now choose from:

    1. , comma (default)
    2. ; semicolon (new)
    3. | vertical bar (new)
  • :truck: For the :hungary: Favi.hu format we have added support for the shipping pricing rule. The following carriers are currently available:

    • DHL
    • DPD
    • GLS
  • :wrench: 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.

  • :file_folder: 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."
  • :mag: 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 :czech_republic: :slovakia: via the Mergado Keychain :old_key: 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.

If you have any questions, please contact us.

New version of Mergado

Wednesday 29. 1. 2019 at 14:00

News and bugfix :bomb:

  • :sparkles: 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.
  • :boom: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.

  • :star2: 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: :warning: 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.
  • :muscle: Improvements: The rule for setting transport prices now supports the use of variables.

  • Formats: :earth_africa:

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

:dizzy: Improvements: For rules that support regular expressions, we now show help on how to use back references.
:eyes: 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 :zap:

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

1 Like

New version of Mergado

Wednesday 02/26 2020 in 15:00

Fixes

  • Fixed bad conversion of accessories in custom formats. :prayer_beads:

  • Suggesting variables in rules for delivery is already working.

  • Users who have been signed-in for a long time will always see invoices in their administration. :moneybag:

New Features

  • The audit warns if the feed format for Heureka or Zboží.cz does not include shipping costs. :post_office:

  • :gear: You are now able to select the decimal separator (comma, period) and thousands separator (nothing, period, comma, space) in the Rounding rule.

  • :mage: We have reworked Creating a new export to make this process easier and clearer.

    • When entering the URL of a new project, Mergado suggests you a URL from projects you have already uploaded.
      1

    • The input and output format selections are separate.
      2

    • The whole process got a new coat.
      3

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. :pray:

You don’t have to worry about your advertising.:man_superhero:
While unprecedented things are happening outside, we want to make sure all Mergado users that their ads will continue to run unchanged.:gear:
If you need help setting up your ads, please feel free to contact us at any time.:couple:

A new version of Mergado

Deployment date and time

March 18, 2020, 15:00

News and updates

:sunny: You are now able to create your own macros

We introduced the Macro Tool - the ability to run preset actions that let you set up your export quickly and easily - last September. At that time, we ran macros in “users can run macros” mode, where you could use sets of actions that we had already prepared, but you couldn’t create them yourself.

The procedure for creating macros was only available to our team at that time, because it was a quite complex process in test mode. The macro editor and the whole interface around it just needed to be more user-friendly and we wanted to catch as many “flies” before launching.

Now we open creating macros for all our users. :sunglasses:

obrazek

In the top-level menu (i.e. on the main page) there is a new item called Custom macros. Create and manage your macros on this new page.

Go and give it a try! :kite:

  • :four_leaf_clover: A macro is basically a sequence of parametric actions that will do something in Mergado that you, as users, can do by yourself, but a well-built macro will do it for you, without error and much faster - and you can run that macro on different exports.

    • Currently supported macro actions are:
      • Create element (and optionally a standard variable)
      • Create query (input and output)
      • Create rule (currently you can create rules such as override, find and replace, hide product, shorten value, change capitalization, round, set UTM parameters, remove HTML tags and calculate. It is not yet possible to create bulk rules - but we plan to do this over time.)
  • :thinking: What is important to note:

    1. A macro is a general formula and as such has no link to any particular export before it runs.
      • Keep in mind that you might be surprised that when you define the Create Rule action, in the list of queries to which the rule applies, there are no queries from any of your existing exports. The rules defined in the macro can only be applied to queries that are defined in the same macro. (And it works the same for other events.)
    2. Once a macro has run over a particular export and has performed the prescribed actions, the macro still has no relation to that or any other export.
      • In other words, the created elements, queries, and rules are not special - it’s like the user created them himself.
  • :candy: The macro can also define parameters that can be used to change the behavior of a macro for a particular situation before it runs over an export.

    • Each parameter has:
      • Name (e.g. Price element)
      • Type (either text, number or element)
      • Default value (e.g., PRICE_VAT)
  • :pizza: Other macro properties:

    • Name of the macro
    • Macro description (GitHub Flavored Markdown can be used to format)
    • Macro language (specifying the language of your macro)
    • Macro format (where you specify for which formats supported by Mergado your macro will be recommended)
  • What to do with the created macro? :four_leaf_clover:

    1. You can run your macros :wrench: over your Mergado exports (in your export, there is a menu link called Macros).
    2. You can share your macros with other users. :nerd_face:
      obrazek
      They can then import it via a link into their own collection of macros :floppy_disk:. And if you then edit your macro, others will know and may have their copy of the macro updated (or they may ignore the changes).
  • :blue_book: Our blog will soon feature articles about macros to help you with this great new feature. :wink:

Keep in mind that the current options in creating and running macros and managing them are just the beginning, and we’d love to hear your thoughts and comments about this new tool after giving it a try. Our goal is to simplify your work in Mergado. :cherries:

:star2: Rule planner

The rule planner tool has been in test insiders mode since November last year. We would like to thank all the insiders who have tested this “feature” and helped us to discover and solve all kinds of mistakes before the launch. Thanks! :heart:

  • New feature! :upside_down_face:
  • :four_leaf_clover: With the rule planner, you can schedule your rules for when to apply and when to skip.
  • Where do I find the rule planner?
    • On the Rules page, there is a new icon for each rule (the rule type must support scheduling) that takes you to its schedule settings page:
      obrazek
  • How does the rule planner work? :thinking:
    • The rule planner has three levels of settings:
      1. As such, the scheduler is either active :white_check_mark: or inactive :heavy_multiplication_x:.
      2. :spiral_calendar: The plan may be limited to:
        1. Date from (inclusive): The daily planner (see next point) takes effect from that date (including this date). You can also choose to apply the rule by default or always skip before that date.
        2. Date to (inclusive): The daily planner (see next point) has an effect until that date. You can also choose to re-apply the rule after this date or skip it after that date.
      3. :timer_clock: A daily planner through which you can set the rule behavior for each day of the week separately. Each day is further divided into six four-hour periods, where you can choose whether or not to apply the rule.

Please note that the rule must be enabled for the planner to do what you want it to do :warning:. The paused rule is not affected by the planner. In other words, the planner cannot force a paused rule to be applied.

  • Example of rule planner setting:
    • For example, you might want to set up a Set a free gift rule to apply only between April 1, 2020 and April 30, 2020 (included), on Fridays only from 12:00 to 24:00, and then all Saturday and Sunday. However, before April 1, 2020, the rule will always apply by default. And then, as of May 1, the rule will always be skipped.

To set up your planner, follow these steps:
rule_planner

Of course, we will also be glad for your feedback about this feature. We are interested in your experience with this tool. :heart:

More news and fixes

  • many other improvements and bug fixes to improve the stability and performance of the platform.

You may notice minor outages of Mergado during the release time. Thank you for your understanding and patience in deploying the new version.

If you have any questions, please contact us.

2 Likes
Get started | Audit XML | Pricing | Help | Blog | Forum | Contact