🌟 News and Releases in Mergado

A new version of Mergado

Deployment date and time

April 6, 2020, 15:30

News and updates

  • :high_brightness: Update: Based on your feedback, we’ve improved a few things about macros.
    • When you filter available macros, you can now display macros for all languages.
    • The view of available macros is redistributed into your macros and public macros.
    • The imported macro is automatically set as unlisted.
    • Many other small things and repairs.
  • Formats
    • We have updated formats for Shoptet.cz :czech_republic: according to news in specification.
    • We updated the specification for an audit of the Zboží.cz format :czech_republic:, where we adjusted the range for valid MAX_CPC and MAX_CPC_SEARCH values.
    • We have modified the RSS format, which we now export with elements with the correct case.
  • Notifications (pop-up messages) in the interface will no longer appear multiple times if they say the same thing. :thinking:
    • We also improved pop-ups in the new export setup guide.
  • :abacus: We improved automatic format detection for Mergado Analytic XML. Now we should recognize it a little better.
  • :candy: We’ve implemented some tweaks in the custom format creation and editing interface and fixed some bugs.
  • Fix: Element value whisperer in the interface did not whisper the 0 value. We fixed this.

Platform News :hammer_and_pick:

In specific cases the widget of the app was sometimes not set to the correct height - the content of the widgets was thus seen “cut off”. This is now fixed.

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.

A new version of Mergado

Deployment date and time

April 29, 2020, 15:30

:sunny: This is primarily a “technical release” with which we improve and modernize the “inside” of Mergado to make our app more sustainable in the future. This release is a milestone with which we are finishing two of our large and long-term projects:

  1. :snake: Complete codebase upgrade of our backend from Python 2 to Python 3.
  2. :floppy_disk: Refactoring of the data structure scheme, in which we represent products from your stores.

:information_source: For standard user work, this version does not change anything except minor fixes.

Other News

Correction of the internal specification of the Shopmania format family - on the Products page, the element for categories will now be displayed correctly.

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.

A new version of Mergado

Deployment date and time

May 13, 2020, 16:00

News

  • :sunny: Macros have received various improvements:
    • Images can now be added to the macro description.
    • Macro search now also searches in macro descriptions.
    • Macros run on a project (export) are now logged in its history.
    • The list of available macros now shows the creation and last modification times of the macro on the macro tab.
    • Paging results when searching for macros was fixed.
  • :star: New feature: Automatic category suggestions for the Rename categories in bulk rule.
    • In this release, we are deploying a completely new component that, using advanced natural language processing algorithms based on the input categories in your feed, can suggest the best possible equivalent category that the target search engine knows.
      We currently support this for the formats :czech_republic: Heureka.cz, :czech_republic: Zboží.cz and :slovakia: Heureka.sk
    • In the Rename categories in bulk rule editor, there is a new “suggest recommended categories” button for supported formats:
      • After clicking, the unique categories present in the input values ​​of your feed will start loading in the background and the suggestions of the correct categories will start to be evaluated, which will then be displayed as options on the right side of the form. This should be very fast for standard use, however for large feeds with a large number (eg with thousands) of categories it may take some time.
    • This is a completely new feature, so we will be happy for any feedback from users! :balloon:
  • :sparkles: We support new formats :serbia: Eponuda XML and Eponuda CSV.
    • The format specification is available here.
    • Example XML format here.
    • Example of CSV format here.
    • We can also audit these new formats.
  • We have fixed the feed audit for Google Shopping. Now we check the product description in the G:DESCRIPTION element and not in the DESCRIPTION element.
  • We’ve improved filtering in the project history. You can now filter events by the user who executed the event.
  • We have improved the behavior of formats for Heureka, which can now recognize and import DELIVERY_ID, DELIVERY_PRICE and DELIVERY_PRICE_COD elements even if they are not uppercase.
  • We’ve fixed a rare spontaneous redirect to the notification page, which should no longer occur.

Insiders :sunflower:

On the Products page, there is a new option for our insiders users to display products in a table.

  • Each line in this view represents one product. The columns represent the names of the elements that are displayed (these can be selected by the user). The values of these elements are then visible in the cells inside the table.

  • The output values can be edited directly in the cells.

  • We also plan to add support for sorting values and exporting selected columns.

We will appreciate any feedback on the table view, to make this feature as useful as possible. :balloon:

