🌟 News and Releases in MERGADO

radim · June 8, 2022, 1:03pm

A new version of MERGADO

Release date and time

June 8, 2022, 15:30 CEST

News

The audits for Shoptet.cz and Shoptet.sk formats XML and CSV have been significantly updated.
For the Google Sheets format, which exports directly to Google’s online spreadsheet processor, we have corrected the output URL displayed on the project overview. It now again leads to the address in Google Sheets.
on the Products page, we were displaying the wrong icon (we took the icon by input format, which is wrong - it should be taken by output format) for the product card click-through in the product finder. This is now fixed.
There is another round of research into possible optimizations - with the goal of speeding up MERGADO’s feed processing.
UI: On the Project History page, we were displaying irrelevant items in the event type field. We have fixed this.
downloading CSV with products from the Products page should now be more robust for projects with a high number of items.
UI: For the infobox on the main online store overview page, the discount** associated with the length of the billing period is now displayed alongside the length of the billing period.
UI: For icon-buttons tightly bound to the input field, we’ve expanded the size of the clickable area.
And a number of other minor fixes and improvements.

Platform

For MERGADO 2 projects, we fixed filtering of elements that the app defined that it wanted to send when applying rules.

You may experience some minor MERGADO downtime at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

radim · June 23, 2022, 6:05am

A new version of MERGADO

Release date and time

June 22, 2022, 15:30 CEST

News

Audit News:
- The audits for the Mall Marketplace formats have been significantly updated.
- We have also updated the audit for the format Kaufland.de (Angebotsdaten)
We now check for the presence of the mandatory handling_time element and deselected the shipping_group, delivery_time_max and delivery_time_min elements as mandatory.
We have updated the converters for different formats:
- Zbozi.cz now knows the LIST_PRICE element.
- Google Ads Dynamic Remarketing now knows the Item subtitle element.
- MALL Marketplace will have the value listed in the WEIGHT element without the “kg” unit.
- Google formats:
  - If delivery_days > 3 is detected in the input value, the value backorder appears in the output of the g:availability element.
  - If delivery_days <= 3 is detected in the input value, the value in_stock appears in the output of the g:availability element.
Improved the logic for automatic detection of the input feed format. The new project creation wizard should now pre-select more relevant formats than before.
UI: We added fuzzy search in the various input fields to select a specific value through the UI - this means that the user does not have to enter the exact text of the value to find it, but just some letters (which don’t even have to be consecutive) for example.
For example, to quickly search for the format Google Shopping [us], just enter gous in the field.
UI: We fixed an error that occurred when the user entered unexpected input into the date input field (e.g. on the Project History page).
UI: We fixed the alignment of the macro sharing icon.
And other minor fixes and improvements.

You may experience some minor MERGADO downtime at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

radim · July 20, 2022, 11:30am

A new version of MERGADO

Release date and time

July 20, 2022, 15:30 CEST

MERGADO comes with a new feature, in which we switch from a linear data representation system to tree-based data organization of products (i.e. Tree Based Products, TBP for short, as our smart developers call the new system internally), with the goal of significantly expanding MERGADO’s capabilities. We call this new feature MERGADO 2 and you can learn more about it in an article on our blog.

News

