History of Merlin Backoffice versions
Merlin Backoffice ® Flex is our new solution replacing Merlin Backoffice ® standard from may 2023.
Merlin Backoffice ® was the evolution of PrestaPricing and PrestaCategory since 2018. See the list of major differences here
The lists below start from 2018, so it does not include the history of PrestaPricing and PrestaCategories released in 2010.
The two tables below have been automatically translated from French to English using Google translate or Deepl.
FLEX versions 3.0.1.a Novelties and improvements
| Version number | |
| Technical optimization: All HTTP requests for sending MySQL read and write requests now use the Windev HTTP REQUEST method, making it possible to always use the HTTP2 protocol, independent of IE and TPS settings. | 3.0.1.a.build1 |
Optimization: improved product table display time when no stock column is requested. |
3.0.1.a.build1 |
Optimization: PS_VERSION_DB read before MPR_PS_VERSION in PS configuration table, enabling detection of the correct PS version after an update even if the connector module has not been reset. |
3.0.1.a.build1 |
| Optimization: the search script and deletions of orphan images and much faster (a single MySQL request instead of one per file). And also delete fileType file | 3.0.1.a.build1 |
Optimization: reading and displaying the contents of large CSV files is much faster (e.g.: 22sec instead of 1min10sec for a file with 1700 rows and 5 columns. This is as fast as or faster than the same file converted to xlsx (27 sec)). Optimization also of the final reading phase (CSV and XLS/XLSX): verification of item existence and reading of the content of the “current value” columns. The same 1700-line XLSX file used to take 1 minute to read, instead of 27 seconds. |
3.0.1.a.build1 |
New, full PrestaShop 9 compatibility: management of obsolete headings (meta keywords), new headings (category redirections), new product redirection choices, extension of EAN13 to 20 characters (GTIN), in all app functionalities (reading, editing, mass processing, forms, import...). |
3.0.1.a.build1 |
An important new feature is that moving products, i.e. changing their default category, as well as associating them with or removing them from secondary categories, can be done entirely by drag & drop, using the mouse. Crt (add), Alt (delete) key management. Drop column detection (different behavior depending on column). Multi-shop support. Support for cross-association in a single operation (x products to x categories). Result preview. Use of both the category tree on the left and the target |
3.0.1.a.build1 |
Very important new feature: category moves (change of parent category), as well as duplication of branches, can now be done entirely with the mouse. Management of Ctrl (add), Alt (delete) keys. Support for cross-association in a single operation (x products to x categories). Result preview. Management from any of the three category tables (no need to switch to category view). |
3.0.1.a.build1 |
Important new feature: redesign of the ergonomics of the “Target categories” panel. The tool is now very “visual” and fun. Colored frames show you, before each operation, in which category(ies) and stores products will be moved, added or removed. Less risk of handling errors, better anticipation and understanding of the operations to be carried out. Also enables “impossible” operations to be previewed (e.g. de-associating a product with its main category). Particularly useful in multi-shop env |
3.0.1.a.build1 |
Important new feature: a simple, visual methodology for copying certain properties of a model product en masse to a selection of other products. Replaces our old collection of cloning modules, saving you €50 per module avoided. This applies to cloning associations with carriers, attachments, related products or accessories, lists of associated categories, main or default categories, tags and even characteristics. We still need to invent a method for specific suppliers and prices (already poss |
3.0.1.a.build1 |
New ergonomic feature: before deleting selected rows in a table, they are highlighted in red, allowing them to be visually identified and thus preventing irreversible errors (such as selecting the wrong table or answering “Yes” too quickly, without reading the confirmation prompt), particularly when using the “Delete” key on the keyboard. |
3.0.1.a.build1 |
New: support for PS's experimental feature of generating multiple image formats at the same time (jpg and webp). As a result, as .webp thumbnails can be created in addition to .jpg ones, photo cleanup and deletion scripts will also search for and delete them. |
3.0.1.a.build1 |
New: second HTML editor in the category file, for editing Additional Information (from PS8) |
3.0.1.a.build1 |
New: the two pre-filters for displaying all orphan (no default category) or invisible (no associated category) products and all products on the site (no category filtering) are now operational. Allows more “visual” repair of faulty products. With multi-shop support. |
3.0.1.a.build1 |
New: simply hovering over one of the cross-association and de-association buttons shows in color the objects that will be associated or de-associated. There's less risk of error: you can see what's going to happen before you click. |
3.0.1.a.build1 |
New: choice of product type added to the form for creating new products by batch. |
3.0.1.a.build1 |
New: missing PrestaShop 8 fields added: in-stock and out-of-stock messages for variations, product types, “Additional information” field for categories... |
3.0.1.a.build1 |
New: new display parameter for setting the height of break lines in tables. |
3.0.1.a.build1 |
PS 9.x compatibility: meta_keywords no longer exist in products, categories, suppliers and brands. |
3.0.1.a.build1 |
PS 9.x compatibility: EAN13 fields extended from 13 to 20 characters (to store different EAN, JA, ITF or UCC code types) |
3.0.1.a.build1 |
PS 9.x compatibility: new product redirection types added (410, 200-displayed, default...) |
3.0.1.a.build1 |
PrestaShop 9 compatibility and support |
3.0.1.a.build1 |
Ergonomic improvements: the product movement options window has been streamlined, displaying only non-grayed options (depending on context). |
3.0.1.a.build1 |
Improved speed: the calculation and display of product/category associations in the right-hand panel is up to 15 times faster (e.g.: 25sec for 100 products in 2000 categories and 4 stores instead of 1min20sec for the first display, then only 5 sec instead of 1min20sec for subsequent displays (once the tree has unfolded)). |
3.0.1.a.build1 |
Improvement: very sharp increase in the display speed of categories and category images when the tree contains a large number of categories that have no photo. |
3.0.1.a.build1 |
| Improvement: removal of the rule of uniqueness of the values in the field used as a synchronization key, at the end of each execution of a scheduled import (check option). | 3.0.1.a.build1 |
Enhancement: possibility of adding custom columns read in the stock table, independently of product stock. Case study: display in the product table a stock management column for their default declination. |
3.0.1.a.build1 |
Improvement: optimization of mySQL queries for reading associations between products and categories (target category table). |
3.0.1.a.build1 |
Enhancement: new algorithm so that when categories are moved and cloned, the moved and copied categories are positioned after the existing sub-categories of the target parent categories, in the right order and no longer randomly. |
3.0.1.a.build1 |
Enhanced: cross-associations and disassociations (tags to product, carriers to product, attached documents, accessories...) highlight in color the corresponding checkboxes in the tables. More educational and error-free. |
3.0.1.a.build1 |
Improvement: the behavior of the carriers table is now identical whether or not multi-shop mode is activated, so that carriers can be copied from one product to other products, even if they don't have the same store by default (a separate line is displayed for each carrier/shop pair). |
3.0.1.a.build1 |
Enhancement: activating or deactivating a selection of product lines or categories surrounds the checkboxes in the “Active” columns in color, to highlight the items that will be modified before validation. |
3.0.1.a.build1 |
Improvement: selecting a store automatically refreshes the carriers table, as its contents are context-dependent (previously you had to click twice on the “See associations” button in the carriers tab). |
3.0.1.a.build1 |
Improvement: modification of a value in a cell of the products, declinations and specific prices tables, impacting the value in other columns (e.g. price excluding VAT and price including VAT), recalculates these in real time and no longer at cell output. |
3.0.1.a.build1 |
Improvement: more intelligent management of the product move button, as well as clicking on one of the move columns per store (category change by default). Previously, no operation was possible if several rows were selected or if recursive mode was activated. |
3.0.1.a.build1 |
Improvement: revised ergonomics of the mapping window, to add new fields and make it easier to understand the main and secondary categories. |
3.0.1.a.build1 |
Improvement: faster product movement code (default category change). Grouping of queries and more use of temporary tables |
3.0.1.a.build1 |
Improvement: product association and de-association codes to categories re-optimized for faster processing (grouping of requests into a single transaction) |
3.0.1.a.build1 |
Improvement: although PrestaShop does not forbid this in its BO, as it generates all kinds of bugs in the store, Merlin Backoffice Flex now prevents you from de-associating categories in your store by default. |
3.0.1.a.build1 |
Improvement: increase category display speed (optimize queries and scripts, read only displayed headings) |
3.0.1.a.build1 |
Improvement: faster loading of various tables (Allocation I_xxx) during the connection phase. |
3.0.1.a.build1 |
Improvement: when deleting or moving categories, if some of them are “Roots”, the program lets you choose whether to process them with the others or to continue by ignoring them (previously this would have blocked the entire operation). |
3.0.1.a.build1 |
Fixed in V2.3.4.c: crash on launch if counters at the bottom of tables are enabled. |
3.0.1.a.build1 |
Fixed: better multi-language management when creating attached documents (parametric names and descriptions are filled in in all languages). |
3.0.1.a.build1 |
Fixed: When all stores were selected and the “multi-shop modification” mode was not activated, changes to a category in the file tab were incorrectly saved (made in a pseudo store with id 0). |
3.0.1.a.build1 |
Fixed: modifications in progress in a product line were not saved when changing category, without leaving the line. |
3.0.1.a.build1 |
Fixed: the valuation calculation was wrong in the declinations if you modified their physical or available quantity and their own purchase price was 0 (did not take into account the parent's purchase price). |
3.0.1.a.build1 |
Fixed: the calculation of the quantity sold over a period of customized dates required a rereading of the categories to be correct, when manually changing one of the two dates. |
3.0.1.a.build1 |
Fixed: the move all products button in the “Categories” view could display association columns in the target category panel. |
3.0.1.a.build1 |
Fixed: Display of customer groups was inactive if no category is selected |
3.0.1.a.build1 |
Fixed: product duplication failed when the “View association” mode was activated in the right control panel. |
3.0.1.a.build1 |
Correction: request for new products or duplication in progress, switch to category view for order (position) change: duplication crashes |
3.0.1.a.build1 |
FLEX versions 2.3.3.a and 2.3.4.a Novelties and improvements |
Version number |
| Important new feature: customizable counters showing the number of child products or products associated with each category. | 2.3.4.a.build1 |
| Fixed: the function for deleting the cache of selected images from categories was not deleting the “thumb” format. | 2.3.4.a.build1 |
| Improvement: HTTP/HTTPS transfers of local image files to PS now use HTTP2 (previously HTTP1). | 2.3.4.a.build1 |
| Enhancement: mechanism for downloading the latest version of a photo when it has been replaced or updated on the server, rather than the previous image, when the server has a cache system. | 2.3.4.a.build1 |
| Improvement: eliminated the impression that the screen disappeared for a few moments each time a secondary window was closed. | 2.3.4.a.build1 |
| Fixed: after selecting a different category, when no product was displayed in the current category, secondary tables (declinations, associations, etc.) were not refreshed. | 2.3.3.a.build1 |
| Fixed: feature columns mapped more than once cannot be read if a space is present to the right of their name. | 2.3.3.a.build1 |
| Fixed: the context menu function (right-click), “Copy to clipboard” was generating a fatal error on certain columns (e.g. manufacturers column) of the type “Field ‘0.TABLE_ps_product’ is unknown.” | 2.3.3.a.build1 |
| Fixed: duplicates in Id boutiques column in quick and advanced search results (inventory)HTTP transfer script responded with access error | 2.3.3.a.build1 |
| Correctif : après rafraichissement de l'affichage des produits, si la table des produits est vide, celle de droite affichant les associations aux catégories étaient bien rafraichies les cases bein décochées), mais leur fond coloré était conservé. | 2.3.3.a.build1 |
| Correction: enlarging a column in step 2 (mapping) of imports was blocking the choice of heading. Long titles are now displayed on two lines. | 2.3.3.a.build1 |
| Fixed: intermittent error when selecting a store from the list You called the [] operator on the TABLE_shop field. The index specified [-1] is invalid. |
2.3.3.a.build1 |
| Fixed: malfunctioning of the two pre-filters “Only current accessories” and “Only those with products as accessories” in the accessories table. | 2.3.3.a.build1 |
| Fixed: since version 2.3.1, the context menu displayed %1 or %2 instead of the clicked value, if used in the first 2 lines of tables. | 2.3.3.a.build1 |
| Improvement: stock calculation in the inventory now ignores inconsistent rows in the stock_available table (id shop must be 0 for a store belonging to a group sharing stock, id_shop_group must be 0 for stores with their own stock). | 2.3.3.a.build1 |
FLEX version 2.3.2.a Novelties and improvements |
Version number |
| Correction for versions 2.3.1.a to .c: clicking on checkboxes to move a product no longer worked. You had to use the large move button. | 2.3.2.a.build1 |
| Fixed: in multi-shop mode, the protection that prevents a product from being removed (unassociated) from default categories in other shops, when moving (changing default category) a product in a single store. | 2.3.2.a.build1 |
| Improved: the two windows for choosing product movement and cloning options memorize their position | 2.3.2.a.build1 |
| Fixed: in the “target” category table, the columns showing whether or not each category is the default category for all selected products in each store were showing a “false negative” (orange tick instead of blue) in stores not associated with the category. | 2.3.2.a.build1 |
| Improvement: visual framing of checkboxes that will be modified when clicking in one of the boxes of a multi-line selection, to associate or de-associate products and categories. | 2.3.2.a.build1 |
FLEX version 2.3.1.a Novelties and improvements |
Version number |
| Fixed: inconsistencies in image duplicate management when attempting to re-download images that have been deleted. Blue “Download useless” status without “Do not retransfer” checkbox. | 2.3.1.a.build1 |
| Fixed: SQL error concerning prsh table if request to set to 1 products no longer obsolete | 2.3.1.a.build1 |
| Improvement: increase (factor 100x) in the speed of deleting a large number of products or variations (in the context of working either in single-shop or multi-shop modification mode). The greater the number of lines, the greater the gain in speed. | 2.3.1.a.build1 |
| Improvement: in MagicFormula, detection of 0's on the left of strings, to retain them and not convert them into numbers (previously: {VA } on an ean13 threw 0's on the left, {'ean13__ps_product'} retained them. Now both keep the 0s on the left). | 2.3.1.a.build1 |
| Improved: smoother movement of main window size changes | 2.3.1.a.build1 |
| Fixed: failure to create new products or declinations by importing, forcing identifiers greater than the maximum value of MySQL's INTs | 2.3.1.a.build1 |
| New: clicking on the arrow or the plus or minus of a line in a hierarchical table (e.g. categories), unrolls the branch WITHOUT selecting it. This makes it possible to quickly scroll through the tree structure without, for example, triggering a product refresh. Benefit: faster navigation. | 2.3.1.a.build1 |
| Corrected mapping of document list heading | 2.3.1.a.build1 |
| Fixed: when changing accessory category, the accessory table was refreshed twice. | 2.3.1.a.build1 |
| Enhanced: dynamic columns such as characteristics, attributes and warehouses now change width more smoothly. | 2.3.1.a.build1 |
| New: you can force the values of product and category IDs created from the main window (“New” buttons). This also corrects the MySQL bug that sometimes leaves gaps in the series of identifiers. | 2.3.1.a.build1 |
| Enhancement: the various tables in the characteristics and attributes tabs now display names and long values in multi-line, self-expanding boxes. Easier to read and modify. | 2.3.1.a.build1 |
FLEX version 2.3.0. b c et d Novelties and improvements |
Version number |
| Fixed the following error in import: “processing of ‘Local procedure prepare_request_recuperation_or_creation_id_supplier_1_product_selected_in_table’ line 17 Table dimensions must be positive.” |
2.3.0.b.build1 |
| Fixed: photo upload blocked when one of the urls or local links of a supplied image is not correct. bug present in v2.3.0 only. | 2.3.0.c.build1 |
| Improved image and document transfer code, especially error handling. | 2.3.0.c.build1 |
| Improvement: removal of the ability to sort the order of lines in photo and document upload tables, as this alters the upload order and therefore the result in terms of cover image selection. It is important to respect the line order defined by the file import tool. | 2.3.0.c.build1 |
| Fix: rebuilt urls now use hyphens instead of underscores. | 2.3.0.d.build1 |
| Fixed: the MPN and ISBN fields in the product sheet tab were limiting their number of characters to 13 (instead of 40 and 32 respectively). | 2.3.0.d.build1 |
| Fixed: when creating new products via import, with authorized stored procedures, the value of the depends_on_stock parameter in the stock_avaialble table was receiving a value equal to 2 if unspecified, rather than the default value of 0. As a result, modifying the stock of these products via the BO, stock tab or API (ERP) no longer worked. |
2.3.0.c.build1 |
FLEX version 2.3.0.a Novelties and improvements |
Version number |
| Important new feature: background uploading of attachments (or attached documents) with automatic association to products, as with images, by searching local or remote folders, comparing file and folder names with product properties. | 2.3.0.a.build1 |
| Important new feature: the file import tool enables the creation and association of attached documents. Possibility of deleting existing links before adding, associating by list of identifiers, uploading, creating and associating local or url-based documents. | 2.3.0.a.build1 |
| Improvement: the automatic counter in MagicEdit retains the same initial value (start of each number or letter series), when the "Reset after each break" box is checked, even if there are no breaks in the table. This is useful for automatic imports, to program series that are always identical in a column, with no offset at each application. | 2.3.0.a.build1 |
| Improvement: following a vertical copy-paste in the import table, the MagicEdit and MagicFormula tools are automatically re-applied only after your agreement (Merlin asks). | 2.3.0.a.build1 |
| Fixed: crash under PS 1.6 in advanced inventory management mode, when unchecking this mode for a specific product. | 2.3.0.a.build1 |
| Fixed: SQL error under PS 1.6 in advanced stock management mode, unchecking the "Warehouse-based stock" mode for a specific product. | 2.3.0.a.build1 |
| New: integrated editors for attached documents on the server, in pdf, xlsx, docx and image formats. A document can be downloaded from the server and opened locally for editing at the click of a button, without leaving the software, and saved and updated on the server as it exits the editor. | 2.3.0.a.build1 |
| New: function for mass deletion of attached documents or to unlink them from all products. | 2.3.0.a.build1 |
| New: automatic parametric modifier for titles and descriptions of attached documents | 2.3.0.a.build1 |
| Enhanced: attachment transfers support local files, http(s) urls and ftp(s) | 2.3.0.a.build1 |
| Enhancement: enrichment of the table of existing attachments: columns giving file size and list of linked products, editing possible in the name (itres) and description columns. | 2.3.0.a.build1 |
| Enhancement: in MagicEdit, auto-increment of numeric or alphabetic series retains its initial value at the end of a value generation in a table containing breaks (if reset after break is checked). This allows automatic use in import mode. | 2.3.0.a.build1 |
| Improvement: in the import table, copying and pasting vertically automatically restarted MagicEdit on the other columns. Now logiclel asks for your approval. | 2.3.0.a.build1 |
| New: mass download of selected attachment files from the server to the PC. Allows them to be modified and resent. | 2.3.0.a.build1 |
| New: drag-and-drop management of a file in the attached documents table to replace one or more document lines with their modified version. | 2.3.0.a.build1 |
FLEX version 2.2.3.a Novelties and improvements |
Version number |
| Add more pre-filters (may be two levels of complexity). Add a check box that opens a window of advanced filters that puts the filter chosen to position 1 or 2 or more | 2.2.3.a.build1 |
| Fixed: photos were no longer displayed in the image table when there was no break line (no sorting by product). | 2.2.3.a.build1 |
| Replace "Directed product identifier" in the column configurator with "Redirection identifier" (because it can also be a category). | 2.2.3.a.build1 |
| Fixed: %1 replaced by the name of the site searched for in the message displayed on failure. | 2.2.3.a.build1 |
| Enhancement: the url and names of Mistral AI models have been added to the pre-defined lists. In addition, the two fields for adding non-standard models now store their values. | 2.2.3.a.build1 |
| Correction: error in time offset calculation if value is negative | 2.2.3.a.build1 |
| Modification of the warning message prior to de-association of features with products (the previous message spoke of deletion, which could lead to confusion). | 2.2.3.a.build1 |
| Enhancement: an explanatory text (tooltip) has been added to all product table columns in the column configurator.pluto | 2.2.3.a.build1 |
| Stabilization: removed the option to uncheck "Automatically reread breadcrumb trail". This allowed faster loading, but at the expense of the reliability of certain operations, such as unassociating products with categories. | 2.2.3.a.build1 |
| New: auto-configuration of URL and AI limits when selecting an engine (ChatGPT 3 , 4 ...or Mistral). Added a button to reset limits to default values. | 2.2.3.a.build1 |
FLEX version 2.2.3.a Novelties and improvements |
Version number |
| New: obsolescence management option to deactivate, change status to non-orderable or hide prices, only if the item concerned is out of stock in your SP. This allows you to continue selling obsolete products from your supplier, but for which you still have local stock. | 2.2.2.a.build1 |
| New: "Reference" import key + filter or additional condition on a certain brand | 2.2.2.a.build1 |
| Important new feature in import: mapped columns can be declared as "Current values" and therefore filled by reading the database before import, to filter/program column data according to the current values of other fields! Example of use case: Disable if current stock =0 Calculation of specific margin rates (which can vary line by line) Modify a value only if not defined Filter: e.g. modify only products from a given supplier Distinguish between products with the same "Reference" by filtering o |
2.2.2.a.build1 |
| Important new feature: Management of obsolete declinations (stock zeroing) in the same way as for products. As well as de-obscolescence | 2.2.2.a.build1 |
| Enhancements: Overhaul of the drag-and-drop position management system (images, attributes, characteristics, categories, products). Sorting by ascending position is now automatic, while drag & drop is only possible from the position column to facilitate multiple row selection by drag (harmonized method between tables). It is no longer necessary to re-sort in the "Position" column each time the parent item is changed. *** Translated with www.DeepL.com/Translator (free version) *** |
2.2.2.a.build1 |
| Time-saving improvement: the create and modify boxes are checked automatically when a heading is mapped. | 2.2.2.a.build1 |
| Improvement: it is now forbidden to create a new import task or mapping template without assigning a name to it. On the contrary, to facilitate learning, the very first task is automatically named | 2.2.2.a.build1 |
| Fixed: The "inferior or equal" filter applied a "strict inferior" filter | 2.2.2.a.build1 |
| Improved de-obsolescence function: when items become available again, only zero stocks are reset to the default stock value. | 2.2.2.a.build1 |
| Fixed: Importing CSVs with numerical values, such as identifiers or prices written with spaces like 3,021, only read the digits before the first space (3). | 2.2.2.a.build1 |
| Fixed: MagicFormula was unable to process strings containing the % sign (because it was replaced by /100), preventing ASCII codes such as %20 from being replaced by their character (%20 is a space). | 2.2.2.a.build1 |
| Fixed: the "All" button in the import table was not working logically when rereading or changing files. Now: if "is" is orange, it remains orange and all lines in the reread file are automatically selected. Otherwise, it remains white and only line 1 is selected (as before). |
2.2.2.a.build1 |
|
Version number | |
| Fixed: error when reading file at step 3 of import - present characteristic or attribute column or custom column containing brackets [ or ] in title | 2.2.1.a.build1 | |
| Fixed: when importing, stock updates were not applied to declinations, when one of the "Action in case of shortage" or "Depends on stock" columns (which only concern parent products) was also mapped. | 2.2.1.a.build1 | |
| Correction : in the import table (step 3), the value displayed in the "id category par defaut" column following a category move to a store other than the default store, was replaced at the end of the import by the identifier of the default category read in the product's default store. | 2.2.1.a.build1 | |
| New: support for PDO and MySQL protocols in addition to MySQLi (requires connector version 9.1.c or higher) | 2.2.1.a.build1 | |
| Fixed: error on 1st connection when installing Flex 2.2.0.b.build1 on a workstation where the Standard version is installed (corrected as of V2.2.0.b.build2). | 2.2.1.a.build1 | |
| Improvement: Removal of extra spaces at the end of the order reference with the copy button on the "Your licenses" page. | 2.2.1.a.build1 | |
| Fixed: under PS 8.x, error "stripslashes() expects parameter 1 to be string, null given" in back office when opening category management page, following creation of category path via import (non-empty description missing) | 2.2.1.a.build1 | |
| Corrected: when using the "Refresh/Read all" function, when TABs are present in the content read from the base, the display of categories shifts (the data moves to the columns further to the right) (reminder: TABs don't exist in HTML, so they shouldn't be present). The new code replaces them with the TAB ASCII code, which is "	". The same protection is applied to other applet tables, such as characteristics, category translations and customer groups. | 2.2.1.a.build1 | |
| Fixed: the quantity available for sale could be incorrect in the product sheet tab (in the event of duplicate stock values in the stock_available table). | 2.2.1.a.build1 | |
| Fixed: failed to re-read the same csv file on a server | 2.2.1.a.build1 | |
| Fixed: incorrect error message (could be ignored and continued) on Magicformula formulas in secondary tables, using a column from the product table as parameter | 2.2.1.a.build1 | |
| Corrected: right-clicking in the "Barred price declinaisons TTC" column gave access to the mass processing functions, which do not exist in this column. | 2.2.1.a.build1 | |
| New feature (enabled by default but can be disabled): the time management system now uses the PS server time zone rather than the workstation time zone. This means that the creation and last modification dates of entities, such as products, are stored in the database in the same time zone, regardless of the location of the various Merlin Backoffice users. This also avoids false negatives (import results indicated as "Failed" when they are in fact correct, as they are based on a comparison betwee |
2.2.1.a.build1 |
FLEX version 2.2.0.a Novelties and improvements |
Version number |
| New: it is now possible to select, map or delete several columns at once in the column mapping table at step 2 of the import. This is a major time-saver when you need to map a large number of characteristic or attribute columns. | 2.2.0.1.build1 |
| Very important new feature: grouped action on a selection of categories or products, enabling automatic cascading associations between products and categories, moving up the tree structure from the main category or categories already associated. | 2.2.0.1.build1 |
| New: as the tool for associating products with parent categories is configurable, it is also equipped with a graphic wizard, making it easy to understand and select each parameter. | 2.2.0.1.build1 |
| Highly requested new feature: new import function, automatically associates products with the parent category of their default category. Choice of number of levels in the tree structure, and choice of including or excluding Home. | 2.2.0.1.build1 |
| New: revamped export tool for files combining products and variations. Elimination of duplicate columns, merging of certain columns (price, stock, weight, keys, other...). | 2.2.0.1.build1 |
| New: the price rounding tool can now be used to round prices excluding VAT (useful for PROs). | 2.2.0.1.build1 |
| Security: it is now impossible (forbidden) to use the deletion options in the processing settings for personal or custom colonens, when they are in one of PS's main tables. | 2.2.0.1.build1 |
| New: a non-blocking system to detect fatal errors that previously closed the program. The new system interrupts the operation in progress without blocking the program, and returns it to you. The "Sitolog QuickSupport" button is then available without having to close the error message. | 2.2.0.1.build1 |
| New: as the export tool has been enriched with new settings, we have developed and integrated a configuration wizard for even simpler use. | 2.2.0.1.build1 |
| New: uploaded images can be emptied and no longer stored in the /img/p/merlin folder on the server, to save disk space (at the expense, of course, of having to re-download images that have been used several times) . Anti-duplicate management is retained. | 2.2.0.1.build1 |
| New: the scheduler only launches an import event if the file has been modified since the previous import. Allows events to be scheduled at very short intervals, but only when necessary. | 2.2.0.1.build1 |
| New feature: as with the import, but from the main fn, associate sub-category products en masse with parent categories, i.e. make all products visible in their parent category. Is there a way to do this on merlin or presta.p? Option in import (associate with all parent categories) | 2.2.0.1.build1 |
| Security: when the table of a personal or custom field is one of the main tables in the database, it is no longer possible to choose one of the options as a processing model, which could lead to the deletion of rows in the table. | 2.2.0.1.build1 |
| Enhancement: automatic closing of the import file at the end of each event (scheduled task) in the scheduler. This makes it possible to open the file in Excel in write mode and modify it, between two successive imports, without having to stop the scheduler and close the import window. | 2.2.0.1.build1 |
| New: complementary button to the "Current value" button, which inserts the cell's current contents, but converted into a numerical value. This allows you to perform mathematical operations without having to add the val() function. To avoid phenomena such as 1+2=12 instead of 3. | 2.2.0.1.build1 |
| New: Automatic clean-up to ignore empty rows in or at the bottom of xls or xlsx files. This type of line is often present by mistake in Excel files, when you have emptied lines without deleting them. This automatic feature avoids the need to manually deselect or filter empty lines in step 3 before importing the entire file. | 2.2.0.1.build1 |
| Missing Sales price excl. VAT before discount in dec table (= dec price excl. VAT crossed out) | 2.2.0.1.build1 |
| New: enter sales price including VAT in the new product creation form. | 2.2.0.1.build1 |
| Enhancement: Addition of a colored frame to any table that has the focus, following row selection, to avoid deleting rows in the wrong table. | 2.2.0.1.build1 |
| Improvement: final price before tax after discount in declination table displayed with 6 decimal places | 2.2.0.1.build1 |
| Improvement: in the import table (step 3), the quick search in each column has been reinstated. | 2.2.0.1.build1 |
| Enhancement: the new product creation form now associates a group of tax rules with products, before taxes are activated in the store. | 2.2.0.1.build1 |
| New: "Total sales price before tax and before discounts" column added to the declinations table (previously there was only a column showing VAT). Useful for sites selling to professionals, it was necessary to allow rounding of prices before tax. | 2.2.0.1.build1 |
| Ergonomics: the settings for validating photo uploads are visible right from the "Getting Started" mode, in step 4 of the import process. | 2.2.0.1.build1 |
| Critical fix for PS8: PS8 now imposes (otherwise item editing generates an error) non-NULL values in a number of fields, for products, variations and categories: isbn, mpn, ean13, upc, reference and category description. If these columns are not mapped in a creation import, the program now forces an empty (but not NULL) string to be sent. | 2.2.0.1.build1 |
| Correctif : Le prix de vente final HT après remise, affiché dans la table des produits, était érronée lorsque la remise du prix spécifique était était de type "amount" et TTC. | 2.2.0.1.build1 |
| Fix: importing product creation or modification with a custom column from the main product table in the database works, but also creates useless empty rows in the same table (containing just the value given to the custom column). Ditto for other native tables (product_lang, product_shop, product_attribute, product_attribute_shop, category, category_lang). | 2.2.0.1.build1 |
| Fixed: problem reading license options when launching program from command line | 2.2.0.1.build1 |
| Corrected: unique synchronization keys other than identifiers are deleted from the database when Merlin is launched, when the import window is exited and before products are duplicated. This avoids product duplication failure due to duplicate values. | 2.2.0.1.build1 |
| Fixed (in Connector V9.1.a): if the "Encrypt before sending SQL queries" option was unchecked, texts containing single quotes or backslashes were not saved. | 2.2.0.1.build1 |
| Improvement: modification by declination import now automatically updates the date_upd pramaeter of parent products, so that hooks run on them. | 2.2.0.1.build1 |
| Fixed: in PS 8.1, the "New" products button was creating products that could not be edited in the PS BO, as the latter now imposes non-NULL values for EAN13, UPC, ISBN and forbids the value 0 as the default supplier identifier. | 2.2.0.1.build1 |
| Fixed: in PS 8.1, the "New" categories button was creating categories that could not be edited in the PS BO, as the latter now imposes non-NULL values in the "description". | 2.2.0.1.build1 |
| Improvement: the new supplier creation form always records an address (empty if not filled in), as required by PS 8. | 2.2.0.1.build1 |
| Fixed: the declination generator now forces an empty but not NULL value in the ean13, upc, isbn and mpn fields, to avoid an error when opening them in BO PS version 8.x. | 2.2.0.1.build1 |
| Fixed: locked control panel displayed over product view when application launched, if in full screen mode | 2.2.0.1.build1 |
| Correction: when taxes are deactivated and specific price discounts are defined as VAT discounts, no tax is removed from them to calculate the equivalent VAT discount. | 2.2.0.1.build1 |
| Fixed: fatal error when import log file creation failed, when first using "Import now" in scheduler. Added non-blocking error handling. | 2.2.0.1.build1 |
| Fixed: photos could sometimes not be uploaded and therefore not associated with products, with the response "Send useless", when the file search returned an error 403 instead of 404. | 2.2.0.1.build1 |
| Fixed: loss of mapping of custom columns ("Other headings") in the template in several cases: selection of another file, use of the product/declination switch, template duplication, language change, template deletion, template refresh, filtering... | 2.2.0.1.build1 |
| Correction: the message stating that "Small" category images no longer exist from 1.6 onwards was incorrect, as they do exist again from PS 1.7 onwards. It's the "Medium" ones that then no longer exist. The measurement has been adapted according to the version. | 2.2.0.1.build1 |
| Fixed: SQL error when importing, in "Create non-existent products" mode, entries in the product_group_reduction_cache table. | 2.2.0.1.build1 |
| Fixed: in versions 2.1.2 and 2.1.3 MagicEdit error on cells containing text. | 2.2.0.1.build1 |
| Fixed: failed to proofread category images without error message (hence no display in Merlin Backoffice Flex). | 2.2.0.1.build1 |
| Corrected display of category thumbnails | 2.2.0.1.build1 |
| Fixed: the date and size of remote import files pointed to by HTTP were incorrectly read, so they were downloaded each time a re-read request was made, even if the file had already been downloaded and not modified. | 2.2.0.1.build1 |
| Correction: error in calculating new quantities via the "Modifier by calculation", in the following complex case: several stores selected, multi-shop modification mode activated, stores belonging to the same group, "Shared quantities" type group. The calculation operation was performed as many times as the number of selected stores. | 2.2.0.1.build1 |
| Fixed: SQL error when requesting isbn plus mpn in both product and declination tables at the same time. | 2.2.0.1.build1 |
| Fixed: randomly, changes made (particularly to the description) are not saved from the file tab when another line is selected, even when clicking on save manually. | 2.2.0.1.build1 |
| Fixed: in a multi-shop PS, the "Replace" mode for importing a list of associated categories only protected the removal of the association with the default category in the product's main store. | 2.2.0.1.build1 |
FLEX version 2.1.3.a Novelties and improvements |
Version number |
| Important novelty: use of ChatGPT to reformulate product descriptions and summaries | 2.1.3.a.build1 |
| Fixed: the width of the orange "Delete current content" banner in MagicEdit does not cover the entire line. | 2.1.3.a.build1 |
| Fixed: in MagicEdit, checking the ChatPGT answer cleaning option displays or hides the settings of the option below it. | 2.1.3.a.build1 |
| Fixed: "AFTER" field displaying the result of modifications made to each line crashed at output. | 2.1.3.a.build1 |
| Correctif : Titres des colonnes qui continuent à s'épaissir si on inclus "1 colonne par caractéristique" ou utilise le filtre par colonne. | 2.1.3.a.build1 |
| Correctif : les filtres de colonne s'activent avant la fin de la saisie | 2.1.3.a.build1 |
| Fixed: column filters activated before end of input | 2.1.3.a.build1 |
| Correction: when moving categories, error indicating invalid date, when number of categories moved exceeds 100 | 2.1.3.a.build1 |
| Fixed: an explanatory error message was not displayed when license unlocking failed, e.g. due to a workstation being disabled by a user. | 2.1.3.a.build1 |
| Correctif : depuis MySQL 5.5 en mode strict la suppression de caractéristiques, attributs ou catégories pouvait générer une erreur sur le recalcul des positions (out of range BIGINT UNSIGNED). | 2.1.3.a.build1 |
FLEX version 2.1.1.a and 2.1.2.a- Novelties and improvements |
Version number |
| Fix: crash when clicking on "See associations" in the target categories window if the default store of the site is incorrectly defined | 2.1.1.a.build1 |
| Improvement: if the legacy mode parameter for image management is not found, the default behavior was "Legacy". We've reversed this, as almost nobody uses this mode anymore (ps version 1.4). This could result in very slow photo display. |
2.1.1.a.build1 |
| Fixed: if you didn't check encryption of requests before sending them, accented characters were lost on registration (transformed into coded characters). | 2.1.1.a.build1 |
| Fix specific to V2.1.0: certain PS parameters (legacy images mode, default country, default language, whether or not taxes are enabled, stock movement rules, etc.) are not read correctly at launch. Probable cause of significant slowdown when displaying photos. | 2.1.1.a.build1 |
| Fix: In the product duplication settings window, the multi-store management part remained grayed out if we have several stores in the database but the PS multi-store mode is not activated. | 2.1.1.a.build1 |
| Fixed: width of mapping template list not adjustable | 2.1.2.a.build2 |
| Amélioration dans MagicFormula : détection automatique des valeurs qui sont des chiffres, pour les traiter automatiquement comme tel (faire des calculs) et non pas comme des chaines de caractères. Evite de devoir ajouter Val() ou d'être obligé de mettre un test de condition différent de 0 pour que la formule soit acceptée. | 2.1.2.a.build2 |
| Improvement: from the import window, the choice of country and state for calculating taxes (or from VAT to HT) is now made from drop-down lists (no need to know country/state identifiers). | 2.1.2.a.build2 |
| Various ergonomic improvements (size and length of text cut according to zoom factor, height of titles, etc.). | 2.1.2.a.build2 |
| Enhancement: the ChatGPT tool is enriched with a pre-entered list of available URLs and templates, the ability to add new ones, and the possibility of interrupting the MagicEdit process in the event of a wait. | 2.1.2.a.build2 |
| New: the interface to ChatGPT automatically manages (waiting time) two other limits imposed by the robot: the number of requests per day and the GPT-4 limit of 50 requests every 3 hours (configurable). | 2.1.2.a.build2 |
| New: the interface to ChatGPT manages the "temperature" parameter, which defines whether responses are more or less alétoire, i.e. variable or constant. | 2.1.2.a.build2 |
| New: we've added an option to clean up replies to the ChatGPT management tool. Allows you to specify that only the part contained between two separators is to be kept, and to tell the robot to place the text supplied between these two separators. | 2.1.2.a.build2 |
| Security: Connector V 9.0 fixes a moderate XSS CVE | 2.1.2.a.build2 |
| Fixed: MagicEdit's new line-by-line result checking system malfunctioned if one of the selected lines was not modified | 2.1.2.a.build2 |
| Amélioration : la focntionnalité ChatGPT devient activable independament pour chaque colonne | 2.1.2.a.build2 |
| New: the interface to ChatGPT automatically manages the limit on the number of tokens consumed per calendar day imposed by the robot, i.e. the number of words exchanged. | 2.1.2.a.build2 |
| Fix: reworked the interface of the tool for adding automatic captions to images, so that + buttons are always aligned with parameter names and descriptions | 2.1.2.a.build2 |
| Fixed: since switching to WD28, command line launch with automatic connection was blocking the confirmation prompt. Problem corrected by deleting this step. | 2.1.2.a.build2 |
| New: ChatGPT available to all (end of beta phase). Requires PREMIUM subscription. | 2.1.2.a.build2 |
FLEX version 2.0.1.a - Novelties and improvements |
Version number |
| Important new feature: support for WEBP images, both local and via url, and for both products and categories (requires a compatible version of PS). | 2.0.1.a.build1 |
| Fixed : failed to import "Action in case of stock shortage" column when quantity column not present | 2.0.1.a.build1 |
| Fixed: the option to avoid re-downloading the same photo files the first time around was sometimes unchecked. | 2.0.1.a.build1 |
| Enhancement: the https protocol, now a standard, is selected by default when entering a new connection to a site. | 2.0.1.a.build1 |
| New: Windows 11 "Snap" multi-zoning support | 2.0.1.a.build1 |
| New: can process images with non-extended file names | 2.0.1.a.build1 |
| New: photo upload files accessible from a php script | 2.0.1.a.build1 |
| New: image import from PHP script url?ean= http://bddi.2dcom.fr/LocalImageExists.php?ean=9782215142058 | 2.0.1.a.build1 |
FLEX version 2.0.0.a - Novelties and improvements
| Version number | |
| 2.0.0.a.build1 | |
|
Bulk edit of custom fields :
|
2.0.0.a.build1 |
|
Choice of list separator other than comma Importing to free fields allows you to define cascading joins, to write to tables linked by non-standard keys. |
2.0.0.a.build1 |
| Improvement: the current editions in a row of the column configuration table are taken into account when you click on the button to close the configurator window (before you had to exit the row being edited) | 2.0.0.a.build1 |
| New: MagicFormula and MagicEdit have a new mode of operation that allows to modify each value of cells containing a list of values (acts on each value independently). Perfect for mass changes in multi-value custom columns. Also allows to break a text block into several pieces (into sentences, words etc...) to apply the modification on each block. | 2.0.0.a.build1 |
| Prohibit delete options on native tables. | 2.0.0.a.build1 |
| Optimization: the opening of the table columns configuration window was sometimes very slow, about a minute. This old random problem is finally corrected, the window now always opens in 2 or 3 seconds maximum. | 1.7.0.a.build1 |
| linked custom import column, grey it out and move its content to the display | 2.0.0.a.build1 |
| New: in the import tool, it is possible to link custom field columns to other columns or variables. For example, an associated product_id column in a module table can be synchronized with the imported product id. | 2.0.0.a.build1 |
| Ergonomic improvement: the wording of the validation button in MagicEdit and MagicFormula varies according to the context (e.g. no saving in the database when editing the import table and depending on whether or not you also want to save your own columns) | 1.7.0.a.build1 |
| New: support for HTTP/2 protocol in HTTPS. Faster than HTTP/1. | 2.0.0.a.build1 |
| Improvement: new HTTPS connection setting that no longer requires disabling TLS1.0 and 1.1 in Internet Explorer advanced settings. | 2.0.0.a.build1 |
| Improvement: possibility to see the passwords you have just entered or are currently entering. This allows you to check your typing. They remain protected, as they are totally invisible once saved. | 2.0.0.a.build1 |
| Nouveauté : pouvoir choisir une période de date libre pour le calcul du volume des ventes et de la couverture de stock. Egalement un choix plus large de périodes pré-définies, du style "Trimestre en cours", "Trimestre flottant", "Trimestre précédent"... | 2.0.0.a.build1 |
| Improvement : the inventory tool allows to count decimal quantities. This gets around the problem encountered with some shower heads that flash twice (by setting a counter to 0.5). | 1.7.1.a.build1 |
| Improvement: Sitolog Quick Suport (Teamviewer), upgraded to version 15. | 1.7.1.a.build1 |
| New: a setting option allows you to disable the use of stored mySQL procedures for each connection, used among other things to manage stocks. When this option is checked, the program uses standard MySQL queries instead, which are certainly slower, but which allow you to work on hostings that do not allow the use of stored procedures (shared with LWS and Infomaniak in particular). | 2.0.0.a.build1 |
| Optimization : now avoids in the import of declinations update, the call of the stock management procedure if the quantity column (and other columns of stock_available) is not mapped | 1.7.1.b.build1 |
| Optimization : the default stock creation request is only included in the import process if you are in creation mode | 2.0.0.a.build1 |
| Improvement: it is no longer necessary to unroll the entire category tree to produce a PDF catalog organized by categories, as long as the column containing the name of the default category is included in the configuration of the product table (without necessarily being visible, so even without being included in the catalog to be produced). | 2.0.0.a.build1 |
| PS8 compatibility : the quantity field has been removed from the product_attribute table of the database | 2.0.0.a.build7 |
| Optimization: noticeable acceleration of scripts performing several successive string replacements. | 2.0.0.a.build7 |
| New: support for MySQL 5.7.50 and higher, in particular fixed SQL error when modifying a quantity in the products table | 2.0.0.a.build7 |
FLEX version 2.0.0.a - Fixes
| Version number | |
| Fixed : SQL error in the request to read attachments, if you set a line number limiter | 1.7.0.b.build1 |
| Fixed : the sales calculation could be wrong in a multi-store context depending on the settings. | 1.7.0.b.build1 |
| Correction : The table of specific prices did not have a table menu anymore | 1.7.0.b.build1 |
| Fixed : each time the context menu was called (right click), the number of ( or [ was increasing in the labels of the menus containing the clicked value. | 2.0.0.a.build1 |
| Correction : the purchase price was no longer indicated in the inventory table | 1.7.0.a.build1 |
| Fixed : the replay function of an inventory file was no longer working. | 1.7.0.a.build1 |
| Fixed : drag and drop from right to left in the table of column configurations was sometimes malfunctioning. | 1.7.0.a.build1 |
| Fixed: a string comparison procedure, used in many different places (possible unidentified bugs fixed) | 1.7.0.a.build1 |
| Fixed : "SQL error ca.id_category does not exist" when importing non-standard column in a table containing id_category. | 2.0.0.a.build1 |
| condition IF Source.Source_data_type<>"" THEN added line 37 of ask_and_save_source_data_type | 2.0.0.a.build1 |
| Fixed : SQL error concerning prsh.id_shop when requesting the display of the quantity sold column or the stock coverage in the declinations table | 1.7.0.b.build1 |
| In all requests of the connector module files and in my scripts on my site, check the "" encapsulation of all parameters | 2.0.0.a.build1 |
| Fix : File too big when sending a local image, in PS 1.6, with connector module V8.4. Correction in connector module V8.5 | 1.7.0.b.build1 |
| Improvement: the warning message that a new version is available is cleared after a few seconds if left unanswered. This is to avoid blocking scheduled import automations. | 2.0.0.a.build7 |
| Correction : the counter of MagicEdit went from 19 to 2a, 2b, then from 29 to 3a, 3b... | 1.7.1.a.build1 |
| Correction : the successive movement of products without refreshing the display was not done on all. | 1.7.1.a.build1 |
| Correction : the modification via import, without checking the "Create existing declinations" mode of declinations, with the synchro key "Attributes", could move declinations from one product to another. | 1.7.1.a.build1 |
| Fixed : deleting only one product at a time could be inoperative and not work if several products were selected. | 1.7.1.a.build1 |
| Fixed : the function to search replace or delete all occurrences of a sub-string defined by a start string and an end string was not working anymore (in MagicEdit) | 1.7.1.a.build1 |
| Improvements : in the import of specific prices, forces the type of discount on percentage when the column is present but empty. Also avoids writing in the from and to fields (start and end dates), when they are not specified. | 1.7.1.b.build1 |
| Correction : filtering a product or a declination by the column filter does not perform the following updates on the newly selected product. If you add a photo or an attachment afterwards, it is done on the previous product. | 2.0.0.a.build7 |
| Fix: for MySQL 5.7.50 and later, modification of category, carrier and declination generator read requests to support the new default mysql mode ONLY_FULL_GROUP_BY | 1.7.1.a.build1 |
| Fixed the following error message: "Error on line 33 of the processing Local procedure breadcrumb_rebuild. You have called the ThreadExecute function. The thread 'rebuild_nested_tree' already exists." |
2.0.0.a.build1 |
| Correction : the potentiometer for setting the acceleration factor of the connection window was limited to the maximum value of 1000 instead of 10000. | 1.7.1.b.build1 |
| Fixed : with multiple stores selected, the update of the quantity available for sale, or the physical quantity... or any other parameter of the stock_available table, could sometimes be done only in the 1st store. | 1.7.1.b.build1 |
| Correction : in the import, unchecking the option "Modify in mapping", on the other columns than the translatable text columns, was without effect, the update of these columns was done all the time, from the moment they were displayed in step 3. | 2.0.0.a.build1 |
| Fixed : in the connector module V8.6.a, connection failure when debug mode was activated, fixed in version 8.6.b | 1.7.1.b.build1 |
| Improvement : memorization of the line deletion setting after sending the pictures | 2.0.0.a.build7 |
| Fixed : the "filtering by missing ids" in the inventory tool was returning the selection instead of the inverse of the selection, when the selection was a continuous list of ids | 2.0.0.a.build7 |
| Improvement: visually cleaner connection and disconnection phases | 2.0.0.a.build7 |
| Fixed : in the image association settings window, the choice of attribute group used for comparison was not always taken into account. | 2.0.0.a.build7 |
| SQL error in the where of the request to associate or disassociate products or customer groups to a category, if the target category is incorrectly selected. | 2.0.0.a.build7 |
| Fixed: SQL error when modifying the purchase price of a product, with the mode of co-conservation of the margin of declinations activated, when the country chosen in "Display" does not contain any state. | 2.0.0.a.build7 |
| PS8 compatibility: the "quantity" field no longer exists in the product_attribute table. Was filled by the advanced generator of declinations which has been modified accordingly. Other parts of the code also impacted. | 2.0.0.a.build7 |
| PS8 compatibility: the attribute_impact table has disappeared with the new PS8 installations. But it is necessary to manage price impacts by attribute. Merlin rebuilds this table if it is missing. | 2.0.0.a.build7 |
|
|||||||||||||||||||||||||||||
Novelties version 1.7.0.a |
Version number |
| Optimization: the opening of the table columns configuration window was sometimes very slow, about a minute. This old random problem is finally corrected, the window now always opens in 2 or 3 seconds maximum. | 1.7.0.a.build1 |
| Ergonomic improvement: the wording of the validation button in MagicEdit and MagicFormula varies according to the context (e.g. no saving in the database when editing the import table and depending on whether or not you also want to save your own columns) | 1.7.0.a.build1 |
| Correction : the purchase price was no longer indicated in the inventory table | 1.7.0.a.build1 |
| Fixed : the replay function of an inventory file was no longer working. | 1.7.0.a.build1 |
| Fixed : drag and drop from right to left in the table of column configurations was sometimes malfunctioning. | 1.7.0.a.build1 |
| Fixed: a string comparison procedure, used in many different places (possible unidentified bugs fixed) | 1.7.0.a.build1 |
| Fixed : better handling of hooks (requires version 8.4 of connector module) | 1.7.0.a.build1 |
Novelties version 1.6.6.a |
Version number |
| Fixed : the cursor of the MagicEdit counter field was returning to the beginning each time a character was entered | 1.6.6.a.build1 |
| Fixed: SQL error when importing HTML code in a free field of a non-standard table. | 1.6.6.a.build1 |
| Fix: failure to copy and paste a formula of more than one line into MagicFormula | 1.6.6.a.build1 |
| Correction : in the quick or advanced search tool, when searching in a shop of a shared quantity group, the known stock value was always indicating 0. | 1.6.6.a.build1 |
| Correction : in the automatic caption generator, the addition of the attributes of the declinations associated with the images did not work in all cases. | 1.6.6.a.build1 |
| Correction : some formulas in MagicFormula that worked well when set up were failing when the file was reread. Mainly formulas containing as parameters columns of characteristics, attributes or other columns whose title contains a space. | 1.6.6.a.build1 |
| Fixed: In step 3 of the import tool, feature columns containing only feature value identifiers were no longer displaying these values. | 1.6.6.a.build1 |
| Improvement: putting a formula in a column of characteristics to be imported sometimes required the inclusion of a "?" before each value. This is no longer the case. | 1.6.6.a.build1 |
| Improvement: the quick and advanced search and inventory result tables now contain a column with the shop group and a column indicating whether it is a shared stock between the shops in that group | 1.6.6.a.build1 |
| Improvement: a change in the selection of several shops is taken into account immediately, no need to refresh the category tree. This is useful for some tools like the inventory tool, when you want to quickly choose which shops to search for stock. | 1.6.6.a.build1 |
| Improvement: in step 3 of the import tool, feature or attribute columns containing only value identifiers in the file now show the value itself in addition to the identifier, when it already exists. This is useful for checking the accuracy of ids and for reusing the value in other columns with MagicFormula. | 1.6.6.a.build1 |
| New: "Group" option in the quick or advanced search and inventory tool: If unchecked: The search returns one line per shop associated with each item for the selected shops. If this option is checked in orange: two groups of lines are returned, one grouping all shops with their own stock, the quantity column then contains the sum of the stocks in these shops. This makes it possible to make exhaustive inventories, cumulating the stocks of all the independent shops for example and counting the |
1.6.6.a.build1 |
Novelties version 1.6.5.a |
Version number |
| Correction: Error in line 37 of the processing Global procedure From_color_field_right_click when right-clicking in a characteristic column, step 3 of the import, when the characteristic name contains spaces. | 1.6.5.a.build1 |
| New: possible use of MagicEdit in the position column of the image list. Allows you to reorder the photos of hundreds of products by choosing for example a common image to put in the first place thanks to a filter on the column "historical file". | 1.6.5.a.build1 |
| Fixed: SQL error when deleting an attribute group, in the final phase of cleaning up the positions of the other groups (the deletion was however done) | 1.6.5.a.build1 |
| Correction : the column was not filled in step 3 of the import when the characteristic name contains a space at the beginning or at the end | 1.6.5.a.build1 |
| Correction: update of declinations with import key set to attributes, the supplier reference column is not imported. Is imported when the same rows are sent a second time | 1.6.5.a.build1 |
| Correction: when importing a supplier reference for a secondary supplier (which therefore becomes the new default supplier), this reference either replaces that of the default supplier (non-reproducible problem) or is ignored (problem noted). | 1.6.5.a.build1 |
Novelties version 1.6.0.b till 1.6.4.a |
Version number |
| IMPORTANT new feature: Option in the import mapping to replace all the categories associated with the product with a new list. | 1.6.0.b.build1 |
| Improvement: no more size limit in the input fields of the filter search values. Useful especially when filtering items in a long list of values. | 1.6.0.b.build1 |
| Fixed a regression: crash of the import window if the "main category name" column was added without being mapped at step 3, to fill it in by hand and import it (same error possible with other columns related to categories or not) | 1.6.0.b.build1 |
| Improvement: removal of the 1024 character limit for text columns in the import table. Useful in particular for the column containing the list of photo urls which could be truncated. | 1.6.0.b.build1 |
| Fixed: SQL error when associating products to a shop if the option to copy custom fields is checked. | 1.6.0.b.build1 |
| Fixed: Error on line 147 of the Local Procedure prepare_requetes_import_associated_tables_via_var@@ processing on import | 1.6.0.c.build1 |
| Fix: if checking existence of declinations with missing key column, flurry of minor SQL errors: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 1 | 1.6.0.c.build1 |
| Correction : the import of the UPC column was creating a fatal error | 1.6.1.a.build1 |
| Compatibility: tested on PS 1.7.8.0.0 | 1.6.1.a.build1 |
| Specific bug correction version 1.6.0 : MagicEdit in the product purchase price column, with specific prices displayed at the bottom, there was a refresh of the specific price table at each modification of each top line. In the same way MagicFormula in the purchase price table of the variations, redisplayed the table x times. Same problem seen and corrected with other columns. | 1.6.1.a.build1 |
| Fixed: Use of MagicFormula in annex tables with use of columns read from the product table as parameters, did not read the correct rows. | 1.6.1.a.build1 |
| Fix: removed the basic version of the CKEditor editor because it removed some HTML markup | 1.6.2.a.build1 |
| Fixed: product name replaced by the generic name "prod-xxx" when the name column is missing from the import file or not mapped. | 1.6.2.a.build1 |
| Fixed: MagicFormula had a bug specific to 1.6.1.c and 1.6.2.a, when the formula calls the contents of other columns in the same table, it was rejected with the indication that a "final" was missing. | 1.6.2.b.build1 |
| Correction : when you modify the stock of a range, it updates the total stock in the product table, but it does not update the quantity field in the record tab. As a result, the figure in this field overwrites the total stock when you save the file. | 1.6.4.a.build1 |
| New: MagicEdit allows you to create alphabetical series (a,b,c,...aa,ab,ac,...), which is very useful for making series of references with letters and not only numbers. | 1.6.3.a.build1 |
| Fixed: Compilation error in MagicFormula when an attribute or characteristic column is used in the formula from the import window. | 1.6.3.a.build1 |
| Optimisation: of the speed of the two tools "Quick Search" and "Advanced Search". Particularly noticeable on very large databases and the search based on supplier references. | 1.6.3.a.build1 |
| Optimisation: of the reading of declinations with display of supplier references. In the order of x 100 on very large databases (tested on 1 million records). | 1.6.3.a.build1 |
| Correction : the button allowing the mass copying of supplier references and supplier prices of parent products to their variations was sometimes returning "No modification made" (button present in the "Suppliers" tab). | 1.6.3.a.build1 |
| Improvement: since 1.6.x, to add columns manually in step 3 (via right click in the table), for example to specify the price when creating products via drag and drop photos, it was mandatory to add a real or virtual column mapped to the heading (price). This is no longer the case, we find the hyper simple side of version 1.5, a column added manually at step 3 is automatically mapped in add and modify mode. | 1.6.3.a.build1 |
| Improvement: automatic deletion of the line break character in the multi-line fields of the pre-filters. Thus, at the end of the searched value, pressing the "Enter" key launches the search | 1.6.4.a.build1 |
| Ergonomic improvement: activated pre-filters always remain visible | 1.6.4.a.build1 |
| Fixed a regression: entering the search value for pre-filters was returning the cursor to the beginning of the word each time you typed | 1.6.4.a.build1 |
| Fixed: Importing with a tag list column was generating an SQL error resulting in the message "Products | 1.6.4.a.build1 |
Novelties version 1.6.0.a |
Version number |
| Correction : repair of the right click menu of the attributes list table, in the declination generator window and of the menu (double chevrons) of this same table | beta.1.6.0.a.build1 |
| Optimization: very significant increase in the speed of mass deletion of client groups | beta.1.6.0.a.build1 |
| Optimization: increase the speed of mass deletion of products and cleaning of products in the database. | beta.1.6.0.a.build1 |
| Optimization: very significant increase in the speed of mass deletion of categories when using the old mode (not breadcrumb based) | beta.1.6.0.a.build1 |
| Optimization: very significant increase in the speed of mass deletion of features or feature values | beta.1.6.0.a.build1 |
| Magic new feature: tool to merge a selection of several feature values into one value. Replacement in all products of deleted values by the retained value. Clean up your databases, delete duplicate characteristic values. Also works for values belonging to different characteristics. | beta.1.6.0.a.build1 |
| Optimization: very significant increase in the speed of mass deletion of attribute groups or attribute values) | beta.1.6.0.a.build1 |
| Important optimization: adding characteristics to products via the import tool is 2 to 60 times faster (the more different values to import, the more significant the improvement) | beta.1.6.0.a.build1 |
| Important optimization: line import time halved when you update the purchase price and ask to apply a margin or keep it (done with a single SQL query instead of 3 previously). | beta.1.6.0.a.build1 |
| Magic new feature: tool to merge a selection of several attribute values of declinations into a single value. Keep the declinations and replace the deleted values by the retained value for all products. Clean up your databases, delete duplicate attribute values. Also works for values belonging to different attribute groups. | beta.1.6.0.a.build1 |
| Ergonomics: when in the import table, one accidentally typed a number or a letter without being entered in a cell (thus without being in the input mode), this carried out a "Windev" search (the magnifying glass icon in the column headings) and thus a sorting of the lines. However, the sorting of rows is often not desired when importing, because the order in which the rows are imported is important (especially for categories). To avoid this "trap", we have deactivated the "Windev" search function | beta.1.6.0.a.build1 |
| New and much requested ergonomics: the mapping of columns required to select a heading in a long unsorted list. This is replaced by a window displaying all the headings at the same time, grouped by theme and with a quick search tool. | beta.1.6.0.a.build1 |
| Importing to free fields allows you to manage duplicates, either mono (the same value in this column already exists) or multi-column (all the values of several columns already exist) | beta.1.6.0.a.build1 |
| Importing to free fields allows you to process both standard and non-standard columns from the base tables (product, product_shop, product_lang, product_attribute, category, category_lang, supplier etc.) and columns from other tables that may or may not contain one of the sync keys such as id_product, id_lang, id_shop, id_product_attribute etc... (the behavior is different depending on the presence or absence of one or more keys). For example, it is possible to import the Amazon special price in | beta.1.6.0.a.build1 |
| Calculated" or "virtual" columns (columns that do not exist in the file) can be mapped to a free field | beta.1.6.0.a.build1 |
| Import to free columns is compatible with MagicFormula and MagicEdit. These free columns can themselves be used in the formulas of other columns. | beta.1.6.0.a.build1 |
| The import to free topics manages the multi stores and multi languages | beta.1.6.0.a.build1 |
| Importing to free fields allows you to choose to replace or add values | beta.1.6.0.a.build1 |
| Importing to free fields allows you to choose the table and field regardless of the column name | beta.1.6.0.a.build1 |
| The import to free fields has an automatic management avoiding the duplication of values | beta.1.6.0.a.build1 |
| Import to free fields allows you to import single values or lists of values | beta.1.6.0.a.build1 |
| Magic new feature: it is possible to use calculated columns, free columns, non-standard field columns, attribute or characteristic columns,... as parameter or result of "MagicFormula" formulas. This opens up unlimited possibilities of data processing before import. | beta.1.6.0.a.build1 |
| Ergonomics: the table in step 3 of the import is enlarged in height when the window is stretched. | beta.1.6.0.a.build1 |
| Important optimization: the import of suppliers and brands is now almost without impact on the import time of a product. Speed gain of about 10 to 30%. | beta.1.6.0.a.build1 |
| Correction : via the import, the modification of the translatable headings of the categories with the choice "In all the languages", did it only in the current language | beta.1.6.0.a.build1 |
| Fixed : failure when reading csv files (does not concern xls), attribute columns exported with Merlin (whose title starts with "at "). | beta.1.6.0.a.build1 |
| IMPORTANT new feature: New option for setting the import of purchase prices, allowing the update to be made on condition that the new price is lower than the current price. Mode compatible with the management of forced margins, constant or by step, both for the calculation of product sales prices and the price impacts of declinations. |
beta.1.6.0.a.build1 |
| Important new feature: the import tool allows you to remove (un-associate) products from the categories of your choice, by adding a minus in front of the category identifier, in the "List of associated category identifiers" column | beta.1.6.0.a.build1 |
| Important new feature: search tool and removal of duplicates in each product, based on the comparison of their attributes (new feature of the search tool and correction of duplicates in the import window) | beta.1.6.0.a.build1 |
| Fixed : the change from standard to custom in the mapping was only taken into account when closing and reopening the import window | beta.1.6.0.a.build1 |
| Important new feature: at the import mapping stage, you have an additional option for each column, with the choice between "Use for new products", "Use for updates" and "Use for new products and updates". This allows for example, to process in one import the creation of new products, taking into account all the columns, and to update only the prices or stock of existing products without overwriting their description that you may have modified manually since their creation. Previously you had to |
beta.1.6.0.a.build1 |
| VERY IMPORTANT new feature: it is now possible to import to free fields, i.e. practically any field from any table in the database | beta.1.6.0.a.build1 |
| IMPORTANT new feature: merge attribute values (Red, red, red, light red =>Red) | beta.1.6.0.a.build1 |
| VERY IMPORTANT new feature : new synchro key for importing declinations : attribute list . This allows you to create and update declinations without having their id or their reference | beta.1.6.0.a.build1 |
Novelties version 1.5.3.a.build1 |
Version number |
| Improvement: the columns "Customizable", "Number of text fields" and "Number of downloadable files" are now multi shop | 1.5.3.a.build1 |
| New: in the options for associating products with shops, you can request that custom fields (or customisations) be copied from the product's default shop to the new associated shop. The same applies to de-association. | 1.5.3.a.build1 |
| Correction in MagicEdit : discrepancy in the selector, the insertion of texts "All caps" was done if the choice "Without accent" was selected and the function "Without accent" was thus absent. | 1.5.3.a.build1 |
| New: automatic index checking and repair tool for files containing Merlin settings. | 1.5.3.a.build1 |
| Fixed: moving products via the import tool (change of category by default) was not associating the products to their new category (they were not visible in the shop in this category unless a second column was included to add this association) | 1.5.3.a.build1 |
| Correction : when using the basic label generator, the logos were not displayed in the left part of the labels, only worked with the right part and with the pro version. | 1.5.3.a.build1 |
| Improvement: automatic addition of mandatory brackets around the list of searched values, when using the condition "In this list" and "Not in this list" in all pre-filters | 1.5.3.a.build1 |
| Correction: copy and paste on a selection of lines in the attribute table of the declination generator created a crash ). Error at line 5 of Local procedure fill_column process. FEN_Declination_Generator is not a table. | 1.5.3.a.build1 |
| Correction : when (rare case) the tables do not have a prefix, access to the database error when clicking in the "Access to source categories" column in the client groups table. | 1.5.3.a.build1 |
| Fixed: when (rare case) tables have no prefix, SQL error (ON(1)) when creating new categories with associations to all groups. | 1.5.3.a.build1 |
| Improvement: planning an import on the 5th Sunday of a month that contains only 4 or 3, chosen instead the last Sunday of the month. | 1.5.3.a.build1 |
| Correction : when duplicating a product with the choice "only in the shop of the selected line...", the duplication was done in the default shop of PS. | 1.5.3.a.build1 |
| Correction : planner, the code of the selector between the day or the xth day or Monday, grey or greyish is inverted | 1.5.3.a.build1 |
| Correction : no saving of the description from the file when you ask for the duplication of the product. Same thing when you switch to the "Declinations and images" tab. | 1.5.3.a.build1 |
Novelties version 1.5.2.a.build1 |
Version number |
| Fixed: SQL error when including the "Location" column or placing a pre-filter on Location, in the declination table; with PS versions before 1.7.5 | 1.5.2.a.build1 |
| Important improvement: support for CSV files containing text surrounded by inverted commas (or any other character), with inverted commas, or characters identical to the column separator, or line breaks, present in the text itself. | 1.5.2.a.build1 |
| Fixed : the remote file (via a PHP scipt) CSV was not read back when it had the same name as the previous one | 1.5.2.a.build1 |
Novelties version 1.5.1.b.build1 |
Version number |
| Improvement: advanced search, no longer launches the search as soon as a field in the multi-value filters is modified and the active box is unchecked | 1.5.1.b.build1 |
| Fixed: in the previous version 1.5.1, the management of files provided by API script was only working for xls/xlsx files but not for csv files | 1.5.1.b.build1 |
| Fixed: sometimes Merlin had to be closed and restarted on the first connection attempt because the new encryption key value was not taken into account. | 1.5.1.b.build1 |
| Fixed: With PS 1.7 it is not possible to make mass changes with MagicEdit and MagicFormula to the redirection Id field. | 1.5.1.b.build1 |
| Improvement: the font colour of the row being edited, for the main tables, changes to orange, to indicate the row being edited when there are many columns. Replaced the 1st column with square buttons introduced in the previous version. | 1.5.1.b.build1 |
| Fixed: since 1.5.1.a, multi-line modification of the import shop choice (to choose the value * (all) was impossible by reading a file containing *, by MagicEdit or by copy and paste. Worked only with MagicFormula | 1.5.1.b.build1 |
| Fixed: SQL error when including the % discount column, concerning the to and from dates when using MySQL version 8 | 1.5.1.b.build1 |
| Fixed : the column Id rêgle of catalogue price remained invisible in the tables | 1.5.1.b.build1 |
| Ergonomic improvement: double-clicking on a category no longer displays the whole tree, but only the sub-categories of the clicked category (equivalent to clicking on the +) | 1.5.1.b.build1 |
Novelties version 1.5.1.a.build1 |
Version number |
| New: possibility to send an email to Sitolog support directly from the app in case of a severe crash. | 1.5.1.a.build1 |
| Improvement: when importing in a multi-shop context, the shop column clearly indicates that, by default, the import will only be done in the current shop and that another choice can be made Many didn't know this. | 1.5.1.a.build1 |
| Improvement: Merlin checks the relevance of the mapping and the choice of sync keys before importing, and if it suspects human error, explains why. Will be a great help to beginners in importing when you know that 99% of failures and duplicate and orphan creations come from a wrong choice of sync key. | 1.5.1.a.build1 |
| Improvement: If the product sync key is set to "Product name", the search and duplicate correction tool now groups the search results by shop and language. It is therefore now allowed to have the same name twice for two different products, as long as it is not for the same language or the same shop. | 1.5.1.a.build1 |
| Fixed: several SQL errors in a row with the button to move all products from one category to another, from the category view, if you are in single shop. | 1.5.1.a.build1 |
| Corrective : failure to modify the supplier reference of the declinations by import, when those already exist. | 1.5.1.a.build1 |
| New: the evolutionary planner. The "time" mode is replaced by the "time interval" mode. Allows you to specify to the minute the time separating two imports of the same file and to specify if the countdown should start from the beginning or the end of the previous import. This allows, among other things, to schedule at a constant time interval and always at the same time. | 1.5.1.a.build1 |
| Fixed: sql error when using the attribute impact modifier, if and only if the declination generator has never been used before, indicating that the "impacted" field is missing in the product_attribute table. | 1.5.1.a.build1 |
| Correction: it was impossible to change the generic name of imported products | 1.5.1.a.build1 |
| Improvement: New more logical behaviour when importing a category: if the column "Default category identifier" is absent, empty or contains a 0 and the line corresponding to the modification of an existing product, its default category will not be modified. However, if the column "Name or tree structure" is present and contains a value and the option "Create non-existing categories" is ticked, then a new category or branch (with no products in it) will be created under the Home, with the names |
1.5.1.a.build1 |
| Fixed: the mb_split routine of the connector could generate a double declaration error (already used by another module), blocking the connection. Has been renamed from version 8.2.b onwards. | 1.5.1.a.build1 |
| Improvement: when deleting photos, Merlin displayed 4 gauges in a row, making it difficult to follow the process. It now displays only 2, one for the SQL part, one for the physical deletion part of the files. | 1.5.1.a.build1 |
| Fixed: crash when re-applying a MagicFormula formula in the declination table, just after changing column configuration and refreshing the display. Only occurred when the formula was using a column from the product table. | 1.5.1.a.build1 |
| Improvement: during the quick search in flash mode, by checking only "products" (without looking for the declinations), the found product was displayed in the main table but it was then not possible to display its declinations. | 1.5.1.a.build1 |
| Optimisation: faster reading at the launch of the PS configuration table (2s instead of 1 minute on a very large base of 300 multi-shops) | 1.5.1.a.build1 |
| Fixed in step 3 of the import, when reading the file, if the title of a column contains a single inverted comma, there is an error: Processing of 'Local procedure automatic_calculation_column_recomputation_recomputation' (FI_Import_product.PROCEDURE.automatic_calculation_column_recomputation), line 29, thread 0 Function 'HFilter', syntax 3 |
1.5.1.a.build1 |
| Fix: crash if there is a shop in the database with an identifier equal to 0 (should not exist however) | 1.5.1.a.build1 |
| The import by file of the "Advanced stock management" column, product by product, had been deactivated since version 1.5.0. Has been reactivated at the request of some of you. | 1.5.1.a.build1 |
| Fix: when reading the file at step 3 of the import, if a filter is set on a column that no longer exists : Error in line 1830 of the processing Local procedure fill_table_products Processing of 'Local procedure fill_table_products' (FI_Import_product.PROCEDURE.fill_table_products), line 1830 (1697), thread 0 Function 'TableActiveFilter', syntax 0 |
1.5.1.a.build1 |
| Improvement: support for already encoded photo file urls (e.g. spaces in the url already replaced by %20). | 1.5.1.a.build1 |
| Corrective: when we wanted to erase entirely the date of availability of a declination, we had an "invallid date" bubble and it was impossible to get out of it without rechoosing a date. | 1.5.1.a.build1 |
| New: the rows being edited in the tables are visually identified with a marker in the first column. | 1.5.1.a.build1 |
| New: Import event scheduling with an interval defined to the minute. With the possibility to define the start of the countdown (start or end of the previous import of the same task). | 1.5.1.a.build1 |
| Fixed: the mass management function of products from categories should not update the date because hooks are not executed on modified products. | 1.5.1.a.build1 |
Novelties version 1.5.0.d.build1 |
Version number |
| Fixed: the advanced search selector was sometimes hidden on the display | 1.5.0.d.build1 |
| Improvement: suppression of the automatic launch of the search when switching from the "quick search" mode to the "advanced filtering" mode and vice versa, to avoid unwanted launching of long searches on large databases. | 1.5.0.d.build1 |
| Ergonomic improvement: the first time the quick search and advanced filtering window is opened, it remains open in quick search mode, without asking to create a first configuration. | 1.5.0.d.build1 |
| Fixed: SQL error (missing one; in the SQL query) when using the declination generator without checking either of the two options for modifying the price and weight impacts. | 1.5.0.d.build1 |
| New: the import scheduler allows you to schedule recurring tasks every x minutes (before it was every x hours). | 1.5.0.d.build1 |
>Novelties version 1.5.0.c.build1 |
Version number |
| Fix: some fonts are not supported in labels | 1.5.0.c.build1 |
| Corrective beta 1.5: The ean13 generator counter was no longer common between products and versions, which could lead to the generation of duplicate barcodes. | 1.5.0.c.build1 |
| Beta fix 1.5.0.b: the product sheet tab was not filled in with PS 1.7.2.x (error concerning the low_stock_threshold heading). Ok from 1.7.3.x onwards. | 1.5.0.c.build1 |
| Improvement: being able to import supplier purchase prices and supplier currencies without having the default supplier column present in the file. | 1.5.0.c.build1 |
| Fixed : automatic association to customer groups of new categories via import when the category key is set to identifier and you are asked to force the value of the identifiers | 1.5.0.c.build1 |
| Correct beta 1.5: crash if no configuration is created in the search window (click on "Cancel"), which is then switched to fast search and back to advanced filtering. | 1.5.0.c.build1 |
| Corrective : the change of vat rule from the tab sheet did not update the column Tax rate in the tables of products and declinations. | 1.5.0.c.build1 |
| Fixed: "Force Ids" of categories to be created, when the encryption key is set to "Category name" instead of "Identifier", is working now | 1.5.0.c.build1 |
Novelties version beta 1.5.0.b.build1 |
Version number |
| Beta fix 1.5: Mass modifier by calculation and copy and paste, in the following columns : Tax rules, Minimum quantities, Weight, Margin rate on purchase price excl. VAT, Ecotax | beta.1.5.0.b.build1 |
| Fix beta 1.5: SQL error when creating new declination via import due to quantity modification | beta.1.5.0.b.build1 |
| Correction: in the labels produced with the publisher in PRO version, the prices of the 1.90 type were displayed as 1.9 | beta.1.5.0.b.build1 |
| Corrective beta 1.5: no display of the data in the tab sheet with the PrestaShop versions between 17100 included and 17300 excluded. | beta.1.5.0.b.build1 |
| Corrective : non execution of the hooks of update of the ebay pro module | beta.1.5.0.b.build1 |
| Fix beta 1.5: SQL error when displaying tabs, sI the line limiter is different from 0. | beta.1.5.0.b.build1 |
| Beta fix 1.5: With PS 1.5 or 1.6, impossible to change the quantity either by direct input or by right-clicking and "pasting. " Also an SQL error when creating new products, always due to changing quantities. Error message in direct input : SQL: PROCEDURE prestashop.update_quantity does not exist |
beta.1.5.0.b.build1 |
| Fixed : Error in line xxx of the processing Local procedure Display_Table_xxx You have called the TableTrie function. | beta.1.5.0.b.build1 |
| Beta fix 1.5: MagicEdit crashes on the declination table if the advanced stock management mode is active. | beta.1.5.0.b.build1 |
Novelties version beta 1.5.0.a.build1 |
Version number |
| New: the function "Add the content of another column" of MagicEdit now manages 5 different columns, to make concatenations of multiple columns in a single operation. Very handy to fill in Meta fields (SEO) and references. | beta.1.5.0.a.build2 |
| Novelty : to be able to run Merlin from the command line with the name of the site in the parameters. Allows you to launch the import with the scheduled tasks Windows from a Windows server and thus not having to leave a PC launched and connected all the time. | beta.1.5.0.a.build2 |
| Improvement: roll everything up at the 1st opening of MagicEdit | beta.1.5.0.a.build2 |
| New: thanks to MagicFormula, it becomes possible during imports from the purchase price and the sale price (recommended retail price to be crossed out) to automatically generate a specific price calculated from a margin coefficient on the purchase price (discount TTC = public PV TTC - PA HT * coefficient). Before, this had to be done in Excel, so it could not be automated. | beta.1.5.0.a.build2 |
| Improved: Refresh function to refresh the reading of attachments | beta.1.5.0.a.build2 |
| Major new feature: 1 fast, multi-criteria search tool An "inventory" option, linked to this quick search tool, which will increment the quantity with each search. Of course, the search field works well with the hand shower. |
beta.1.5.0.a.build2 |
| Novelty : MagicEdit, allows you to remove the x first or last characters of the cells. This was missing to be able to remove a chain different from one line to the other, but of constant length. | beta.1.5.0.a.build2 |
| Fix : installing fresh, still no connection configuration "rename me" empty, is created. if there was a "License", we had a crash. It had to do with "New" before "save" | beta.1.5.0.a.build2 |
| Major new feature: it is now possible to add free columns calculated from formulas using as parameters the values present in the other columns. Allows you to calculate and display data such as margin coefficient, product volume, turnover per product, profit, etc... | beta.1.5.0.a.build2 |
| Fixed: Process of 'Global_procedure_color_right_click_field' (Procedures_globales_de_Merlin.colorer_champ_cliqueé_droit), line 60, thread 0 when right-clicking in characteristics | beta.1.5.0.a.build2 |
| New : from PS 1.7.1, complete management of new fields "time of delivery" specific to in-stock products and products depleted + Choice between "delivery Time"= 'No, 'default','specific'. | beta.1.5.0.a.build2 |
| New product pre-filters: not available for sale, no image, no summary, no description, disabled, no positive price, negative margin. Also included in the new "advanced filtering" tool | beta.1.5.0.a.build2 |
| New possibility: with a "Calculated" column and MagicFormula, it becomes possible and simple to display a column indicating the turnover realized by each product, over the period of your choice. | beta.1.5.0.a.build2 |
| New: complete management of the new headings "Low stock level" and "Alert me in case of low stock", by product and by declination | beta.1.5.0.a.build2 |
| Major new feature: in the import table, you can store in the mapping model and have a calculation per column (with MagicFormula) automatically applied to each proofreading of the file. For example to fill the ref declination column by copying the product reference and adding the number of each declination. Or to use a public price column and by performing a -x% operation to calculate and import into the sales price according to the desired margin coefficient. It is no longer necessary to go thro | beta.1.5.0.a.build2 |
| New possibility: with a column of type "Calculated" + MagicFormula, it becomes possible to display the sales margin rate (also called brand rate). | beta.1.5.0.a.build2 |
| Fixed: old random bug finally fixed, an SQL error could be generated when modifying products containing an apostrophe in the description, but only in unencrypted query mode. | beta.1.5.0.a.build2 |
| Fixed: an untitled column in an Excel file was creating an offset and not reading the next column. | beta.1.5.0.a.build2 |
| New: pre-filters allowing to display only the tags already associated (or on the contrary those that are not yet associated) to the selected products (to un-associate them or delete them more quickly). Allows you to easily copy tags between products. | beta.1.5.0.a.build2 |
| New possibility: with MagicFormula, a brand rate can be applied in the import, for the calculation of the selling price. formula: PAchat = PVente - Brand rate in %. in other words PVente = (PAchat x (100 - brand rate)) / 100 |
beta.1.5.0.a.build2 |
| Important new feature: access to csv/xls files from the provider via an API script like https://domainefournisseur/script.php?parametres. This allows to automate the import of files accessible only by PHP HTTP API. | beta.1.5.0.a.build2 |
| New option : the new advanced search tool also allows you to find the products that have variations using some attributes. | beta.1.5.0.a.build2 |
| New possibility: with MagicFormula you can fill in the price impact and unit price impact by calculation from other columns. | beta.1.5.0.a.build2 |
| Fixed: Error in line 430 of the processing Local procedure Send_http_or_ftp_for_image_change. The list is empty. No index is valid for the field TABLE_ps_image. (Index specified: 3). |
beta.1.5.0.a.build2 |
| Major new feature: with MagicFormula, it becomes possible to easily copy and paste from and to the digital columns (e.g. copy the prices excluding VAT into the price column including VAT). No more need to make a re-import export. | beta.1.5.0.a.build2 |
| Improvement: the dropdown list to replace a characteristic value is now sorted in alphanumeric order and allows to quickly find a value by typing the first letters. | beta.1.5.0.a.build2 |
| Improvement: taking into account the multi-line modifications of the checkboxes from the accessories table (columns: is virtual, is orderable, in line only, active, on sale, display the price or the state...) | beta.1.5.0.a.build2 |
| Fixed: error message at the end of the combined exports, in the case where one of the 2 tables had no column sort. | beta.1.5.0.a.build2 |
| Fixed : image of the products missing in the PrestaShop administration of the active baskets (product_mini thumbnails in /tmp missing). | beta.1.5.0.a.build2 |
| Fixed: SQL error when mass modifying in percentage from the categories, the "Minimum quantity" section of the products | beta.1.5.0.a.build2 |
| Improvement: it becomes possible to give the values * (star) and "0" (digit zero) as value to an attribute via the import. | beta.1.5.0.a.build2 |
| Fixed: the SFTP connection to fetch a remote import file was only working if the same connection was also allowed in FTP | beta.1.5.0.a.build2 |
| Patch: White images. Due to a flaw in the image class that does not store its own id when creating an instance. Fixed with version 8.1.b of the connector module. | beta.1.5.0.a.build2 |
| New: full support of the SFTP protocol for retrieving images from an SFTP server and sending them to PrestaShop. | beta.1.5.0.a.build2 |
| New: starting with version 1.7.3, PrestaShop behaves by default as if a "Multiple Features" module was installed. As a result, in Merlin's main window, characteristics tab, it was no longer possible to replace a value without having to delete it first. So we added an option to "Replace" values rather than "Add" them. Note that this possibility was already present in the import window. | beta.1.5.0.a.build2 |
| Correction: not taking into account a characteristic value replacement | beta.1.5.0.a.build2 |
| New: You can launch Merlin by command line with the name of the connection as a parameter, followed by an automatic connection to the site. Allows you to schedule imports by .bat file and scheduled tasks from Windows or from a server. | beta.1.5.0.a.build2 |
| Optimization: speed of deletion of lines in the table of step 3 of the import process | beta.1.5.0.a.build2 |
| New: complete management of the new Manufacturer Part number field (from PS 1.7.7) | beta.1.5.0.a.build2 |
| Correction: not taking into account a characteristic value replacement | beta.1.5.0.a.build2 |
| Improvement: management of "locations" (or non-warehouse locations) that become multi-shops from PS 1.7.5.0 (now stored in the stock available table) | beta.1.5.0.a.build2 |
| Improvement : hiding the blocking message about the impossibility to create categories because category name column is missing during scheduled imports | beta.1.5.0.a.build2 |
| Fixed : untimely change of the file linked to the source when using the scheduler | beta.1.5.0.a.build2 |
| Improvement: during the automatic import, the import window goes over the main window to follow the progress, but without going over the other applications, to keep control of the machine. | beta.1.5.0.a.build2 |
| Fixed: the table of category images could in some cases display thumbnails instead of main images | beta.1.5.0.a.build2 |
| Fixed: crash if you forgot to create a new connection before setting it up, just after re-installing the software | beta.1.5.0.a.build2 |
| Security improvement: the "active" column is removed from the list of columns displayed by default at the first launch, because new users often confuse it with a checkbox to select lines | beta.1.5.0.a.build2 |
| Fixed: crash if you forgot to create a new connection before setting it up, just after re-installing the software | beta.1.5.0.a.build2 |
| Fixed: the indication of the number of ignored rows was sometimes incorrect in the automatic import report | beta.1.5.0.a.build2 |
| Fixed : fatal error when creating the log file of scheduled imports, when this one contains forbidden characters. | beta.1.5.0.a.build2 |
| Improvement: implementation of an input mask on the input field of the import source names, to avoid the use of forbidden characters, causing later errors during the creation of the log file. | beta.1.5.0.a.build2 |
| Change: it was decided to use the term "TASK" instead of "SOURCE". In the planner, an "Event" thus becomes a "Planned Task", more understandable for everyone and especially those who are used to the term "Cron Task". | beta.1.5.0.a.build2 |
| Improvement: confirmation request before deleting a task (source) or a mapping template | beta.1.5.0.a.build2 |
| Fixed: displaying images of PS 1.4 products saved in the new mode when the legacy mode is true | beta.1.5.0.a.build2 |
| Major technical fix: better management of task parallelization, when sending photos to the server in the background, in order to prevent some random crashes that could occur when the user was interacting at the same time with the data in the tables displaying the images. | beta.1.5.0.a.build2 |
| Improved: In the main table, the search for the specific price currently applicable takes into account undefined start and end dates. | beta.1.5.0.a.build2 |
| Major new feature: in the import table, it is possible to add any number of columns not present in the file, to map them to a field in the database, and to fill in the calculation with MagicFormula automatically when reading the file. Allows for example: to add a column with declination references, built from product references and use them as a key, or to add a column mapped to the selling price and calculate them with a formula from the purchase price or public price column. | beta.1.5.0.a.build2 |
| Optimization: Hidden table during mass price rounding (speed gain by a factor of 2 or 3) | beta.1.5.0.a.build2 |
| Major new addition : MagicFormula, you'll love it ! allows you to enter the mouse your own formulas filling of the columns. For example ecotax = prixHT*3%. Also works with text columns, for example : meta description = name+" : "+summary+" "+"reference . The formula can include conditions, for example : if in stock, visibility =true else visibility=false, the functions of mathematics, or management of chains of characters. Each column of each table stores the formulas entered, you can re-use it | beta.1.5.0.a.build2 |
| Fix : Error at line 284 of local Procedure chercher_produits_correspondant_images_remplir_table_de_transfert process. | beta.1.5.0.a.build2 |
| Improvement : added a warning message if you choose the size "Medium" for the display of the logo of the categories in PS 1.7, because they are not enabled by default. | beta.1.5.0.a.build2 |
| New: thanks to MagicFormula, it is possible to fill/modify the columns of the declination table using or conditioning with the values of the parent product, read from the corresponding row in the product table. | beta.1.5.0.a.build2 |
| Fixed for PS 1.7: the currency drop-down lists were empty (because the name column of the PS currency table is no longer filled by PS). | beta.1.5.0.a.build2 |
| Fixed: the product table was not systematically updated when changing supplier references or default suppliers in the suppliers tab. | beta.1.5.0.a.build2 |
| Fixed: dates/times could be displayed without the times, depending on the method used to enter them. | beta.1.5.0.a.build2 |
| Improved: The list of carriers is refreshed with each request to view product associations. This makes it possible to include carriers created outside of Merlin, without having to log out and log back in. | beta.1.5.0.a.build2 |
| New: pre-filters allowing to display only the attachments or documents already associated (or on the contrary those not yet associated) with the selected products (to un-associate them or delete them more quickly). Makes it easier to copy documents between products. | beta.1.5.0.a.build2 |
| New possibility: thanks to Magic Formula, it is possible to modify by calculation the values in the specific price table, such as the discount percentage, using or conditioning with the values of the parent product, read in the corresponding row in the product table, such as the purchase or sale price of the product, or its stock. Example: apply 10% discount on products that have a lot of stock and 5% for others. ... everything can be done in a single operation, without having to use the filter | beta.1.5.0.a.build2 |
| New possibility: thanks to Magic Formula, it becomes possible to fill in the fields of the product translation table with content from any column of the main product table. For example, for SEO, you can mass add in the meta fields information such as the selling price or the values of the characteristics. And as this table is also multi-shop, the time saving becomes phenomenal. | beta.1.5.0.a.build2 |
| Improvement: mass changing of the default declination choice over a large number of lines is 10x faster. | beta.1.5.0.a.build2 |
| Major new feature: MagicEdit is now also available on numeric columns (e.g. price, stock, dimensions, margins...), list columns (e.g. suppliers, taxes...) and checkbox type (e.g. active, default declinations...). This multiplies the possibilities of mass modification, such as for example to fill a price column from a copy and paste of a column from Excel or Word. | beta.1.5.0.a.build2 |
| New possibility: With MagicFormula always, you can mass calculate sales prices and price impacts according to product dimensions (surface area, volume). | beta.1.5.0.a.build2 |
| Novelty : in MagicEdit, the function "copy from another column" is able to fetch the data in another table. For example, you can use the category name of the product, read in the products table, in order to build the reference declinations. It also works with the figures. | beta.1.5.0.a.build2 |
| Improvement: automatic and bi-directional synchronization between the form tab and the suppliers tab. No more need to think about refreshing the other tab when changing the default supplier in one of these two tabs. In the same way, for consistency reasons, the choice of a different supplier from the sheet tab, replaces the value in the supplier reference field by the one already stored for this supplier, as it was already the case if it was done from the products table. | beta.1.5.0.a.build2 |
| Improved: Windows containing a non-fatal error message and an "OK" button to continue now close automatically after 2 minutes. This makes it possible, for example, to automatically continue scheduled imports at night, in case of a SQL error on a line. System unlockable in advanced settings. | beta.1.5.0.a.build2 |
| Fixed: mass modification of the status "Is virtual" in the accessories table | beta.1.5.0.a.build2 |
| Fix : the custom names given to the columns of the tables in the main window, thanks to the configurator of columns, were not taken into account after refresh | beta.1.5.0.a.build2 |
| New major possibility: it becomes possible to import declinations from a single column gathering all the attributes (e.g. "Red,M"). This is thanks to the new columns that can be added in the import, even if they do not exist in the file (e.g. "Color" and "Taile" columns), map to attribute groups" and fill automatically thanks to MagicFormula. | beta.1.5.0.a.build2 |
| Fixed : in the column mapping, we removed "According to stock" in the list, because it was not importable. | beta.1.5.0.a.build2 |
| Optimize : a single query for the entire set of products rather than a product to update their quantities, when one changes the amount of their variations. (PS 1.5 and later) | beta.1.5.0.a.build2 |
| Corrective: update of the date of modification of the products when modifying by batch the quantities of their declinations | beta.1.5.0.a.build2 |
| Optimization: the modification or the choice of another column configuration caused a double refresh of the secondary tables (declinations, specific prices, translation, ...) | beta.1.5.0.a.build2 |
| Fixed: unicode character handling in new product references, before PS 1.5 | beta.1.5.0.a.build2 |
| New: from PS 1.7.5, the field "Location" (or "Location outside warehouses") is read and stored in the table stock_available to remain compatible with PrestaShop. | beta.1.5.0.a.build2 |
| Important new feature: from PS 1.7.2 on, complete management of the new "Physical quantity" section and display of the new "Reserved quantity" section. | beta.1.5.0.a.build2 |
| Optimization: in some cases (e.g. click on the "Save" button) saving changes made to a product or a category from the "File" tabs would update the other tables twice in a row instead of once. | beta.1.5.0.a.build2 |
| Fixed: Error at line 70 of Local procedure partial_reading_and_update_ariana_films_a_l_screen_selected_process lines. | beta.1.5.0.a.build2 |
| Ergonomic fix: in the contextual menus of the columns (right click), the clicked value (the one to be copied/pasted) displayed was not updated when repeating the same operation on another line | beta.1.5.0.a.build2 |
| Fixed: xls files were not listed in the directory when choosing the product export file | beta.1.5.0.a.build2 |
| Optimization: reduction by 3 of the Windows memory consumed by HTML CKEditor editors. Better management when changing the version of CKEditor, avoiding the increase in memory used. | beta.1.5.0.a.build2 |
Novelties version 1.4.2.a.build2 |
Version number |
| Optimization: reduction by 3 of the Windows memory consumed by HTML CKEditor editors. Better management when changing the version of CKEditor, avoiding the increase in memory used. | beta.1.5.0.a.build2 |
| Optimization: in some cases (e.g. click on the "Save" button) saving changes made to a product or a category from the "File" tabs would update the other tables twice in a row instead of once. | beta.1.5.0.a.build2 |
| Important new feature: from PS 1.7.2 on, complete management of the new "Physical quantity" section and display of the new "Reserved quantity" section. | beta.1.5.0.a.build2 |
| New: from PS 1.7.5, the field "Location" (or "Location outside warehouses") is read and stored in the table stock_available to remain compatible with PrestaShop. | beta.1.5.0.a.build2 |
| Optimize : a single query for the entire set of products rather than a product to update their quantities, when one changes the amount of their variations. (PS 1.5 and later) | beta.1.5.0.a.build2 |
| New major possibility: it becomes possible to import declinations from a single column gathering all the attributes (e.g. "Red,M"). This is thanks to the new columns that can be added in the import, even if they do not exist in the file (e.g. "Color" and "Taile" columns), map to attribute groups" and fill automatically thanks to MagicFormula. | beta.1.5.0.a.build2 |
| Improved: Windows containing a non-fatal error message and an "OK" button to continue now close automatically after 2 minutes. This makes it possible, for example, to automatically continue scheduled imports at night, in case of a SQL error on a line. System unlockable in advanced settings. | beta.1.5.0.a.build2 |
| Improvement: automatic and bi-directional synchronization between the form tab and the suppliers tab. No more need to think about refreshing the other tab when changing the default supplier in one of these two tabs. In the same way, for consistency reasons, the choice of a different supplier from the sheet tab, replaces the value in the supplier reference field by the one already stored for this supplier, as it was already the case if it was done from the products table. | beta.1.5.0.a.build2 |
| Novelty : in MagicEdit, the function "copy from another column" is able to fetch the data in another table. For example, you can use the category name of the product, read in the products table, in order to build the reference declinations. It also works with the figures. | beta.1.5.0.a.build2 |
| New possibility: With MagicFormula always, you can mass calculate sales prices and price impacts according to product dimensions (surface area, volume). | beta.1.5.0.a.build2 |
| Major new feature: MagicEdit is now also available on numeric columns (e.g. price, stock, dimensions, margins...), list columns (e.g. suppliers, taxes...) and checkbox type (e.g. active, default declinations...). This multiplies the possibilities of mass modification, such as for example to fill a price column from a copy and paste of a column from Excel or Word. | beta.1.5.0.a.build2 |
| Improvement: mass changing of the default declination choice over a large number of lines is 10x faster. | beta.1.5.0.a.build2 |
| New possibility: thanks to Magic Formula, it becomes possible to fill in the fields of the product translation table with content from any column of the main product table. For example, for SEO, you can mass add in the meta fields information such as the selling price or the values of the characteristics. And as this table is also multi-shop, the time saving becomes phenomenal. | beta.1.5.0.a.build2 |
| New possibility: thanks to Magic Formula, it is possible to modify by calculation the values in the specific price table, such as the discount percentage, using or conditioning with the values of the parent product, read in the corresponding row in the product table, such as the purchase or sale price of the product, or its stock. Example: apply 10% discount on products that have a lot of stock and 5% for others. ... everything can be done in a single operation, without having to use the filter | beta.1.5.0.a.build2 |
| New: pre-filters allowing to display only the attachments or documents already associated (or on the contrary those not yet associated) with the selected products (to un-associate them or delete them more quickly). Makes it easier to copy documents between products. | beta.1.5.0.a.build2 |
| Improved: The list of carriers is refreshed with each request to view product associations. This makes it possible to include carriers created outside of Merlin, without having to log out and log back in. | beta.1.5.0.a.build2 |
| New: thanks to MagicFormula, it is possible to fill/modify the columns of the declination table using or conditioning with the values of the parent product, read from the corresponding row in the product table. | beta.1.5.0.a.build2 |
| Major new addition : MagicFormula, you'll love it ! allows you to enter the mouse your own formulas filling of the columns. For example ecotax = prixHT*3%. Also works with text columns, for example : meta description = name+" : "+summary+" "+"reference . The formula can include conditions, for example : if in stock, visibility =true else visibility=false, the functions of mathematics, or management of chains of characters. Each column of each table stores the formulas entered, you can re-use it | beta.1.5.0.a.build2 |
| Major new feature: in the import table, it is possible to add any number of columns not present in the file, to map them to a field in the database, and to fill in the calculation with MagicFormula automatically when reading the file. Allows for example: to add a column with declination references, built from product references and use them as a key, or to add a column mapped to the selling price and calculate them with a formula from the purchase price or public price column. | beta.1.5.0.a.build2 |
| Improvement: confirmation request before deleting a task (source) or a mapping template | beta.1.5.0.a.build2 |
| Change: it was decided to use the term "TASK" instead of "SOURCE". In the planner, an "Event" thus becomes a "Planned Task", more understandable for everyone and especially those who are used to the term "Cron Task". | beta.1.5.0.a.build2 |
| Improvement: implementation of an input mask on the input field of the import source names, to avoid the use of forbidden characters, causing later errors during the creation of the log file. | beta.1.5.0.a.build2 |
| Improvement: during the automatic import, the import window goes over the main window to follow the progress, but without going over the other applications, to keep control of the machine. | beta.1.5.0.a.build2 |
| Improvement: management of "locations" (or non-warehouse locations) that become multi-shops from PS 1.7.5.0 (now stored in the stock available table) | beta.1.5.0.a.build2 |
| New: complete management of the new Manufacturer Part number field (from PS 1.7.7) | beta.1.5.0.a.build2 |
| Optimization: speed of deletion of lines in the table of step 3 of the import process | beta.1.5.0.a.build2 |
| New: You can launch Merlin by command line with the name of the connection as a parameter, followed by an automatic connection to the site. Allows you to schedule imports by .bat file and scheduled tasks from Windows or from a server. | beta.1.5.0.a.build2 |
| New: starting with version 1.7.3, PrestaShop behaves by default as if a "Multiple Features" module was installed. As a result, in Merlin's main window, characteristics tab, it was no longer possible to replace a value without having to delete it first. So we added an option to "Replace" values rather than "Add" them. Note that this possibility was already present in the import window. | beta.1.5.0.a.build2 |
| New: full support of the SFTP protocol for retrieving images from an SFTP server and sending them to PrestaShop. | beta.1.5.0.a.build2 |
| Improvement: taking into account the multi-line modifications of the checkboxes from the accessories table (columns: is virtual, is orderable, in line only, active, on sale, display the price or the state...) | beta.1.5.0.a.build2 |
| Improvement: the dropdown list to replace a characteristic value is now sorted in alphanumeric order and allows to quickly find a value by typing the first letters. | beta.1.5.0.a.build2 |
| Major new feature: with MagicFormula, it becomes possible to easily copy and paste from and to the digital columns (e.g. copy the prices excluding VAT into the price column including VAT). No more need to make a re-import export. | beta.1.5.0.a.build2 |
| New possibility: with MagicFormula you can fill in the price impact and unit price impact by calculation from other columns. | beta.1.5.0.a.build2 |
| New option : the new advanced search tool also allows you to find the products that have variations using some attributes. | beta.1.5.0.a.build2 |
| Important new feature: access to csv/xls files from the provider via an API script like https://domainefournisseur/script.php?parametres. This allows to automate the import of files accessible only by PHP HTTP API. | beta.1.5.0.a.build2 |
| New possibility: with MagicFormula, a brand rate can be applied in the import, for the calculation of the selling price. formula: PAchat = PVente - Brand rate in %. in other words PVente = (PAchat x (100 - brand rate)) / 100 |
beta.1.5.0.a.build2 |
| New: pre-filters allowing to display only the tags already associated (or on the contrary those that are not yet associated) to the selected products (to un-associate them or delete them more quickly). Allows you to easily copy tags between products. | beta.1.5.0.a.build2 |
| New possibility: with a column of type "Calculated" + MagicFormula, it becomes possible to display the sales margin rate (also called brand rate). | beta.1.5.0.a.build2 |
| Major new feature: in the import table, you can store in the mapping model and have a calculation per column (with MagicFormula) automatically applied to each proofreading of the file. For example to fill the ref declination column by copying the product reference and adding the number of each declination. Or to use a public price column and by performing a -x% operation to calculate and import into the sales price according to the desired margin coefficient. It is no longer necessary to go thro | beta.1.5.0.a.build2 |
| New: complete management of the new headings "Low stock level" and "Alert me in case of low stock", by product and by declination | beta.1.5.0.a.build2 |
| New possibility: with a "Calculated" column and MagicFormula, it becomes possible and simple to display a column indicating the turnover realized by each product, over the period of your choice. | beta.1.5.0.a.build2 |
| New product pre-filters: not available for sale, no image, no summary, no description, disabled, no positive price, negative margin. Also included in the new "advanced filtering" tool | beta.1.5.0.a.build2 |
| New : from PS 1.7.1, complete management of new fields "time of delivery" specific to in-stock products and products depleted + Choice between "delivery Time"= 'No, 'default','specific'. | beta.1.5.0.a.build2 |
| Major new feature: it is now possible to add free columns calculated from formulas using as parameters the values present in the other columns. Allows you to calculate and display data such as margin coefficient, product volume, turnover per product, profit, etc... | beta.1.5.0.a.build2 |
| Novelty : MagicEdit, allows you to remove the x first or last characters of the cells. This was missing to be able to remove a chain different from one line to the other, but of constant length. | beta.1.5.0.a.build2 |
| Major new feature: 1 fast, multi-criteria search tool An "inventory" option, linked to this quick search tool, which will increment the quantity with each search. Of course, the search field works well with the hand shower. |
beta.1.5.0.a.build2 |
| Improved: Refresh function to refresh the reading of attachments | beta.1.5.0.a.build2 |
| New: thanks to MagicFormula, it becomes possible during imports from the purchase price and the sale price (recommended retail price to be crossed out) to automatically generate a specific price calculated from a margin coefficient on the purchase price (discount TTC = public PV TTC - PA HT * coefficient). Before, this had to be done in Excel, so it could not be automated. | beta.1.5.0.a.build2 |
| Improvement: roll everything up at the 1st opening of MagicEdit | beta.1.5.0.a.build2 |
| Novelty : to be able to run Merlin from the command line with the name of the site in the parameters. Allows you to launch the import with the scheduled tasks Windows from a Windows server and thus not having to leave a PC launched and connected all the time. | beta.1.5.0.a.build2 |
| New: the function "Add the content of another column" of MagicEdit now manages 5 different columns, to make concatenations of multiple columns in a single operation. Very handy to fill in Meta fields (SEO) and references. | beta.1.5.0.a.build2 |
Fixes version 1.4.2.a.build2 |
Version number |
| Fix : installing fresh, still no connection configuration "rename me" empty, is created. if there was a "License", we had a crash. It had to do with "New" before "save" | beta.1.5.0.a.build2 |
| Fixed: Process of 'Global_procedure_color_right_click_field' (Procedures_globales_de_Merlin.colorer_champ_cliqueé_droit), line 60, thread 0 when right-clicking in characteristics | beta.1.5.0.a.build2 |
| Fixed: old random bug finally fixed, an SQL error could be generated when modifying products containing an apostrophe in the description, but only in unencrypted query mode. | beta.1.5.0.a.build2 |
| Fixed: an untitled column in an Excel file was creating an offset and not reading the next column. | beta.1.5.0.a.build2 |
| Fixed: Error in line 430 of the processing Local procedure Send_http_or_ftp_for_image_change. The list is empty. No index is valid for the field TABLE_ps_image. (Index specified: 3). |
beta.1.5.0.a.build2 |
| Fixed: error message at the end of the combined exports, in the case where one of the 2 tables had no column sort. | beta.1.5.0.a.build2 |
| Fixed : image of the products missing in the PrestaShop administration of the active baskets (product_mini thumbnails in /tmp missing). | beta.1.5.0.a.build2 |
| Fixed: SQL error when mass modifying in percentage from the categories, the "Minimum quantity" section of the products | beta.1.5.0.a.build2 |
| Improvement: it becomes possible to give the values * (star) and "0" (digit zero) as value to an attribute via the import. | beta.1.5.0.a.build2 |
| Fixed: the SFTP connection to fetch a remote import file was only working if the same connection was also allowed in FTP | beta.1.5.0.a.build2 |
| Patch: White images. Due to a flaw in the image class that does not store its own id when creating an instance. Fixed with version 8.1.b of the connector module. | beta.1.5.0.a.build2 |
| Correction: not taking into account a characteristic value replacement | beta.1.5.0.a.build2 |
| Correction: not taking into account a characteristic value replacement | beta.1.5.0.a.build2 |
| Improvement : hiding the blocking message about the impossibility to create categories because category name column is missing during scheduled imports | beta.1.5.0.a.build2 |
| Fixed : untimely change of the file linked to the source when using the scheduler | beta.1.5.0.a.build2 |
| Fixed: the table of category images could in some cases display thumbnails instead of main images | beta.1.5.0.a.build2 |
| Fixed: crash if you forgot to create a new connection before setting it up, just after re-installing the software | beta.1.5.0.a.build2 |
| Security improvement: the "active" column is removed from the list of columns displayed by default at the first launch, because new users often confuse it with a checkbox to select lines | beta.1.5.0.a.build2 |
| Fixed: crash if you forgot to create a new connection before setting it up, just after re-installing the software | beta.1.5.0.a.build2 |
| Fixed: the indication of the number of ignored rows was sometimes incorrect in the automatic import report | beta.1.5.0.a.build2 |
| Fixed : fatal error when creating the log file of scheduled imports, when this one contains forbidden characters. | beta.1.5.0.a.build2 |
| Fixed: displaying images of PS 1.4 products saved in the new mode when the legacy mode is true | beta.1.5.0.a.build2 |
| Major technical fix: better management of task parallelization, when sending photos to the server in the background, in order to prevent some random crashes that could occur when the user was interacting at the same time with the data in the tables displaying the images. | beta.1.5.0.a.build2 |
| Improved: In the main table, the search for the specific price currently applicable takes into account undefined start and end dates. | beta.1.5.0.a.build2 |
| Optimization: Hidden table during mass price rounding (speed gain by a factor of 2 or 3) | beta.1.5.0.a.build2 |
| Fix : Error at line 284 of local Procedure chercher_produits_correspondant_images_remplir_table_de_transfert process. | beta.1.5.0.a.build2 |
| Improvement : added a warning message if you choose the size "Medium" for the display of the logo of the categories in PS 1.7, because they are not enabled by default. | beta.1.5.0.a.build2 |
| Fixed for PS 1.7: the currency drop-down lists were empty (because the name column of the PS currency table is no longer filled by PS). | beta.1.5.0.a.build2 |
| Fixed: the product table was not systematically updated when changing supplier references or default suppliers in the suppliers tab. | beta.1.5.0.a.build2 |
| Fixed: dates/times could be displayed without the times, depending on the method used to enter them. | beta.1.5.0.a.build2 |
| Fixed: mass modification of the status "Is virtual" in the accessories table | beta.1.5.0.a.build2 |
| Fix : the custom names given to the columns of the tables in the main window, thanks to the configurator of columns, were not taken into account after refresh | beta.1.5.0.a.build2 |
| Fixed : in the column mapping, we removed "According to stock" in the list, because it was not importable. | beta.1.5.0.a.build2 |
| Corrective: update of the date of modification of the products when modifying by batch the quantities of their declinations | beta.1.5.0.a.build2 |
| Optimization: the modification or the choice of another column configuration caused a double refresh of the secondary tables (declinations, specific prices, translation, ...) | beta.1.5.0.a.build2 |
| Fixed: unicode character handling in new product references, before PS 1.5 | beta.1.5.0.a.build2 |
| Fixed: Error at line 70 of Local procedure partial_reading_and_update_ariana_films_a_l_screen_selected_process lines. | beta.1.5.0.a.build2 |
| Ergonomic fix: in the contextual menus of the columns (right click), the clicked value (the one to be copied/pasted) displayed was not updated when repeating the same operation on another line | beta.1.5.0.a.build2 |
| Fixed: xls files were not listed in the directory when choosing the product export file | beta.1.5.0.a.build2 |
Version 1.4.2.a.build1 |
Version number |
| Novelty : it is possible to filter rows according the value in the column "Is a pack" | 1.4.2.a.build1 |
| Update QuickSupport version 15 | 1.4.2.a.build1 |
| Fixes : several minor defects in the tool of search and automatic association of the images | 1.4.2.a.build1 |
| Fix step 3 of the import, editing, proofreading performed twice, with columns of features : error on line 138 of the processing Procedure local Verification_existence_elements_création_sinon. A field has no sub-element. The operator '.' is forbidden. |
1.4.2.a.build1 |
| Fix : Processing of 'local Procedure code_affichage_ligne_table_ps_specific_prices' (FEN_MAIN.PROCEDURE.code_affichage_ligne_table_ps_specific_prices), line 196, thread 0 What has happened in the past ? The list is empty. No index is not valid for the field TABLE_ps_product. |
1.4.2.a.build1 |
| Fix : after drag and paste a picture on a selection of the same image for several products (to replace it), while other images may be still in court of transfer, crash : error on line 19 of the processing Procedure local Lance_clignotement_bouton_refresh_product. You have called the function TimerSys. Unable to create a timer in a thread without a window : it would never be executed. |
1.4.2.a.build1 |
| Fix : when expanding the height of the panel attributes, the lift of the right table would disappear in some configurations. | 1.4.2.a.build1 |
| orrectif : When doing a copy paste vertical of a location in a warehouse since the table of the declensions : Error on line 287 of the treatment Procedure local mass_update_combi_selectionées_pour1_seule_ou_all_selected_shop. A field has no sub-element. The operator '.' is forbidden. |
1.4.2.a.build1 |
| Fix : the import function of the marks was incomplete (from ps 1.7.6, it got mandatory to create a line in manufacturer_lang for each brand new) | 1.4.2.a.build1 |
| Fix : the pictures of the categories are not processed from the import window, when the key e synchro categories is set to "Name or" tree | 1.4.2.a.build1 |
| Fix : Error at line 1287 of internal Procedure get_info_for_legende process. A value should have been returned by 'Method mySQLExec'. |
1.4.2.a.build1 |
| Fix : Error at line 1144 of internal Procedure chercher_historique process. A value should have been returned by 'Method mySQLExec'. |
1.4.2.a.build1 |
| Fix : error on line 196 of the treatment Procedure local code_affichage_ligne_table_ps_specific_prices. The list is empty. No index is not valid for the field TABLE_ps_product. |
1.4.2.a.build1 |
| Hotfix : failed to create thumbnails of pictures | 1.4.2.a.build1 |
| Fix : error in the script to display specific price (price discovery of a product “sucks”).Error at line 1144 of internal Procedure chercher_historique process. A value should have been returned by 'Method mySQLExec'. |
1.4.2.a.build1 |
| Improvement : a new option in the search tool and automatic association between the image of products and variations, that allow to associate the variations of the images that do not meet the cirtères association products | 1.4.2.a.build1 |
| Improvement : the lists of rules of tax to exclude those who have a status of "deleted" in the database | 1.4.2.a.build1 |
| Improvement : allow pipe (|) in the fields title-tag | 1.4.2.a.build1 |
| Améioration : it is no longer necessary to remove the breaks in the tables, nor the order by product ID growing to achieve an export combined products+variations. | 1.4.2.a.build1 |
Version 1.4.1.4.build1 |
Version number |
| Improvement : the slice table of margin rates of the import window is twice as wide | 1.4.1.a.build1 |
| Enhancement : the message "a Reading of the complete list of the ids of the categories" remains displayed throughout the import process, it disappears at the end of the import. Relevance to other messages of the type "pop-up". Replaced by messages at the bottom of the window. |
1.4.1.a.build1 |
| Fix : Method SQLPrepare (SQLManagerX.SQLPrepare), line 70 Global procedure upload_liste_images_a_transferer (Procedures_globales_de_Merlin.upload_liste_images_a_transferer), line 949 |
1.4.1.a.build1 |
| Fix : process of 'internal Procedure chercher_historique' (Procedures_globales_de_Merlin.upload_liste_images_a_transferer), line 1129, thread 0 A value should have been returned by 'internal Procedure chercher_historique'. |
1.4.1.a.build1 |
| Following the passage of PS 17.4 to 1.7.6, many failed import of products (listed orphans) | 1.4.1.a.build1 |
Older versions novelties and improvements |
Version number |
Discover all new key features about photos management into this blog post. |
1.4.0.a.build2 |
| Improvement : to save time, do more download the product images via the import, the lines that indicate "not exists" (or if one has not selected the option to "Create products that are not existing" or that are not associated to the shop by default) or "failed". Similarly, don't upload the pictures of the categories of "orphans". Same for the images of the products of déclinaisosns "orphan". | 1.4.0.a.build2 |
| Security : it is no longer possible to connect with the key in this encryption by default. Merlin asks you to change it if you have not yet done so. Thus we limit further risk of hacking of your data or injection into the base. | 1.4.0.a.build2 |
| Security : Sitolog the choice of security to all floors. It is now made mandatory to choose the option to encrypt the requests sent to the server when the connection is not HTTPS. We recommend the activation of the protocol TSLS (HTTPS Strict). In addition, if you are in HTTPS and when you choose not to encrypt the queries to take advantage of the maximum speed, Merlin sends an identification code with each request (which is mandatory to be encrypted) to the connector, that the analysis before a | 1.4.0.a.build2 |
| Improvement : a new optimization of the initialization code of Merlin is yet to win a little time by deleting (together) a dozen of SQL requests. On a control site, the opening phase passes, 43 seconds, 26 seconds | 1.4.0.a.build2 |
| Ergonomics : the column displaying the photos is moved in the # 1 position in the table of product images | 1.4.0.a.build2 |
| Novelty : an option that allows you to protect the legends, current images against the automatic re-generation, when one re-assigns the same camera to the same product, for example, to add variations. | 1.4.0.a.build2 |
| New : adding in the options of automatic search on photos to associate two new filters on the value of the item to compare it to the name of the file (before the last separator and after the first separator). Allows for example to combine images as 123_toto.jpg the reference products 123_toto_beta, 123_toto_final | 1.4.0.a.build2 |
| Novelty is brilliant : the generator and modifier of variations allow this to define a list of photos to associate (and éventuellment download before) to each attribute value. The variations (either all or just the ones changed, the ones pre-selected) using the attribute will receive the photo. Thus, for example, from the creation (the choice also works or not with the variations already existing), you can associate the photo blue to all the variations of blue in your products. An additional opt | 1.4.0.a.build2 |
| New : new option in the settings of the automatic search of the images of products and categories, "Equality in the strict sense, which allows you to choose if e.g. a file named "ben" should not be associated with a reference "abeni" (the difference between "contains "and" equal to "). Was added in particular for associations automatic modifications according to the values of attributes (ex : strict equality, the size L is not associated with the attribute BLUE (blue contains a l, but the blue i | 1.4.0.a.build2 |
| Improvement : add a progress meter dynamic during the automatic search of photos to be linked to the products and / or modifications in a local folder or a remote. | 1.4.0.a.build2 |
| Novelty : in the table of product images, a column tells you the name of the history file that was used to make the image. This allows you to filter your images by file name, for example, to rempalcer by lôt the image common to several products or even use it as part of this column, with MagicEdit to fill in the ALT tags (captions). | 1.4.0.a.build2 |
| Security : the recovery of the database name, its prefix, of the number of employee and the key value is also encrypted. | 1.4.0.a.build2 |
| Optimization : the encryption of the queries being made mandatory for the HTTP connections are not secure, the encryption code and decryption queries, and data has been optimized for a gain in speed of the order of 40% in order to reduce a bit the impact su the rla speed, the enhancement of security. For those who are already using encryption, it is a net gain in speed, especially for the treatment of mass and imports, but also for the reading of the data. | 1.4.0.a.build2 |
| Security : all the scripts of the module connector (which also changes name) are now executable only after identification with the user and the password used PrestaShop. In addition, when Merlin uses one of the scripts that it encrypts the password to identify | 1.4.0.a.build2 |
| New : a new option to import the photos of the products to those who do not have declensions (lines for which the key synchro versions is empty). This allows you to import the photos during the import of products AND the import of the variations without creating duplication and to avoid creating products that are simple without a photo. | 1.4.0.a.build2 |
| Newness to which you réviez can be for your SEO : a new tool for the intelligent charging and configurable legends (ALT tags) of the pictures of the products, at the same time as the addition (or now replacement) of photos, to improve the SEO of your listings in a turn of the hand. You can, for example, as a prior to automatically insert the name of the products and / or the file, but also the references, brands, category, bar code,... And even the values of attributes common to all variations r | 1.4.0.a.build2 |
| New : thanks to the management of the history of images, you can now replace the photo of all of the products that already have a photo created from the same file name, and do not add on the other products. Hyper practice to update the same photo on an infinite number of products without even looking which are concerned. For this it is necessary to filter the products that have at least one photo, and then choose the option "Always replace" and "never add image" | 1.4.0.a.build2 |
| Novelty : MagicEdit available in the column containing the paths and urls of the photos in the import table, for example, to make correction in the mass of the domain name or replace the url by a local path | 1.4.0.a.build2 |
| New : Merlin allows you to choose to display some photos of product that when the customer displays the page in a language data. This is the technique used on the own site, Sitolog for pictures containing texts in French or in English. | 1.4.0.a.build2 |
| Security : to prevent any risk of attack by SQL injection, the queries sent to the server are now compulsorily encrypted. In addition, all requests received by the new module connector pass through a stage of identification of the sender (the password checking PrestaShop) to block any attempt to access with another program. With this secure, multi-storey, it naturally loses a bit in speed, especially during imports, but it is the price of tranquility. | 1.4.0.a.build2 |
| Security : strengthening the securing of the first connection, intended to retrieve the name of the database and its prefix, after you have asked your PrestaShop to identify you, by encrypting the password from the encryption key. Because of this, this key is not read automatically by Merlin, you are asked to enter | 1.4.0.a.build2 |
| Novelty : and not least, the drag-and-drop a photo into the image table in the bottom right, is used to replace a picture by another may be present on multiple rows pre-selected. Combined with the new sort on the name of the file history have been used to produce the images, this gives a second method to replace in one operation, the same image on an infinite number of products. | 1.4.0.a.build2 |
| New : option to send a photo to only the products or categories that do not yet have image. This avoids the need to or even filter the products. | 1.4.0.a.build2 |
| Improvement : in the generator PRO tags, all pricing and percentage of various are rounded to 2 digits after the decimal point. | 1.4.0.a.build2 |
| Ergonomics : the option to add the FTP port number in the url is available in the settings window to add images from the import. Before it was only accessible from the window for manually adding a image address. | 1.4.0.a.build2 |
| New : in the tab Sheet category, the possibility to choose between the display of the thumbnail or the main picture, to permit the addition or replacement by drag-and-drop a new photo category or thumbnail (requires PS 1.6.1 +) | 1.4.0.a.build2 |
| Novelty : the possibility to choose regardless of the size of the photos of the table of products and variations, from the sheet and table of images | 1.4.0.a.build2 |
| Novelty : in the image table of the categories, when selected the display format for the "Medium" column "Miniature" is used to indicate whether that thumbnail image from a main image or a thumbnail . This enables you to quickly see which categories have or not a thumbnail, and also to conduct replacement of the image by drag-and-drop in the format of your choice (photo or main thumbnail) | 1.4.0.a.build2 |
| Improvement : a table of images category no longer displays an empty row for the categories no photo | 1.4.0.a.build2 |
| New : clicking on a product photo or category, in tables or forms, allows you to view it in its size, effective in a floating window. Can be disabled in the display options. Very useful for those who select a visual representation of their products, without giving too much enlarge the pictures in the tables and to check the quality of the photos. Also works for new photos "thumbnails" categories. |
1.4.0.a.build2 |
| Improved : the display format of "Great" photos of the categories is set to 2 x smaller to avoid taking unnecessarily all over the place in the tables | 1.4.0.a.build2 |
| New : ability to export and re-import the result to the mailing list, images and product categories, with conservation of the status (sent, failed,...) and color of each line. Hyper convenient if you have connection problems and want to return later only the missing photos | 1.4.0.a.build2 |
| Major new addition : the search tools and automatic association of photos to a folder also work to present on the variants (comparison of the name of the file or folder of images with, for example, the reference to the declination, or their user id, or the color of an attribute). | 1.4.0.a.build2 |
| Newness, adding in the tables of the sending of images, a column indicating the status of the transfer. This allows you to filter the rows that failed to export the file, before you do raise it. | 1.4.0.a.build2 |
| Improvement : in the tab sheets, the images are automatically magnified (homométhiquement) to occupy all the space disponique | 1.4.0.a.build2 |
| Improvement : in the tab "Data" of the categories, the displayed image was always the version "small". In the case where the size "small" is removed from the list of thumbnails, no image is displayed. Has this tab displays the same image as the selected size for the main table. | 1.4.0.a.build2 |
| Novelty : the first time you connect to a website, this version of Merlin will suggest you to copy the files stored in the root of img/p, to the new folder /img/p/merlin archive photos télépchargées by Merlin. | 1.4.0.a.build2 |
| Improved handling of urls FTP of images, from lists to Excel or import from different suppliers. At present the software is able to manage differentiated the names of the user and the FTP passwords for each image | 1.4.0.a.build2 |
| New : when you duplicate of the products, with their photos, their past history was created by Merlin, is also duplicated. This allows also a strict management of the duplicates images. | 1.4.0.a.build2 |
| Improvement : the photos of products and categories (and the thumbnails now) grow all only in proportion to the size of your screen | 1.4.0.a.build2 |
| Novelty : to be able to request the deletion of the images present (physically and in the database) of a product before they add new ones via the import function. In addition, the deletion script runs in a background task in parallel not to slow down the import process. | 1.4.0.a.build2 |
| New options for handling duplicates sending image. For example, "add only if the product has not yet the" image, optimum for the sites on which the products have only one photo. | 1.4.0.a.build2 |
| Novelty : the transfer of pictures through their url, http or ftp, allows you to save a copy of the image on the server, thus avoiding the need to transfer again if used a second time (this was the case only for local files) | 1.4.0.a.build2 |
| New : option "Don't re-transfèrer the same files that you have already sent is deactivated. | 1.4.0.a.build2 |
| New : conservation in a table of the database, the history of the association of images to each product, then allowing a real management avoidance of double images. | 1.4.0.a.build2 |
| New : option to ajouterou not an image based on the fact that the same file has already been sent or not, irrespective of the size and date of the file. | 1.4.0.a.build2 |
| Novelty : it is possible to transfer the local files (images) to PrestaShop without using FTP. So no more need to configure the FTP. More simple and faster | 1.4.0.a.build2 |
| Major new addition : the import function now allows, as for the products, to import also the photos the main (or logos), and thumbnails of categories. | 1.4.0.a.build2 |
| Faster Option : do not re-upload PrestaShop images already sent (same name), even if the date and the file size is different. | 1.4.0.a.build2 |
| New features : sending images to the categories lets you choose between the creation of the photo or main thumbnail (from ps 1.6, categories can have two different images between their thumbnails, miniature and large-format photos). In the image table, a new column indicates whether the displayed photo is the main or thumbnail. All other function s(removal, replacement), are compatible and allow you to manage both formats. |
1.4.0.a.build2 |
| Novelty much in demand : automatic deletion of photo files on the server at the time of deletion of products and categories In multi-shops, intelligent management, does not delete the photo files that if the products or categories are removed from all shops. Processing in a background task in parallel not to slow down your work. | 1.4.0.a.build2 |
| Improvement : the option that allows you not to re-associate images to products if the same file is present on server, worked only for local images, now works also with those provided through a url. | 1.4.0.a.build2 |
| Revolutionary with PrestaShop : Merlin allows you to present, through its historical images associated with the products, to replace (update) old images with a new one using the same file name (with the option to choose "never," "all the time", or "only if the date or size of files differ"). It retains the Id's, descriptions,...one replaces just the thumbnails in the new version. This mode and can be switched off if you préferre always add a second image | 1.4.0.a.build2 |
| Novelty good practice : the legend of the images added via the import function is filled in automatically according to the settings defined in the settings window of the photos, as is already the case for the photos added from the main window. No more need to add a column "Legend", or use the tool remplisagge automatic captions after the import, everything is done in a single operation. You work even faster. | 1.4.0.a.build2 |
| Improvement : no user who reported failure to import, or other errors as a result of the use of the acceleration factor, which we had mounted to 500% (x5), we have increased this limit to 1000% (x10). On our own server, it works even with such a figure. As a reminder, the factor of acceleration plays on the max size of the queries sent to the server. The higher it is, the more Merlin, for example, can process a large number of rows to import in a single query. | 1.4.0.a.build2 |
| Drastic improvement in speed : the preparation phase for the sending of images of goods and especially of variations, after the import is now taking a few seconds on very large files instead of tens of minutes . | 1.3.3.a.build2 |
| Enhancement : Merlin signals the presence of a filter column when the result of the display of the table gives an empty table and indicates the number of hidden lines | 1.3.3.a.build2 |
| New : added a link to the version history at the bottom of the 1st window | 1.3.3.a.build2 |
| Improvement : filters, columns that lead to an empty display of the table are visible. | 1.3.3.a.build2 |
| Improvement : added the function "Remember my choice and do not show" on all of the windows options when you travel or association of products and categories | 1.3.2.a.build1 |
| New : possibility to define and add a pause between each sending of SQL queries, to slow down, to Merlin, when the host has configured a quota of requests per unit of time on the server (in the case of shared servers at OVH). This helps avoid blockages in access of 10 min when you import or changes massive. | 1.3.2.a.build1 |
| Enhancement : the button "Refresh" of the table of the products (and accessories) flashes, after modification of the specific price, if the column date of the last modification is present, because the focus is now changed. | 1.3.2.a.build1 |
| Improvement : the inclusion of the column "Position" may render incomplete the content of the column "List of categories" (the fact that Position varies for each category associated with a product). This was just reported in the tooltips. This is now automatically controlled by the code. When one adds the colonen "Position", this removes the column lists the categories associated with them, and vice versa. | 1.3.2.a.build1 |
| Improvement of the import code to limit the number of SQL queries sent to the server (the previous version was sending at least one request per line. This version allows you to consolidate up to 300 rows in a single query). | 1.3.2.a.build1 |
| Improvement : the last change date of the products is now updated when it adds, modifies, or deletes one or more specified prices. This allows the execution of automatic scripts "hookés" (cleaning the cache, updating, market squares, etc.) as a result of the changes made via the tab-specific prices. | 1.3.2.a.build1 |
| Improvement : if the column "New price base" is present in the import, but contains empty cells, they are treated now as if they contennaient (-1), which is the code used by PrestaShop to not change the base price (what users know). Previously this was important to the value 0, and thus made the products free. | 1.3.1.d.build1 |
| Safety : in the event of unexpected closure of the main window, the app offers you to initiate a check/repair of the structure of the categories. | 1.3.1.d.build1 |
| Improvement : the function "View web page" is now multi shops. Displays the page of the product or category in the shop of the selected line. | 1.3.1.d.build1 |
| New : from PS 1.7.3.0 , PrestaShop has its own characteristics mode to multiple values is now detected and supported by Merlin Backoffice | 1.3.1.a.build1 |
| Improvement : some warning messages or requests for confirmation have now an option "Do not show" to earn even a little bit more time. | 1.3.1.a.build1 |
| Improvement : in the exported files, the text "- -" indicating on the screen the lack of a supplier or brand, are replaced by channels empty | 1.3.1.a.build1 |
| Fix : using the button "New" products back in PrestaPricing when the button had two distinct functions. | 1.3.1.a.build1 |
| Change in mass as possible for the date added column products | 1.3.1.a.build1 |
| Novelty : to be able to export a “combined”, that is to say an export of the table of declinations, but with the addition in the same file, in each line, the columns of the products table | 1.3.1.a.build1 |
| Labels PRO : Able to move the slides by clicking the arrows on orange (more intuitive than moving the input field) | 1.3.1.a.build1 |
| Improvement : the thumbnails in the table of variations will now display the thumbnail of the image having the smallest value in a position, from among those associated with the declination (or the cover image of the product if none of the images are directly related to the declension) | 1.3.1.a.build1 |
| Labels PRO : It is possible to choose the position of the 1st label that will be printed on the sheet. Useful to avoid the wastage by printing on the same sheet, the following labels already printed. | 1.3.0.c.build1 |
| Labels PRO : the areas can print the contents of the columns 'dynamic', as an attribute, or a particular characteristic or even the 5 columns are "Customizable" to print non-standard data. | 1.3.0.c.build1 |
| Labels PRO : possibility to choose a background image of label is different for products that are on sale or not. | 1.3.0.c.build1 |
| Labels PRO : The field settings of an area (choice of content, font size, color, etc...) to hide automatically when it is reduced to a size that is not visible, to minimise the interface | 1.3.0.c.build1 |
| Labels PRO : copy and paste mass parameters (ex : size, font or color text so as not to have to set up each area one by one) | 1.3.0.c.build1 |
| Novelty : in the table of décinaisons, it was already possible to include a column for each attribute of the declination. Now, when one of the columns is related to a group of attributes of type "Color", the cell background is colored using the color associated with the value of the attribute. In short one sees on the color or colors of each declension. | 1.3.0.c.build1 |
| Labels PRO : option to view two images (or logos) different | 1.3.0.c.build1 |
| Labels PRO : a field label can now display a QR code pointing to the page of your choice or the product page. Realize true electronic labels giving as much information as possible. | 1.3.0.c.build1 |
| Labels PRO : It is possible to request that the text, the border or the background color of areas that display an attribute of type "Color" is printed in the color of this attribute. Usefulness the most common : include in the label a colored dot representing the color of the declination. | 1.3.0.c.build1 |
| Label PRO, you can define the areas, texts, and frameworks as being "tranparents" (it is the background colour of the label that appears in place or not, depending on the value of the discount rate applied to the article). Practice to display certain information relevant only when the product is in the balance. | 1.3.0.c.build1 |
| Label PRO : adding an internal margin of about 0.5 mm, placing them into the text boxes so that the text does not touch the frames | 1.3.0.c.build1 |
| Label PRO : able to place in the top, middle or bottom of the 2 block F and G (log, bar code, photos, discount) | 1.3.0.c.build1 |
| Label PRO : you can choose to move to the left or to the right of the symbol of the currency | 1.3.0.c.build1 |
| Label PRO : rounded corners configurable for each zone(allows you to make an area round) | 1.3.0.c.build1 |
| Label PRO : being able to orient (rotate) the contents of each box. For example, to print -70% at 45°, or the barcode vertically. | 1.3.0.c.build1 |
| Label PRO : It is possible to add a line return between the labels of the zones and their value | 1.3.0.c.build1 |
| Label PRO : background color (parametrable) independently for each zone. | 1.3.0.c.build1 |
| With the extension Labels PRO : Each area of the label can have its own framework | beta.1.3.0.b.build1 |
| With the extension Labels PRO : Ability to add a background image to the labels | beta.1.3.0.b.build1 |
| With the extension Labels PRO : It is possible to set a Label fixed to the value of each cell of the labels (Ex : Ref : to the front of each reference) | beta.1.3.0.b.build1 |
| With the extension Labels PRO : Adding 2 areas of free text, common to all labels | beta.1.3.0.b.build1 |
| With the extension Labels PRO : Each text area label can have its own font and centering horizontal and vertical | beta.1.3.0.b.build1 |
| With the extension Labels PRO : Generation of labels that are square with rounded corners or round | beta.1.3.0.b.build1 |
| With the extension Labels PRO : The editor tag is now dynamic, it shows you a simulation of the result in real time. | beta.1.3.0.b.build1 |
| With the extension Labels PRO : any column of the tables can now be used in labels. Customize at your leisure. | beta.1.3.0.b.build1 |
| With the extension Labels PRO : Size of the internal areas of the label configurable (12 zones re - scalable), thanks to a new graphical user interface with sliders. Thus, we can for example hide areas, extend more across the width .. | beta.1.3.0.b.build1 |
| With the extension Labels PRO : Content of labels differentiated and stored between products and variations | beta.1.3.0.b.build1 |
| Improvement : if, after you have selected other categories, in addition to the one(s) that is already on, the program re-selects automatically the product that was selected before this operation | beta.1.3.0.a.build1 |
| Optimization : the deletion of features does not require more rereading of the database to refresh the table. | beta.1.3.0.a.build1 |
| Improvement : after the refresh of the table of products, if the product that was selected is still listed, it is not only reselectionné automatically, but in most other tables, and tabs that display information on this product, are no longer flushed. One does not lose more time to wait for them to meet again, with the same information. It gains in fluidity. Attention : functionality removed then in the 1.3.2 version because there are cases where this refresh is necessary (change of configuratio | beta.1.3.0.a.build1 |
| Novelty is much more than a detail : when a filter is put in place in a column, the title of the indicates, in color, with an explicit text such as "a Quantity greater than 10". As well, without having to go in the contextual menu of each column, you immediately see all the active filters. | beta.1.3.0.a.build1 |
| Improvement : the refresh of the contents of the tables do more to lose the filters in place in their columns. | beta.1.3.0.a.build1 |
| Improvement : now filters in place on the columns are visible (titles colored in orange, with detail filter), Merlin Backoffice retains the filters on the column characteristics (products table) and attributes (table of declinations), as long as you don't change the column configuration (for a configuration that does not contain these columns). | beta.1.3.0.a.build1 |
| Improvement : as for the attributes, you cannot change the order of the feature by drag and drop, that once one has clicked on the column title "Position". This prevents accidental movement | beta.1.3.0.a.build1 |
| Improved : storing of the sorting options (taking account of numeric, uppercase, etc...) specific to each column, to the closure of the application and automatic reloading | beta.1.3.0.a.build1 |
| New : an option to keep the tris set up in columns, between two launches of the application | beta.1.3.0.a.build1 |
| New : Deletion and auto-correction (MagicEdit) duplicates | beta.1.3.0.a.build1 |
| New : possibility to remove all the sorts that are present in the columns of a table. Until now, once a sort in place you could only replace it by another sort, but not remove it. | beta.1.3.0.a.build1 |
| Improvement : when clicking in columns of type selector, makes the modified cells, as the other editing functions by copy and paste | beta.1.3.0.a.build1 |
| New : ability to set even the max size of queries import, to try to speed up or slow down the speed, until you find the critical size. | beta.1.3.0.a.build1 |
| Improvement : the refresh of the content of the tables makes them lose their sort settings of their columns. | beta.1.3.0.a.build1 |
| Novelty : being able to change the default category of the products (the moving mass), via the import csv/xsl. | beta.1.3.0.a.build1 |
| Novelty :from PS 16100, the reading of the list of rules of taxes, excluding rules that have a status "deleted" in the database (PrestaShop does removing more réélement). | beta.1.3.0.a.build1 |
| Improvement : mass edit (calculator) makes the modified cells, as the other function of change by copy and paste | beta.1.3.0.a.build1 |
| Improvement : add a progress meter on the shares of multi lines as the deletion of products, calculations in the mass, round, creation of new products... | beta.1.3.0.a.build1 |
| Novelty : visu and cancel (undo) function to copy this value in the whole column..., such as Magic Edit | beta.1.3.0.a.build1 |
| New : you can choose among a large number of options for sorting the values, you can set for each column individually (lexicographic sorting, numeric, ignoring the capital letters , accents, spaces,...) | beta.1.3.0.a.build1 |
| New : an option allows to keep the filters in place in columns, between two launches of the application | beta.1.3.0.a.build1 |
| Novelty : MagicEdit, its generator series a new option allows you to restart the counting at the beginning of each block (after each break table) | beta.1.3.0.a.build1 |
| Novelty : in MagicEdit, a new option allows the generator of the series (1, 2 ,3, ...) again to the 1st value (1) at each change of rupture (group of rows) of the table. Typically this allows to re-order the "positions" of all the attributes or characteristics in a single operation. Or generate lists of references incremented to the variations of several products at the same time. | 1.2.0.a.build1 |
| Improvement : The removal of the products seemed very slow when we activated the display of the meters of lines. | 1.2.0.a.build1 |
| Improvement : rows of the breaks in the table of the products (separation lines of blocks indicating the number of the associated category, appearing in the mode of sequencing products) are now not only hidden, but réélement deleted in standard mode. This allows you to in all cases, to sort the display by any column. | 1.2.0.a.build1 |
| Reorganization presentation window, a command for clarity. | 1.2.0.a.build1 |
| Novelty : MagicEdit available on the column "positions" of the category tree, in order to be able to re-order mass sub-categories, after being classified according to one of the other three criteria (name, breadcrumb trail, or Id), using the builder series of MagicEdit. | 1.2.0.a.build1 |
| Replacement of qcq buttons by the management of the long click in order to lighten the interface (ex : window "turnover date") | 1.2.0.a.build1 |
| Novelty : MagicEdit utilsable on the columns 'position' attributes and values of attributes, to allow them to re-order quickly by increasing value or alphabetic | 1.2.0.a.build1 |
| What's new : MagicEdit available on the column "positions" of the table of characteristics, in order to be able to re-order in mass this topic in one click, after having classified according to any other column of the table. Typically, we can order the features by alphabetical order, without having to change the value of "position" manually in each line, or use the drag-and-drop to order equipment lines. Ditto for the positions of the groups of attributes and attribute values of the declinations | 1.2.0.a.build1 |
| Optimization : when the modification by calculating the mass amounts of versions of several products, we had x times the progress meter that is displayed. | 1.1.0.a.build1 |
| In the import table, after reading and afficahge of the file, the status of the product and/or of the declension now shows "Exists" and not "Duplicate", when the reference provider, is used as the key of sync, is the same for multiple suppliers of the same product or declination. | 1.1.0.a.build1 |
| The memorization of the choice of the display order of the categories in the trees. | 1.1.0.a.build1 |
| The spreadsheet embedded in the import dialog is now much more rich, with a ribbon menu, that is equivalent to that of Excel. For example, to edit formulas in cells of files xlsx, without leaving Merlin Backoffice. | 1.1.0.a.build1 |
| When importing new groups of attributes in PS1.7, it is necessary to force the "type" to select, because PrestaShop forgot to give them a default type in the database. | 1.1.0.a.build1 |
| Improvement of the management of the supplier default during import: -After the import of a product that : automatic correction of the data (association forunisseur, copy of the reference supplier and the price of the acaht) in product_supplier, for products that have a supplier by default defined only in the product table (this is the case when importing with a column default provider, without giving the reference provider). -After the import of the variations : the product is automatically a |
1.1.0.a.build1 |
| Improvement : automatic creation of a local copy of the file to import, when you click on the button "Edit-XLSX" | 1.1.0.a.build1 |
| alert when the user requests the closing of the application, if images are still being transferred | 1.1.0.a.build1 |
| Important novelty : the calculators in mass allows to pre-visualize the result of operations, in the table, to validate the calculation before of write in the database. This allows to strongly limit the risks of bad handling. | 1.1.0.a.build1 |
| Disallow value of 0 (see dessosu of 1000) in option cutout import block | 1.1.0.a.build1 |
| Detector of the absence of the use of the protocol TLS 1.2, needed to establish secure connections to Sitolog, for the verification of the license in particular. | 1.0.5.a.build1 |
| Add functions to copy and paste it in the column store by default, the table of products, allowing you to bulk modify this value. | 1.0.5.a.build1 |
| Backup in the settings of each source of imports, the value of the option "Do not check the absolute oneness of the keys" | 1.0.5.a.build1 |
| See two screenshots 7/03, ereru SQL out of the mode position. He continues to ask for the column garp.id_category or, on the contrary, the coonne position | 1.0.5.a.build1 |
| Adding explanations in the tooltip on the columns of association of products to shop that will only work for licenses complete (product management + category management). | 1.0.5.a.build1 |
| Changing the behavior of button "New" source. This created a new source with the default settings of the Merlin Backoofice and not with the settings of the currently open source . The previous behaviour can be obtained with the button "Duplicate" source. | 1.0.5.a.build1 |
| Click on the button "Position" of the table of the products detects the presence of columns that are prohibited in this mode and prevent him to continue. | 1.0.5.a.build1 |
| Adding the DLL to send us an email from the application in case of fatal error | 1.0.4.a.build1 |
| Blocking of the use of the button "position" (with an explanation message) in conjunction with the column tree or a list of categories associated because it does not give the complete list of products associated to the category. | 1.0.4.a.build1 |
| Default choice set to UTF8 for the alphabet | 1.0.4.a.build1 |
| Possibility to select a zoom factor display overall. Allows you to work more comfortably with screens at very high resolution (e.g. 4k, and 5k) by magnifying the display of all open windows or on the contrary on the small screen by decreasing their size. | 1.0.2.a.build1 |
| Automatic update of the lists of suppliers and manufacturers of the window pricnipale when adding via the import window | 1.0.2.a.build1 |
| Ability to perform cut, copy, paste multi-line of language tags | 1.0.2.a.build1 |
| Now you can keep always visible for blocks of pre-filters. Just open them with a right click rather than left click. | 1.0.2.a.build1 |
| Possibility not to execute the scripts in the hooks in the output. | 1.0.2.a.build1 |
| Improvement of the export mode to create files directly ready to be re-imported in PrestaShop, in particular for the columns "visibility", "Condition", "redirection Type", "Suppliers" and "Manufacturers". | 1.0.0.a.build1 |
| Detection of the version of the connector module from version 7.5 (Merlin Backoffice can not cope correctly with an older version). | 1.0.0.a.build1 |
| Added the export function in the button actions grouped together in the table of categories (view categories), to be consistent with the table of products. | 1.0.0.a.build1 |
| Column "Id product redirected" was renamed the "forwarding Id" because it can now (PS 1.7) be the id of a category | 1.0.0.a.build1 |
| So you can see the color of the text (and therefore the success or not of the download of the images), the column containing the name of the files in the two tables to send photos, still remains on a white background, even for the lines selected. | 1.0.0.a.build1 |
| Removal of the filters from the columns in the tables of categories, to be replaced advantageously by the function "Select filtered" | 1.0.0.a.build1 |
| grey out button place just before the end of complete reading categories | beta.0.1.2.a.build1 |
| Removal of the limiters to 32 characters of numbers and declension | beta.0.1.2.a.build1 |
| New interface and ergonomics of the generator of bar code in MagicEdit | beta.0.1.1.a.build1 |
| Fix : the backup of the EAN13 or UPC from the card-could do to lose the bit of control (13iem and 12th character, respectively) | alpha.0.1.0.a.build1 |
| Improvement : after an import, when the option to refresh the main screen is checked and the mode "Select all" is activated, this mode is maintained after the refresh (products or variations are all re-selected automatically). Similarly, if one or more products or variations, but not all, were selected, the first of them is automatically re-selected and his line made visible after the import. | alpha.0.1.0.a.build1 |
| New parameter allowing to specify what is the row containing the first row of data in the import file (default=2). It is thus possible to process the file that has a header and even import the row containing the column titles. Supports all file formats. | alpha.0.1.0.a.build1 |
| securing, with use of a part of the code pre-compiled, placed on my server. | alpha.0.1.0.a.build1 |
| Improving the speed of the update of products table when making mass changes in their declinations (ex recalculation total amount) | alpha.0.1.0.a.build1 |
| New : pressing the Enter key on the keyboard during the entry of the value of a filter, rafraichier the display immediately d ela table by applying the filter you entered, don't have to click on the refresh button. | alpha.0.1.0.a.build1 |
| Improvement : each time that it is possible, display the product name in the line separating a block of rows into the tables. For example, in the table of declinations, the separators indicate the name of the product variations below. | alpha.0.1.0.a.build1 |
| secure by reading number of the hard disk, compage number of installation, possible deactivation, remote a site-specific installation | alpha.0.1.0.a.build1 |
| Security update recomandée | alpha.0.1.0.a.build1 |
| New : seems marginal or technical, but yet it is a major change, the filters of the columns in the trees of the categories now have the ability to get the categories to be hidden, even in the branches ever read. For the user this simply means that the result of the filtering is always complete, no category missing. | alpha.0.1.0.a.build1 |
| Improvement : in the tables of categories, filters, columns and the new function of auto selection filtered, ignore accents and case when searching (search for "Camera" is "camera") | alpha.0.1.0.a.build1 |
| New option to decide if the list of groups of customers is filtered or not on the selected stores (before, was being filtered by default). | alpha.0.1.0.a.build1 |
| Improvement : context menu added, for filtering, for example, in all of the columns of the list of attributes in the builder window | alpha.0.1.0.a.build1 |
| Improvement ergonomically : clear separation of functionality. The right click menu contains only the features specific to the columns (copies of the value in the column, for example). The features such as height adjustment of the ligens, are in the table contextual menu (icon in top right). Orders playing globally on the data of the table have their own button (for example "Select all"), and enfon the "bulk actions" acting on a selection of lines, are regorupées in a button multiple choice. | alpha.0.1.0.a.build1 |
| Enhancement : new supported formats timestamp of the import files, using the : as a separator | alpha.0.1.0.a.build1 |
| Synchronization (update) of the various lists containing the list of groups of clients, when adding or deleting a group | alpha.0.1.0.a.build1 |
| Improvement : when entering the name of a connection to search, press the Enter key on the keyboard initiates the search (no need to click on the button "magnifying glass") | alpha.0.1.0.a.build1 |
| Buttons, gear, and eye replaced by a drop-down list of pre-filtering allowing you to choose which products to list (main Products and/ or product asociés,... see paper list) | alpha.0.1.0.a.build1 |
| Space saving : the mini action buttons (activate, round,...) are grouped into a single button multi functions with arrow drop-down | alpha.0.1.0.a.build1 |
| Save space : the fields defining the pre-filter mask for lighten the interface to the top of the tables | alpha.0.1.0.a.build1 |
| Global harmonization of colours in two tones (orange and blue). Regarding the icons, the buttons, the colors of the cells... | alpha.0.1.0.a.build1 |
| Incredible improvement of the speed of the mass change, by calculation and by the importation of quantities of products and/or variations. It was a weak point of previous versions (with PS >=15000) was able to transform into a strong point thanks to the use of advanced features of MySQL 5.x. Other parts of the software will be in the future the same makeover. An example : to increase by 10 the amount of 250 products is now taking less than a second instead of 30 seconds on some configurations | alpha.0.1.0.a.build1 |
| Improvement : copy and paste values to impact prices or rates of tax made in the table of attributes of the generator performs automatically on all the lines concerned the calculation of the impact ttc | alpha.0.1.0.a.build1 |
| Improvement : in the context menu, in addition to the two options "filter on this column" and "remove the filter from this column", it appears to "Delete all filters of the columns". In addition, this option is grayed-out automatically if no filter is to remove. And the option "remove the filter from this column is gray as if the column clicked is not filtered. | alpha.0.1.0.a.build1 |
| Improvement ergonomically the context menu : in the menu options of the style "Copy this value to ...", the words "the value" are replaced by the value itself for a better understanding of the action performed. Of more cells that will be changed are highlighted in the table (darker background). In the case of a copy of a cell to other cells, the cell model is highlighted in a bright color. | alpha.0.1.0.a.build1 |
| Improvement : interface to the simplified by hiding the default forms for the creation of new client groups and specific prices | alpha.0.1.0.a.build1 |
| Improvement : added a confirmation request when doing a copy paste vertically in a column of the tables, windows, import, and generator variations. This was already the case in the other windows. | alpha.0.1.0.a.build1 |
| Novelty : the date of creation of the products that are editable in mass. Allows you to copy, paste and change the status to "new" a selection of products. | alpha.0.1.0.a.build1 |
| Improvement of the ergonomics of MagicEdit : once the window MagicEdit open, it keeps the focus (it is impossible to commit the error of change the selection of rows in the table. In addition the values which will be modified are highlighted (darker background) in the table. | alpha.0.1.0.a.build1 |
| Improvement and simplification : significant streamlining of the interface, with the removal of more than 90 mini buttons. They are replaced by additional tools in the context menus (right-click), with the profit of having a legend explanatory and automatically hide the tools out of context. This concerns especially the buttons recalculation of width of columns, the fields of setting row height, tilt of the securities, fold/unfold, management of the multi-mode lines, but also the automatic selec | alpha.0.1.0.a.build1 |
| New : delete button images categories. | alpha.0.1.0.a.build1 |
| New : replacement of the photo to a category by simple drag-and-drop in the line of the image, danas the image table of the categories | alpha.0.1.0.a.build1 |
| New : ability to replace a photo of a product by another, by a simple drag and drop. Conservation of the caption (Alt tag), position, coverage, association for the shops and to the declension, only the files of the thumbnails are replaced. | alpha.0.1.0.a.build1 |
| The function of removing the quotation marks surrounding the text now works also with the file Excel XLS and .XLSX. Practice to manage the CSV files converted to Excel. | alpha.0.1.0.a.build1 |
| Improved : the display in the list of groups of shops and boutiques is now more consistent : the groups that select all only as soon as all their shops are selected (or the opposite). Ditto for the line "All". In addition to being more clear and intuitive, it allows you to optimise the treatments, multi shops. | alpha.0.1.0.a.build1 |
| Replacement of the window "ABC" by the new fields in the tab "Sheet". Faster and more convenient, it has all the info in the same place. | alpha.0.1.0.a.build1 |
| Very important new development : new button allowing to display in the table of categories target new columns showing all the default categories of selected products (1 column for each store in multi shops) as well as the categories known as associated. It contain check marks in the three states, such as tables, tags, or carriers, for example, allowing at a glance to see if a category is or is not associated with all the selected products or only some of them. These columns are editable proposin | alpha.0.1.0.a.build1 |
| New : add and possible replacement of the photo to a category by simple drag-and-drop the image from Windows explorer, in the image field of the tab card. With the immediate transfer and in the background. | alpha.0.1.0.a.build1 |
| New : available stock indicated in the title of the tab stock, and sale price (including taxes) indicated in the pricing tab, for visu rapid when editing a product | alpha.0.1.0.a.build1 |
| New option, checked by default, which allows each connection, as for the products, to ensure that each category is a row in the table category_lang, for all stores and all languages. Necessary to display these lines (even if they are empty of data) and so working on the translations. | alpha.0.1.0.a.build1 |
| Improved : the behavior of the backup mode, multi shops, data from the tab "data Sheet" category is now consistent with the backup data of the category tree and translations of categories. At present, therefore, are not saved in the various shops selected, that the data is actually modified in the file | alpha.0.1.0.a.build1 |
| Improvement : in the tables other than the categories (this was already the case in those tables), the new function of auto selection filtered, and unaware to this the accents, and capitalization | alpha.0.1.0.a.build1 |
| Improved : the behavior of the backup mode, multi shops, data from the tab "product description" is this consistent with the backup data from the products table, and translations of products. At present, therefore, are not saved in the various shops selected, that the data is actually modified in the file | alpha.0.1.0.a.build1 |
| Improved : the export of the column "Behaviour in case of rupture of stock" , mode compatible PrestaShop gives 0,1 or 2 and no more "Accept", "Refuse orders", "default". This makes it easier to re-import auto because the database acceepte only the values 0,1 or 2. | alpha.0.1.0.a.build1 |
| Improvement : the list of values for "State" (new, used, refurbished) in the table of products is now translated in French for clarity (in English translation for the base of PrestaShop done automatically in the background) | alpha.0.1.0.a.build1 |
| Improvement : the list of values of "Visibility" (in the catalog, in research, in both) in the products table is now translated in French for clarity (in English translation for the base of PrestaShop done automatically in the background) | alpha.0.1.0.a.build1 |
| Novelty in practice : possible addition of images (a single, a lôt, or even a listing XLS photos) by simple drag-and-drop from the Windows file explorer, directly in the thumbnail image of the product of the tab sheet. If the product already has a cover photo, we suggest you either remove it or replace it, or simply treat the new as a secondary image. With association to the product immediately (no need to change the settings in the window association) and transfers running in the background (no | alpha.0.1.0.a.build1 |
| improvement ergonoique : the columns of association (for example tags or carriers to the product) are now placed to the left of the tables, to be always visible | alpha.0.1.0.a.build1 |
| New editor of configurations of columns, by drag and drop. Unlimited number of configurations. Possibility to change and memorize the order, the title and the width of the columns, independently for each configuration. The objective is to allow you to make pre-configuration of export format to your market places. Ability to duplicate the configuration to make variants. Ability to define and filter your columns "favorites" for faster selection. Quick selection of topics for a family (for example, | alpha.0.1.0.a.build1 |
| Conservation of the sorting of the rows in the product table according to your choice. | alpha.0.1.0.a.build1 |
| New mode of travel products, in any selection of shops (in addition to the two legacy modes : in all shops and in one shop) | alpha.0.1.0.a.build1 |
| By default, when all the shops are we select, and the edit mode, multi-shops is selected, the displayed data are now those of the default shop of each product and not that of the 1st shop of the selection. | alpha.0.1.0.a.build1 |
| New option to assoicer or not all the carriers to new groups of clients | alpha.0.1.0.a.build1 |
| Optimization of all the scripts tab of the client groups using loops. Replacement by joins 100 times faster. This concerns : -association of all customers to the selected groups -association of all classes to new groups of clients -filling the table product_group_reduction_cache -association of the new groups to the carriers -association of the new groups modules -association of the new groups to the shops -association of the new groups to existing customers |
alpha.0.1.0.a.build1 |
| Progress meter (optional) for the display of tables (allows you to see the progress of the long SQL requests) | alpha.0.1.0.a.build1 |
| New option when cloning of categories, which allows you to choose, such as shops, target, the shops associated with categories of sources, or shops associated with the target group. This last choice (again) is often more relevant, because a parent category, must always be associated with the same stores that these sub-categories. | alpha.0.1.0.a.build1 |
| Cloning of the categories as possible in a selection manual multiple shops (not necessarily the same as those already associated with categories of sources). Before we could do that in a single shop. | alpha.0.1.0.a.build1 |
| Removal of spaces displayed in the ids between the thousands and the hundreds. | alpha.0.1.0.a.build1 |
| Important improvement : the movement of products (from one category to another), is present on all the selected ones, even if it does not belong to one of the categories selected sources. This allows you to move products, for example by using the "Eye" button for the search. This function becomes a lot more intuitive, because this limitation was often the cause of loss of time, because they were poorly understood and the users thought either a bug or a bad maipulation of their hand. | alpha.0.1.0.a.build1 |
| The main table of product list at present, even the products that do not yet have a translation, so that it can give them a name, a description, etc... from any language-of-work and not from only the default language used when creating the product. It makes all the difference when adding languages to the shop, after the creation of the products. You gain enormously in flexibility of work. | alpha.0.1.0.a.build1 |
| New : support of Excel files for multi sheet. Import any sheet of the file. | alpha.0.1.0.a.build1 |
| Btn refresh tab of the translation category have to enable the display if not already done. | alpha.0.1.0.a.build1 |
| Lack MAgicEdit table attributes of the window generator, or other function to copy TTC in HT or vice versa | alpha.0.1.0.a.build1 |
| The automatic creation of simplified URLs of the categories can now be run on any selection of shops. | alpha.0.1.0.a.build1 |
| The mode of product display "Grouped by categories" is simplified, it does list this as the blocks of products corresponding to the selected categories. Previously it also included the block products corresponding to the other categories of products associated with the selected categories (in short, it was confused). It is more comprehensive, in so far as it list to present all products, regardless of their(s) boutique(s) of belonging. This is important because this mode is mostly used to chang |
alpha.0.1.0.a.build1 |
| NO, useless. Add "only show translations of the selected stores," in onlget trad products ? Or to put it in global as a filter in the tab shops ? | alpha.0.1.0.a.build1 |
| Small change but fundamental : the tables of translations for products and categories now display a line for all languages, even when the product or the category has not yet translated into the language. This allows precisely to create these translations, and not just edit ones that already exist. | alpha.0.1.0.a.build1 |
| Window dévérrouillage and connection is more clear, lighter. The part release and license management is independent from the connection. | alpha.0.1.0.a.build1 |
| Confirmation request before closing the connection window (ESC key) and the main window (logout button) | alpha.0.1.0.a.build1 |
| Duplication of a cconfiguration or a source, we suggest you immediately remommer copy (1 click less in the process) | alpha.0.1.0.a.build1 |
| If the 4 shops are selected (2 by one), put slect_all to 1 to simplify scripts. | alpha.0.1.0.a.build1 |
| Well practice, It is now possible to view the web page of a product (right-click), even if the URL column complete is not checked. | alpha.0.1.0.a.build1 |
| Existence of column filters more visible (the background of the button of removal of the filter becomes colored when a column filter is in place) | alpha.0.1.0.a.build1 |
| Unlimited number of customizable columns (always 5 per game configuration of columns, but an unlimited number of games) | alpha.0.1.0.a.build1 |
| "Maximize window on open" is unchecked when you change the size of the window and check when it maximizes | alpha.0.1.0.a.build1 |
| Style windows info | alpha.0.1.0.a.build1 |
| Message the window is not wide enough for cadenaser the sign => only if fen completely loaded | alpha.0.1.0.a.build1 |
| Amendment to the code of reading of the categories for that if multiple shops are selected, is displayed the names and other texts, read for the default shop of the shop. Same principle for the backup in the event of change. | alpha.0.1.0.a.build1 |
| The table of categories of products, allowing navigation and selection of categories of products to display, may now display the same columns as in the table of categories of PrestaCatégories. This allows in particular to put in place filters (e.g. only list the active categories) | alpha.0.1.0.a.build1 |
| New display mode or automated, it just has the look, the separators line-by-categories associated with the column position. Mode is chosen automatically when you want to change the order of the products in their categories | alpha.0.1.0.a.build1 |
| Configurator column of the table editing categories (view categories), as well as the navigation table (view products). Choice of columns, width, sequence,... unlimited Number of possible configuration. | alpha.0.1.0.a.build1 |
| For categories not refresh table products | alpha.0.1.0.a.build1 |
| New parameter allowing to specify what is the line containing the titles in the import file (default=1). Allows you to skip lines of header files. It is also possible to import files which do tnot of titles of columns, using one of the data lines. Supports all file formats. | alpha.0.1.0.a.build1 |
| Improvement : simplication for a better intuitiveness, and a single column "Behaviour in case of rupture of stock" instead of 2 (text and value) | alpha.0.1.0.a.build1 |
| Management of the new topic show_condition,from PS 1.7 | alpha.0.1.0.a.build1 |
| Change in depth : all the part of management and modification of categories, the outcome of PrestaCatégorie, is now, as it was already the case in PrestaPricing, capable of operating on a selection in any of the stores (and no longer only on a single or all at once). | alpha.0.1.0.a.build1 |
| New : you've often wondered, auto search quick in the lists of manufacturers and suppliers of pre filters by entering the 1st letters. | alpha.0.1.0.a.build1 |
| Management of the new topic ISBN from PS 1.7 | alpha.0.1.0.a.build1 |
| Tab "sheet" enriched with fields, references, price, quantity,... and then remove plug ABC | alpha.0.1.0.a.build1 |
| Improvement : after a modification of a product in the tab sheet and the transition to the next product, it was automatically placed in the first row in the products table, which could be cause for confusion. It had the same behavior when the table was refreshed and the selected row was preserved. Ditto in other tables (versions, categories, prices, import). Now the program is arranged so that the selected row is always visible in the table, but not necessarily at the top. It will, for example, | alpha.0.1.0.a.build1 |
| Missing right click menu on column a rate of tax fen generator, to quickly copy a rate in totue the column. | alpha.0.1.0.a.build1 |
| Re automatic naming of columns for export to markets the main | alpha.0.1.0.a.build1 |
| Option of deleting all the photos before import with pictures | alpha.0.1.0.a.build1 |
| Auto selection of categories to target filtered (for example, to select automatically all the categories called "engine", of a car brand specific). | alpha.0.1.0.a.build1 |
| Improved : deletion possible of files when it deletes the photo of a product (your choice), in order to save disk space on the server side. | alpha.0.1.0.a.build1 |
| Option to remove the selected photo when adding a photo | alpha.0.1.0.a.build1 |
| The refresh (gear) of the table of accessories passes twice by the launch script of the application of the "Affichage_product" | alpha.0.1.0.a.build1 |
Older versions fixes |
Version number |
| Fix : the gauge remains visible when you have a SQL error | 1.4.0.a.build2 |
| Fix : in the table of declinations, the VAT-inclusive price per unit of measurement of the declinations did not include VAT in the price impact by untié measurement. No effect on the data since this column is purely informative (non-imported into the database) | 1.4.0.a.build2 |
| Fix : when a click in the check box of the column "Dec." of the table photos (the association of the selected photos to the variations selected in the same product), a display problem gave the impression that the operation was not taken into account for a single product. While the operation is performed on all selected product. | 1.4.0.a.build2 |
| Change : to match what is PrestaShop, the column VAT-inclusive price per unit of measurement of the variations do not include at present the price impact of the declination. This does not seem logical at all, but this change allows Merlin to indicate the same unit price as in the shops which is essential for the generation of catalogues of prices or labels. | 1.4.0.a.build2 |
| Improvement : removed the automatic adjustment of the width of the columns of the two tables of images, which had tendency to over-expand the columns. | 1.4.0.a.build2 |
| Fix : in builder PRO label, we could not post the QR Codes of the urls of the products in the labels of variations | 1.4.0.a.build2 |
| Fix : crash at ancement if in the database there is a warehouse which the name ends with a space. | 1.4.0.a.build2 |
| Patch important : the option "make invisible in the former category by default" of the fonctionnlaité of movement of products, made the product invisible in all the other categories and not only in their former category by default. | 1.4.0.a.build2 |
| Fix : failure in the association of images to the products, mode direct search in the database, when the separator of the beginning or end of the string to exclude is longer than 1 character. | 1.4.0.a.build2 |
| Fix : the categories are created by cloning, had a creation date that contains a year wrong (+1 year relative to the current date), what was the hook, "adding category" was triggered over each time it is closed for a year instead of only once. Without great consequence (just a waste of time). Very old bug passed completely unnoticed, discovered by chance by modifying the code. | 1.4.0.a.build2 |
| Fix : products images in size "large" were never removed from the local cache of Merlin | 1.4.0.a.build2 |
| Fix : since the previous update, we had a crash when we wanted to edit the translation of an attribute value | 1.4.0.a.build2 |
| Fix technique : the type of the variable "cover" of the class "image" is now a "variant", so that it can accept null values, and thus avoid the value 0, causing a key error in duplicate on the version of PS as the 16100, who, by mistake, a key combined id_product+cover | 1.4.0.a.build2 |
| Fix : in the image table of the categories, the image of the category "Root" appeared as many times as there are shops in PrestaShop. | 1.4.0.a.build2 |
| Fix : the duplicate products, but without images were not indexed in the search engine. | 1.4.0.a.build2 |
| Fix : Identifier 'option_skip_association_when_file_exist' unknown or inaccessible when replacing images. | 1.4.0.a.build2 |
| Fix : sometimes, if we choose as key the name of the product, although the button "check and correct duplicates" indicates to us that all goes well, the launch of the import stops with an SQL error indicating the presence of duplicate (error id_shop). You have to check "Do not check for the unicity of the key in sync". | 1.4.0.a.build2 |
| Fix : changing the language in "Display" only rafraichissait not the display of the table of images | 1.4.0.a.build2 |
| Improvement : the use of the function from the context menu (right-click in a table), as the MagicEdit or copy and paste should start with save and clear the tab sheet if it contains the data of a product (similarly for the categories. | 1.4.0.a.build2 |
| Improvement : flashing of the "Refresh" button for the products table, after each upload of new photos | 1.3.3.a.build2 |
| Fix : the topic defining the type of inventory management packs (pack_stock_type) is supported from version PS 1.6.1.0.0 instead of 1.6.1.4.0 | 1.3.3.a.build2 |
| Fix : since the v1.3.2, the column headings of the declinaisons prices and specific remain French when the interface is in English. | 1.3.3.a.build2 |
| Fix : failure to read the contents of the column associated with the warehouse das the products table | 1.3.3.a.build2 |
| Fix : crash if you check the two options to hide rows of variations in step 3 of the import | 1.3.3.a.build2 |
| Fix : the locks of control panels left and right sometimes disappear | 1.3.3.a.build2 |
| Fix : error Message CKEditor evil launched systematic at startup | 1.3.3.a.build2 |
| Fix : translation into English of the management of the breaks, the text "Roll/Unroll all" and other menu options not translated in the menus, right-click tables | 1.3.3.a.build2 |
| Fix : if you switch from a connection to a site multi shops site mono shop and had checked the pre-filter "Uniq. products multi shops", the button "Other pre-filters" remains in orange. | 1.3.3.a.build2 |
| 1.3.2.b.build1 | |
| Fix : SQL Error "Unknown column 'HAS_DEC' in 'having clause'..." at the display of accessories, if one does not activate the recursive mode in the tree view of the categories of accessories and the table of products parents is pre-filtered to only list products with variations | 1.3.2.b.build1 |
| Fix : the title of the columns filtered is incorrectly updated with each refresh | 1.3.2.b.build1 |
| Fix : the message indicating the reading of the id of the categories are still displayed when using the scheduler | 1.3.2.b.build1 |
| Fix : % 1 %2 from the popup menu tree of categories is not replaced by the value of the cell in which it was clicked | 1.3.2.a.build1 |
| Fix : PS 17000, the activation box of the mode of management of the stock advanced must stay greyed out | 1.3.2.a.build1 |
| Fix : SQL error when viewing the variations, if we included the coverage or the value of the stock, on PS >=1.7. | 1.3.2.a.build1 |
| Fix : SQL error in the backup code of the tab sheet on the topic id_type_redicrected from PS 1.7.1 | 1.3.2.a.build1 |
| Fix : error at line 59 of overall Procedure colorer_champ_cliqué_droit process. | 1.3.2.a.build1 |
| Fix : dots (.) in the name of a warehouse, made plant Merlin in the start | 1.3.2.a.build1 |
| Improvement of performance important for in the code of the option "Display only one line per product" when reading and viewing Excel files that contain a mix of products and variations to import. On a file of 200 000 lines, of which 51 000 products, the operation had taken more than two hours with the previous version. The same operation on the same file takes now 15 min. In addition, this treatment is now done at the same time that the other option "Exclude rows that have a value for the key |
1.3.2.a.build1 |
| Fix : errerur in local procedure mémorisation_ordre_et_largeur_toutes_colonnes (FEN_MAIN.PROCEDURE.mémorisation_ordre_et_largeur_toutes_colonnes), line 53 when a click on import button in Excel | 1.3.2.a.build1 |
| Fix : mode control of the import, do not hide the option to send photos , nor the choice field key synchro categories. | 1.3.2.a.build1 |
| Fix : with the export function simultaneous "products + variations" with the option to wysiwyg, in the export file, the columns are not always in the same order as the columns displayed in the products table On the other hand, wysiwyg or not, the columns manufacturer and supplier do not indicate the name of the supplier/manufacturer, but its identifier. |
1.3.2.a.build1 |
| Fix : new display option to choose not to load the global file.css of the site, in HTML editors (CKEditor) to Merlin. This allows you to correct the conflict between the CSS styles to CKEditor, and those defined in the global.css. | 1.3.2.a.build1 |
| Fix : processing of 'local Procedure code_modification_INT_compteurs' (FEN_MAIN.PROCEDURE.code_modification_INT_compteurs), line 8, thread 0 System error : Access violation (GPF) |
1.3.2.a.build1 |
| Fix : when editing the discount rate of a target category for a group of customers, and that it is valid by changing the line target category, we lose the display of the value that you just choose, as if we had to change group (if the source category is not the same) | 1.3.2.a.build1 |
| Improvement : after a duplication of products, there is no need of having to click twice on the "Display" button to refresh the table. The button changes to "Refresh" and blinks to indicate that the duplication is complete. | 1.3.2.a.build1 |
| Fix : the module SitologApplicationConnect 7.6.a shows version 7.5.at the time of the connection, in the trace window. | 1.3.2.a.build1 |
| Fix : after refresh of the categories by the method"read all", if a sub class has the same name as its parent category, the two have the same tree (=name of the two categories) | 1.3.2.a.build1 |
| Fix : SQL error in the translation table of the categories, when the recursive mode is enabled, with two shops selected, if the categories are ordered by id, indicating a problem on the nleft | 1.3.2.a.build1 |
| Fix : the filtering by the shop of the list of characteristics associated with the products is without effect | 1.3.2.a.build1 |
| Fix : clicking on rle small red rectangle in the generator of declination : Error on line 14 of the treatment Click on BTN_selection_lignes_rupture ( TABLE_Ps_attribute ). The passage of the parameter to 1 caused error. An element of type 'UNICODE string' cannot be converted to type 'field'. |
1.3.2.a.build1 |
| Fix : opening error line 68 of construire_rubrique_colonne_stock_avancé_product, table dimension non-positive | 1.3.2.a.build1 |
| Fix : the association function in mass of all the products in several categories, such as accessories of all products in other categories was that on the first category of accessories selected | 1.3.2.a.build1 |
| Patch using : generator, replace "product "" " by simply "products" in step 2 | 1.3.2.a.build1 |
| Ergonomics : in the tab sheet, the language selector is moved to the top of the "Name" field to no longer check/uncheck by error the backup option automatic | 1.3.2.a.build1 |
| Fix : the button "All" of the generator of the variations remains orange even when you empty the table or select the rows or adds attributes | 1.3.2.a.build1 |
| Fix : when exporting categories : Error on line 30 of the processing Procedure local code_affichage_ligne_TABLE_ps_category_navigation. | 1.3.2.a.build1 |
| Fix : the switch ' On..." calculator to view products appear in category view | 1.3.2.a.build1 |
| Fix : the close box of the window repair is not anchored to the right | 1.3.2.a.build1 |
| Fix : the pre-filter "uniq. products multi shops appears even if you did not click on "pre-filters", when one selects a second shop | 1.3.2.a.build1 |
| Fix : if a store several URLs are defined in PrestaShop, Merlin had 1 row per url in the table of shops. | 1.3.2.a.build1 |
| Fix : generation not possible from PDF catalogue of déclianisons because it was missing files in the compilation | 1.3.2.a.build1 |
| Fix : translation of the title "login Window..." | 1.3.2.a.build1 |
| Fix : the titles of the columns that are displayed are not the securities selected in the configurator, but the default titles | 1.3.2.a.build1 |
| Fix : the column "discount amount" of the import, if the cell of the Excel file, the standard type, was empty, had to 0.00 in the table in step 3 (and therefore created a specific price of $ nil) | 1.3.1.d.build1 |
| Fix : error on line 353 of the treatment Click on BTN_move_all_selected_categories_and_products. You have called the [] operator on the field TABLE_ps_category_lang3. The specified index [x] is invalid. |
1.3.1.d.build1 |
| Fix : the column "new price base" in the import table affcihait 0 in the empty cells (making the product free) | 1.3.1.d.build1 |
| Fix : move a product in another category, when the tab "File" is active, could result in to copy the data of the file in the following product to the list if you selected another product. | 1.3.1.d.build1 |
| Fix : errors in the structure of the categories, following the displacement or cloning of categories after having used the "Refresh-read" of the table of categories of sources. | 1.3.1.d.build1 |
| Fix : the images were imported as double in spite of the option "New products only", when imports from the tab of the scheduler. | 1.3.1.d.build1 |
| Improvement : the program no longer asks for permission to replace "Merlin Backoffice.REP" during updates. | 1.3.1.d.build1 |
| Fix : bug that is specific to the V1.3.1, the app closes when the page displays specific prices or the table of links to products/suppliers. | 1.3.1.b.build1 |
| Safety improvements : if, after having been stored in memory, you uncheck the option to "remember" a password, it is erased from the database. | 1.3.1.a.build1 |
| Fix : with PS 1.4, SQL error if you request the display of the captions of the images in the table of declinations | 1.3.1.a.build1 |
| Fix : error on line 41 of the treatment Procedure overall upload_liste_images_a_transferer. The dimension 1 of the array has 2 element(s) and you try to access the element |
1.3.1.a.build1 |
| Fix : selecting a row in the table of characteristics of the products, is to disable the button "All" of the table of attribute groups | 1.3.1.a.build1 |
| Enhancement : changes made to the xlsx format using the tool are taken into account without the need to click on "replay" | 1.3.1.a.build1 |
| Fix : if the variable PrestaShop PS_IMG_PROD_DIR_ is not defined, the script to remove orphaned images remove the images in all the folders | 1.3.1.a.build1 |
| Improvement : drag and drop images to change their position is not functional if the lines are ordered by increasing value of position. Now, if this condition is not met, a message will tell you which to quickly understand and correct this problem. | 1.3.1.a.build1 |
| Fix : the values of characteristics in which the column "custom" is set to "null" instead of 0, are not displayed in the products table and in the values of characteristics. | 1.3.1.a.build1 |
| Fix : 1st launch of merlin , after the installation, the pre-filter main is empty | 1.3.1.a.build1 |
| Fix : line 186 of delete_images_products_.php connector, variable "deleted" is not declared | 1.3.1.a.build1 |
| Fix : checkmark to rate margins automatic is problematic when you have multiple sources (error HFSQL : The value of IDtaux_de_marge must be unique in the database) | 1.3.1.a.build1 |
| Fix : duplicate records have been detected for the key <IDtaux_de_marge> on the file <source_taux_de_marge>. | 1.3.1.a.build1 |
| Fix : it could happen that the columns of the type "1 column-by-attribute" are not displayed when the color attributes have a null value in the database. | 1.3.1.a.build1 |
| Fix : two scheduled events, mix up the files and mappings. | 1.3.1.a.build1 |
| Fix : it happens randomly as a source of import to lose his connection with his model of the mapping | 1.3.1.a.build1 |
| Fix : processing of 'local Procedure warning_deroule_tout' (FEN_left_panel.PROCEDURE.warning_deroule_tout), line 16, thread 0 | 1.3.1.a.build1 |
| Fix : with PS 1.4, SQL error, if one uses a pre-filter on the table of the product and that the one selects all the categories ('WHERE AND') | 1.3.1.a.build1 |
| Error at line 426 of overall Procedure upload_liste_images_a_transferer process. A value should have been returned by 'Method mySQLExec'. |
1.3.1.a.build1 |
| Fix : when exporting in csv rather than xls, the column "Active" contains "x" instead of "1" | 1.3.1.a.build1 |
| Bug severe fix : the script to repair the database by delete rows of the tables containing id_product=0 were removed, the associations between products and packs. | 1.3.1.a.build1 |
| Fix : Error when displaying the variations of color with "1 colonen by attribute", if a color is a texture | 1.3.1.a.build1 |
| Improvement : for all tables, if one selects manually all the rows in the table, the button "all" or "All" of the table shown (orange) | 1.3.1.a.build1 |
| Security enhancement : it is no longer possible to view saved passwords (employee, https, ftp, proxy,...) | 1.3.1.a.build1 |
| Fix : moving a category to itself is done in spite of being forbidden .Suddenly it disappears and you have to disable the mode for loading progressive (based on the breadcrumbs) to move it again. | 1.3.1.a.build1 |
| Fix : error in procedure global procedure De_colorer_champ_cliqué_droit line 20 | 1.3.1.a.build1 |
| Fix : if English interface, it indicates that the recursive mode is enabled when one wants to create a new category. Bug random, the software refuses to create a new category, claiming wrongly that the recursive mode is engaged. |
1.3.1.a.build1 |
| Fix : pre-filters manufacturers and suppliers do not seem to be able to be modified, the preceding value are taken into account. It is necessary to re-read the categories to be taken into account | 1.3.1.a.build1 |
| Fix labels PRO : Area K, if transparent color is indexed, appears only on the 1st label | 1.3.1.a.build1 |
| Fix : crash when viewing declinations if an attribute value of type color, it has no associated color, and, if we request to include the "1 column per attribute" in the table. | 1.3.1.a.build1 |
| Fix labels PRO : Choice of lapolice area => open fen trace with name police | 1.3.1.a.build1 |
| fix : Error on line 43 of the processing Procedure local assigner_apres_check_taille_date_un_fichier_image. The passage of the parameter 2 has caused an error. |
1.3.1.a.build1 |
| Fix labels PRO : If "Batch" is checked, the second label has two € , and the same for the prefix... and then 3 , four... On the bottom graph, on the contrary, - and % do not appear on the 1st labels. | 1.3.1.a.build1 |
| Fix : Merlin indicated to see a pre filter so that it does not have one, when you validate a change of positions of the products of a sub category | 1.3.1.a.build1 |
| Fix : crash if right-click in the table mapping of columns in the import window. | 1.3.1.a.build1 |
| With the extension Labels PRO : Fix : input fields color appeared black to the opening of the window of the label generator | beta.1.3.0.b.build1 |
| Fix : the column provider price the vendor table is set up incorrectly, it does not accept that the price rounded. The tooltip of the column is also incorrect, its content is that of another column | beta.1.3.0.a.build1 |
| Satbilisation : removal of the "Maximize on open", because the corresponding function of Windev sometimes produces a window larger than the screen, hiding part of the title bar and the orange bar on the right. | beta.1.3.0.a.build1 |
| Fix : SQL error during the reading of the charges, if no default country is not defined in PrestaShop | beta.1.3.0.a.build1 |
| Security : It is now forbidden to activate the mode of inventory management developed when using the 1.7 version of PrestaShop (which no longer supports this mode) | beta.1.3.0.a.build1 |
| Fix : the mode of management of stock developed was 100% focntionnel that if the licence also includes the option to import (as in PrestaPricing), whereas it is independent in Merlin. This affects very few users. | beta.1.3.0.a.build1 |
| Fix : depending on the size of the screen, the buttons at the bottom of the window repair database could be inaccessible. | beta.1.3.0.a.build1 |
| Fix : when adding a config table, error at line 53 of the treatment Click on BTN_configuration_tables. 'Open' should return a value. | beta.1.3.0.a.build1 |
| Fix : in the barcode generator, the selector, EAN13/ UPC was masked, preventing it to switch to UPC | beta.1.3.0.a.build1 |
| Fix : SQL Error if you select a single warehouse after you have displayed the columns for all the warehouses | beta.1.3.0.a.build1 |
| Fix : the list of providers in the table and duplicates were not met, preventing to change the default provider of the products in double. | beta.1.3.0.a.build1 |
| Fix : The title of the column "Quantity sold" is not showing the duration if the advanced management mode is not enabled | beta.1.3.0.a.build1 |
| Fix : in the table of duplicates, the change of references or other values, could not be taken into account, when the product was poorly associated with a shop. | beta.1.3.0.a.build1 |
| Fix : SQL Error duplicate key on feature_value_lang when creating a new characteristic value, if translation of the old values have not been correctly erased from the database. | beta.1.3.0.a.build1 |
| Fix : connection error if there is a warehouse which the name ends with a space. | beta.1.3.0.a.build1 |
| beta.1.3.0.a.build1 | |
| Fix : SQL error when selecting a country without a state, in the table to display a specific price existing. | beta.1.3.0.a.build1 |
| Fix : error when you check the box of any of the association columns of the attribute values to a shop | beta.1.3.0.a.build1 |
| Fix : SQL error when refreshing from the products table after you have deactivated the mode of management, advanced inventory, so that the products table contained all the columns of the warehouses | beta.1.3.0.a.build1 |
| Minor fix : the columns of the warehouses cannot be masked more as long as they do not resume the app, in the specific case, or they were posted before you disable the mode of inventory management advanced. | beta.1.3.0.a.build1 |
| Fix : if you get out of the sheet by clicking in a check box of the table of the high ("enabled", "ordered", "inventory Management advanced", "Quantity based on stock in warehouse", "web exclusive", "virtual product", "balance", "show status", "prices visible" ), this click is not taken in to account if the card is in the mode "automatic Backup" | beta.1.3.0.a.build1 |
| Fix : the quantity field in the tab sheet does not accept negative values (same for other numeric fields, such as the price) | beta.1.3.0.a.build1 |
| Fix : when a button indicated cool, blinking, he had to click it twice to refresh, the 1st click does nothing but clear the table. | beta.1.3.0.a.build1 |
| Improvement : remove the automatic width calculation of the columns of the import table, which gave sometimes of the column too small in width. | beta.1.3.0.a.build1 |
| Fix : drag and drop of photos in the import window created two lines (two products) per photo | beta.1.3.0.a.build1 |
| Optimization : the activation of the mode of inventory management advanced launched a request which took about twenty seconds to run. Reduced to less than 2 seconds. | beta.1.3.0.a.build1 |
| Fix : the generation of catalogues PDF could crash if all of the rows from the table had not been displayed at least once and that the column photo was this | beta.1.3.0.a.build1 |
| Fix : columns of attributes and caractérisitques, lacked "Remove the filter from that column" in their menu | beta.1.3.0.a.build1 |
| Fix : SQL error in using MagicEdit on the column of the names of the attribute groups | 1.2.0.a.build1 |
| Fix : when refreshing a table with breaks already rolled-up, everything is peeled, but the flag coiled remains to be true, so the action is wrapped following does nothing | 1.2.0.a.build1 |
| Fix : since version 1.0.4, the command "Place all the current content" of the context menus of the tables ran a replay and afficahge of the complete tree, instead of only the branches already taken place. | 1.2.0.a.build1 |
| Optimization : the display of accessories rafraîchissait unnecessarily the display of the products table. Ditto when you use the selection button to recursively the tree structure of the tab of accessories. | 1.2.0.a.build1 |
| Fix the zoom excessive of the window of configuration of the columns if we use the global zoom of Merlin in addition to the zoom Windows. | 1.2.0.a.build1 |
| Fix : click on the red rectangle with a rupture of the table value is predefined feature not refreshing not posting translations | 1.2.0.a.build1 |
| Fix : the tooltip of the button "New" category date of PrestaCatégories. | 1.2.0.a.build1 |
| Fix : in the mode "Ordering of products", it could be the blocks of products associated with a category were displayed in several blocks instead of one. | 1.2.0.a.build1 |
| Adding the verification of lack of duplication of products (according to the key sync selected) when importing variations via the scheduler or via the manual import by block of rows. This is in order to block the import of which would result in the creation of variations of that orphan. | 1.1.0.a.build1 |
| Fix : SQL error if we loosed the column "List of attributes" in the table to the right of the configurator | 1.1.0.a.build1 |
| Fix : there was no backup of the changes made to the reference supplier for the tab sheet, on versions 1.5 and higher of PrestaShop. | 1.1.0.a.build1 |
| Lacked the functions of cut, copy, paste in the column "Management amount of the pack" of the table of products | 1.1.0.a.build1 |
| Minor fix : the display of specific prices , then the choice of a customer in the table of specific price seemed to be run multiple times the script reading of the full list of customers. | 1.1.0.a.build1 |
| Fix : the association columns of the products with the shops remained displayed even if it is drilled the line in the configurator column, right table. | 1.1.0.a.build1 |
| Fix a bug in the function "selection is filtered on this column, in the table of specific price, on the column "Versions". Do séléctionnait that among the rows visible on the screen and was not aware of the lines masked below the bottom of the table. | 1.1.0.a.build1 |
| Fix : the columns of the attributes of the variations were still shown even if we drilled the line in the configurator column, right table. | 1.1.0.a.build1 |
| Lacked the functions of cut, copy, paste in the column "Customer" of the table of specific prices | 1.1.0.a.build1 |
| Fix a SQL error that could occur in the output of the tool changing positions of the products. | 1.0.5.a.build1 |
| Fix : in the view and table of the categories, the column Id shop default category remained grayed out in some cases. | 1.0.5.a.build1 |
| Fix SQL error if one unchecks the "1 column per feature" or "accessory" in the table to the right of the configurator columns | 1.0.5.a.build1 |
| Fixed the problem of encoding-wrong display of special characters and accents) that could occur after the passage of the interface from English to French) | 1.0.5.a.build1 |
| Fix : with the licence limited to the management of products, categories were hidden in the opening, it was necessary each time to pull the splitter down to reveal them. | 1.0.5.a.build1 |
| Fix : the selection of a default provider was not always stored with the settings of the source, in particular during the use of the planner. | 1.0.5.a.build1 |
| Fixed an import failure if a column mapping of Type "redirect" and Id product redirected | 1.0.5.a.build1 |
| Random problem : no backup of changes made to the description of the categories from the tab sheet. OK after switching in mode "Applications SQL encrypted at the sending" | 1.0.5.a.build1 |
| Fix : fail to launch if the name of a storage contained only special characters, such as cyrillic, for example. | 1.0.5.a.build1 |
| Deletion of the execution in task parallel, the initialization phase of the main window. It loses a little in speed (only visible on very large databases), but it gains in stability. | 1.0.4.a.build1 |
| Added checking existence of image file on FTP before attempting to read. | 1.0.4.a.build1 |
| Fix : TAB characters were replaced by the string aa-bb, when displayed in the HTML editors | 1.0.4.a.build1 |
| Correction of this error message : "Error on line 22 of the treatment Procedure overall echec_connexion_ftp. The member 'Image' does not exist in the class or structure 'STGS_Thread_images_category_a_transferer'." when trying to send image categories, while the setting of the FTP connection is incorrect. | 1.0.4.a.build1 |
| Fix : All the photos and all the translations of all the categories to be displayed instead of displaying only those of the selected categories | 1.0.4.a.build1 |
| Fix : not shifted and not the display of the table of translations, and images of the categories, after you have deleted the selected categories. | 1.0.4.a.build1 |
| Fix a bug in random : the calculation of the values of the column "coverage" did not always if it was not included in the column "Quantity sold" and "Quantity available for sale". | 1.0.4.a.build1 |
| Crash the app with error message (garbage): Error at line 568 of treatment Procedure local partie_finale_code_bouton_connexion. 'Open' should return a value. ********************************************** ----- Technical information ----- Call WL : Treatment of 'local Procedure partie_finale_code_bouton_connexion' (FEN_Fenetre1.PROCEDURE.partie_finale_code_bouton_connexion), line 568, thread 0 What has happened in the past ? 'Open' should return a value. Known cases: -Removing a c |
1.0.4.a.build1 |
| Stabilization of the blinking code of the buttons | 1.0.4.a.build1 |
| Fixing the code to anticipate and prevent this type of error due to Windev : "Method mySQLLitCol and mySQLLitLigne (c_xxxx.mySQLLitCol), line 14, of the type The dimension 1 of the array has x element(s) and you try to access element x+1. | 1.0.4.a.build1 |
| Doubt there will be duplication, or to update the model mapping inactivated if no template is selected to avoid critical error. | 1.0.4.a.build1 |
| Error of reading of translated texts in the table of products, on version 1.3 and 1.4 of PrestaShop in multi languages | 1.0.4.a.build1 |
| Fix a SQL error on shgr.share_qt when we filter the products with or without variations | 1.0.4.a.build1 |
| At the first launch, the decoding UTF8 is wrong sometimes. It is necessary to disconnect and reconnect to fix the problem. This is seen in the word "French" poorly-written. | 1.0.4.a.build1 |
| Fixed a severe error of calculation of the amount available to the selling of products that are in the mode of management of the stocks advanced, that in some cases, does not take into account cancelled orders. | 1.0.4.a.build1 |
| Fix : when the deletion request is immediately categories newly created, the program refused arguing that they contained the products (it was not looking in the right categories). It was necessary to change the view and go back to work around the problem. | 1.0.4.a.build1 |
| Fixed a critical error in the script delete duplicate images download | 1.0.4.a.build1 |
| Error on line 36 of the treatment Procedure overall EnvoieEmail. You have called the function EmailLanceAppli. See mail 7/02 |
1.0.4.a.build1 |
| The export of the column "URLS of all the photos," duplicated urls in the xls file. | 1.0.4.a.build1 |
| SQL error on prsh.id_product when the request for display of translations of the products, based on PS 1.3 and 1.4 | 1.0.4.a.build1 |
| Fixed an SQL error in the launch, during the reading of groups of clients, when the database tables have no prefix. | 1.0.2.a.build1 |
| Fix : the tooltips of the buttons for bulk actions grew with each display of the subsequent (the content is duplicated) | 1.0.2.a.build1 |
| Repair the filter to choose a provider in the provider tab. The list was empty and the selection of a line causes a SQL error | 1.0.2.a.build1 |
| Some of the lists were empty : list of states, language, list shopping tab price specific | 1.0.2.a.build1 |
| Style lift table columns custom | 1.0.2.a.build1 |
| The content of some of the combo drop-down was brought back fully to the left (pre-filters, list countries) | 1.0.2.a.build1 |
| Fix : use the button "position" in conjunction with the column "VAT-inclusive Prices final" or any other column concerning the specific price or crossed, was not the complete list of products associated to the category, but only those that have a specific price associated with it. | 1.0.2.a.build1 |
| Functionality expert : getting set up even to the GROUP BY the request of reading of the products, when you configure a column customizable to display a topic non-standard). This allows for example to display multiple rows per product, provided that it has of possible values for the field. | 1.0.2.a.build1 |
| Increase height securities table accessories | 1.0.2.a.build1 |
| Removal of the comprotement following that so poorly known, led to a result that is not desired : the sending of an image era, it automatically selected at the right. The replacement of an image is done at present only by a drag-and-drop the new image on the old | 1.0.2.a.build1 |
| Fix crash when creating new suppliers via import | 1.0.2.a.build1 |
| Mauvasie translation of the button to display photos | 1.0.2.a.build1 |
| Fix : the list of scheduler events was not anchored to the left | 1.0.2.a.build1 |
| Patch important : the importation of new products, with a license that does not include the basic function of "category Management", could lead to the creation of products that are called "orphans", that is to say not attached to a category by default. | 1.0.1.a.build1 |
| last ligen init thread parallel to recopy in merlin 23 | 1.0.1.a.build1 |
| PC LICENSE only => disable possibility to duplicate products, ability to delete products, activate/off,modify the products by calculation from the categories (or the action button agroupées on products),delete images, orphan,graying calculation options such as chg management of the stock advanced, impact on sale price, deactivation fees, graying under onlget dec. to display (or hide commeSP | 1.0.1.a.build1 |
| Prevention of a crash random tied to the opening incomplete panel right (The field "FEN_right_panel" is unknown.) | 1.0.1.a.build1 |
| Xls export of the categories do not always open the window when it is launched from the button "Action Groupées" | 1.0.1.a.build1 |
| The association columns of the products with the shops remain greyed out, even when the license includes the basic function of "category management". | 1.0.1.a.build1 |
| Following a change of language interface, the button text of the pre-filter was orange even if no pre-filter was put in place. | 1.0.0.a.build1 |
| Crash when using the repair tool levels and breadcrumb on-site in v1.7 | 1.0.0.a.build1 |
| In the end of the import, if the import included download pictures, the table of step 3 saw its columns disparaitrent and réaparaitrent, this is not a bug but a loss of time and unpleasant visually. Replaced by an updated "silent" of the table (it is hidden in the time of the update). | 1.0.0.a.build1 |
| Right-click on the drawer, "Categories" freed all of the other drawers too far to the bottom | 1.0.0.a.build1 |
| See mail: 15/12 failed to decrease in amount, an application stored missing => OK module 7.4 | 1.0.0.a.build1 |
| Missing the function of filtering in the column "Status" in the table of step 3 of the import | 1.0.0.a.build1 |
| Inherited defect of PrestaCatégories, now fixed, if you move a category after you have selected grace to a column filter, the breadcrumb is broken. | 1.0.0.a.build1 |
| Bug display drawer categories after minimizing window | 1.0.0.a.build1 |
| Missing hourglass when you check the column gum in the table of attribute groups | 1.0.0.a.build1 |
| Export categories, I have 1> in front of the tree during the reading of the file to import (and not in PP) -- and then crash (see screenshot if cleaning 1> with magic edit | 1.0.0.a.build1 |
| SQL error when you choose "All dates" for the calculation of the sales and afichait the column "stock cover" | beta.0.1.2.a.build1 |
| The display of the manufacturer was wrong in the tab file (read the vendor id or location id manufacturer). If the mode is automatic backup was activated, it replaced the association product/manufacturer in the database. | beta.0.1.2.a.build1 |
| Click in the table showing the features associated with the products, on a value of custom, opens a popup edit. In the language en could appear several times instead of only once. | beta.0.1.2.a.build1 |
| Update quantities by import generates an SQL error speaking of !$! => It is not a bug, but a result of the use with a version that is not compatible with the module connector. To update the connector module in version 7.4.c minimum, first version compatible with Merlin backoffice to avoid this error. | beta.0.1.2.a.build1 |
| On the tab versions the ccolonne captions of the images remains empty | beta.0.1.2.a.build1 |
| on my site, duplication of the product merlin does not clone not the variations, I do it with PP or with Merlin. It works if I duplicate PP ave PP. Reason : Property Combination->reference length (58) must be between 0 and 32 | beta.0.1.2.a.build1 |
| on my site, duplication of the product merlin does not clone not the variations, I do it with PP or with Merlin. It works if I duplicate PP ave PP. Reason : Property Combination->reference length (58) must be between 0 and 32 | beta.0.1.2.a.build1 |
| on my site, duplication of the product merlin does not clone not the variations, I do it with PP or with Merlin. It works if I duplicate PP ave PP. Reason : Property Combination->reference length (58) must be between 0 and 32 | beta.0.1.2.a.build1 |
| Old bug inherited from PrestaPricing and now corrected: transfers of stock of the variations don't work if you chose the option "Put all the used stock usable" | beta.0.1.2.a.build1 |
| Preventive management of cases or the table category_shop contains lines with id_shop=0 (this created lines with id_shop=0 in category_lang) | beta.0.1.2.a.build1 |
| In PrestaPricing, the calculation of coverage does not occur when the column inventory valuation is enabled. In Merlin beta 1.1, the display order of the columns can influence on this calculation, which is now fixed. | beta.0.1.2.a.build1 |
| Fixed SQL error in the where clause of the applications of displacement of the products, if you selected the setting "in all the shops" | beta.0.1.2.a.build1 |
| Old bug present in PrestaPricing also : entering a characteristic value custom to a feature that does not have the predefined value, without linking it to a product, added a line with id_feature_value to 0 in the table feature_value_lang, which will then appear in admin on every product, for all the features. | beta.0.1.2.a.build1 |
| Add section on method or retrieve the param : copy and renoomme MPR_PP_Data in SIT_MB_Data and remove in the two files custom.ndx and custom .fic | beta.0.1.2.a.build1 |
| Allow the anicien playback mode category for debug | beta.0.1.1.a.build1 |
| Move the duplicate products in bulk actions | beta.0.1.1.a.build1 |
| wrong prefix given in the table configuration, if one disconnects and reconnects on two bases which are tnot the same prefixes tables | beta.0.1.1.a.build1 |
| The side panels are detachable to present that by clicking in their title bar, and not in the window itself. This is to avoid that new users off the panels without the want (and don't know how to reattach them). | beta.0.1.1.a.build1 |
| Prochaine version | |
| the changes in mass quantities / stocks. In fact, they are very slow on the main interface, while all other changes are very fast. In addition, when you import a CSV, if there is not the column stock, it is very fast, but if there are stocks it is very slow. => fixed in shopmaster grace to a stored procedure |
Prochaine version |
| Fix bugs 5* PP, such as the slow change of the quantities. | alpha.0.1.0.a.build1 |
| version 7.3.a => 7.4.c in all messages | alpha.0.1.0.a.build1 |
| Management of the SN Merlin on the site | alpha.0.1.0.a.build1 |
| Fix a crash in case of failure of creation of a new characteristic or a new attribute in the database (table with index zero) | alpha.0.1.0.a.build1 |
| Impossible to do otherwise than accept the release of the forunisseur by default when the exchange -- in the column of the product table | alpha.0.1.0.a.build1 |
| Fix SQL error " unknown column shgr.share_stock in field list..." when displaying products in a shop forming part of a group to amount shared, with as choice of column "physical Quantity" or "Location". | alpha.0.1.0.a.build1 |
| Mod mulit shop or not , the two shops are selected, magic edit not possible modif cat not related to any. But display modified and no error message | alpha.0.1.0.a.build1 |
| 2:43:34:68 License's validity check done. Validity=Fatal error: Uncaught Db->run() must be used only with select, show, explain gold describe queries thrown in /home/sitolog2/public_html/classes/db/Db.php on line 638. If the debug mode of my sie is true. | alpha.0.1.0.a.build1 |
| Simple Mode shop. If a single shop selected, not possible modif cat not associated (+ message erreru ok). But possible if two shop selected, even not associated. | alpha.0.1.0.a.build1 |
| Table translation product does not put up to date if all shop selec and edit mulit shop, after modification of name in sheet | alpha.0.1.0.a.build1 |
| if 1234 shops selected, mode mulit shop, the amendment does not change that in shop 3 while cat associéee 3 and 4. OK if only 3 and 4 are selected | alpha.0.1.0.a.build1 |
| Mod mulit shop, two shops are selected, not possible modif cat not associated with any. But display modified and no error message | alpha.0.1.0.a.build1 |
| Mode mulit or not not possible to edit by copy pasted cat not associated with those selected (1 or 2), but display screen is updated and no error message | alpha.0.1.0.a.build1 |
| bug light, change the selection of categories, not reselectionne not all of the image if the button "Selection all" of the table of images is pressed | alpha.0.1.0.a.build1 |
| Bug SQL old mode of reading ac id_shop_default then, that this mode does not use ailais | alpha.0.1.0.a.build1 |
Category's other articles Versions history
-
PrestaPricing versions history
Info
Full list of corrected bugs, changes made and new features of each version of PrestaPricing, the best alternative to PRestashop back office