Platform :clamp:

  • We’ve updated the conversion tracking code (turning on the app) for Sklik.

  • When an app in the Mergado Store is disabled, we will ask the user if he does not want to leave a rating and feedback.

  • We have added the option to have an app icon in two versions - for light and dark backgrounds.

  • New endpoints for finding out user access rights for a specific project/online store:

    • /users/<user_id>/permissions/eshop/<eshop_id> - to find out the user rights for the given store.
    • /users/<user_id>/permissions/project/<project_id> - to find out the user’s rights for the given project (which are always the same rights as the given user has for the rest of the store to which the project belongs)
    • The answer then takes this form

      {
      “user_id”: 1,
      “eshop_id”: 2, // or “project_id”
      “role”: “writer” // Possible values: ‘writer’, ‘reader’, ‘owner’, null
      }

  • After app is turned off for the project, Mergado will take care of deleting all app rules for the given app, if the app for some reason failed to “clean up” when turning off.

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.

A new version of Mergado

Deployment date and time

May 27, 2020, 15:30

News

  • :sunflower: We added format support for the :czech_republic: UPgates platform.
    • Format specifications available here.
    • Audit of this format is in the making.
  • :sparkles: We have optimized the application of rules for large projects.
    • We analyzed cases in which for large projects the application of rules has worked with products inefficiently.
    • This was most evident in projects with hundreds of thousands of products and tens to hundreds of rules, many of which target output queries.
      Based on these analyzes, we have implemented improvements that should significantly reduce the overall duration of the application of rules in these extreme cases :hourglass:
  • :straight_ruler: UI news: In several places in the interface - where it can be useful - the rules and queries now show icons that let you know at first glance whether the queries are on input or output.
    • Example from the Rules page:
      • icon1 - the rule is targeted only at queries on input.
      • icon2 - the rule is targeted at queries on input and output.
      • icon3 - the rule is targeted only at queries on output.
    • This can make it much easier for users to optimize rule settings - which has a direct impact on how long a project will take to apply rules to a project.
      You can read more about this topic in the article on our blog: Set Mergado effectively #1: Queries to input values.
  • :ribbon: Another update for the Rename categories in bulk rule.
    • You can now insert multiline text in the left column of the categories, which is then correctly divided into new lines.
      • This works for plain text, but also for copied lines from Excel or CSV. If you copy two columns in this way, even these copied values will be correctly divided into left and right columns. :balloon:
      • copy-paste
  • :adhesive_bandage: We’ve fixed some cases where MQL did not handle special characters in element content - for example, it was not possible to properly search for the content of an element with multiline text inside the multiline content of another element. This has been fixed and it is now possible.
  • We’ve updated the format for Google Shopping, which stores the product description in the G:DESCRIPTION element, not in the DESCRIPTION. This is also taken into account by our format converter.
  • Improved work in the UI: The modal window for editing values ​​for conditions is included / not included in the list now has better visible buttons even on smaller displays.
  • :hammer_and_wrench: We’ve fixed the Data file Import rule whose application ended in error if the URL where the source CSV is to be located contained a completely empty file. Newly, in such a case, the rule will do nothing.
  • We have updated the Glami format, which now supports the Set product parameters and Set shipping price rules for all language versions :earth_africa:.
  • We have added basic support for Iceland (e.g. its currency).
  • We’ve devoted a lot of time to stabilize the Mergado infrastructure.
  • And a number of other minor fixes.

Insiders

  • :candy: For our insiders, we have also prepared a supplement to the updates in the UI.
    • Above the list of rules on the Rules page, you can see the new Show rule series checkbox, which can be used to enable visual differentiation of individual rule series.
    • According to these series, when applying the rules, Mergado “splits” the current list of rules - and such series must then be processed in series - one after the other.
      • This “chopping” has always happened in the background - but thanks to this new tool, it is possible to clearly see how Mergado really plans to apply the rules.
      • The general rule is that the fewer such series in a project, the faster the process of applying the rules.

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.

1 Like

A new version of Mergado

Deployment date and time

June 10, 2020, 15:30

News

  • :star2: We have created a new global format called :earth_africa: Plain CSV, which can be used to import and export any CSV to and from Mergado.
    • If the user creates a project where the Plain CSV format is input and output, Mergado becomes a universal tool for processing CSV files.
  • :balloon: We have upgraded the rule for data import in cases where the input CSV is loaded directly into Mergado.
    • BOM files can now also be uploaded to this rule.
    • We should also be able to better upload files from the macOS system, for which this rule has sometimes had a problem.
  • We support a new format :czech_republic: UPgates Categories.
  • we have better adapted the format for :hungary: Árukereső.hu to the current specification.
    We now also support setting product attributes:
<Attributes>
	<Attribute>
		<Attribute_name>Típus</Attribute_name>
		<Attribute_value>Fejhallgató</Attribute_value>
	</Attribute>
	<Attribute>
		<Attribute_name>Vezeték nélküli</Attribute_name>
		<Attribute_value>Igen</Attribute_value>
	</Attribute>
</Attributes>

… which can be newly managed in Mergado using this notation:

