WEBVTT Kind: captions Language: en-US 00:00:10.280 --> 00:00:15.480 Hello, this is Franck from Sitolog. I'm going to talk to you today about the concept of position or 00:00:15.480 --> 00:00:22.200 order. So, there are two types of position or order. There are the display orders of lines 00:00:22.200 --> 00:00:28.200 in Merlin and there is the display order of objects like categories or products in 00:00:28.200 --> 00:00:33.080 Prestashop. So two different concepts and we're going to cover both. So, I'm going to start with the 00:00:33.080 --> 00:00:39.120 categories and at the category level already, I'm going to talk to you about the concept of display order 00:00:39.120 --> 00:00:46.000 in Merlin. So, in Merlin, the categories are necessarily displayed by structure, 00:00:46.000 --> 00:00:51.120 finally in the form of a structure, that is to say we have the root, the home page, then we unfold the 00:00:51.120 --> 00:00:57.240 categories like this. So the categories or subcategories of a category are necessarily 00:00:57.240 --> 00:01:01.360 in the tree structure, in this structure, eh. I can't ask it to display me, for example, 00:01:01.360 --> 00:01:06.800 this category here at the top, at the very bottom when it's in the women's structure which is here at the top, 00:01:06.800 --> 00:01:12.880 eh. Well, they must be part of this branch. On the other hand, in a given branch, for example 00:01:12.880 --> 00:01:19.040 in the home branch, all these categories here that are at the same level, eh, they are 00:01:19.040 --> 00:01:24.640 four categories or subcategories of home. Well, I can ask it to display them in 00:01:24.640 --> 00:01:29.520 a different order. Currently, they are displayed, you don't necessarily see it, but in 00:01:29.520 --> 00:01:38.480 ascending order of memory of this value here that we call NLT or the Arian thread. 00:01:38.480 --> 00:01:42.880 Well, we can ask it to display the categories differently, for example in 00:01:42.880 --> 00:01:51.480 ascending or alphabetical order according to their name. So for that, it happens in the control panel. 00:01:52.320 --> 00:01:55.960 You have to go to display, eh. So I remind you, control panel, 00:01:55.960 --> 00:02:02.400 you have the categories when you are in product view, the stores, then the display, 00:02:02.400 --> 00:02:08.000 then other drawers below. And so in display, you have different tabs here, 00:02:08.000 --> 00:02:17.480 product, variation and category. And in the category tab, here you have the choice 00:02:17.480 --> 00:02:21.640 of the display order of the categories or the category branches. So as I was telling you, 00:02:21.640 --> 00:02:25.200 it's currently by then not by Arian's thread, I made a mistake. Currently, 00:02:25.200 --> 00:02:30.720 it's sorted by ascending ID indeed 1 2 3 12 40 55 but I can 00:02:30.720 --> 00:02:37.240 ask it for example to sort them by name. I click on name. This one, you have to refresh. So, 00:02:37.240 --> 00:02:40.640 I'm going to do it but before that, I'm going to point out to you. So, see, women's accessories 00:02:40.640 --> 00:02:49.800 here are at the very bottom. So I refresh, I click and this time women's accessories are at the top eh 00:02:49.800 --> 00:02:55.000 because I broke it in alphabetical order according to this column. So I modified the 00:02:55.000 --> 00:02:59.720 display order of the categories on the screen but this does not at all reflect the display order of the 00:02:59.720 --> 00:03:05.000 categories in your back office or in the store. What will determine these display orders in the 00:03:05.000 --> 00:03:11.280 store or in the Prestashop administration is the value of the position column that you 00:03:11.280 --> 00:03:16.480 see here. In fact, in Prestashop for quite a few things, categories, products, 00:03:16.480 --> 00:03:21.480 features and other things. Well, these elements have a position and 00:03:21.480 --> 00:03:27.120 it's this position value that determines the display order. And so how do we modify 00:03:27.120 --> 00:03:32.480 these position values? Well, quite simple. We're going to do it by dragging and dropping. So, 00:03:32.480 --> 00:03:38.000 if I try to take a category like this here and move it, it doesn't work 00:03:38.000 --> 00:03:43.080 by default. You see, what it actually does is select other rows. So that's 00:03:43.080 --> 00:03:46.680 intentional, it's to be able to quickly select several categories. So how 00:03:46.680 --> 00:03:50.600 do we drag and drop to reorder the rows? Well, 00:03:50.600 --> 00:03:55.880 first, you have to click on the position button here. So, I click on the position button. 00:03:56.520 --> 00:04:01.360 So, Merlin warns me that to be able to do that, it needs to change some settings. 00:04:01.360 --> 00:04:07.480 It first needs to sort the categories by ascending position. So an order according to these 00:04:07.480 --> 00:04:13.040 values, precisely. And it also needs in case you have multiple stores to limit the list 00:04:13.040 --> 00:04:19.400 of categories displayed to that of the stores selected in the control tab. 00:04:19.400 --> 00:04:25.120 So I tell it to do it for me. So it will refresh the list. There, 00:04:25.120 --> 00:04:29.560 I can scroll down and I end up with not quite the same display as before 00:04:29.560 --> 00:04:33.560 . See, women's accessories have gone back to the bottom. Simply because, as indicated, 00:04:33.560 --> 00:04:39.880 it has restarted the display of categories according to increasing position values. Well, now 00:04:39.880 --> 00:04:44.600 that I'm in position mode, which is indicated to me here by the orange color of the button, well, I 00:04:44.600 --> 00:04:50.440 can move my categories. For example, I can say that promotion here, I simply take it 00:04:50.440 --> 00:04:54.720 and move it where I want. You see, this time, I don't have a sliding selection 00:04:54.720 --> 00:04:59.280 of categories but really a placement or a movement. For example, I'm going to put promotion 00:04:59.280 --> 00:05:05.400 here first in the home page. There you go. So on my store, the categories will be displayed 00:05:05.400 --> 00:05:10.320 as they are there. You see, when I released the mouse, it recalculated the values 00:05:10.320 --> 00:05:14.960 ​​in the position column. Not just on the promotion category that I moved, 00:05:14.960 --> 00:05:21.200 but also on the others, eh. So it remains consistent across the entire tree structure. And of course, what 00:05:21.200 --> 00:05:25.160 I just did here you can do on multiple categories at once, or even branches. 00:05:25.160 --> 00:05:30.040 For example, here I can take the women's branch to what I call a branch and a category with 00:05:30.040 --> 00:05:35.400 these subcategories. So I take the women's branch, I take the men's branch with a control 00:05:35.400 --> 00:05:41.520 click or a shift click and I move them both. And this time, I'm going to put them right 00:05:41.520 --> 00:05:48.680 there. And so, you see, women and men go back above promotion. Now, be careful, 00:05:48.680 --> 00:05:53.600 what I just showed you allows you to change the display order of the categories, of course, 00:05:53.600 --> 00:05:59.080 but it doesn't allow you to move categories, to modify the structure or the tree structure. That 00:05:59.080 --> 00:06:04.760 's something different. So I remind you if you want to move a category 00:06:04.760 --> 00:06:10.800 into another category, we'll do an example. For example, we'll take home here. See, 00:06:10.800 --> 00:06:15.200 I have different categories. I have a category here called home accessory, for example. 00:06:15.200 --> 00:06:19.400 Let's suppose that this home accessory category, which is currently part of home, I want 00:06:19.400 --> 00:06:26.560 to move it to the home page. So, we're going to use the right panel. There's a tutorial that 00:06:26.560 --> 00:06:33.400 already shows you all of this in detail. I won't go over it completely, but quickly. You 00:06:33.400 --> 00:06:39.520 just have to scroll down, choose the target branch, the place where you want to move the categories. 00:06:39.520 --> 00:06:44.240 So, for example, home page, I'll take home here. I'll take my home accessory category and 00:06:44.240 --> 00:06:55.280 move it with this button, this one allowing you to clone. So, I click here. 00:06:55.280 --> 00:07:01.720 It asks me to confirm the move. There, it's done. I can close my right panel 00:07:01.720 --> 00:07:08.080 here. I'll end up with my home accessory here placed at the same level as the others in 00:07:08.080 --> 00:07:15.080 the home page. And the position values, of course, have automatically refreshed. 00:07:15.080 --> 00:07:21.640 The men's accessory here is placed, just before the women's accessory. 00:07:21.640 --> 00:07:29.680 So to summarize, in the display here in the category tab you can modify the 00:07:29.680 --> 00:07:35.720 display order of the branches of the subcategories according to their name, their position, the identifier, the 00:07:35.720 --> 00:07:42.520 breadcrumb trail, therefore in a given branch. You can then click on the position button here 00:07:42.520 --> 00:07:53.560 to move your categories to modify their display in the store. And then 00:07:53.560 --> 00:07:58.360 you can finally, thanks to the right-hand panel, move categories, therefore take them out of their 00:07:58.360 --> 00:08:02.520 branch to put them in another branch or to change their 00:08:02.520 --> 00:08:08.000 default category if you prefer. So three quite different things. Now let's see what happens at the 00:08:08.000 --> 00:08:12.240 product level. So I have already deactivated my position mode in the category view and 00:08:12.240 --> 00:08:20.600 I switch to product view. So in product view, I remind you your categories, they 00:08:20.600 --> 00:08:29.080 now appear here. We are going to put a little order. There you go. So my categories appear here in 00:08:29.080 --> 00:08:33.720 the left panel in the control panel. I also remind you that this table here, 00:08:33.720 --> 00:08:38.880 this tree structure is synchronized with the category view, the table that we have here in the center when 00:08:38.880 --> 00:08:44.360 we are in category view. It's really the same thing displayed in two different places. So, 00:08:44.360 --> 00:08:49.960 So when we are in category view to display the products, nothing new. We select our 00:08:49.960 --> 00:08:56.880 branches, for example, I see all women's products in recursive mode, and I display my products. So, 00:08:56.880 --> 00:09:03.360 the display order of the products in this table on the screen in Merlin is determined in a 00:09:03.360 --> 00:09:07.280 very simple way. You don't need to go to display as we just saw for 00:09:07.280 --> 00:09:13.320 the categories. You simply have to click on the title of a column. And that's true 00:09:13.320 --> 00:09:18.680 for all the other tables. For example, if I want to order my display here according to ascending values 00:09:18.680 --> 00:09:25.800 , and of the default category name, I'll click on it. There you go. There, 00:09:25.800 --> 00:09:31.440 I have a descending order. I click again an ascending or alphabetical order according to the 00:09:31.440 --> 00:09:36.240 category name. I can do it on any column. For example, if I want to have it 00:09:36.240 --> 00:09:41.640 in ascending alphabetical order on the product name, I click here. And what you can 00:09:41.640 --> 00:09:46.160 do on one column, you can do on several columns. That is to say that you can 00:09:46.160 --> 00:09:51.760 click here on this one to have this first order, but with a control click, click on 00:09:51.760 --> 00:09:58.600 a second or even a third column to multiply the sort level. So there, I clicked 00:09:58.600 --> 00:10:03.760 on this one then this one. So in fact, it sorts first in ascending order of category. 00:10:03.760 --> 00:10:09.120 Then when we have two finally a category by this one it is three lines which is common 00:10:09.120 --> 00:10:15.520 at this time here I have an ascending or descending order according to the name of the products according 00:10:15.520 --> 00:10:20.120 to sort on this column. And that's how you can sort as I told you 00:10:20.120 --> 00:10:26.640 on as many columns as you want in a combined way. So it can sometimes happen that this 00:10:26.640 --> 00:10:31.360 action of a click on the type of a column to sort in ascending order does not give the 00:10:31.360 --> 00:10:35.040 result that you expect. Simply because it is possible that in your column you 00:10:35.040 --> 00:10:39.480 have special characters which disrupt your sort. So to show you that, I will add 00:10:39.480 --> 00:10:46.920 a column. So I go to the column configurator and I'm going to add the reference column. 00:10:46.920 --> 00:10:53.080 There you go. And we're going to sort in this order. So I click on reference and see what happens 00:10:53.080 --> 00:10:59.640 . Quite peculiar. I have demo 5 then demo-1 then demo-10 then 2 then 6 then 7. 00:10:59.640 --> 00:11:05.120 So we should have 1 then 2 then 10 for example and then words 5. Why is it at the very 00:11:05.120 --> 00:11:11.280 top? Well that comes from the fact that here I have a space while the others are dashes. 00:11:11.280 --> 00:11:17.800 And then it also comes from the fact that by default when we sort by alphabetical order, the 00:11:17.800 --> 00:11:24.360 number 10 alphabetically comes before the number 2. And yes, it's weird but that's how it is. So 00:11:24.360 --> 00:11:29.840 you have to ask it to sort by taking into account, for example, here the numerics, the numbers. In fact, 00:11:29.840 --> 00:11:33.800 you have to teach it to count. So how do we do that? Well, in any 00:11:33.800 --> 00:11:37.720 column of any table, you can define the sort modes, 00:11:37.720 --> 00:11:43.080 the sort options. So how do we do it? Well, we go to the column 00:11:43.080 --> 00:11:49.280 we want to sort on, for example, preference. Here, we right-click and in the menu, we have 00:11:49.280 --> 00:11:54.920 something called sort option and you have all the possible options. So, 00:11:54.920 --> 00:11:57.640 normally, by default, you are on the first setting here which is called 00:11:57.640 --> 00:12:02.600 default sort which does not take into account capital letters, which does not take into account numbers, 00:12:02.600 --> 00:12:07.360 nor accents, nor spaces. But here, I will ask it first, for example, 00:12:07.360 --> 00:12:13.480 to take into account with this choice here the numbers, therefore the numbers within the strings. So the 2 00:12:13.480 --> 00:12:20.880 will go before the 10. Look, I click, I have the 1, the 2 then the 10 which goes to the bottom. There, 00:12:20.880 --> 00:12:26.800 it's correct. I still have the problem of this demo 5 here with a space. So, 00:12:26.800 --> 00:12:32.760 I modify another order. I will ask it to take into account the spaces. 00:12:34.520 --> 00:12:38.320 So, it's not the right one, 00:12:38.320 --> 00:12:45.160 it's this one. There you go. So here, the 5 goes well here. I have this one left, the dimo 6. So, 00:12:45.160 --> 00:12:50.040 why does it stay at the very top? Simply because here, we have a capital D 00:12:50.040 --> 00:12:55.280 and a capital D in alphabetical order, it takes priority over the lowercase D. So 00:12:55.280 --> 00:13:01.320 You have to ask it, for example, to ignore capital letters. I check 00:13:01.320 --> 00:13:07.480 here and so I can get exactly the order I want, ignoring capital letters, 00:13:07.480 --> 00:13:14.880 ignoring spaces before, after or within strings and taking numbers into account. 00:13:14.880 --> 00:13:19.320 So to be really thorough about this sorting tool, I would just like to draw your 00:13:19.320 --> 00:13:24.880 attention to the last one here. Do not use identifiers. So what is this for? Well, 00:13:24.880 --> 00:13:31.120 it's specific for certain columns like the list columns of, how to 00:13:31.120 --> 00:13:35.800 say, suppliers or manufacturers. So, we're going to put these two columns. 00:13:35.800 --> 00:13:42.600 I don't know if I defined suppliers of manufacturers on this basis. We'll look. 00:13:42.600 --> 00:13:48.120 So, we have some but apparently there aren't many. The manufacturers here either. So, 00:13:48.120 --> 00:13:52.160 it's not very relevant in this case. Well, I won't be able to do a real demo, 00:13:52.160 --> 00:13:55.680 but I'll still explain to you how it works. In fact, these columns, 00:13:55.680 --> 00:14:00.560 when you click on their title to sort in ascending order of supplier 00:14:00.560 --> 00:14:05.160 manufacturer, in fact, it will sort in ascending order of the identifier, that is to say of the 00:14:05.160 --> 00:14:11.800 number of the supplier or manufacturer and not in ascending order of the name of the value. So 00:14:11.800 --> 00:14:16.600 if you want to change this behavior and you obtain a sort in ascending or descending alphabetical order 00:14:16.600 --> 00:14:23.160 on the supplier or manufacturer column from the name, well 00:14:23.160 --> 00:14:29.000 in the sorting options you must check not to use identifiers. So everything I just 00:14:29.000 --> 00:14:33.960 showed you reorders the products displayed in Merlin but only in Merlin. It has no 00:14:33.960 --> 00:14:39.520 impact at all on the display of Prestashop. What determines the display in Prestashop 00:14:39.520 --> 00:14:45.440 is like for categories, it is the value of each product in the column or the 00:14:45.440 --> 00:14:54.320 position section. And this position value of each product and the functions of each category. 00:14:54.320 --> 00:15:00.520 That is to say, a product will have a given position in a given category in which it 00:15:00.520 --> 00:15:05.560 is associated, it will have the same or another position value in another category. 00:15:05.560 --> 00:15:10.560 So we really work category by category when it comes to adjusting the 00:15:10.560 --> 00:15:15.440 position of products. So how do we do that in Merlin? Well, it's a bit like 00:15:15.440 --> 00:15:21.240 in Presta category, excuse me, in the category view of Merlin which was called Presta 00:15:21.240 --> 00:15:30.960 Category before. In fact, you have a button here position. So when I click on this button, 00:15:30.960 --> 00:15:34.240 you have a window that appears, I'll show it in a moment. 00:15:34.240 --> 00:15:39.680 And then, uh, a warning or rather an instruction. Uh, Merlin tells us that it must 00:15:39.680 --> 00:15:44.640 automatically reconfigure the interface in order to choose the right columns 00:15:44.640 --> 00:15:50.200 and make certain adjustments necessary for using the position tool. So I 00:15:50.200 --> 00:15:59.520 'm going to ask it to do that. So it refreshes my display and tells me that it's finished. 00:16:01.760 --> 00:16:08.560 And here, I have my position adjustment window. So what did Merlin do? In fact, it 00:16:08.560 --> 00:16:14.360 redisplayed the products to me, but as you can see, it went into a particular mode 00:16:14.360 --> 00:16:21.000 where for each of the selected categories, in fact, it created a group showing me all the 00:16:21.000 --> 00:16:30.080 products associated with these different categories. And so I have my products here, let's say classified or 00:16:30.080 --> 00:16:36.600 I don't know how to say grouped by associated category. So if I want to modify, uh, the order 00:16:36.600 --> 00:16:41.760 of the products in a given category, well, I go into this group here, for example, category 00:16:41.760 --> 00:16:47.720 4, and I will be able to modify my positions here. You can also see in each of these groups 00:16:47.720 --> 00:16:53.960 the products have been reorganized alphabetically, sorry, by ascending position value. 00:16:54.960 --> 00:16:59.160 And as I was saying, some products, you will find them several times. So, 00:16:59.160 --> 00:17:03.760 try to find an example. There you go. For example, this one, product 5 here, actually, it 00:17:03.760 --> 00:17:11.680 's associated with my category 11, but it's also associated here with my category 3. And in each of 00:17:11.680 --> 00:17:17.920 these two categories, it has a different position value. Here, it's in 3rd position, or more 00:17:17.920 --> 00:17:26.320 precisely 4th since we always start with zero in 4th position. And here, it's in position one or 00:17:26.320 --> 00:17:34.120 0 when we talk about value. And so we can now reorder our products. So 00:17:34.120 --> 00:17:42.360 how does it work? In fact, this button or this position button or this position window 00:17:42.360 --> 00:17:49.320 allows you to reorder the products in different ways, either by a simple drag and drop. 00:17:50.200 --> 00:17:56.280 So for that, this is what we call the manual method which is explained here. And it's 00:17:56.280 --> 00:18:02.640 like for the categories. I take my product, for example this one and I move it. If I 00:18:02.640 --> 00:18:10.320 put it here at the top, there you go, my product has moved to the first position on the display. 00:18:10.320 --> 00:18:18.760 Here, if I take this one, I move it, it goes here. So there, I have a change in 00:18:18.760 --> 00:18:24.240 the display of the products in my block on the screen. Note, however, that this has not yet modified 00:18:24.240 --> 00:18:29.360 the position value. It has not recalculated it. It's just a drag and drop on the screen. 00:18:30.200 --> 00:18:35.400 or second way, what we call sorting by column. So that corresponds exactly to what 00:18:35.400 --> 00:18:40.920 I showed you before, that is to say, I click on any of the columns, for 00:18:40.920 --> 00:18:47.920 example the name. And at that point, I have my rows here which are reordered in 00:18:47.920 --> 00:18:54.040 ascending or descending alphabetical order according to the names. Or for example, I can click on reference as 00:18:54.040 --> 00:18:59.040 I showed you just before to sort in ascending order of the reference crescents. 00:19:00.600 --> 00:19:07.160 There you go. So already two ways to reorder the products in their category when displayed. 00:19:07.160 --> 00:19:12.280 Then once that's done, in fact, we're going to use this interface to automatically 00:19:12.280 --> 00:19:18.480 recalculate the position values ​​here to respect the order we obtained on the screen. 00:19:19.280 --> 00:19:24.840 So for that, we move on to step 2, sorry, step 3. So there, currently, I showed you 00:19:24.840 --> 00:19:32.440 step 2, eh, the manual method or by sorting. So step 3, I select the products for 00:19:32.440 --> 00:19:37.440 which I want to obtain an automatic calculation of the position value. So, it can be either 00:19:37.440 --> 00:19:43.920 all my rows. So, I can click here on select all. It will do this on all the 00:19:43.920 --> 00:19:48.520 products in all the categories. Okay, why not? Well, I only want to work on this block 00:19:48.520 --> 00:19:54.720 . So I can either manually select these three products, or also click on this little 00:19:54.720 --> 00:20:00.680 button here. You see the little rectangle that will automatically select the three products 00:20:00.680 --> 00:20:05.960 in this block. And so once my selection is made, I will ask it to do 00:20:05.960 --> 00:20:12.640 this incremental calculation here. Now, this is not very relevant as an exercise because it is already 00:20:12.640 --> 00:20:16.720 classified. So I will ask it to sort by something else. I will sort for example by name. 00:20:18.160 --> 00:20:22.040 It's the same maybe by category. No, I will get something. So what I 00:20:22.040 --> 00:20:26.160 will do, I will move by hand as I just showed you. There, I would like 00:20:26.160 --> 00:20:32.480 it to sort the products like this. So I reselect them. Once again, my goal is 00:20:32.480 --> 00:20:42.040 to get 0, 1 and 2 here. So my products are selected. I go to step 4. Here I can 00:20:42.040 --> 00:20:47.360 enter the value I want to give to the first line of my selection. So by default 00:20:47.360 --> 00:20:52.040 it's zero but it can be something else because I can very well at a given moment select 00:20:52.040 --> 00:20:56.600 only two lines this one and this one and ask it here to start counting from 00:20:56.600 --> 00:21:02.000 10. It's entirely possible. I'm going back to the basic explanation again. Most of the time, 00:21:02.000 --> 00:21:08.600 you will select your three lines, in all your lines and you will start with the value zero. 00:21:09.160 --> 00:21:16.800 Then when it's done, you apply. At that moment, you will see here the positions 00:21:16.800 --> 00:21:22.680 have been recalculated and I can close or continue working on another block if 00:21:22.680 --> 00:21:31.720 I wish. In fact, what is the point of this tool? Well, it's to be able to reorder 00:21:31.720 --> 00:21:35.480 in store, eh, I mean in store on Prestashop. So that is to say recalculate 00:21:35.480 --> 00:21:41.760 the value of the positions by playing on the order of display on the screen in Merlin. In particular, 00:21:41.760 --> 00:21:47.040 by clicking on one or more columns to organize your display in the order 00:21:47.040 --> 00:21:51.640 you want. This way, you can achieve quite sophisticated, quite complex sorting 00:21:51.640 --> 00:21:58.640 in just a few clicks. There you go. So I'll give you a little summary. Perhaps 00:21:58.640 --> 00:22:03.680 that I was a bit long but so basically we open this window with the position button. 00:22:04.840 --> 00:22:09.640 We visually order the products on the screen, either by using the 00:22:09.640 --> 00:22:15.080 column sorting method, that is to say by clicking on column titles, possibly, 00:22:15.080 --> 00:22:19.880 as I showed you earlier by also acting on the sorting options, eh, 00:22:19.880 --> 00:22:25.000 by right-clicking and to obtain a sort taking into account spaces or ignoring spaces, 00:22:25.000 --> 00:22:31.400 capital letters, numbers and so on. or we sort manually by dragging and dropping 00:22:31.400 --> 00:22:37.720 the lines. Then, we select either all the products, or only those 00:22:37.720 --> 00:22:43.480 for which we want to have a recalculation of the position value. Then, we choose the 00:22:43.480 --> 00:22:48.720 value of the first selected line. In principle, it is the value zero, but it can 00:22:48.720 --> 00:22:55.920 be something else. And we apply to obtain a recalculation of these position values ​​on 00:22:55.920 --> 00:23:02.920 all the selected lines. And then when it is finished, well we close the window. 00:23:02.920 --> 00:23:06.920 So, this position column or this position section exists in other places in the 00:23:06.920 --> 00:23:13.200 Prestashop database. You have it in particular in the characteristics step. So when we 00:23:13.200 --> 00:23:18.160 display the characteristics here, uh so you have a position column at the level of the 00:23:18.160 --> 00:23:24.000 characteristics names and I think from memory, I'm not sure no you don't have it at the level of the values, 00:23:24.000 --> 00:23:29.120 I think it's at the level of the attributes. So I go to image variation in the 00:23:29.120 --> 00:23:34.200 attribute tab, I display my attributes. And here, you see, you also have a position column 00:23:34.200 --> 00:23:41.800 on the values ​​of the attributes of your different attribute groups. And I think that's it, 00:23:41.800 --> 00:23:45.080 that's it. You also have it at the level of the name, finally what we call the 00:23:45.080 --> 00:23:49.920 attribute group itself. You also have the possibility of defining your positions. So, 00:23:49.920 --> 00:23:56.880 in these tables uh the management of this order is very very easy. You just have to 00:23:56.880 --> 00:24:05.240 click on the title of the column and then uh drag and drop uh your positions 00:24:05.240 --> 00:24:11.080 like this. Okay? And so there, you get a different order, recalculated on all the lines, 00:24:11.080 --> 00:24:17.720 which will reflect the display order in the store. So the same here on the 00:24:17.720 --> 00:24:25.360 position column of the list of values ​​and also at the characteristics level. 00:24:26.080 --> 00:24:31.240 On the characteristics. In the tutorial talking about the characteristics tab, I 00:24:31.240 --> 00:24:40.000 gave you a fairly detailed exercise on how to use Magic Edit. So I remind you, 00:24:40.000 --> 00:24:46.440 Magic Edit is a tool that you get with the right click, it's this one. And in Magic Edit, 00:24:46.440 --> 00:24:53.440 you have different functions. So in Magic Edit, you can use the counter here, 00:24:53.440 --> 00:24:59.480 what we call the index. to fill lines from numbers with 00:24:59.480 --> 00:25:06.480 numbers counted one by one or by things like that. So we can use this tool here for automatic 00:25:06.480 --> 00:25:15.440 calculation line filling to fill these values ​​here on several lines 00:25:15.440 --> 00:25:20.960 in the position columns. So the idea is, for example, to sort in 00:25:20.960 --> 00:25:26.400 ascending alphabetical order of the characteristics. So by clicking here on the title. So here I 00:25:26.400 --> 00:25:33.440 am in ascending alphabetical order. My order here doesn't necessarily match. See, the 8 is there. 00:25:33.440 --> 00:25:39.600 I select all my rows. I use Magic Elite. So I launch 00:25:39.600 --> 00:25:44.560 Magic Elite in the entire column and I ask it two things: complete deletion of the 00:25:44.560 --> 00:25:53.920 content and to count from, let's say, 1, a 1 by 1, possibly with a reset 00:25:53.920 --> 00:25:59.240 after a break if you have breaks in your table. I apply and I save. 00:25:59.880 --> 00:26:05.320 And there, I have, you see, my positions which have been recalculated from 1 to 8 in ascending 00:26:05.320 --> 00:26:09.840 alphabetical order. So you can use that on this table here. You can also use it, 00:26:09.840 --> 00:26:16.160 so I was thinking about the attribute tables in this column or in this one. 00:26:17.200 --> 00:26:21.680 Note that it is very common that in the columns of attribute groups or attribute values 00:26:21.680 --> 00:26:28.120 ​​or even characteristic values, we use a mixture of capital letters, spaces, 00:26:28.120 --> 00:26:34.440 numbers, etc., and when we want to sort in ascending order of these values, we don't get 00:26:34.440 --> 00:26:38.600 always the result you want. Well, it's like just now, if you 00:26:38.600 --> 00:26:42.560 right-click in this column, in the menu you have here, then you don't see it, it's a 00:26:42.560 --> 00:26:47.480 little lower down, but so in this type of menu, on all these columns, you have the same function 00:26:47.480 --> 00:26:53.000 here, sort option, which allows you to activate or deactivate taking into account the accents of the 00:26:53.000 --> 00:26:58.360 capital letters, take into account the numbers and so on in your sorting. So that's very practical here 00:26:58.360 --> 00:27:04.080 on these columns to really sort your values ​​according to the order you want before using 00:27:04.080 --> 00:27:12.200 Magic Edit to automatically fill with an index that will count from 0 to x in the 00:27:12.200 --> 00:27:20.880 position column. So just now when we used the position function here, 00:27:20.880 --> 00:27:29.800 remember uh automatically, I'm going to do it again, Merlin added separators 00:27:29.800 --> 00:27:34.960 here. These famous orange lines there, these are what we also call breaks. In fact, 00:27:34.960 --> 00:27:39.440 breaks are lines that are added that allow you to group 00:27:39.440 --> 00:27:47.240 products by common value. Here, they are grouped by common associated category. 00:27:47.240 --> 00:27:52.120 Well, you should know that you can finally define breaks like that in 00:27:52.120 --> 00:27:58.200 your tables on one or more levels. So, it's not quite what we call a sort, 00:27:58.200 --> 00:28:03.040 but it does allow you to display or group products in the way you 00:28:03.040 --> 00:28:08.880 want. So, I'm going to show you some examples. So, we're going to make a little space. 00:28:10.800 --> 00:28:16.840 So I asked it to group me or set up a break by category. 00:28:16.840 --> 00:28:20.280 A bit like when you click on the position button. At that point, 00:28:20.280 --> 00:28:26.520 I go to my category column anywhere. I right-click and ask it to add 00:28:26.520 --> 00:28:32.400 a break. So you can either add breaks, or delete a break in 00:28:32.400 --> 00:28:38.120 a list, or delete all breaks. There you go, I add a break and you see, 00:28:38.120 --> 00:28:43.240 I actually have a grouping of my products, of my three or more categories 00:28:43.240 --> 00:28:51.000 here grouped by main category. So I have two products in my default category. 00:28:51.640 --> 00:28:55.720 And know that you can add as many levels as you want. So if for example you 00:28:55.720 --> 00:29:02.920 had in the category here products from different suppliers, for example this one, uh, 00:29:02.920 --> 00:29:07.400 it doesn't have a supplier and this one does. Well, you put in this supplier column, 00:29:07.400 --> 00:29:12.560 right-click, add a break again on this column and I get a second 00:29:12.560 --> 00:29:20.480 level. So here, you see for example in my summer dress category and well, I have two 00:29:20.480 --> 00:29:31.120 groupings. First grouping with one product, second grouping here with two products. 00:29:31.120 --> 00:29:37.840 There you go. And you can reject again and again endlessly. So a fairly simple way to group your 00:29:37.840 --> 00:29:45.440 products, to structure your displays by adding breaks. Also note that when there are 00:29:45.440 --> 00:29:50.920 a lot of breaks in a table, especially when there are a lot of lines, 00:29:50.920 --> 00:29:57.200 in the elevator here, the elevator with the orange bar here, markers will appear that 00:29:57.200 --> 00:30:02.160 will show you where your different breaks are located throughout the height of the table. 00:30:02.160 --> 00:30:06.880 And by clicking on these little brown markers, eh, the same color as break, you can 00:30:06.880 --> 00:30:12.320 quickly move from one block to another. So that's also quite practical, uh, for 00:30:12.320 --> 00:30:17.720 quickly navigating through a large list of lines. And as I was saying, you can of course delete 00:30:17.720 --> 00:30:23.000 the breaks that you have set up. Just right-click and either delete 00:30:23.000 --> 00:30:27.960 the break you want, or delete them all. Here, I'm going to first delete, for example, the 00:30:27.960 --> 00:30:32.440 second supplier. More directly, I'm going to delete the first to show you that 00:30:32.440 --> 00:30:37.840 the second will remain, but it will become the first-level break. There you go, I'm 00:30:37.840 --> 00:30:44.840 more than grouped by supplier. So another view, another way to order your products. And 00:30:44.840 --> 00:30:50.520 lastly, delete all the breaks. At this point, I return to the default display. 00:30:51.040 --> 00:30:53.800 So this type of break, you have it of course in the product table, 00:30:53.800 --> 00:31:04.600 but in almost all tables. Uh for example, if I return to my characteristic, 00:31:04.600 --> 00:31:08.680 Here, you see, I had selected all my characteristics. So here, I have all the 00:31:08.680 --> 00:31:14.400 characteristic values. It's a bit messy. I can go to the name column, 00:31:14.400 --> 00:31:21.440 which actually contains the name of the characteristic. Right-click. Add a break, and at that point, 00:31:21.440 --> 00:31:27.800 I have a much cleaner classification of my characteristic values. It's 00:31:27.800 --> 00:31:35.240 also good to know these famous breaks, they are memorized in your column settings, 00:31:35.240 --> 00:31:39.440 configuration if you prefer. For example, here, so you see, I'm in mode finally, 00:31:39.440 --> 00:31:44.200 I created a configuration called basic repair. I'm going to put my break back 00:31:44.200 --> 00:31:53.040 on my category column. Well, if I go to another view or another configuration here by 00:31:53.040 --> 00:31:59.560 tag and keyword, you see, I no longer have my break on my category column. I could very well 00:31:59.560 --> 00:32:06.040 put it on another column, for example the list of tags here. There you go. So here, 00:32:06.040 --> 00:32:11.960 I have my products grouped according to their tag. When I go through, I go back more precisely 00:32:11.960 --> 00:32:19.800 to my previous setting, repair base, and well you'll see how I'm going to find, 00:32:19.800 --> 00:32:27.600 you see my break on my ID column, finally category name. And that's also true for 00:32:27.600 --> 00:32:33.800 the famous sorting there, eh, the fact of clicking on the column titles to sort your products. That 00:32:33.800 --> 00:32:40.360 too is memorized in your column configuration. So with all these tools, uh mixed together, 00:32:40.360 --> 00:32:45.360 you have plenty of ways to really create very personalized views of your different 00:32:45.360 --> 00:32:49.880 tables depending on the type of work you want to do. These are not very 00:32:49.880 --> 00:32:54.960 well-known functions. Uh every time I take control remotely on your configurations, it's very rare 00:32:54.960 --> 00:32:59.320 that I see people use these breaks. And yet, I assure you that when I 00:32:59.320 --> 00:33:04.840 work on my database, I really abuse it because it's really very, very practical when 00:33:04.840 --> 00:33:10.200 you're used to working with it. The one I certainly use the most is at the 00:33:10.200 --> 00:33:15.680 level of the variations table. Uh when we display the variations of several 00:33:15.680 --> 00:33:21.080 products. So that's what I do here. See here, everything is in bulk. So I don't like that at all. 00:33:21.080 --> 00:33:28.880 Almost systematically, I set up a break here on sorry here on the name of the 00:33:28.880 --> 00:33:35.400 product. There you go. And like this, I really have here the easy way to 00:33:35.400 --> 00:33:42.520 quickly find the variations of this or that product. By default, I have the name which is displayed here in the break. Uh 00:33:42.520 --> 00:33:48.160 I didn't say it, you can also delete your breaks here with the little trash can. Uh and of 00:33:48.160 --> 00:33:52.360 course, I showed you this earlier in the tutorial on positions, you can click on 00:33:52.360 --> 00:33:57.640 this type of button here, the little rectangle to select all the lines uh of a block at 00:33:57.640 --> 00:34:05.240 once without selecting the lines of the other blocks, eh. There you go. And then here is the 00:34:05.240 --> 00:34:09.600 trash can, I'm going to show you how to quickly delete the breaks directly in your 00:34:09.600 --> 00:34:16.560 tables. So, there is another tool which is very practical and complementary to this notion of sorting. 00:34:16.560 --> 00:34:23.400 position and break, these are the filters, the column threads. Right-click here, filter 00:34:23.400 --> 00:34:29.240 on this column or then select filtered on this column which is our sort type or even 00:34:29.240 --> 00:34:35.480 the pre-filters. And so to not overload this tutorial too much, I will do another tutorial dedicated to these 00:34:35.480 --> 00:34:41.640 pre-filters, these filters. That's it for this tutorial. Thank you and see you soon for another tutorial.