In the create a new project wizard there is now an option to create an experimental MERGADO 2 project.
MERGADO can now load input feeds over HTTPS even with an incorrectly set certificate.
Gone are the days when an incorrectly set TLS/SSL certificate from your infrastructure provider prevented you from using MERGADO.
If MERGADO detects an error in the HTTPS certificate settings when downloading the input feed, we still download the feed and import it - in which case we display a warning on the project overview page with any details of the detected error (e.g. the certificate has expired, or perhaps that the URL with https://... in the background redirected to the insecure protocol http://...).

A poorly set HTTPS certificate on your web server may mean that data traffic between your server and MERGADO will carry a risk of eavesdropping by third parties. We strongly recommend that you have your HTTPS certificate set up correctly.

We support a new format: Facebook CSV.
- and it is also supported by Feed Audit .
We’ve updated the spec for the Emag.ro format and its audit.
For more complex input XML feeds, the estimate of the number of products in the feed could be too different from the actual number of products in the feed in the new project creation wizard. The estimation mechanism has been improved.
On the user’s custom formats listing page, we added a new column to indicate which type of files (.xml, .csv, etc.) the custom format is for.
The error when creating an element that would automatically create a variable whose name conflicts with an existing variable, we now display the correct error message.
and a large number of other minor changes and fixes.

MERGADO 2

MERGADO 2 is now in public beta.
For MERGADO 2, we have added support for the following formats: Kieskeurig, Kuantokusta, Mailkit, Miinto, Modemi, Moebel, Mojinterier, Mojoutfit, Monitor, Monitorcien, Nextag, Pricegrabber, RSS, Shopzilla, Srovname.
Speed: Since we were aware that complex products (i.e., products with a high number of nesting) in MERGADO 2 exported very slowly when we exported the output XML, we gave it a closer look…
- The result of our investigation is optimization, which as a result means a multi-fold speed boost in the export process of the output XML feed (the more complex the structure of the exported products, the greater the speed boost compared to the previous state).
UI: We have improved the mechanism for highlighting paths to elements available in various input fields in the UI.
We have improved the mechanisms for hinting element values in various fields in the UI.
- The whispering is triggered by typing (or deleting), and the dropdown can be hidden using the ESCAPE button.
- The whispering is based on the nesting, i.e. for example after PARAM | the Heureka.cz format will whisper PARAM_NAME and VAL.
We have added support for displaying warnings that can occur for individual products when applying rules (e.g. that the path to the target element overwrites multiple values instead of the expected single element value - which can occur for multiple elements if the path to the element does not specify the target position/index of the element).
- Warnings from the last successful application of the rules will be visible in the UI for that product on the Products page.
- A listing of all warnings can be found by clicking on the rule application record in the project history.
- For the most recent rule application, warnings will also appear on the project dashboard.
We have optimized the mechanism for exporting CSVs with product data on the Products page to be able to download CSVs with many products (e.g. 100k or more products).
when displaying product changes during rule application, we have improved the display of the paths to the elements and attributes affected by the changes.
We have fixed situations where, when using element path as a variable in rules, the specified path to the element value was not processed correctly when applying rules.

Please note that MERGADO 2 projects will be charged for as of this release according to the standard price list.

You may experience some minor MERGADO downtime at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

radim · October 6, 2022, 7:53pm

A new version of MERGADO

Release date and time

August 8, 2022, 15:30 CEST

News

A new rule type was added for MERGADO 2: Add value to a multi-value element.
This rule can be used to add a new value to a multi-value element (such an element must of course be already defined in the schema - i.e. in the element list - of the project).
We have added support for additional language versions of the Google Ads Dynamic Remarketing format:
- Poland,
- Germany,
- Hungary,
- Romania,
- Denmark,
- Greece,
- Finland,
- France,
- Italy,
- Netherlands,
- Spain,
- Switzerland.
XML specification for Google formats was updated.
We fixed a bug that could occur when creating a new project that requires a connection to Keychain to work.
Macros: We fixed a bug that caused repeated executions of the same macro to fail if the macro contained a Create Rule action.
For new projects with the Plain CSV output format, the .* is now the default value in GA source setting (and no longer the string plaincsv.global).
UI: After searching for a string in the input fields to select a value, the highlighted portion of the searched value no longer “hovers”.
And a number of other minor fixes and changes.

You may experience some minor MERGADO downtime at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

radim · November 10, 2022, 7:55am

A new version of MERGADO

Release date and time

August 16, 2022, 15:30 CEST

News

MERGADO 2: We added support for new formats Alza Marketplace - product and also Alza Marketplace - availability.
MERGADO 2: We also added new formats Pinterest XML and Pinterest CSV.
- Further information on these formats is available here.
- We can now also audit both types of formats.
MERGADO 2: We are continuously exploring ways to optimize the import of input feeds and the application of rules.
MERGADO 2: A button has been added to the Elements UI page to change order of elements according to specification if the project has an output format that requires strict order of elements.
MERGADO 2: We added a number of improvements to the element/attribute value listing page:
- We added caching for already loaded and displayed values - the UI should be more responsive in many cases.
When listing the output values of a given element-path, the status of hidden of products is now considered. Thus, values from hidden products will not be taken into account when displaying information about the output values of an element/attribute.
- We have improved the graph with "TOP values " - now it primarily lists the number of products in which the value occurs.
  - Previously, the focus was on the total number of occurrences - in fact, a single value can occur multiple times within a multi-value element for a particular element of a single product - however, we consider this information to be less useful than the number of products. However, if the number of products and number of occurrences are different, the user will see this information for the “TOP values” chart.
MERGADO 2: The variables already work in the Add a value to a multi-value element rule.
MERGADO 2: We have adapted the component for setting pairing elements to allow any element-path to be set as the one to pair products by when importing the input feed.
MERGADO 2: We fixed and improved the display of products on the Products page:
- We’ve cleaned up the visual of the tab headers of listed products.
Now, when clicking into the values of a specific element/attribute, the product values page will be displayed with the correct target set - i.e. whether to display input or output values for the element-path.
- We fixed a bug that sometimes caused the user preference for how to display products to not be saved.
The checkbox that allows you to create an experimental Mergado 2 project is now displayed above the input feed URL field in the new project viewer for better visibility.
And really a lot of other small improvements and fixes.

You may experience some minor MERGADO downtime at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

radim · November 10, 2022, 12:41pm

A new version of MERGADO

Release date and time

August 31, 2022, 15:30 CEST

News

MERGADO 2: We have added support for Greek Google Merchants [gr].
MERGADO 2: We now support the XML format for Scraping Camel.
MERGADO 2: Due to the acquisition of the search engine Stileo.it by Glami, the format for Stileo is now split into the old Stileo.it (Until 07/2022), which uses the original XML specification, and then the new Stileo.it, which now uses the Glami specification.
The MERGADO 2 converter from the input Google format now converts the shipping price without currency. Then if the target output format requires currency again, we return it to the value.
- The formats that require this currency are: Facebook, Google, Kuantokusta, PriceRunner.
MERGADO 2: We have been working on optimizing the import of products from the input feeds. The final speedup may vary case by case, but in testing we measured up to 45 percent faster product imports.
In the rule for adding UTM parameters you can now select any target element (or element-path in the case of MERGADO 2 project).
For the Biano format, we have added support for the Set shipping price rule.
For this format, we can also now audit shipping price information in our feed audit.
For the following formats, we’ve updated the supported carrier lists that can be used in the Set Shipping Price rule:
The data import rule now has a limit on the size of the CSV source if the source is specified as a URL. In that case, the remote file must not exceed 100 MB in size.
The MERGADO Audit: We fixed a bug that could cause an email with information about a completed audit to be sent multiple times.
We fixed a bug that could occur when analyzing the input feed when creating a project if the input feed contained “excessively non-valid” HTML (e.g. in elements of type DESCRIPTION where item descriptions are sometimes inserted as HTML).
We fixed the visual highlighting of the NOT IN operator (not in the list) when writing a custom MQL query in the query form.
We fixed a bug when whispering values for an element in the query form.
We fixed the generation of CSV header when downloading rows in the Bulk rewrite by value rule setting.
And also, of course, we’ve added other minor tweaks and fixes here and there.

You may experience some minor MERGADO downtime at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · October 5, 2023, 7:31am

New version of MERGADO

Release date and time

Wednesday 24 May 2023 15:30

News

Introducing the user regeneration scheduler.
- Through it, you can set the ideal time when you want MERGADO to regenerate your project.
- In the first version, it allows you to set two time slots per day with a minimum of 6 hours apart.
- You can find it in the user interface under the project on the Regeneration page.
- For more information about the user scheduler, see in the forum article.
The user scheduler is available only for MERGADO 2 projects.
We have updated the specifications for the Shoptet CSV formats.
- The pairCode element will now always be present in the output feed.
- The relationships between the value of the element with the universal MERGADO XML meaning CONDITION and the value of the Shoptet element itemType are as follows:
  - CONDITION = "new" is converted to itemType = "product" and vice versa.
  - CONDITION = "used" is converted to itemType = "bazaar" and vice versa.
- The element weight (weight) now does not convert units (kg, lb, etc), but only the numeric value.
We have also updated the specifications for the format Shoptet universal.
We have improved the format converters for Kaufland:
- The value 0 in the element with universal Mergado XML meaning DELIVERY_DAYS will be converted to formats for Kaufland as the value 1 in the handling_time element.
Modifications in auditech feeds:
- Revised and updated audit feeds for formats from :earth_africa families: Kaufland Marketplace - Offer and Kaufland Marketplace - product.
- In general, we have improved the autodetection of formats from the Kaufland family.
- When displaying results for the validator Element EAN contains an invalid value, we now correctly highlight the EAN element for the product.
We have implemented optimizer for MQL queries entered by the user on the Products page.
- Currently it focuses mainly on the following cases:
  - Queries with equality over the same element, i.e. a = 'a' OR a = 'b' OR a = 'c' OR a = ..., are converted to the form a IN ('a', 'b', 'c', ...).
  - Queries with the multiple operator CONTAINS over a single element - that is, a CONTAINS 'a' OR a CONTAINS 'b' are converted to the regular expression form a ~= '(a)|(b)'.
  the optimizer operates transparently. That is, externally - from the user’s point of view - the specified MQL remains in unchanged form, but if MERGADO finds that the query could be streamlined before running the query itself, it converts it into a better form in the background.
UI: The Rules page has been rewritten into more modern code. This will make it easier to improve in the future.
- As part of this, we have resolved some ailments, such as in certain cases problematic moving rules around app rules when the app rule was at the top of the rules list.
Duplicating a rule within a project now works by inserting the duplicate rule at the position after the original. Previously, the duplicate was inserted at the end of the rule list.
And other minor improvements and fixes.

Platform

Individual app rules that have the property is_movable = 1 set and are also prioritized next to each other are blinded together when moved by the user. The user then moves the entire group when moving rules, and the rules in that group maintain their position relative to each other.

You may experience minor MERGADO outages at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · October 5, 2023, 7:54am

New version of MERGADO

Release date and time

Wednesday 7 June 2023 15:30

News

MERGADO supports new formats for Kupi.cz:
- Kupi.cz extended (according to the specification here) and
- Kupi.cz simplified (as specified here).
We’ve extended the capabilities of automatic element value creation through the use of unsupported element paths (element-path) in rules.
- That is, if there is a condition using a non-existent element in the element-path to which the rule should write a value, MERGADO will attempt to create the element.
  - However, only if there are conditions with the = operator or the AND logical connector in the element path.
- Simple example: The Rewrite rule with the path PARAM {PARAM_NAME = "Size"} | VAL with the value XXL will completely create such a nested PARAM element, even if no parameter with PARAM_NAME = "Size" existed for the product yet.
We have fixed support for input feed URLs with sftp:// (e.g. in the new project creation wizard).
MERGADO 2: We have added help text to a bunch of places in the MERGADO Editor interface, which is intended to clarify and make it easier for users to understand the new interface features related to managing projects in MERGADO 2.
- We have also updated various other help texts already present in the interface.
We fixed an occasional error when importing input feeds, which could occur when there were zero products in the input feed.
And lots of other little things, but also background stuff that the user is more likely to not see, but improve the internal workings of MERGADO…

Platform

We fixed a frequently occurring API bug that could occur when suddenly accessing many API requests to products of one project at once.

You may experience minor MERGADO outages at the time indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · October 5, 2023, 8:27am

New version of MERGADA

Release date and time

Wednesday 21 June 2023 15:30

News

MERGADO Guide will help you in understanding our application. The first time you run it or in the hint box you will find the answers:
- How to easily edit data with MERGADO?
- What are the most common ways to use MERGADO?
- What terms do we use?
This will give you very quickly information that you can use in the first days after registration or when you just need to review something.
MERGADO has learned new format Shoptet Category. You can use it to manage categories and subcategories of the Shoptet platform and thus create the structure of your online store.
Introducing new tool: Element path. In its first version, you can try and play with different paths without worrying, which you can then use in almost all parts of the Editor (selections, rules and more). For more, see the article on forum.
Returning the Product Detail page. In both MERGADO 1 and MERGADO 2, you can hide a specific product in it. More features will be added gradually.
In the Set UTM Parameters rule, we have added the ability to set new parameters: utm_id and utm_source_platform needed for GA4.
We fixed a bug where when clicking to edit a field in the Table on the Products page, in some cases the field could not be edited.
Shoptet formats have been extended with Hungarian version.
MERGADO XML now supports the same language versions as Google formats.
We have added a new IMAGE_ALTERNATIVE element to the Idealo.de CSV format.
The Shoptet complete now contains the elements:

ATYPICAL_PRODUCT
  ATYPICAL_SHIPPING
  ATYPICAL_BILLING

OSS_TAX_RATES
  OSS_TAX_RATE
  TAX_COUNTRY
  TAX_RATE_LEVEL

In MERGADO 2 we added support for MERGADO Category and MERGADO Analytic XML formats.
We have improved the component for automated remodeling of projects from MERGADO 1 to MERGADO 2 and back.
And other minor improvements and fixes.

You may experience minor MERGADO outages at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · October 5, 2023, 9:16am

New version of MERGADO

Release date and time

Wednesday 19 July 2023 15:30

News

MERGADO supports new formats:
- Google Product Reviews - straight for a range of countries.
- Malfini - also for a range of countries.
We have updated format converters:
- The format converter for Google, Facebook, TikTok and Pinterest now adds currency to the g:shipping | g:price element even if the shipping price is zero.
- Converter to Kaufland Marketplace - inventory formats now only populates the price_cs element with the price of the item.
We have improved the UX to easily click on related values on the specific element value page - we now design more relevant related elements.
In the component for automatic conversion of MERGADO 1 projects to MERGADO 2 projects, the MERGADO 1 elements EXTENDED_WARRANTY|Something and SALES_VOUCHER|Something were not converting correctly for Heureka formats. This is now fixed.
We have fixed a bug in the Data Import rule that caused rules to end up applying with an error if the imported CSV data file contained a column with a non-existent element that contained an accent in the name.
We added icons for other known services (and updated some existing ones).
And a bunch of other minor fixes and improvements.

You may experience some minor MERGADO outages at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · October 9, 2023, 1:55pm

New version of MERGADO

Release date and time

Thursday 3 August 2023 15:30

News

MERGADO supports new integrations:
- Baselinker
- Spolehliverecenze.cz
We have extended the format families for Google Ads DSA and Facebook to support countries: Chile and Colombia.
We have added certification-related elements to the Google Shopping format: certification_authority, certification_name and certification_code and support for additional countries .
In the Kaufland Bidding format, the currency is now filled in correctly according to the country.
The converter in Shoptet CSV will now correctly convert values with °C.
We have deployed a new version of Element path. It now provides examples of specific paths to help you understand the changes from MERGADO 1.
In the Bulk Rewriting by Value rule, we have improved the data retrieval for pre-filling values into the left column of the form.
The UI: product name can now be only two lines. Subsequently, it will wrap and display in full only when the mouse is hovered over.
We fixed a lot of minor bugs in the UI. For example:
- Error displaying designs on the Elements page.
- A bug where some values were not being offered in the parameter whisperer when entering the path to an element.
- A bug in the MQL input field on the Elements page where the element whisperer did not display when the [ keyboard shortcut was pressed.
- Sometimes it could happen that the rule listing for a rule type Hide Products showed the target element (which doesn’t make sense). We have treated the situation that could cause this to happen and it will no longer happen for newly saved rules.
We fixed a bug in the component for automatic conversion of MERGADO 1 to MERGADO 2 where the special element @MERGADO_ID was not converting correctly in saved selections.
The component for conversion to MERGADO 2 has undergone another round of improvements and fixes.
And a bunch of other minor fixes and improvements.

You may experience some minor MERGADO outages at the time indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us

veronika_kusalikova · October 9, 2023, 2:24pm

New version of MERGADO

Release date and time

Wednesday 16 August 2023 15:30

News

The registration process for MERGADO has undergone significant changes:
- Registration itself is now simplified to a few steps.
- We have improved the design of our Accounts login authority interface.
- The actual invoicing data will not be needed until the end of the trial period of the online store (in 30 days). If the user does not have the payment details filled in, then after the trial period all projects in the user’s online store will be disabled.
- We prefer payment by credit card debit. For new users, this is now the only form of payment we allow. Existing users can set it up as well.
The project conversion component of MERGADO 2 no longer converts unused variables.
We have modified the converters for Shoptet (supplier, complete, CSV) formats.
- The converter now correctly converts values between ITEM_TYPE (Shoptet) and elements with meaning CONDITION (Mergado XML), as follows:
  - CONDITION = "new" ↔ ITEM_TYPE = "product" and
  - CONDITION = "used" ↔ ITEM_TYPE = "bazaar".
- We fixed action price conversion (element ACTION_PRICE) - if this price already contained tax, we will not count it in the converter a second time.
Based on feedback, we have enlarged the search box** on the main page; this makes it easier to find, for example, the URLs of your feeds.
UI: If the URL of your input feed contains a login password and a name (in the form https://jmeno:heslo@nejaky-eshop.cz/...), the project overview page (where we hide the name and password from the URL for security reasons) now shows that the URL contains a name and password at all.
- The button to copy URL now also copies the entire URL with this information, not without it as before. This means that the full URL copied in this way can now be used in searches on the main MERGADO online store overview page.
We have fixed some issues when downloading products of complicated feeds in CSV format on the Products page. We continue to explore further ways to optimize this.
When detecting a format in the New Project Wizard, we now prefer the “main format” instead of formats that are only based on it. We prefer Google (e.g. over the very similar Pinterest format), Heureka (e.g. over the very similar Glami format), and Shoptet complete.
UI: We’ve optimized the project management interface so that now project pages will load at all even if the project contains a very large number of rules.
We fixed a rare bug in the rules that occurred when automatically creating element values (see news, June) if an additional nested condition was used in the path of the element to be written to.
And other minor changes and improvements.

veronika_kusalikova · October 9, 2023, 2:43pm

New version of MERGADO

Release date and time

Wednesday 30 August 2023 15:30

News

The element-path component (element-path) has undergone another wave of improvements.
- The valid element-path now displays a green firefly. The
- We are now highlighting the syntax - just like in the MQL entry form.
- Use the ALT+q and ALT+Q keyboard shortcuts to switch between tabs.
- New suggest operators that can be used.
- The search in elements is now supported by fuzzy-search.
For information on where to work with the new component, see this article.
Alza Marketplace integration formats will now be called AlzaTrade.
We’ve fixed the converter for the Zboží.cz format - we will no longer convert the CONDITION meaning element with the value "used" to the value "bazaar", but leave it with the original value.
We have slightly updated the specification for Malfini formats.
- The value that used to be put under the ATTRIBUTES | ATTRIBUTE | ICON element will now be put as the attribute value under the ATTRIBUTES | ATTRIBUTE | VALUE | @icon path.
We have modified the behavior of the XML file exporter so that XML attributes are now wrapped with double quotes `` instead of single '.
We have reduced the amount of warnings generated when applying rules.
- If an element path (element-path) targets a non-existent value, we will now only warn for element paths that contain conditions.
We’ve fixed an interesting bug in detecting and comparing the date of the last input feed change when that date is provided by the remote server in the last-modified HTTP header. This could cause a problem with comparing datetimes written in different timezones. This should now be fixed.
**We have refined the mechanism for detecting the number of changed products on import. Inaccuracies could occur when there was an element without a value inside the XML structure of the imported product, e.g. <VAT></VAT>.
when whispering categories for Kaufland formats, we will now suggest plural instead of singular forms. Thus, for example, we will suggest the form Fertilizer instead of the form Fertilizer.
We’ve also spent time on optimizations in the XML parsers that MERGADO uses to read your input feeds. They are now slightly faster, but most importantly they now require less memory, which (among other things) will ultimately help to make reading larger/more complex XML files more stable.
We’ve gone through piles of text in the MERGADO UI and updated it.
The UI: In the rules listing for the Set Click Pricing rule, we will now display the correct target CPC element of that format.
And other minor improvements and fixes.

Platform

As of 1 Sep 2023, we are changing the ratio of the amount paid out of revenue for paid apps. The new ratio is 10% better towards app developers, i.e.:
- 80% goes to developers and
- 20% goes to MERGAD.
As part of the phasing out of Appcloud as a repository for apps, we have removed the ability for newly created apps to reside on Appcloud. Existing apps that already use Appcloud can continue to use it.

You may experience minor outages of MERGADA at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · October 10, 2023, 10:48am

New version of MERGADO

Release date and time

Wednesday 13 September 2023 15:30

News

Bringing the next version of the user re-generation scheduler.
- With it, you can set the ideal time for you when you want MERGADO to start re-generating your project.
- You can now set up to 3 time slots per day with a minimum of 4 hours apart.
You can now edit your product descriptions via the new WYSIWYG editor. This allows you to easily edit the HTML content of an element value.
- To start it, simply click on the “edit value” button next to the element with the meaning DESCRIPTION.
We support new integration of Pepita. This is one of the largest markeplaces in Hungary. It contains the formats:
- Pepita.hu and
- Pepita.hu - stock, which is an availability variant of the format.
The component for automatic conversion to MERGADO 2 is now ready for projects containing the rule import data file. Previously, we could not automatically convert these projects.
**We have adjusted the behavior of the data file import rule so that columns with the name of the target elements are matched even regardless of case (unless a match with the same case is found first). This is to make the rule a little easier to work with.
We also spent time on additional optimizations. Among other things, we have investigated and treated inefficiencies in storing data for products that have passed the rule application, but in reality the values of their elements may not have changed at all.
The embedded elements are now exported in the correct order when exporting the output CSV feeds in the header.
We’ve cleaned up the input product import process so that it doesn’t unnecessarily reset the values of multiple elements unless needed.
- On the one hand, this makes the detection of the number of changed products** during import a bit more refined, on the other hand it is a slight optimization of the import process and the process of applying rules. The
We added the ability to easily copy the output feed URL in the last step of the create new project wizard.
We fixed the incorrect display of status icons in the Selection Manager on the Products page.
We edited the text in the application according to MERGADO Dictionary.
When you click on the product listing on the element values page, you will now correctly see products containing the name and diacritics.
And other minor improvements and fixes.

Platform

We will now log the following events for projects after operations through the M2 API:
- Queries - create, edit and delete.
- Rules - create, edit and delete.
- Elements - create and delete.
- Variables - create, edit and delete.

You may experience minor MERGADO outages at the times indicated. Thank you for your understanding and patience while deploying the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · October 10, 2023, 11:20am

New version of MERGADO

Release date and time

Wednesday 4 October 2023 15:30

News

We have modified the converters from Malfini to Shoptet CSV format.
- The SUPPLIER element is now automatically converted to the supplier element.
- The elements ATTRIBUTE | NAME and ATTRIBUTE | VALUE are now converted to textProperty elements (and if there are more than one, to textProperty2, etc.).
We’ve added a bunch of new localizations for existing integrations:
- Google Merchants:
  - Ireland (IE), Latvia (LV), Luxembourg (LU), and Portugal (PT).
- Google Ads:
  
  List
  
  Bulgaria (BG)
  Egypt (EG)
  Estonia (EE)
  Finland (FI)
  Indonesia (ID)
  Israel (IL)
  South Africa (ZA)
  South Korea (KR)
  Lithuania (LT)
  Latvia (LV)
  Malaysia (MY)
  Greece (GR)
  Singapore (SG)
  United Arab Emirates (AE)
- Google Ads Dynamic Remarketing:
  
  List
  
  Australia (AU)
  Brazil (BR)
  Bulgaria (BG)
  Chile (CL)
  Egypt (EG)
  Estonia (EE)
  India (IN)
  Indonesia (ID)
  Ireland (IE)
  Iceland (IS)
  Israel (IL)
  Japan (JP)
  South Africa (ZA)
  South Korea (KR)
  Canada (CA)
  Colombia (CO)
  Cyprus (CY)
  Lithuania (LT)
  Latvia (LV)
  Luxembourg (LU)
  Malaysia (MY)
  Malta (MT)
  Mexico (MX)
  Norway (NO)
  Portugal (PT)
  Russia (RU)
  Singapore (SG)
  Slovenia (SI)
  United Arab Emirates (AE)
  United Kingdom (UK)
  Sweden (SE)
  Turkey (TR)
  Uruguay (UY)
For the automatic category suggestions Bulk category renaming rule, we have added support for the following formats:
- Formats for Facebook:
  - CZ, SK, HU, PL, AT, BR, DE, DK, ES, FI, FR, IT, NL, NO, RO, RU, SE, TR, UK, US.
- Formats for Google Merchants:
  - AT, BR, DK, ES, FI, FR, ID, IT, KR, NL, NO, RO, RU, SE, TR, UK.
The component for automatic conversion of projects from MERGADO 1 to MERGADO 2 got a lot of improvements and fixes.
In the listing of your e-shops and projects on the main MERGADO page we show basic statistics from Google Analytics, if the online store is linked to GA. Now we display data from GA4 as well.
When reading the input CSV files we were sometimes unable to correctly identify the CSV dialect of the file. We have now improved this detection.
Improvements on the Rules page:
- Filtering rules by element used now works correctly even if the rule targets a justified element path (element-path).
  - So now, for example, searching by the element IMGURL_ALTERNATIVE will also find rules that target the element path IMGURL_ALTERNATIVE { @@POSITION = 2 }.
- The Rule Listing for rules like Set Product Parameters and Set Shipping Rate will now no longer show nonsensical target elements that may have appeared in certain cases.0
after duplication of a project, it will now automatically start the regeneration of the newly created project.
Again, we have slightly refined the detection of the number of changed products** when importing input feeds.
We have fixed an error when displaying the Project Settings page that was occurring when a project was using the output feed of another project in MERGADO as an input feed - and that other project was freshly deleted.
And lots of other small changes and improvements.

You may experience minor MERGADO outages at the times indicated. Thank you for your understanding and patience while deploying the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · October 23, 2023, 2:07pm

New version of MERGADO

Release date and time

Wednesday 18 October 2023 15:30

News

For MERGADO 2 projects we have implemented optimized rule application.
We accelerated the compilation of MQL queries.
- This applies especially to huge MQLs, e.g. of the type ITEM_ID IN ("xyz", ... 20 thousand items in total), which took extremely long to process and often ended up with an error. Now this should be much more efficient and faster.
We have improved feed audits:
- For the and variants of the Kaufland Marketplace - bid format, we now treat the value 0 as a valid value in the handling_time element.
- For the audit for Heureka formats, we now report multiple identical PARAM_NAME values not as an error, but as a recommendation that Heureka may ignore the remaining parameters with the same name.
We have updated the specification for Shoptet integration.
- We now support ARUKERESO_HIDDEN and ARUKERESO_MARKETPLACE_HIDDEN elements.
to improve the usability of the user rescheduler, we have added performance to MERGADO so that projects scheduled in this way can be handled better.
Our component for automatic conversion of MERGADO 1 projects to MERGADO 2 projects has received further improvements and fixes.
UI: On the Elements page, for elements that are used as multi-value (if we know this information) for at least one product in a project, we now display their known maximum number (i.e. the highest value of @@POSITION that makes sense to use in the path to that element.)
Again, we’ve improved the download of the CSV product file on the Products page.
- It should now handle larger projects than before, and also the resulting CSV now contains more information about the products and their elements.
The UI: In the rules form, when entering variables, we now also correctly whisper the special variable @MERGADO_ID (representing the unique product identifier in MERGADO).
UI: On the project overview page, the Product Count Variability graph was sometimes rendered with the wrong data. This has been corrected.
UI: On the Rules page, the rules rows now display a number with their order (to make it clear at a glance that their order matters).
UI: We fixed an error when displaying the project history if the current page was displaying app on/off records.

Platform

At the endpoint https://api.mergado.com/shops/<id>/info/ in the number_of_projects field, we now display the correct number of active projects.
On the endpoint https://api.mergado.com/queries/<id>/products/, which returns products from qeuries (which are under projects), we can now filter products by their created_at field (i.e. when they first appeared in MERGAD).
- Example: https://api.mergado.com/queries/<id>/products/<id>/?filter=created_at>=2023-03-03

You may experience minor MERGADO outages at the time indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us

veronika_kusalikova · November 2, 2023, 12:54pm

New version of MERGADO

Release date and time

Wednesday 01 November 2023 15:30

News

We have updated format specifications Upgates.
For the TikTok integration, we have added support for additional countries:
- Chile
- Colombia
- Mexico
- Russia
- Ukraine
We have updated the specifications for the Glami formats.
- We support the GTIN element** (the EAN element is now marked as outdated).
- We have added support for Glami.pl.
We have spent time working on internal and “invisible” improvements to our code, which will then greatly simplify and speed up the implementation of new functionality in MERGADO - e.g. new rule types.
In the section for Audit output feed on the project overview page, we have fixed the behaviour of the audit progress indicator - it should now correctly show the status of the audit in progress.
We have fixed an error that could occur when trying to save project settings if the project was using custom format, which had previously had its state changed in the settings.
The Component for automatic conversion of MERGADO 1 projects to MERGADO 2 projects has received additional improvements and fixes.
And other minor fixes and improvements.

You may experience minor MERGADO outages at the times indicated. Thank you for your understanding and patience as we deploy the new version.

If you have any questions, please feel free to contact us.

veronika_kusalikova · November 22, 2023, 3:20pm

New version of MERGADO

Release date and time

Monday 20 November 2023 15:30

News

In MERGAD there is a new rule type: Remove parameter values.
- With this rule it is possible to remove parameters according to their value.
  - For example, it is possible to remove all Color parameters with values Green and Red in this way,
  - or it is also possible to remove all values with a specific parameter name (i.e. remove all parameters with the name Color regardless of their value).
- The field for specifying the values to be removed can use variables.
- If the output format has multiple potential target elements (or paths to an element) containing parameters, then you can select a target element from under which to remove parameter values.
  - For example, for Shoptet formats, you can choose between the target elements TEXT_PROPERTIES | TEXT_PROPERTY and VARIANTS | VARIANT | PARAMETERS | PARAMETER.
- This rule type is only available for MERGADO 2 projects.
- An article with a more detailed description of the new rule type is in preparation.
On the Products and Rules pages, we have optimized the retrieval of data needed to display the pages. Now large projects with a large number of selections with long MQL conditions (e.g. `ITEM_ID IN (…20 thousand items…) will load much faster and be less prone to rendering errors.
Keychain: We fixed a bug when saving the Mergado Analytic XML URL settings.
UI: We have restored alphabetical paging above the online store listing on the main MERGADO page to easily switch the listed shops according to whether their name starts with the selected letter.
UI: On the Rules page, we have corrected the display of the rules planner status icon.
UI: On the Products page, we fixed the display of the Save Changes button after changing the condition of the saved and currently displayed selection.
UI: We fixed the behavior of the WYSIWYG Element Value Editor on the Products page that added unwanted <p> elements when repeatedly switching the editor view mode.
We have improved character encoding detection of the input feed when importing it to better handle characters of other languages (e.g. Danish).
Again, other minor fixes and improvements.

If you have any questions, please feel free to contact us.

veronika_kusalikova · January 17, 2024, 3:25pm

New version of MERGADO

Release date and time

Wednesday 24 January 2024 15:30

After the traditional Christmas break, MERGADO is back with another batch of regular new features and improvements!

News

Rule Rewrite is now multi-line (only for MERGADO 2 projects).
The rewriting of values for different elements can now be handled by a single rule instead of having to set multiple rewrite rules for different elements, as was previously the case.
- Each line in this rule specifies the target element (or element path) and its new value.

clever insertion works in the row list - that is, two-column data in the clipboard can be inserted as new rows when editing a rule.

For custom formats, the URL of the file from which to retrieve the category list for the custom format can now be specified.
- MERGADO expects a list in the target file where categories are specified; one category per line.
  - A single-column CSV without quotes around the values corresponds to this format - so you can also use, for example, a dynamically exported CSV from Google Sheets (see image below).
  - This file will not be downloaded once, but repeatedly as needed; the downloaded list is then remembered for a while (currently 30 minutes) before MERGADO downloads it again if needed.
- The categories from this file will then be offered in the user interface wherever we offer categories for common formats (e.g. Heureka.cz), i.e. e.g. in the category rules form or when editing the manual value of a category element.

News in formats:
- MERGADO has a new format Flexdog, for the states such as:
  - Czech Republic,
  - Slovakia,
  - Germany,
  - Spain,
  - France,
  - Italy,
  - Poland, and
  - Romania.
- We have updated the Malfini format to the latest specification.
- We can now audit process the feed for Pepita.hu format.
We have optimized the application of rule Find and Replace in situations where search by regular expressions mode is used and at the same time there are more than ~500 such expressions (i.e., lines in the rule setting).
- According to our measurements, this leads to a significant speedup of applying such a rule.
Queries: In the selections form on the Products page, we considered entries like ITEM__ID = 00123 to be an error, because a number cannot start with zero. This is now fixed because a number can actually start with zero.
Rules: The rule order number (in which order the rules are applied in sequence) visible in the rule list now holds the correct value even when searching or filtering rules.
UI: In the (extended) element-path component (element-path) the Right and Parameters tab has a new, brighter icon.
Variables: When creating or editing a variable to test a regular expression, we provide a random value for the selected element. Previously, this random value was taken only from the input values, and this mechanism could not be reasonably used to create variables from elements that are filled only when the rules are applied. This has been improved and now these random values are also taken from the output values of the selected element.
Queries: In the simplified mini-list of selections on the Products page, queries can now also be deleted.
- This mini-list is also now open by default.
Improvements to the new project creation wizard:
- We now preferably offer input and output formats by user state.
- As suggestions for pairing elements, we now correctly offer nested elements, if any - e.g. VARIANTS | VARIANT | EAN.
On the Products page, we sometimes had text “bleeding” to the right when displaying the differences between input and output element values. This is now fixed.
:history: In the header of the component for displaying the e-shop listing its projects, there is now a click to quickly jump to the online store history.
We have fixed a bug in displaying the pairing chart of products (this applies to Heureka.cz and Heureka.sk formats).
When importing an unchanged input feed an error could occur in certain cases instead of the usual skipping of the import. We have fixed this.
When downloading product data as CSV on the Products page, we were returning the values in the resulting CSV position in the element path as ELEMENT { POSITION = 1 } instead of the correct ELEMENT { @@POSITION = 1 }. This has now been fixed.
We have fixed a bug in app Repairman when creating rules.
And lots of other minor fixes and improvements.

Platform

We can send a new hook process.apply.failed in case of rule application errors. Sending it can be set in the webhook settings for your app in Developers.

If you have any questions, feel free to contact us.

veronika_kusalikova · February 9, 2024, 1:27pm

New version of MERGADO

Release date and time

Wednesday 7 February 2024 15:30

News

Rule application now processes variables iteratively.
- What does this mean?
  - It means that when values from a variable/path to an element originating from a multi-value element are written to a multi-value element, then pairs of source vs `target** are newly processed sequentially. That is, the first found value is used to write to the first target element, the second found value is used to write to the second target element, etc.
  - What?!
    - For example, multiplying the prices of all variants under a product can now be done via one single rule calculation, in which you set the VARIANTS | VARIANT | PRICE_VAT element to write %VARIANTS | VARIANT | PRICE% * 1.21:
      - The value %VARIANTS | VARIANT | PRICE% of the first variant is multiplied by 1.21 and inserted into the element VARIANTS | VARIANT | PRICE_VAT only for the first variant.
      - The value %VARIANTS | VARIANT | PRICE% from the second variant is multiplied by 1.21 and inserted into the element VARIANTS | VARIANT | PRICE_VAT only for the second variant.
      - And so on.
- This applies to the following rule types:
MERGADO inserted a newline at the end of the element value when creating the output XML in certain cases for an element with an attribute. This is now fixed.
UI: In some places in the multi-line rule editing form we support smart paste from the clipboard. However, in certain situations, such smart pasting is undesirable - so you can now disable smart paste in those places.
In the create new project wizard we now suggest appropriate matching elements for custom formats as well.
Minor redesign of the top right corner of the MERGADO interface with the user menu. It is now easier to click on e.g. payment settings or invoices.
And other minor adjustments, fixes and improvements.

Platform

Endpoint /queries/<id>/products/ now supports the values_to_extract parameter, with which you can easily extract the values of their element-paths or variables to the returned products. See API documentation for more information.
Endpoint /elements/<id>/ now supports the PATCH method, through which you can change name (string), hidden (bool), order (int, only in MERGADO 2), is_attribute (bool, only in MERGADO 2).
We fixed sending webhooks after queries operations for projects, some of which were accidentally not being sent.

We have customized Invoicing for each customer.
We’ve made useful changes to billing for use of MERGADO paid services. Customers will now receive differential invoices during the month depending on the origination of the paid service under their user account - not until the 1st day of the following month.

If you have any questions, please feel free to contact us.