[ATTRIBUTE|Típus] = "Fejhallgató"
[ATTRIBUTE|Vezeték nélküli] = "Igen"
  • :flying_saucer: We have modified the format behavior for :czech_republic: Shoptet.cz regarding hiding elements that do not meet the specification.
    • Previously, even in Mergado, we automatically hid unhidden elements when exporting the final feed - elements outside the specification did not get into the feed, because such a feed is then invalid for Shoptet.
    • This behavior is still preserved, however - so that this mechanism is not too magical for the user - when applying the converter to the Shoptet format, elements that the specification does not know are automatically marked as hidden (which is then visible at first glance, for example on the Products page.)
  • :wrench: We upgraded the format for :czech_republic: Alza.cz:
    • We now always export the PRICEWITHFEE, PRICEWITHOUTFEE, RECYCLEFEE, COPYRIGHTFEE, CURRENCY, COPYRIGHTFEE, and CURRENCY elements with a decimal point.
    • For the STOREDQUANTITY element, only the integer part is now always exported.
    • From now on, we hide elements that the specification does not know (as with the Shoptet format).
  • :hammer_and_pick: We fixed the behavior of duplicating a project, which previously duplicated the rules for apps (which, however, do not automatically turn on when duplicating a project for a new project). This will no longer happen.
  • When sending audit results, the language of e-mails now takes into account the user’s language setting, if known.

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.

1 Like

A new version of Mergado

Deployment date and time

June 24, 2020, 15:30

News

  • :star2: The component for automatic category suggestions (the Rename Categories in bulk rule) has received further improvements.
    • The proposed categories are newly returned without a root category (e.g. Heureka.sk |), which is now consistent with how we suggest the categories. When selecting an incomplete category, clicking on the field already activates the whisperer and the selection of the final category is now more user-friendly.
    • :candy: We’ve added a filter box that lets you choose whether to display:
      1. Only those rows whose value in the left column is not in the input feed.
      2. Only those rows whose values in the left column overlap in such a way that the value in the lower row overrides the effect of the row that is higher.
        • E.g., the value on line no. 1 is Baby Goods | Toys | Board games | Board games, and the value on line no. 3 is Baby Goods | Toys. Because the Rename Categories in bulk rule always processes all rows and does not stop after the first match, the 3rd row overwrites the effect of the 1st row as a result.
          • With this filter option, the two lines will be displayed and you can resolve any unwanted conflicts.
      3. Only those rows whose value in the right column is not in the known category tree for the given format.
  • :mag: In the search field on the main page, projects can now be searched by input or output URL.
  • We have improved error messages when manually creating elements (and their variables) so that they are more informative (e.g. the user will learn if it is not possible to create an element due to the fact that there is already a variable name that this element should get).

Platform

  • :earth_africa: We’ve added the ability to support all formats for project-related apps.
    • Now, the project-related apps that “don’t really care” about the project format will be able to set that they support “All formats”.
    • In such case, it will be possible to run the app over any project - including projects that use a custom format.

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.

1 Like

A new version of Mergado

Deployment date and time

July 8, 2020, 15:30

News

  • :high_brightness: In Zboží.cz format, we have started to support element CUSTOM_LABEL_3.
  • :sunflower: We’ve actualized the format Mergado XML to match the latest specification in version 1.8, and we have taken into account these changes in converters to other formats.
    • Newly supported elements: COST, COST_VAT, STOCK_QUANTITY and multiple BENEFIT.
    • At the same time, we revised the converters to other formats and expanded them to support other well-known elements:
  • :eight_spoked_asterisk: We have updated the formats Shoptet supplier a Shoptet complete according to the current specification.
    • Element changes:
      • INFORMATION_PARAMETER can have multiple values, e.g. [INFORMATION_PARAMETER|Color|1] = 'Red'
      • We support element SURCHARGE_PARAMETER, e.g. [SURCHARGE_PARAMETER|Imprint|DESCRIPTION] = 'Label' or [SURCHARGE_PARAMETER|Imprint|VALUE|Black and white] = '100'.
      • Element creation support WAREHOUSE under STOCK.
      • Shoptet supplier: Extended by a multiple element GIFT, STOCK|AMOUNT and PURCHASE_PRICE.
      • Shoptet complete: Extended by elements PART_NUMBER and PRODUCT_NUMBER.
    • The generated output feed has the correct order of elements.
    • We have also taken these changes into account in our XML audit.
  • :candy: Selection of pairing elements when creating a new project is nicer and more user-friendly.
  • Lots of other minor changes and fixes.

Insiders

  • We continue to improve the functionality and design of the product spreadsheet.
    • Fullscreen is now optional.
    • We’ve added the option to move columns with drag&drop.
    • Fixed bug: An empty element can now be edited and saved.

