WEBVTT Kind: captions Language: en-US 00:00:10.000 --> 00:00:15.520 Hello, this is Franck from Sitolog. Today I'm going to talk to you about MagicEdit, which has been integrated 00:00:15.520 --> 00:00:19.560 into Merlin for a very long time. In fact, it already existed in previous versions 00:00:19.560 --> 00:00:24.440 of Presta Pressing and Presta Category. It hasn't evolved much since then, but you'll see that 00:00:24.440 --> 00:00:28.640 it's a fantastic tool. In fact, it's really my favorite of all the 00:00:28.640 --> 00:00:33.400 features in Merlin. So, what is Magic Edit used for? It's actually a tool for 00:00:33.400 --> 00:00:41.320 mass editing text columns. A text column is, for example, the name column 00:00:41.320 --> 00:00:48.080 , or the references, or even fields like the meta description, meta keywords, 00:00:48.080 --> 00:00:54.960 keyword lists, or the summary, or even the long description. There are others, for example, 00:00:54.960 --> 00:00:59.440 messages when the product is in stock or in stock. So for all these columns, 00:00:59.440 --> 00:01:04.440 which contain text by definition, there are practically no tools on the market that allow 00:01:04.440 --> 00:01:10.000 mass editing. So, what is mass editing on text used for? Well, 00:01:10.000 --> 00:01:15.360 it's useful for lots of things. For example, correcting spelling mistakes or replacing words 00:01:15.360 --> 00:01:21.040 with others or inserting sentences, words, expressions. It can also be used, 00:01:21.040 --> 00:01:25.640 as we'll see, to generate barcodes or generate reference lists. This means that there 00:01:25.640 --> 00:01:30.720 are almost an infinite number of possible things that can be done with Magic Edit. So, how do 00:01:30.720 --> 00:01:36.880 you use it? Simply by placing yourself in the column you want to modify and 00:01:36.880 --> 00:01:43.600 right-clicking. For example, if I want to act on the column, no, I right-click, 00:01:43.600 --> 00:01:50.480 my context menu appears and here you have two options for launching Magic Edit. The 00:01:50.480 --> 00:01:55.920 first will run Magic Edit on the lines I selected. So here, in this case, only on 00:01:55.920 --> 00:02:02.560 this orange printed dress. And this one will do pretty much the same thing, except that first the Merlin 00:02:02.560 --> 00:02:07.240 will start, you see, by selecting all the lines. So we're actually acting on 00:02:07.240 --> 00:02:17.240 everything that's displayed. So, if I want, for example, to modify, I don't know, 00:02:17.240 --> 00:02:23.800 I'll take these five lines here or these six lines there, these four lines there, I want to add 00:02:23.800 --> 00:02:32.800 something, uh, at the beginning in front, for example, or at the end. We'll add a brand, for example. 00:02:32.800 --> 00:02:37.560 Okay? I'll add "channel" right at the end of this one of these sentences here, of these names. 00:02:37.560 --> 00:02:42.960 So I select my four lines. I right-click anywhere in this column. 00:02:42.960 --> 00:02:50.920 I choose to launch Magic Edit and Magic Edit launches. Magic Edit looks like this. So, in 00:02:50.920 --> 00:02:57.800 fact, it's a set of tools organized from top to bottom that you can activate by clicking on it. 00:02:57.800 --> 00:03:04.840 So when you activate a tool, it turns orange like this or deactivate it by graying it out. 00:03:04.840 --> 00:03:12.720 If I activate two or more of these tools, well, when I execute them, in fact, all 00:03:12.720 --> 00:03:17.520 the functions that I configure in these tools will be executed from top to bottom. So here, 00:03:17.520 --> 00:03:23.240 for example, it will perform this function: add text in front. So add a text in front of the 00:03:23.240 --> 00:03:29.080 text that is here and then it will add something else, the content of another column that I will 00:03:29.080 --> 00:03:36.400 configure here. So it will perform both actions simultaneously but acting from top to bottom. 00:03:36.400 --> 00:03:42.600 So if I activate everything for example, I can have up to ten consecutive actions that will 00:03:42.600 --> 00:03:51.080 act on my texts. So what I was saying, we will take the example of wanting to add a mark 00:03:51.080 --> 00:03:56.120 at the end of these names here. So I search in my tool and I will take for example 00:03:56.120 --> 00:04:02.960 this one. Add a text at the end. So I do this. I just simply add here to type 00:04:02.960 --> 00:04:08.560 the text that I want to add. So for example a space and then I will OK I will do something 00:04:08.560 --> 00:04:16.000 like that by channel in English why not. Here I type my text that I want to add in 00:04:16.000 --> 00:04:24.040 bulk. I do phase one apply and you will see in fact Magic Edit tells me the number 00:04:24.040 --> 00:04:28.600 of operations that it has carried out. So 4. So, that doesn't mean that it has modified four lines, 00:04:28.600 --> 00:04:33.600 it means that it has carried out four operations. If, for example, I had programmed two actions 00:04:33.600 --> 00:04:40.200 on my four lines, I would have had a total of h operations. So I have four operations and I can 00:04:40.200 --> 00:04:46.320 Here, view or preview the result if you prefer. We can clearly see my sentence, which has been 00:04:46.320 --> 00:04:54.080 modified each time with the addition of by channel. If I don't like it, I can cancel, so I use a 00:04:54.080 --> 00:04:59.880 backspace function. See, it's back to how it was before. I can reapply. And 00:04:59.880 --> 00:05:05.040 if I'm happy with the result, at that point, I click on phase 2. Be careful, once 00:05:05.040 --> 00:05:10.400 you've clicked on phase 2, you can no longer go back. Phase 2 saves to the 00:05:10.400 --> 00:05:16.440 database. You have a gauge here that tells you the execution time, and then it's finished. 00:05:17.080 --> 00:05:25.000 When we've saved, Magic Edit remains open. That is to say, you can then 00:05:25.000 --> 00:05:30.080 either close the window or continue to act on the same four lines that I had 00:05:30.080 --> 00:05:34.720 previously selected. For example, if I now want to add text in front, well, I click 00:05:34.720 --> 00:05:43.280 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 00:05:43.280 --> 00:05:49.080 I have "pretty dress" applied everywhere. And if I like it, I save. So, 00:05:49.080 --> 00:05:57.160 when you relaunch Magic Edit, right after, you see that your last 00:05:57.160 --> 00:06:04.440 use is memorized. So here, it's ready to add new pretty to the same selection. 00:06:04.440 --> 00:06:11.200 So if I apply, I'll have two pretty in front of my sentence. So it memorizes the tools 00:06:11.200 --> 00:06:16.240 that were selected to reapply the same, how to say, the same modification on 00:06:16.240 --> 00:06:21.320 other lines or other columns. And similarly, it memorizes the texts or parameters that 00:06:21.320 --> 00:06:25.520 you entered in the interfaces. For example, in the add text at the end tool, 00:06:25.520 --> 00:06:31.240 we find here the byte channel from earlier. So let's see what we can do. 00:06:31.240 --> 00:06:36.520 So, we're going to work on the reference column here. So, I right-click in my column, 00:06:36.520 --> 00:06:42.040 I relaunch Magic Edit on my selection of four lines. The first tool that is offered to you 00:06:42.040 --> 00:06:48.040 is a content deletion tool. So, as usual, I activate the tool to be able 00:06:48.040 --> 00:06:54.840 to use it. And you see that inside, you have different sub-options under possibilities. The 00:06:54.840 --> 00:07:03.000 first allows you to delete the entire thing. So if I apply it, all my cells are emptied. 00:07:03.000 --> 00:07:09.840 You can also tell it to search for text sequences, for example, to 00:07:09.840 --> 00:07:14.800 delete everything from the beginning up to and including the first following string. So, for example, 00:07:14.800 --> 00:07:21.560 I'm going to tell it to delete everything up to the first dash. In fact, it's going to delete 00:07:21.560 --> 00:07:27.560 the demo and the dash itself. So it's a dash and down, so it's the other one. Look, 00:07:27.560 --> 00:07:34.040 if I apply it, I only have the end left. And then other options. So instead of the beginning, 00:07:34.040 --> 00:07:39.560 it can be the end. Uh, it can be all the strings between two strings. So, for example, 00:07:39.560 --> 00:07:46.800 I could ask it to delete everything between the M and the dash. We're going to do that. 00:07:46.800 --> 00:07:54.760 M and the dash is down. And I apply it. See, in fact, I have MO which disappears with the dash. 00:07:54.760 --> 00:08:02.120 There you have it, a whole bunch of deletion possibilities. Here, one that is important, uh, a search for 00:08:02.120 --> 00:08:06.680 any text and deletion of this any text. So for example, the same here, 00:08:06.680 --> 00:08:13.520 I can ask to delete, search and delete o everywhere. So, something 00:08:13.520 --> 00:08:20.080 quite simple to understand. Then, you have a search and replace function. So there, 00:08:20.080 --> 00:08:24.680 it's a bit the same thing. It will search for text according to certain criteria. So similarly, 00:08:24.680 --> 00:08:29.360 it can be text from the beginning to the first string, for example my underscore. So 00:08:29.360 --> 00:08:35.640 it's the same example as before. And this text that it will find, I ask it to 00:08:35.640 --> 00:08:40.520 replace it with something here. Replace with this text. And there I will type what I want. 00:08:40.520 --> 00:08:47.440 For example, a dress. I apply there, you see, I have words and my dash that disappear 00:08:47.440 --> 00:08:53.680 in favor of dress. Notice that here it didn't find it. Indeed, the dash was missing. So 00:08:53.680 --> 00:09:00.360 my search here cannot be performed on this cell. So here is a search and 00:09:00.360 --> 00:09:07.280 replace function. So either from the beginning to a certain character on a certain character or the end 00:09:07.280 --> 00:09:14.960 from another character. A selection, a search between two strings. Uh or 00:09:14.960 --> 00:09:21.000 You can also search for the string from such and such a position to such and such a position. So here, it's not 00:09:21.000 --> 00:09:26.240 a search by comparison, but it's asking it to systematically remove, for example, 00:09:26.240 --> 00:09:32.600 all the characters between position 2 and position 3. So if I apply it, it will 00:09:32.600 --> 00:09:40.720 remove it if I'm not mistaken, it will keep the D. There you go. And then it inserts the mor and keeps 00:09:40.720 --> 00:09:49.760 the top of the end. There you go. Well, I'm not insisting on this tool. I think it's self-explanatory. 00:09:50.360 --> 00:09:57.680 Just perhaps, uh, your attention here on this one, on this option which allows you 00:09:57.680 --> 00:10:05.320 to fill your columns with synonyms. If, for example, I ask to search for 00:10:05.320 --> 00:10:09.120 all the occurrences found of the following text, so I ask to search for the word 00:10:09.120 --> 00:10:16.080 demo with or without a capital letter because there I see that there is a lowercase D here, an 00:10:16.080 --> 00:10:20.480 uppercase D. So I'm going to ask it to ignore the capital letter, so as to 00:10:20.480 --> 00:10:26.000 act on all my lines. And then rather than replacing with another word like for example Rob, 00:10:26.000 --> 00:10:32.400 so that would give this. In fact, I'm going to ask it to replace with a synonym for dress 00:10:32.400 --> 00:10:39.120 taken from a list. So it could be dress, I put some slightly strange things. Rub, skirt, 00:10:39.120 --> 00:10:49.320 sorry, uh we'll say long dress and so on. If I apply it, well it goes randomly, 00:10:49.320 --> 00:10:52.760 so there on four lines relevant but it did it at least once, you see? At random, 00:10:52.760 --> 00:11:00.000 choose one of the words from my list and make its replacement uh in all the lines that we have that 00:11:00.000 --> 00:11:04.800 we have selected. If I apply it again, I don't know if it gives me the same 00:11:04.800 --> 00:11:10.560 thing at random. Yeah. No, it's different. dress skirt dress and long dress. So this is a 00:11:10.560 --> 00:11:16.000 fairly simple way to enrich the vocabulary of your texts, particularly in descriptions, in 00:11:16.000 --> 00:11:21.000 product names with lists of synonyms uh of your keywords. So for SEO, 00:11:21.000 --> 00:11:26.960 I assure you it's pretty awesome and it's especially super quick to set up. 00:11:26.960 --> 00:11:30.880 So I'm going to close this tool, I'm deactivating it. So, the next two tools, I already 00:11:30.880 --> 00:11:35.840 showed you in the first exercise, eh. So, it's adding text in front like the pretty one or adding 00:11:35.840 --> 00:11:42.680 text at the end like the by channel that I had put here. Then, we have a very useful function that 00:11:42.680 --> 00:11:48.080 allows you to add the content of one column to another, line by line. What does that 00:11:48.080 --> 00:11:54.880 mean? Well, it means that we choose a destination column and a target column. 00:11:54.880 --> 00:12:01.200 For example, if I want to copy my names here, my product names into my reference column, 00:12:01.200 --> 00:12:05.520 well I can do it with this tool. So I just have to right-click in my 00:12:05.520 --> 00:12:12.160 reference column. That's my target. Select my tool. So I add the content of another column and 00:12:12.160 --> 00:12:17.480 here for that, I just have to select the column containing my content. So for example, 00:12:17.480 --> 00:12:26.320 I'm going to take the name. So that is to say this column and I apply it in this field. So 00:12:26.320 --> 00:12:34.960 it will apply it either in front or at the end. So if I put in front, it will give something 00:12:34.960 --> 00:12:40.640 like this. Pretty printed dress and the text behind. And if I put it at the end, 00:12:40.640 --> 00:12:48.880 we will keep that and we will have the pretty dress coming behind, the name coming at the end. 00:12:48.880 --> 00:12:53.240 We can optionally put a separator between the two. A dash for example, 00:12:53.240 --> 00:12:56.280 something like that. So of course here it would not be relevant, 00:12:56.280 --> 00:13:00.840 it would give me a weird thing. So at that point, I could combine this function with the 00:13:00.840 --> 00:13:07.080 delete tool, a request for complete deletion. If I apply this time, 00:13:07.080 --> 00:13:12.640 I only have this left with my dash there which is hanging around because I put it in place 00:13:12.640 --> 00:13:19.080 here in my second tool. So at that moment, I remove it and it gives us something like 00:13:19.080 --> 00:13:25.200 this. So there, I copy a column in its entirety into another column line by line. So, 00:13:25.200 --> 00:13:30.400 I haven't told you about this little option here display. What is it for? Quite simply, 00:13:30.400 --> 00:13:35.720 when we copy certain columns, for example, so I don't have it here, but if we 00:13:35.720 --> 00:13:42.160 take as a source column a column like the list of suppliers or the list of manufacturers, 00:13:42.160 --> 00:13:47.160 in fact by default what will be copied is not the name of the supplier of the manufacturer, but that's fine. 00:13:47.160 --> 00:13:54.080 be its ID its number if you check display in fact then on the contrary it is not the number 00:13:54.080 --> 00:13:57.760 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 00:13:57.760 --> 00:14:03.240 on the screen and well It is therefore this name that will be copied into the destination column. So there you have it, 00:14:03.240 --> 00:14:10.240 just a differentiated management at your choice between the default ID or when it is checked the name, 00:14:10.240 --> 00:14:18.280 that is to say what is displayed on the screen. The next function, add the clipboard. 00:14:18.280 --> 00:14:26.040 So that is also very practical. It allows you to copy a column from a 00:14:26.040 --> 00:14:33.240 spreadsheet type file from Excel or other spreadsheet it does not matter. Open Office also works well towards a column 00:14:33.240 --> 00:14:41.280 of your table here so towards your database. So to show you that and 00:14:41.280 --> 00:14:45.320 well I will start for example from this Excel file in which I have barcodes 00:14:45.320 --> 00:14:53.400 and references. I will take here these three lines, these four lines more precisely. So 00:14:53.400 --> 00:15:01.040 supplier reference. I do a copy paste copy. I come here and so I choose my tool 00:15:01.040 --> 00:15:09.520 added to the clipboard. So, before, I made sure that I deleted the content. 00:15:09.520 --> 00:15:13.880 I do then I will leave the default settings and then I will explain to you later. There you go, 00:15:13.880 --> 00:15:19.720 I do it like this. I will just apply and you see my first three references are 00:15:19.720 --> 00:15:24.560 filled here. So, I had only taken three, the 4th line is empty. So here, it 00:15:24.560 --> 00:15:32.600 emptied this cell for me. There you go. So simply, I quickly did a copy and paste from Excel. 00:15:32.600 --> 00:15:37.840 to my table. And if I save, that's what's great, right, is that we save in the database 00:15:37.840 --> 00:15:42.000 directly. So it's as if we were copying and pasting from Excel to a database 00:15:42.000 --> 00:15:48.240 . So I was saying, there are different options here. So what is it? The first one 00:15:48.240 --> 00:15:54.360 here is the separator between the lines. So by default it contains RCLF which means carriage 00:15:54.360 --> 00:16:01.160 return finally line feed so carriage return line feed. So this is the code 00:16:01.160 --> 00:16:07.840 that Excel uses by default to create a line break. So it's important to know it. 00:16:07.840 --> 00:16:11.600 Be aware that on some spreadsheets or some versions of spreadsheets it can be different. It 00:16:11.600 --> 00:16:16.880 can be just an RC or just an LF. Anything is possible, but most of the time it will be 00:16:16.880 --> 00:16:25.680 RCLF. If the separator here is incorrectly defined, in fact, instead of copying one value per cell, 00:16:25.680 --> 00:16:29.600 you will actually find yourself with all your values ​​copied into the first row. 00:16:29.600 --> 00:16:33.280 So it's quite easy at that point to realize it. You cancel and change 00:16:33.280 --> 00:16:38.760 your separator. The other option here, first row of the list, corresponds to the first row 00:16:38.760 --> 00:16:43.520 selected and often checked by default, and I advise you to leave it. In the majority of 00:16:43.520 --> 00:16:49.920 cases, that will be fine. If I uncheck it and reapply it, you will see the 00:16:49.920 --> 00:16:57.280 behavior here is different. In fact, what's happening? It's my third line here 00:16:57.280 --> 00:17:03.560 that is filled, finally, which fills the third line here in fact of my entire table. So in fact, there, 00:17:03.560 --> 00:17:11.880 we have a correspondence between this first line here with ABCD was matched or corresponds to this 00:17:11.880 --> 00:17:17.080 first line here. The second to this second and the third here to this one. So in fact, 00:17:17.080 --> 00:17:22.000 we have more of a correspondence between the selection of my three lines, of my four lines here and my 00:17:22.000 --> 00:17:28.080 four lines here. We have a correspondence between these four lines here but starting from the top 00:17:28.080 --> 00:17:34.680 of my table. So we have an offset in this case. So that has certain uses in certain cases. 00:17:34.680 --> 00:17:38.720 Well, I'm not going to go into detail, you have your own experience. But most of the 00:17:38.720 --> 00:17:45.040 time, as I was saying, you will use the correspondence function which allows you to have 00:17:45.040 --> 00:17:49.920 an exact correspondence in relation to what you want to do. And then finally in front or at the 00:17:49.920 --> 00:17:55.600 end, well, but you understand, it's the same thing as almost everywhere. Uh, it allows you to decide 00:17:55.600 --> 00:18:05.760 whether when we don't empty the content or when we deactivate here, uh, well, it allows us to fill, 00:18:05.760 --> 00:18:11.040 therefore to concatenate our column content with what already exists. So there, if I reapply, 00:18:11.040 --> 00:18:17.080 I actually have two times CD ABCD. I have two times my sequence of values ​​on each 00:18:17.080 --> 00:18:21.800 line. And so when we have a concatenation like this, we can decide to put in front or at the 00:18:21.800 --> 00:18:32.960 end and also decide which separator we're going to put between our concatenated values. Like this, 00:18:32.960 --> 00:18:37.520 the following tool allows us to do conversion. So, there are all kinds of 00:18:37.520 --> 00:18:45.520 possible conversions. The most obvious ones are, for example, converting to lowercase like this 00:18:45.520 --> 00:18:50.960 or, on the contrary, converting to uppercase or simply the first letter in uppercase. So 00:18:50.960 --> 00:18:54.640 I can ask it to use lowercase with the first letter in uppercase. If I apply 00:18:54.640 --> 00:19:02.560 both, you see, it executes both modifications. We'll save like this. I can 00:19:02.560 --> 00:19:07.680 ask it to remove the accents. Well, I don't have any. But I can also ask it 00:19:07.680 --> 00:19:14.760 to convert my text into different formats. So you may know the formats or fit he 00:19:14.760 --> 00:19:19.640 they are alphabets. So you can convert from one alphabet to another alphabet in one direction 00:19:19.640 --> 00:19:25.040 or the other. You can also convert from RTF to text. So RTF is the rich text 00:19:25.040 --> 00:19:30.360 format. In fact, it's what you get when you copy from a Word or 00:19:30.360 --> 00:19:37.840 Excel page. So, rich text. So this is useful for removing the enrichment coming from Word. 00:19:37.840 --> 00:19:45.520 Other functions like converting text to XML or the opposite of richx format to 00:19:45.520 --> 00:19:54.320 HTML, from HTML to rich format or even then this one will be more frequently used converting 00:19:54.320 --> 00:19:59.640 text to HTML or especially from HTML to text. So, the usefulness of converting HTML to 00:19:59.640 --> 00:20:04.640 text is, for example, you make a copy of text that you retrieve from a web page, 00:20:04.640 --> 00:20:09.120 but you want to put that in the name, for example, of the product. So, 00:20:09.120 --> 00:20:13.920 you should know that the product name in Prestashop does not accept HTML encoding, what we call 00:20:13.920 --> 00:20:18.520 HTML tags. So at this point, after copying and pasting, you'll 00:20:18.520 --> 00:20:24.080 perhaps use the add column content function or add from clipboard 00:20:24.080 --> 00:20:31.640 or others, well, you'll use the HTML vertex to remove the HTML tags from what 00:20:31.640 --> 00:20:38.880 was copied into your cells. Another interesting function is adding a barcode. 00:20:39.400 --> 00:20:43.320 So before using it, I'm going to close it and select another column. So 00:20:43.320 --> 00:20:49.640 we're going to fill our column here with UPC. So these are the UPC barcodes in Prestashop. So likewise, 00:20:49.640 --> 00:20:58.400 I'm going to act on these four lines here. So I right-click Magic Edit and I'm going to activate 00:20:58.400 --> 00:21:02.760 my barcode addition. So adding a barcode is perhaps a little more complicated to 00:21:02.760 --> 00:21:07.080 understand if you don't know at all what a barcode is and how it works. So you 00:21:07.080 --> 00:21:12.440 already know that you have two types of barcodes in Prestashop, EN13 and UPC. So here I 00:21:12.440 --> 00:21:17.440 am in the UPC column, so I obviously choose this one. Next, you should know that a barcode 00:21:17.440 --> 00:21:23.720 is made up of three parts. The left part, which is a fixed part that won't vary between 00:21:23.720 --> 00:21:29.640 your different products. It will always be the same value. In principle, this left part 00:21:29.640 --> 00:21:33.240 is something provided to you by the company that sells the barcodes. You should 00:21:33.240 --> 00:21:37.240 know that barcodes are standardized. And to be able to use barcodes on your 00:21:37.240 --> 00:21:42.000 website or on marketplaces, you have to buy a series of barcodes. 00:21:42.000 --> 00:21:46.720 And when you buy a series of barcodes, you are assigned a number, often 5 00:21:46.720 --> 00:21:55.080 or 6 digits. I think it's 5 by default, like this. And in fact, this left-hand code will 00:21:55.080 --> 00:21:59.520 allow you to identify yourself as a company. In fact, in this code, there is 00:21:59.520 --> 00:22:06.120 who you are, where you are, and also the type of activity you operate. So, 00:22:06.120 --> 00:22:10.040 it can be a little longer than five digits depending on different parameters. 00:22:10.720 --> 00:22:17.720 So the left part, which is fixed. Then you have the right part which will actually be a 00:22:17.720 --> 00:22:21.480 counter that will increment. So maybe we will provide you with the first barcode, 00:22:21.480 --> 00:22:26.040 it will start at 1 but that is rarely the case. So maybe it will be I don't know, 00:22:26.040 --> 00:22:31.760 I will say 4 5 6 okay. So that will be the right part of your barcode of your first 00:22:31.760 --> 00:22:36.720 barcode. Then the following barcodes for the following lines will 00:22:36.720 --> 00:22:41.440 normally increment by a value of 1. It can be something else, but most of the time it will be 1 here at 00:22:41.440 --> 00:22:46.880 the increment level. This will generate barcodes with 11 digits, whereas a UPC barcode 00:22:46.880 --> 00:22:53.000 contains 12 digits. So the 12th digit, in fact what we call the check bit, will be 00:22:53.000 --> 00:23:01.040 calculated by Magic Edit and added to the right of my series. So look, we're going to do it. 00:23:01.680 --> 00:23:09.680 So I'm going to apply it. So here I have my first barcode with my left series 1 2 3 4 00:23:09.680 --> 00:23:19.520 5, my five fixed digits. Then I have zeros, then I have 4 5 6, so my right part. And finally, 00:23:19.520 --> 00:23:25.160 I have a last digit here, 2, which is the check bit that was calculated. The check bit 00:23:25.160 --> 00:23:32.280 is what we call the checksum. It's the binary sum of all the digits that are 00:23:32.280 --> 00:23:37.960 here on the left. So the first 11 digits in the case of a UPC barcode. 00:23:37.960 --> 00:23:42.720 For a UN13 barcode, it's exactly the same principle, except that we have 13 digits, 00:23:42.720 --> 00:23:52.400 so 12 fixed digits plus the 13th check bit on the right. So I cancel, I show you the 00:23:52.400 --> 00:23:58.960 five digits on the left plus or minus your zeros which will be added automatically between the two. 00:23:58.960 --> 00:24:06.040 Here, I had my three digits on the right, my increment and finally my check bit, 00:24:06.040 --> 00:24:10.480 the 12th in the case of a UPC or the 13th in the case of an EN13 which will be added 00:24:10.480 --> 00:24:14.800 automatically by Merlin after being calculated. What is interesting to note 00:24:14.800 --> 00:24:20.000 is that here Magic Edit remembers the last number generated. Remember, I started at 00:24:20.000 --> 00:24:28.760 456,456. Since I generated four barcodes, the next one will start at 460. So with this tool, 00:24:28.760 --> 00:24:32.520 you don't risk it unless you manually go and modify this counter 00:24:32.520 --> 00:24:40.160 here, but you don't risk regenerating barcodes that have already been used. 00:24:40.160 --> 00:24:46.040 So, the last tool in Magic Edit is what we call indexing. What is indexing used for 00:24:46.040 --> 00:24:50.440 ? Well, most of the time, it's mainly used when you want to create reference lists. 00:24:51.080 --> 00:24:55.880 For example, let's say I'm going to fill my column here with something like reference 1, 00:24:55.880 --> 00:25:01.240 reference 2, reference 3. So, I'm going to do that. So, I've already closed it. I'm going to come here to 00:25:01.240 --> 00:25:08.640 my reference column. I'm going to restart Magic Edit. So I'm going to ask it to start by emptying my 00:25:08.640 --> 00:25:17.640 content. I'm then going to ask it to add some text in front of it, such as ref with a hyphen. 00:25:18.720 --> 00:25:26.120 Then I'm going to activate my index and I'm going to ask it to add -1-2-3. 00:25:26.120 --> 00:25:31.640 So that means that the first value, I put a 1. I ask to count one by one. 00:25:31.640 --> 00:25:38.160 It could be something else. I'm going to put my index at the end and I could put either my 00:25:38.160 --> 00:25:44.240 dash here, or actually finally either put it there or put it up there in ref but not in 00:25:44.240 --> 00:25:51.880 both places. And I apply. There, I get a series of auto-incremented references and if 00:25:51.880 --> 00:25:58.400 I like the result, I save. I'm going to close. I'm going to show you something else. This time, 00:25:58.400 --> 00:26:04.160 I'm going to display the variations of these products. So, I'm going to start by enlarging my area. I 00:26:04.160 --> 00:26:08.200 go to image variation. I display my variations. So there, I have all 00:26:08.200 --> 00:26:13.400 the variations of my four products. So, let's imagine that I structure my display a little 00:26:13.400 --> 00:26:17.800 here by adding a break, a break, sorry, on the product name column. So, 00:26:17.800 --> 00:26:22.200 I remind you to do that, we right-click, we add a break. The break, 00:26:22.200 --> 00:26:29.040 that's it, it's this separation line here. which allows you to group the variations for each 00:26:29.040 --> 00:26:35.160 of the products. There, product 4, here, product 3 and so on. So, if I wanted, for example, 00:26:35.160 --> 00:26:41.800 to fill my column here with the variation reference for all these variations of these four products. 00:26:41.800 --> 00:26:46.400 So, I would do the same thing. I would right-click in my table. I would search 00:26:46.400 --> 00:26:52.480 in the same way with Magic Edit. So there, I would choose from the entire column, which means that it 00:26:52.480 --> 00:26:58.400 automatically selected all my rows and I am asking it the same thing in fact. So, 00:26:58.400 --> 00:27:02.800 I would like to fill this column a little differently. I would like it to take 00:27:02.800 --> 00:27:11.040 the product reference and add a counter behind it. So, for example, reference-3-1 00:27:11.040 --> 00:27:17.240 et cetera. So, we're going to do it. So, I can delete the content. I'm going to 00:27:17.240 --> 00:27:22.280 remove add text. I'm going to ask it to copy the contents of a column. And there, 00:27:22.280 --> 00:27:28.080 I'm going to take the column that contains the product reference as it is displayed. 00:27:28.080 --> 00:27:33.640 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. 00:27:34.200 --> 00:27:38.440 So, it remembers the 5 because it already generated a series of 5 earlier. I'm going to reset 00:27:38.440 --> 00:27:47.160 the counter to 1. Ask it to increment by 1 at the end with a separator. If I leave it like 00:27:47.160 --> 00:27:55.080 that, what will happen? I'm going to apply it to show you. Do 80 operations, I save 00:27:55.080 --> 00:28:03.520 and I close. What happens? So we have our reference 3 then t- 1 2 3 4 5 but the 00:28:03.520 --> 00:28:12.040 problem is that on the next product here it continues to count 18 goes to 19 in fact the series 00:28:12.040 --> 00:28:17.600 is not interrupted by the breaks. So that's not what I would like. What I would like is 00:28:17.600 --> 00:28:22.800 for it to start counting from one to 1 again. In fact, that's what we call a reset, right. I would have 00:28:22.800 --> 00:28:28.760 a reset after each break. Well, to do that, you just have to check an option. So, 00:28:28.760 --> 00:28:33.520 we're going to go back. So, we're starting the tool again. It has memorized everything we had set. So, 00:28:33.520 --> 00:28:38.640 except for this little choice because it will ask you for it again each time. So, I'm taking 00:28:38.640 --> 00:28:46.520 my product reference here. I'm starting to count again from 1. But this time, the only difference is that I 00:28:46.520 --> 00:28:54.920 'm going to check this reset after break option here. I apply, I save, I close and this time, 00:28:54.920 --> 00:29:03.600 you see after each break, it starts counting again from 1. 00:29:03.600 --> 00:29:08.720 That's it, we'll stop there for Magic Elite. I'll let you discover this tool. You have to practice 00:29:08.720 --> 00:29:13.120 a little to get used to it and understand all the subtleties, the possibilities. But 00:29:13.120 --> 00:29:18.280 you'll see, with this, you'll save a lot of time, especially when filling out 00:29:18.280 --> 00:29:24.520 SEO columns. Typically, I use Magicid frequently to copy the name of my 00:29:24.520 --> 00:29:32.720 products into what's called the title tag. And I also use it to copy the summary 00:29:32.720 --> 00:29:38.160 into what's called the meta description. And so if you do that on thousands of 00:29:38.160 --> 00:29:43.600 products in a few seconds, there you go, you'll probably save weeks, 00:29:43.600 --> 00:29:46.960 maybe even months of work. Thank you and see you soon for the next tutorial.