MagicEdit for bulk editing of text and numbers in PrestaShop
MagicEdit has revolutionized PrestaShop catalog management. What used to take days of work, such as adding a sentence to the end of all product descriptions, or correcting a spelling mistake that's everywhere, can now be done in a matter of seconds.
Several types of operation can be carried out simultaneously on a large number of products:
- Search and delete part of the texts.
- Search and replace part of a text with another piece of text. See by a synonym taken from a list.
- Add a sentence before or after the current text.
- Concatenate content from other sections (very useful for SEO).
- Copy and paste a data column from Excel into a database field
- Convert text (to uppercase, HTML, etc.)
- Fill in the fields with a series of EAN13 or UPC barcodes.
- Fill with a series of digits (automatic counter). Very useful for producing reference series.
If there's one tool in the Merlin Backoffice module you absolutely must know, it's this one.
Since version 1.5, MagicEdit has been supported by a second, equally powerful mass editing tool, MagicFormula.
MagicEdit uses a form to intuitively select the actions to be performed.
MagicFormula is a little more technical, but offers infinite possibilities. It requires you to enter a data modification formula, either mathematical or string-based.
The two tools are therefore complementary, and well worth a closer look.
Complete video tutorial of the MagicEdit mass editing tool, included in the PrestaShop Merlin module.
MagicEdit was originally designed for mass editing of columns containing text, such as names, descriptions, references or meta fields.
This tutorial reviews all the features of MagicEdit.
New features introduced with version 1.5 and not shown in this video:
- This tool now works on all columns, both numbers and text.
- You can now save your settings in column-specific configurations and re-use them later.
- The function for copying from one column to another becomes multi-column (several columns copied to the target column at the same time, with a separator between each concatenated piece of data).
Manage your catalog faster with the free version of Merlin Backoffice :
Category's other articles Mass editing tools for PrestaShop
-
MagicFormula online help
How to
Video
MagicFormula is a tool integrated into the Merlin Backoffice module for PrestaShop, enabling you to enter or modify any item in the database, using free calculation formulas