Platform

  • :cherries: An app developer can now specify for each rule of his app in Developers which elements will be sent to his rule in JSON payload for products. There are three modes to choose from:
    1. :turtle: Send all elements (default)
    2. :rabbit2: Do not send any elements - for the product, in JSON, under the date key, in which there would otherwise be a dictionary containing pairs "element name": "its value" will send an empty dictionary. So, for example, instead of "data": {"ITEM_ID": "123", "NAME": "Rocket", "DESC": "Really good."} will only be sent "data": {}.
    3. :owl: Send only elements containing a regular expression - only those elements whose name this regular expression contains itself will be sent.
      • For example, based on the regular expression PRODUCT|ITEM|VAT only the elements PRODUCT, PRODUCTNAME, ITEM_ID, ITEM_GROUP_ID, VAT, PRICE_VAT, etc. will be sent.
  • :warning: If the rules of your app need only some elements (e.g. ITEM_ID,or even just the internal Mergado product ID), we strongly recommend using these mechanisms.
    • Thanks to the fact that unnecessary data will not be sent unnecessarily, work will be saved for both parties and, according to our benchmarks, in certain cases the application of the rules can be significantly accelerated :racing_car:.

You may experience minor Mergado outages at this time. Thank you for your understanding and patience in deploying the new version.

If you have any questions, do not hesitate to contact us.

A new version of Mergado

Deployment date and time

July 22, 2020, 15:30

News

  • :sunflower: We support a new Dutch format :netherlands: Kieskeurig.nl.
  • :candy: New nice clicker for selecting pairing elements when creating and editing a project.
    • pairing_new
  • :high_brightness: We’ve improved error reporting when applying rules.
    • In the case of an error occurring during the processing of a specific rule, we now notify the user directly within which specific rule the error occurred, with the option to click directly into the rule if the rule can be modified (if not, the link will point to the rule list page and rule with error will be highlighted).
    • error_log
  • :sunflower: Improvement: If we detect the use of a non-existent variable when applying the rules, we end the process immediately and give the user information about in which rule it happened and which non-existent variable it is.
    • Previously, the process of applying rules was silently ignored by a non-existent variable (and an empty value was substituted for the variable), which could be a potential problem due to possible impacts on the resulting feed.
    • missing_variable
  • For several other email notifications, we have corrected the language in which they are sent to match the user’s language.
  • :hammer_and_pick: Data import rule: If the URL of an external data file is specified for the rule, there is now a new icon next to the URL field, which will open it in a new window.
  • Other minor fixes and improvements.

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

A new version of Mergado

Deployment date and time

August 5th, 2020, 15:30

News

  • :high_brightness: We support a new format: :czech_republic: QuarticOn.cz
  • We have added support for auditing the format :netherlands: Kieskeurig.nl, both XML and CSV.
  • We have extended support for existing formats to other countries :earth_americas:.
  • :postal_horn: We have consolidated email addresses for messages sent from Mergado.
    • We now use different email addresses to send different types of emails:
      • Regular notifications are now sent from notifications@mergado.com.
      • Notifications of (completed) audits are now sent from audit@mergado.com.
      • Emails regarding account management (registration emails, password recovery, access to the online store in Mergado, etc.) are now sent from accounts@mergado.com.
  • :sunflower: In the improved selection of pairing elements, which we introduced in the latest version of Mergado, you can now enter “pairing” elements that do not yet exist.
  • :green_apple: We fixed Keychain messages when entering invalid credentials. We inadvertently displayed a general “unknown error” message there for some time.
  • Other minor bug fixes and improvements.

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.

A new version of Mergado

Deployment date and time

August 19, 2020, 15:30

News

  • :green_apple: New rule type Remove Diacritics!
    • This rule removes diacritical and other characters in the text and replaces them with equivalents from “standard” latin script (de facto English alphabet, i.e. characters defined by the table ASCII).
      • Example:
      • äöü ÄÖÜß őñô çģ ęāăğ łø țżè đħơ will be converted to aou AOUss ono cg eaag lo tze dho.
    • Symbols of other languages, such as Chinese or Japanese, are transliterated.
      • E.g. 北亰 will be converted to Bei Jing
      • Unfortunately, the conversion of such complex systems into Latin will never be completely perfect. :cold_sweat:
  • :sunflower: We have added support for new formats:
  • :hammer_and_pick: We fixed a serious bug in the converter to the Shoptet format, due to which new multiple elements were created when the converter was repeatedly applied.
    • This caused a gradual massive degradation of performance in the projects concerned.
    • This will not happen anymore. :high_brightness:
  • :eight_spoked_asterisk: We fixed an unhandled state for the Find and Replace rule, where an empty value of a variable that was used as a search expression caused completely unexpected results for it, as well as a possible subsequent crash of the entire rule application process.
  • Lots of other fixes and minor tweaks in the UI. :candy:
    • E.g. the graphs sometimes showed “truncated” numbers on the axes, which is now fixed.

