Hello, this is Franck from Sitolog. Today I'm going to talk to you about MagicEdit, which has been integrated
into Merlin for a very long time. In fact, it already existed in previous versions
of Presta Pressing and Presta Category. It hasn't evolved much since then, but you'll see that
it's a fantastic tool. In fact, it's really my favorite of all the
features in Merlin. So, what is Magic Edit used for? It's actually a tool for
mass editing text columns. A text column is, for example, the name column
, or the references, or even fields like the meta description, meta keywords,
keyword lists, or the summary, or even the long description. There are others, for example,
messages when the product is in stock or in stock. So for all these columns,
which contain text by definition, there are practically no tools on the market that allow
mass editing. So, what is mass editing on text used for? Well,
it's useful for lots of things. For example, correcting spelling mistakes or replacing words
with others or inserting sentences, words, expressions. It can also be used,
as we'll see, to generate barcodes or generate reference lists. This means that there
are almost an infinite number of possible things that can be done with Magic Edit. So, how do
you use it? Simply by placing yourself in the column you want to modify and
right-clicking. For example, if I want to act on the column, no, I right-click,
my context menu appears and here you have two options for launching Magic Edit. The
first will run Magic Edit on the lines I selected. So here, in this case, only on
this orange printed dress. And this one will do pretty much the same thing, except that first the Merlin
will start, you see, by selecting all the lines. So we're actually acting on
everything that's displayed. So, if I want, for example, to modify, I don't know,
I'll take these five lines here or these six lines there, these four lines there, I want to add
something, uh, at the beginning in front, for example, or at the end. We'll add a brand, for example.
Okay? I'll add "channel" right at the end of this one of these sentences here, of these names.
So I select my four lines. I right-click anywhere in this column.
I choose to launch Magic Edit and Magic Edit launches. Magic Edit looks like this. So, in
fact, it's a set of tools organized from top to bottom that you can activate by clicking on it.
So when you activate a tool, it turns orange like this or deactivate it by graying it out.
If I activate two or more of these tools, well, when I execute them, in fact, all
the functions that I configure in these tools will be executed from top to bottom. So here,
for example, it will perform this function: add text in front. So add a text in front of the
text that is here and then it will add something else, the content of another column that I will
configure here. So it will perform both actions simultaneously but acting from top to bottom.
So if I activate everything for example, I can have up to ten consecutive actions that will
act on my texts. So what I was saying, we will take the example of wanting to add a mark
at the end of these names here. So I search in my tool and I will take for example
this one. Add a text at the end. So I do this. I just simply add here to type
the text that I want to add. So for example a space and then I will OK I will do something
like that by channel in English why not. Here I type my text that I want to add in
bulk. I do phase one apply and you will see in fact Magic Edit tells me the number
of operations that it has carried out. So 4. So, that doesn't mean that it has modified four lines,
it means that it has carried out four operations. If, for example, I had programmed two actions
on my four lines, I would have had a total of h operations. So I have four operations and I can
Here, view or preview the result if you prefer. We can clearly see my sentence, which has been
modified each time with the addition of by channel. If I don't like it, I can cancel, so I use a
backspace function. See, it's back to how it was before. I can reapply. And
if I'm happy with the result, at that point, I click on phase 2. Be careful, once
you've clicked on phase 2, you can no longer go back. Phase 2 saves to the
database. You have a gauge here that tells you the execution time, and then it's finished.
When we've saved, Magic Edit remains open. That is to say, you can then
either close the window or continue to act on the same four lines that I had
previously selected. For example, if I now want to add text in front, well, I click
on my tool here and, I don't know, let's say I'm going to add "pretty in front." I apply it, and here
I have "pretty dress" applied everywhere. And if I like it, I save. So,
when you relaunch Magic Edit, right after, you see that your last
use is memorized. So here, it's ready to add new pretty to the same selection.
So if I apply, I'll have two pretty in front of my sentence. So it memorizes the tools
that were selected to reapply the same, how to say, the same modification on
other lines or other columns. And similarly, it memorizes the texts or parameters that
you entered in the interfaces. For example, in the add text at the end tool,
we find here the byte channel from earlier. So let's see what we can do.
So, we're going to work on the reference column here. So, I right-click in my column,
I relaunch Magic Edit on my selection of four lines. The first tool that is offered to you
is a content deletion tool. So, as usual, I activate the tool to be able
to use it. And you see that inside, you have different sub-options under possibilities. The
first allows you to delete the entire thing. So if I apply it, all my cells are emptied.
You can also tell it to search for text sequences, for example, to
delete everything from the beginning up to and including the first following string. So, for example,
I'm going to tell it to delete everything up to the first dash. In fact, it's going to delete
the demo and the dash itself. So it's a dash and down, so it's the other one. Look,
if I apply it, I only have the end left. And then other options. So instead of the beginning,
it can be the end. Uh, it can be all the strings between two strings. So, for example,
I could ask it to delete everything between the M and the dash. We're going to do that.
M and the dash is down. And I apply it. See, in fact, I have MO which disappears with the dash.
There you have it, a whole bunch of deletion possibilities. Here, one that is important, uh, a search for
any text and deletion of this any text. So for example, the same here,
I can ask to delete, search and delete o everywhere. So, something
quite simple to understand. Then, you have a search and replace function. So there,
it's a bit the same thing. It will search for text according to certain criteria. So similarly,
it can be text from the beginning to the first string, for example my underscore. So
it's the same example as before. And this text that it will find, I ask it to
replace it with something here. Replace with this text. And there I will type what I want.
For example, a dress. I apply there, you see, I have words and my dash that disappear
in favor of dress. Notice that here it didn't find it. Indeed, the dash was missing. So
my search here cannot be performed on this cell. So here is a search and
replace function. So either from the beginning to a certain character on a certain character or the end
from another character. A selection, a search between two strings. Uh or
You can also search for the string from such and such a position to such and such a position. So here, it's not
a search by comparison, but it's asking it to systematically remove, for example,
all the characters between position 2 and position 3. So if I apply it, it will
remove it if I'm not mistaken, it will keep the D. There you go. And then it inserts the mor and keeps
the top of the end. There you go. Well, I'm not insisting on this tool. I think it's self-explanatory.
Just perhaps, uh, your attention here on this one, on this option which allows you
to fill your columns with synonyms. If, for example, I ask to search for
all the occurrences found of the following text, so I ask to search for the word
demo with or without a capital letter because there I see that there is a lowercase D here, an
uppercase D. So I'm going to ask it to ignore the capital letter, so as to
act on all my lines. And then rather than replacing with another word like for example Rob,
so that would give this. In fact, I'm going to ask it to replace with a synonym for dress
taken from a list. So it could be dress, I put some slightly strange things. Rub, skirt,
sorry, uh we'll say long dress and so on. If I apply it, well it goes randomly,
so there on four lines relevant but it did it at least once, you see? At random,
choose one of the words from my list and make its replacement uh in all the lines that we have that
we have selected. If I apply it again, I don't know if it gives me the same
thing at random. Yeah. No, it's different. dress skirt dress and long dress. So this is a
fairly simple way to enrich the vocabulary of your texts, particularly in descriptions, in
product names with lists of synonyms uh of your keywords. So for SEO,
I assure you it's pretty awesome and it's especially super quick to set up.
So I'm going to close this tool, I'm deactivating it. So, the next two tools, I already
showed you in the first exercise, eh. So, it's adding text in front like the pretty one or adding
text at the end like the by channel that I had put here. Then, we have a very useful function that
allows you to add the content of one column to another, line by line. What does that
mean? Well, it means that we choose a destination column and a target column.
For example, if I want to copy my names here, my product names into my reference column,
well I can do it with this tool. So I just have to right-click in my
reference column. That's my target. Select my tool. So I add the content of another column and
here for that, I just have to select the column containing my content. So for example,
I'm going to take the name. So that is to say this column and I apply it in this field. So
it will apply it either in front or at the end. So if I put in front, it will give something
like this. Pretty printed dress and the text behind. And if I put it at the end,
we will keep that and we will have the pretty dress coming behind, the name coming at the end.
We can optionally put a separator between the two. A dash for example,
something like that. So of course here it would not be relevant,
it would give me a weird thing. So at that point, I could combine this function with the
delete tool, a request for complete deletion. If I apply this time,
I only have this left with my dash there which is hanging around because I put it in place
here in my second tool. So at that moment, I remove it and it gives us something like
this. So there, I copy a column in its entirety into another column line by line. So,
I haven't told you about this little option here display. What is it for? Quite simply,
when we copy certain columns, for example, so I don't have it here, but if we
take as a source column a column like the list of suppliers or the list of manufacturers,
in fact by default what will be copied is not the name of the supplier of the manufacturer, but that's fine.
be its ID its number if you check display in fact then on the contrary it is not the number
but it is the name that is to say what is displayed on the screen and by default it is the name that is displayed
on the screen and well It is therefore this name that will be copied into the destination column. So there you have it,
just a differentiated management at your choice between the default ID or when it is checked the name,
that is to say what is displayed on the screen. The next function, add the clipboard.
So that is also very practical. It allows you to copy a column from a
spreadsheet type file from Excel or other spreadsheet it does not matter. Open Office also works well towards a column
of your table here so towards your database. So to show you that and
well I will start for example from this Excel file in which I have barcodes
and references. I will take here these three lines, these four lines more precisely. So
supplier reference. I do a copy paste copy. I come here and so I choose my tool
added to the clipboard. So, before, I made sure that I deleted the content.
I do then I will leave the default settings and then I will explain to you later. There you go,
I do it like this. I will just apply and you see my first three references are
filled here. So, I had only taken three, the 4th line is empty. So here, it
emptied this cell for me. There you go. So simply, I quickly did a copy and paste from Excel.
to my table. And if I save, that's what's great, right, is that we save in the database
directly. So it's as if we were copying and pasting from Excel to a database
. So I was saying, there are different options here. So what is it? The first one
here is the separator between the lines. So by default it contains RCLF which means carriage
return finally line feed so carriage return line feed. So this is the code
that Excel uses by default to create a line break. So it's important to know it.
Be aware that on some spreadsheets or some versions of spreadsheets it can be different. It
can be just an RC or just an LF. Anything is possible, but most of the time it will be
RCLF. If the separator here is incorrectly defined, in fact, instead of copying one value per cell,
you will actually find yourself with all your values ​​copied into the first row.
So it's quite easy at that point to realize it. You cancel and change
your separator. The other option here, first row of the list, corresponds to the first row
selected and often checked by default, and I advise you to leave it. In the majority of
cases, that will be fine. If I uncheck it and reapply it, you will see the
behavior here is different. In fact, what's happening? It's my third line here
that is filled, finally, which fills the third line here in fact of my entire table. So in fact, there,
we have a correspondence between this first line here with ABCD was matched or corresponds to this
first line here. The second to this second and the third here to this one. So in fact,
we have more of a correspondence between the selection of my three lines, of my four lines here and my
four lines here. We have a correspondence between these four lines here but starting from the top
of my table. So we have an offset in this case. So that has certain uses in certain cases.
Well, I'm not going to go into detail, you have your own experience. But most of the
time, as I was saying, you will use the correspondence function which allows you to have
an exact correspondence in relation to what you want to do. And then finally in front or at the
end, well, but you understand, it's the same thing as almost everywhere. Uh, it allows you to decide
whether when we don't empty the content or when we deactivate here, uh, well, it allows us to fill,
therefore to concatenate our column content with what already exists. So there, if I reapply,
I actually have two times CD ABCD. I have two times my sequence of values ​​on each
line. And so when we have a concatenation like this, we can decide to put in front or at the
end and also decide which separator we're going to put between our concatenated values. Like this,
the following tool allows us to do conversion. So, there are all kinds of
possible conversions. The most obvious ones are, for example, converting to lowercase like this
or, on the contrary, converting to uppercase or simply the first letter in uppercase. So
I can ask it to use lowercase with the first letter in uppercase. If I apply
both, you see, it executes both modifications. We'll save like this. I can
ask it to remove the accents. Well, I don't have any. But I can also ask it
to convert my text into different formats. So you may know the formats or fit he
they are alphabets. So you can convert from one alphabet to another alphabet in one direction
or the other. You can also convert from RTF to text. So RTF is the rich text
format. In fact, it's what you get when you copy from a Word or
Excel page. So, rich text. So this is useful for removing the enrichment coming from Word.
Other functions like converting text to XML or the opposite of richx format to
HTML, from HTML to rich format or even then this one will be more frequently used converting
text to HTML or especially from HTML to text. So, the usefulness of converting HTML to
text is, for example, you make a copy of text that you retrieve from a web page,
but you want to put that in the name, for example, of the product. So,
you should know that the product name in Prestashop does not accept HTML encoding, what we call
HTML tags. So at this point, after copying and pasting, you'll
perhaps use the add column content function or add from clipboard
or others, well, you'll use the HTML vertex to remove the HTML tags from what
was copied into your cells. Another interesting function is adding a barcode.
So before using it, I'm going to close it and select another column. So
we're going to fill our column here with UPC. So these are the UPC barcodes in Prestashop. So likewise,
I'm going to act on these four lines here. So I right-click Magic Edit and I'm going to activate
my barcode addition. So adding a barcode is perhaps a little more complicated to
understand if you don't know at all what a barcode is and how it works. So you
already know that you have two types of barcodes in Prestashop, EN13 and UPC. So here I
am in the UPC column, so I obviously choose this one. Next, you should know that a barcode
is made up of three parts. The left part, which is a fixed part that won't vary between
your different products. It will always be the same value. In principle, this left part
is something provided to you by the company that sells the barcodes. You should
know that barcodes are standardized. And to be able to use barcodes on your
website or on marketplaces, you have to buy a series of barcodes.
And when you buy a series of barcodes, you are assigned a number, often 5
or 6 digits. I think it's 5 by default, like this. And in fact, this left-hand code will
allow you to identify yourself as a company. In fact, in this code, there is
who you are, where you are, and also the type of activity you operate. So,
it can be a little longer than five digits depending on different parameters.
So the left part, which is fixed. Then you have the right part which will actually be a
counter that will increment. So maybe we will provide you with the first barcode,
it will start at 1 but that is rarely the case. So maybe it will be I don't know,
I will say 4 5 6 okay. So that will be the right part of your barcode of your first
barcode. Then the following barcodes for the following lines will
normally increment by a value of 1. It can be something else, but most of the time it will be 1 here at
the increment level. This will generate barcodes with 11 digits, whereas a UPC barcode
contains 12 digits. So the 12th digit, in fact what we call the check bit, will be
calculated by Magic Edit and added to the right of my series. So look, we're going to do it.
So I'm going to apply it. So here I have my first barcode with my left series 1 2 3 4
5, my five fixed digits. Then I have zeros, then I have 4 5 6, so my right part. And finally,
I have a last digit here, 2, which is the check bit that was calculated. The check bit
is what we call the checksum. It's the binary sum of all the digits that are
here on the left. So the first 11 digits in the case of a UPC barcode.
For a UN13 barcode, it's exactly the same principle, except that we have 13 digits,
so 12 fixed digits plus the 13th check bit on the right. So I cancel, I show you the
five digits on the left plus or minus your zeros which will be added automatically between the two.
Here, I had my three digits on the right, my increment and finally my check bit,
the 12th in the case of a UPC or the 13th in the case of an EN13 which will be added
automatically by Merlin after being calculated. What is interesting to note
is that here Magic Edit remembers the last number generated. Remember, I started at
456,456. Since I generated four barcodes, the next one will start at 460. So with this tool,
you don't risk it unless you manually go and modify this counter
here, but you don't risk regenerating barcodes that have already been used.
So, the last tool in Magic Edit is what we call indexing. What is indexing used for
? Well, most of the time, it's mainly used when you want to create reference lists.
For example, let's say I'm going to fill my column here with something like reference 1,
reference 2, reference 3. So, I'm going to do that. So, I've already closed it. I'm going to come here to
my reference column. I'm going to restart Magic Edit. So I'm going to ask it to start by emptying my
content. I'm then going to ask it to add some text in front of it, such as ref with a hyphen.
Then I'm going to activate my index and I'm going to ask it to add -1-2-3.
So that means that the first value, I put a 1. I ask to count one by one.
It could be something else. I'm going to put my index at the end and I could put either my
dash here, or actually finally either put it there or put it up there in ref but not in
both places. And I apply. There, I get a series of auto-incremented references and if
I like the result, I save. I'm going to close. I'm going to show you something else. This time,
I'm going to display the variations of these products. So, I'm going to start by enlarging my area. I
go to image variation. I display my variations. So there, I have all
the variations of my four products. So, let's imagine that I structure my display a little
here by adding a break, a break, sorry, on the product name column. So,
I remind you to do that, we right-click, we add a break. The break,
that's it, it's this separation line here. which allows you to group the variations for each
of the products. There, product 4, here, product 3 and so on. So, if I wanted, for example,
to fill my column here with the variation reference for all these variations of these four products.
So, I would do the same thing. I would right-click in my table. I would search
in the same way with Magic Edit. So there, I would choose from the entire column, which means that it
automatically selected all my rows and I am asking it the same thing in fact. So,
I would like to fill this column a little differently. I would like it to take
the product reference and add a counter behind it. So, for example, reference-3-1
et cetera. So, we're going to do it. So, I can delete the content. I'm going to
remove add text. I'm going to ask it to copy the contents of a column. And there,
I'm going to take the column that contains the product reference as it is displayed.
I'm going to put it at the beginning and without a separator. And finally, I'm going to ask it to add an index.
So, it remembers the 5 because it already generated a series of 5 earlier. I'm going to reset
the counter to 1. Ask it to increment by 1 at the end with a separator. If I leave it like
that, what will happen? I'm going to apply it to show you. Do 80 operations, I save
and I close. What happens? So we have our reference 3 then t- 1 2 3 4 5 but the
problem is that on the next product here it continues to count 18 goes to 19 in fact the series
is not interrupted by the breaks. So that's not what I would like. What I would like is
for it to start counting from one to 1 again. In fact, that's what we call a reset, right. I would have
a reset after each break. Well, to do that, you just have to check an option. So,
we're going to go back. So, we're starting the tool again. It has memorized everything we had set. So,
except for this little choice because it will ask you for it again each time. So, I'm taking
my product reference here. I'm starting to count again from 1. But this time, the only difference is that I
'm going to check this reset after break option here. I apply, I save, I close and this time,
you see after each break, it starts counting again from 1.
That's it, we'll stop there for Magic Elite. I'll let you discover this tool. You have to practice
a little to get used to it and understand all the subtleties, the possibilities. But
you'll see, with this, you'll save a lot of time, especially when filling out
SEO columns. Typically, I use Magicid frequently to copy the name of my
products into what's called the title tag. And I also use it to copy the summary
into what's called the meta description. And so if you do that on thousands of
products in a few seconds, there you go, you'll probably save weeks,
maybe even months of work. Thank you and see you soon for the next tutorial.