If you have any questions, do not hesitate to contact us.

A new version of Mergado

Deployment date and time

September 3, 2020, 15:30

News

  • :apple: The find and replace rule is now multiline!
    • Instead of splitting more complex replacement rules into a large number of separate rules, only one replacement rule can now be used. :sunglasses:
    • :thought_balloon: When applied, the lines are scrolled from top to bottom and the changes are evaluated gradually over all (i.e. the change defined by line no. 2 is applied even if something has already been found and replaced in the previous line no. 1).
  • :yarn: We now support the Modio/Modisimo search engine format.
    For these countries: :czech_republic: Czech Republic, :slovakia: Slovakia, :poland: Poland and :uk: United Kingdom.
  • :pill: We have added support for the new Pilulka.cz Marketplace XML format.
  • We’ve updated the formats for :world_map: Google and Facebook to their latest specifications.
  • :hammer: We’ve revised the Mall Marketplace format and updated it to the latest specification.
  • :memo: For projects converting feeds from Heureka to Favi, element values for alternative images were incorrectly rewritten. This is now fixed.
  • :money_with_wings: We’ve added support for the Set shipping rates rule for our Mergado XML format.
  • To avoid inattentive errors when creating a custom format, we now ask for confirmation :ballot_box_with_check: if a user selects a file type different than the one found by the feed analysis.
  • :gear: If the user manually cancels the operation of processing the feed (i.e. importing data, applying rules, or exporting data), information about it will now be stored in the project history (until now, this canceled operation appeared to have been canceled by Mergado).
  • :card_file_box: UI: The number of currently present products in the project is now displayed on the left side in the dashboard on the Overview page of the project.
    • Previously, the number of products uploaded during the last import was displayed here, which meant that if the import ended with an error, zero was displayed here. This is now being addressed.
  • The General view of the Products page no longer displays information obtained from hidden elements. :face_with_monocle:
  • :racehorse: We added whispering of element names for Slovak :slovakia: Google Shopping when creating new elements.
  • :partly_sunny: We fixed a bug that in certain rare situations, some products might not be automatically re-generated during auto-regeneration - even though they changed on input on the last import - until the input changed again.
  • We handled rare situations where when saving a rule form, their multiline entries could be saved in the wrong order. :sweat:
  • And other minor improvements and fixes…
    • For example, here and there we have fixed errors and typos in translating Mergado’s interface into other languages.

Platform

In the https://api.mergado.com/projects/<project_id>/queries/ endpoint, we no longer display anonymous (and therefore temporary) untitled queries.

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.

1 Like

A new version of Mergado

Deployment date and time

September 14, 2020, 15:30

News

Platform

  • We now repeat HTTP requests in the direction of apps (events or rules) even when the response is returned with the 404 HTTP code.
  • When entering a URL for custom storage for apps, we now validate the value as a URL.

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.

A new version of Mergado

Deployment date and time

September 30, 2020, 15:30 GMT+2

News

  • We support a new format - :de: Moebel24.de CSV.
  • We have added Balikovna to the Set shipping rates rule for the :czech_republic: Zboží.cz format.

Bugfixes

  • In the :world_map: Google Shopping format, the LINK element has occasionally emptied. It’s fixed now.
  • We fixed possible crashes when uploading CSV files to Mergado that did not have utf-8 encoding.
  • We fixed a minor bug with duplicate rows in the Find and Replace rule.
  • :wrench: Other minor fixes and improvements.

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.

A new version of Mergado

Deployment date and time

October 15, 2020, 15:30 GMT+2

News

  • We support new formats:
  • We have revised the :poland: Ceneje.pl format and updated its specifications.
    • E.g., we’ve added wrapping to CDATA for elements that require it.
  • We no longer export these elements from Mergado for the UPgates output format:
    • PRODUCT_DISCOUNT_REAL, PRICE_WITH_VAT, PRICE_WITHOUT_VAT, CURRENCY, PRODUCT_ID and VARIANT_ID.
  • :candy: In the Find and replace rule, an “annoying” space was being added after the selected whispered variable, which then affected the search for the term. This is now fixed.
  • :hocho: When importing input data, we will now ignore elements with attributes that have values that are too long - and merge such elements into a single element without attributes.
    • Specifically, if, for example, the name of the element_name(attr1=value1;attr2=value2)|number element exceeds the length of 100 characters, we import the element in the form element_name|number.
    • Elements above 100 characters in length have so far been imported truncated and have caused errors when exporting the output feed. :sweat:
  • :gear::heart: We’ve spent a lot of time exploring ways to optimize Mergado’s collaboration with third-party apps when applying rules.
    • The results are promising and, according to our benchmarks, this update can significantly speed up the application of app rules and our input/output format converters.
    • :green_apple: According to our measurements, the rate of acceleration improved in some cases by a factor of 10, however, it depends on many parameters (e.g. the location of the app or converter rule in the list of rules or whether there are any rules aimed at output queries before these rules).
  • :wrench: Other minor fixes and improvements.

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.

A new version of Mergado

Deployment date and time

October 29, 2020, 15:30 GMT+2

News

  • :star2: We learned how to import and export from Google Sheets.
    • To import data, use the URL of your spreadsheet and enable sharing. The resulting export will then allow you to upload your feed to Google Drive. You can find out more in the article we are currently preparing for you. :green_apple:
  • We have created new, updated formats for all language versions of the Shopalike CSV format.
  • :apple: Two new product listing options have been added to the Products page:
    • Only monitored products.
    • Only hidden products.
  • New projects with formats Spartoo.at, Designforumshop.de, Pricerunner.de and Pricerunner.at will no longer be available to be created, because they don’t exist anymore.
  • Events where a rule has been modified by a third-party app will also be recorded in the project history. :clamp:
  • :gear: We have optimized the retrieval of random values of elements that are used to test regular expressions when creating or modifying variables.
  • :gear: We have optimized the downloading of element values to CSV for large projects - for elements with hundreds of thousands of values, this could sometimes be an error.
  • On the Elements page, in addition to the number of unique output values, each element also has a new number of unique values at the input.
  • The main page with an overview of shops now shows the input and output format and the number of active rules for each project.
  • It should no longer happen that - although the products really are in Mergado - the number of imported items is displayed as zero on the project dashboard.
  • :toolbox: After saving a selection on the Products page, the number of items in that selection may not be displayed. This is now fixed.
  • :hammer_and_wrench: We have fixed the duplication of the project, which did not have to be completely successful if there was a rule to find and replace in the project.
  • :ribbon: We have fixed a bug in custom format converters, that could cause new elements to “multiply” in the project each time the rules are applied. :cold_sweat:
  • :candy: We have spent time on further optimizations - this time we focused on the export process.
    • It should be faster and more stable when processing projects that have many (tens of thousands, hundreds of thousands) elements, if they have an empty value for individual products.
  • We examine the causes and possible solutions to infrastructure problems that have recently begun to emerge.
  • And other minor improvements and fixes.

Audit news :spiral_notepad:

  • In addition to the feed audit link, we’ve added a new image audit link to the sidebar.
  • The feed audit now supports the &gt; entity as a valid category delimiter for G:PRODUCT_TYPE element.
  • We can now also audit feeds secured via přes basic HTTP authentication (jednoduché ověření přístupu).
    • Which means we can now process feeds with a URL in the form of https://name:password@www.some-shop.com/feed.xml.
  • A number of texts concerning the results of audits have been modified and corrected.

Platform :wrench:

  • At the endpoint /shops/<shop_id>/stats/sources/ we now provide four new types of sources:
    • shop_reviews_export_url
    • product_reviews_export_url
    • shopping_cart_overview_report_url
    • shopping_cart_stats_report_url
  • When editing a rule via the API, this event is newly written to the project history.

If you have any questions, do not hesitate to contact us.

A new version of Mergado

Deployment date and time

November 11, 2020, 15:30 GMT+2

News

  • :star2: We support new formats:
  • :candy: Improved UX: Smart copy-pasting of multiline values from the clipboard is now supported by the Rename values in bulk rule. :star_struck:
  • :spiral_notepad: Online stores in Mergado now have their own History page.
    • Important changes concerning the online stores themselves will be recorded here.
    • For now, we’re recording information about these events:
      • Create a project, delete a project, enable a project, and disable a project.
      • Creating a connection in the Keychain app, deleting the connection in the Keychain app.
      • Sending invitations to access the online store in Mergado.
      • Enabling and disabling apps tied to the online store.
  • :abacus: We’ve improved the export to Google Sheets, which now accepts sheet names in another language (e.g. Hárok1 instead of Sheet1).
  • :articulated_lorry: We fixed an issue when calculating the cheapest transport option included a zero value. Transport with a value of 0 will now be evaluated as the cheapest option when converting to another format.
  • :cherries: We have improved the format converter in cases where the output element can be populated from multiple candidate elements on the input.
    • The value of the first non-empty candidate element is now used. Previously, only the first candidate was used, although it did not have to contain that value (but another candidate may already have had a value).
  • :hammer_and_wrench: Bugfix: If the attribute value of an element contained a vertical bar |, which Mergado otherwise uses as a separator of multiple and embedded elements, such an element caused errors when exporting the output feed. We are now removing verticals in attribute values to prevent errors.
  • Custom format bugfix: Although the user could have set the custom format definition to "hide" an input element, this was not the case :frowning:. From now on, such an element will really be hidden.
  • :information_source: We’ve added a notification to the Rename Categories in Bulk rule to alert you to a higher risk of discrepancies when trying to automatically design categories based on input categories in a language other than the one used in the output format.
  • Other minor fixes and improvements.

Platform :wrench:

  • UI: The top bars with notifications from Mergado will no longer “push down” the IFRAME viewport of an app.
  • The following news is in Mergado Developers:
    • Vendor texts (description, website, banners, etc.) are now localizable - they can be entered for different languages that Mergado supports in the UI.
    • Small banners Get the app in the Mergado Store are now prettier and available for more locales: cs_CZ, sk_SK, pl_PL, en_GB, de_DE, hr_HR, hu_HU, sl_SI, sr_RS.
  • A new endpoint https://api.mergado.com/eshop/<id>/eventlogs/ is available in the API. This endpoint is where selected events that we recorded at the online store are available.
  • Mergado Store: The rating tab on the app detail is now always displayed. If no rating exists yet, the user will be prompted to add one.

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.

1 Like

A new version of Mergado

Deployment date and time

January 13, 2021, 15:30 GMT+1

News

  • :star: We have improved work with the Plain CSV format, which is now supported by the format converter. So now Plain CSV can be used with other formats on input or output.
  • For the prices of items in the custom format, we can now read the prices written “in another order” - so we can read the CURRENCY 123.45 form if the price could not be read in the standard form 123.45 CURRENCY.
  • :truck: When processing shipping prices, the converter rule for some formats considered the zero shipping price to be undefined. Now the zero shipping price is converted to the true zero shipping price.
  • :speedboat: Optimization of the converter rule if a custom format is used at the project input.
    • For custom format projects that also had many elements (thousands, tens of thousands, and more) the converter was very slow. We have investigated this specific case of inefficient application of the converter rule and implemented changes that solve it.
  • :adhesive_bandage: In some rare cases we may have misidentified whether a project should export (or skip) the output feed. We fixed this.
  • :spiral_notepad: On the Elements page, you can now sort elements by the number of their values (both input and output).
  • Notification bars at the top of the page that inform users about various events can now have different background colors, depending on the importance of the event.
  • Feed audit:
    • We can now audit the format :hungary: Árukereső.hu.
    • We performed cleanup in certain validators and improved their descriptions.
  • We improved UI localization in different languages.
  • Other minor fixes and improvements.

Platform :wrench:

  • :cherries: In certain situations, due to an HTTP error when sending webhooks to apps, the error may have been incorrectly logged. We fixed that.
  • MAIA contains a new method setAppTitle(), through which the app can modify the title of the page, within which its main IFRAME viewport is displayed.
  • :spider_web: We fixed the generation of a sitemap file for the Mergado Store for better discoverability of apps in internet search engines.

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.

A new version of Mergado

Deployment date and time

January 27, 2021, 15:30 GMT+1

News

  • :star2: We have implemented the latest changes to our :mergado: Mergado feed specifications.
  • :currency_exchange: Again, we’ve improved the way we read currency from price elements when converting formats. As a result, we will reprocess the price containing non-ASCII characters - such as or $ - correctly.
  • :information_source: We’ve added new information bars that inform users about the upcoming end of the trial period, or about issued invoices.
  • :spiral_notepad: the Data file import rule: When uploading a CSV file, we may have inaccurately detected the mimetype of the file as text/html, if the CSV defined values containing HTML elements (e.g. the file defined HTML content for the CSV DESCRIPTION column). In this case, we notified the user that it was not a CSV file and the rule could not be saved. We have removed this specific restriction.
  • :adhesive_bandage: We fixed the custom format editing form in which the saved mapping for DELIVERY and PARAM elements is correctly displayed.
  • :candy: UI: Information about the current tariff is now displayed in the information box on the online store main page with the list of projects.
  • :lollipop: UI: Long values in graph tooltips were sometimes truncated too soon. They will now look better.
  • Added a number of missing translations for different languages for UI and for notification email texts.

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.

A new version of Mergado

Deployment date and time

February 10, 2021, 15:30 GMT+1

News

  • :old_key: Keychain: If your Google Analytics account managed more than 1000 profiles, we didn’t display some of them when connecting to GA. We have solved this and we now display all profiles.
  • :candy: On the Products page, we fixed a bug in switching the view of tracked and hidden products.
  • :apple: Custom format: We continue in :mag: exploring and :broom: cleaning up “bad” edge cases.
    • We focused on situations when the combination of custom format (on input) vs Shoptet format (on output) could lead to the fact that each time the converter rule was applied to the project, new and new elements were repeatedly created. We have now fixed this. :cherries:
    • Another update is that if the project contained multiple elements (e.g. GIFT|1, GIFT|2, etc.) to be exported (i.e. not hidden), but such elements were not known to the output custom format, the export ended in error. This is fixed and now such “unknown” elements are exported correctly. :watermelon:
  • :hammer_and_pick: Format converters: We have handled various places in format converters where an error could have occurred if the name of the element being processed contained more | vertical bars than the converter expected.
  • :candle: On the Project Settings page, we added the option to select Google Sheets as feed generator :spiral_notepad: .

Platfrom

  • :chart: On the app’s Overview page (in Mergado Store), we now load the number of running instances and the status of estimated sales asynchronously. This should reduce the occurrence of situations where for some reason we do not have time to calculate the data, and at the same time do not block the page loading.

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.

1 Like

A new version of Mergado

Deployment date and time

February 2, 2021, 15:30 GMT+1

News

  • :star2: Redesign and new features on the Products page.
    • The part of the page with settings for different views on products has undergone a facelift and is now beautiful. :heart_eyes:
    • :watermelon: New features were published!
      • Product sorting
        • Products from the current query can now be sorted according to the selected element (for input queries, the input value of the element is used for sorting, for output queries its output value).
        • Sorting is not part of the query as such (i.e. sorting does not affect, for example, the order in which the rules are applied to the products in the query), it is just a way of displaying the results.
      • Export to CSV for the table view.
        • Only the elements of the selected columns are saved in the CSV.
  • News about formats :sun_behind_small_cloud:
    • :hammer_and_wrench: We support the new Idealo CSV format
      • Specifications here.
      • In addition, we have updated the current Idealo XML format according to the current specification.
    • It will no longer be possible to create projects with the input formats Scontofacile.it (service has expired) and Designforumshop (service has expired). :thinking:
  • :information_source: At the top of a page within the project (export), we now display a warning message about non-passing import or application of rules, if these processes have ended 2 or more times with an error in the last 24 hours.
  • :rainbow: We have improved the component for suggesting variables and values in the rule for bulk rewriting by values. At the same time, we corrected the bugs in highlighting, which may have occured in some edge cases.
  • :mailbox: We have improved the pasting of multiline values from the clipboard in the Rewrite, Bulk rewrite by values and Rename categories in bulk rules, where we now better recognize and insert values representing a regular expression.
  • :candy: A button to download the list as CSV has been added to the Elements and Variables page.
  • Data File Import Rule: When uploading a CSV file via a form, for “more exotic-looking CSV files”, we may misidentify their mime-type - and not allow such uploads. We have recently expanded the list of supported mime-types to eliminate these “false negative” situations as much as possible.
  • We fixed the incorrect behavior of the converter from the custom format in the case when the input is missing elements representing IMAGE elements.
  • We have removed the word XML from the subject of notification e-mails - Mergado has long been able to process other data files than just XML.
  • Minor improvements in process names and breadcrumb navigation under Project History.
  • Lots of other minor fixes and improvements.

Platform :wrench:

  • :national_park: The app image for social networks, defined by the meta property = "og: image" element on the app detail page in the Mergado Store, can now be set for different locales.
    An online store’s avatar URL field has been added to the online store information (e.g. GET http://api.mergado.com/shops/123456). :camping:
{
  "id": "123456",
  "name": "Some e-shop name",
  "owner_id": "1",
  "exported_items": 80000,
  "tariff_id": "2",
  "tariff_validity": "2022-10-31",
  "paid_tariff_id": "2",
  "created_at": "2020-09-17T12:29:42+00:00",
  "permissions": [],
  "avatar_url": "https://app.mergado.com/upload/8787f44a7f7da538ded3d7fc8d6bf7f3.png"
  // Or "avatar_url": null, if the online store does not have an avatar set.
}
  • :fried_egg: Added support for variables in URL rules - can be set in the rule administration of your app in Mergado Developers.
    • The known placeholders/variables that wrap in the URL in {curly_braces} are as follows:
      • project_id: Project ID.
      • apply_log_id: ID of the apply_log
      • rule_id: Rule ID
      • request_id: A random identification string unique to each request.
      • item_count: Number of items in the currently sent payload.
      • current_format: Current format - here it depends on whether the app rule is before or after the format converter rule.
    • Example of a newly valid URL: http://some-app.com/rule/{project_id}/{rule_id}?logId={apply_log_id}

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.

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