Hello, this is Franck from Sitolog. I'm going to talk to you today about the concept of position or
order. So, there are two types of position or order. There are the display orders of lines
in Merlin and there is the display order of objects like categories or products in
Prestashop. So two different concepts and we're going to cover both. So, I'm going to start with the
categories and at the category level already, I'm going to talk to you about the concept of display order
in Merlin. So, in Merlin, the categories are necessarily displayed by structure,
finally in the form of a structure, that is to say we have the root, the home page, then we unfold the
categories like this. So the categories or subcategories of a category are necessarily
in the tree structure, in this structure, eh. I can't ask it to display me, for example,
this category here at the top, at the very bottom when it's in the women's structure which is here at the top,
eh. Well, they must be part of this branch. On the other hand, in a given branch, for example
in the home branch, all these categories here that are at the same level, eh, they are
four categories or subcategories of home. Well, I can ask it to display them in
a different order. Currently, they are displayed, you don't necessarily see it, but in
ascending order of memory of this value here that we call NLT or the Arian thread.
Well, we can ask it to display the categories differently, for example in
ascending or alphabetical order according to their name. So for that, it happens in the control panel.
You have to go to display, eh. So I remind you, control panel,
you have the categories when you are in product view, the stores, then the display,
then other drawers below. And so in display, you have different tabs here,
product, variation and category. And in the category tab, here you have the choice
of the display order of the categories or the category branches. So as I was telling you,
it's currently by then not by Arian's thread, I made a mistake. Currently,
it's sorted by ascending ID indeed 1 2 3 12 40 55 but I can
ask it for example to sort them by name. I click on name. This one, you have to refresh. So,
I'm going to do it but before that, I'm going to point out to you. So, see, women's accessories
here are at the very bottom. So I refresh, I click and this time women's accessories are at the top eh
because I broke it in alphabetical order according to this column. So I modified the
display order of the categories on the screen but this does not at all reflect the display order of the
categories in your back office or in the store. What will determine these display orders in the
store or in the Prestashop administration is the value of the position column that you
see here. In fact, in Prestashop for quite a few things, categories, products,
features and other things. Well, these elements have a position and
it's this position value that determines the display order. And so how do we modify
these position values? Well, quite simple. We're going to do it by dragging and dropping. So,
if I try to take a category like this here and move it, it doesn't work
by default. You see, what it actually does is select other rows. So that's
intentional, it's to be able to quickly select several categories. So how
do we drag and drop to reorder the rows? Well,
first, you have to click on the position button here. So, I click on the position button.
So, Merlin warns me that to be able to do that, it needs to change some settings.
It first needs to sort the categories by ascending position. So an order according to these
values, precisely. And it also needs in case you have multiple stores to limit the list
of categories displayed to that of the stores selected in the control tab.
So I tell it to do it for me. So it will refresh the list. There,
I can scroll down and I end up with not quite the same display as before
. See, women's accessories have gone back to the bottom. Simply because, as indicated,
it has restarted the display of categories according to increasing position values. Well, now
that I'm in position mode, which is indicated to me here by the orange color of the button, well, I
can move my categories. For example, I can say that promotion here, I simply take it
and move it where I want. You see, this time, I don't have a sliding selection
of categories but really a placement or a movement. For example, I'm going to put promotion
here first in the home page. There you go. So on my store, the categories will be displayed
as they are there. You see, when I released the mouse, it recalculated the values
​​in the position column. Not just on the promotion category that I moved,
but also on the others, eh. So it remains consistent across the entire tree structure. And of course, what
I just did here you can do on multiple categories at once, or even branches.
For example, here I can take the women's branch to what I call a branch and a category with
these subcategories. So I take the women's branch, I take the men's branch with a control
click or a shift click and I move them both. And this time, I'm going to put them right
there. And so, you see, women and men go back above promotion. Now, be careful,
what I just showed you allows you to change the display order of the categories, of course,
but it doesn't allow you to move categories, to modify the structure or the tree structure. That
's something different. So I remind you if you want to move a category
into another category, we'll do an example. For example, we'll take home here. See,
I have different categories. I have a category here called home accessory, for example.
Let's suppose that this home accessory category, which is currently part of home, I want
to move it to the home page. So, we're going to use the right panel. There's a tutorial that
already shows you all of this in detail. I won't go over it completely, but quickly. You
just have to scroll down, choose the target branch, the place where you want to move the categories.
So, for example, home page, I'll take home here. I'll take my home accessory category and
move it with this button, this one allowing you to clone. So, I click here.
It asks me to confirm the move. There, it's done. I can close my right panel
here. I'll end up with my home accessory here placed at the same level as the others in
the home page. And the position values, of course, have automatically refreshed.
The men's accessory here is placed, just before the women's accessory.
So to summarize, in the display here in the category tab you can modify the
display order of the branches of the subcategories according to their name, their position, the identifier, the
breadcrumb trail, therefore in a given branch. You can then click on the position button here
to move your categories to modify their display in the store. And then
you can finally, thanks to the right-hand panel, move categories, therefore take them out of their
branch to put them in another branch or to change their
default category if you prefer. So three quite different things. Now let's see what happens at the
product level. So I have already deactivated my position mode in the category view and
I switch to product view. So in product view, I remind you your categories, they
now appear here. We are going to put a little order. There you go. So my categories appear here in
the left panel in the control panel. I also remind you that this table here,
this tree structure is synchronized with the category view, the table that we have here in the center when
we are in category view. It's really the same thing displayed in two different places. So,
So when we are in category view to display the products, nothing new. We select our
branches, for example, I see all women's products in recursive mode, and I display my products. So,
the display order of the products in this table on the screen in Merlin is determined in a
very simple way. You don't need to go to display as we just saw for
the categories. You simply have to click on the title of a column. And that's true
for all the other tables. For example, if I want to order my display here according to ascending values
, and of the default category name, I'll click on it. There you go. There,
I have a descending order. I click again an ascending or alphabetical order according to the
category name. I can do it on any column. For example, if I want to have it
in ascending alphabetical order on the product name, I click here. And what you can
do on one column, you can do on several columns. That is to say that you can
click here on this one to have this first order, but with a control click, click on
a second or even a third column to multiply the sort level. So there, I clicked
on this one then this one. So in fact, it sorts first in ascending order of category.
Then when we have two finally a category by this one it is three lines which is common
at this time here I have an ascending or descending order according to the name of the products according
to sort on this column. And that's how you can sort as I told you
on as many columns as you want in a combined way. So it can sometimes happen that this
action of a click on the type of a column to sort in ascending order does not give the
result that you expect. Simply because it is possible that in your column you
have special characters which disrupt your sort. So to show you that, I will add
a column. So I go to the column configurator and I'm going to add the reference column.
There you go. And we're going to sort in this order. So I click on reference and see what happens
. Quite peculiar. I have demo 5 then demo-1 then demo-10 then 2 then 6 then 7.
So we should have 1 then 2 then 10 for example and then words 5. Why is it at the very
top? Well that comes from the fact that here I have a space while the others are dashes.
And then it also comes from the fact that by default when we sort by alphabetical order, the
number 10 alphabetically comes before the number 2. And yes, it's weird but that's how it is. So
you have to ask it to sort by taking into account, for example, here the numerics, the numbers. In fact,
you have to teach it to count. So how do we do that? Well, in any
column of any table, you can define the sort modes,
the sort options. So how do we do it? Well, we go to the column
we want to sort on, for example, preference. Here, we right-click and in the menu, we have
something called sort option and you have all the possible options. So,
normally, by default, you are on the first setting here which is called
default sort which does not take into account capital letters, which does not take into account numbers,
nor accents, nor spaces. But here, I will ask it first, for example,
to take into account with this choice here the numbers, therefore the numbers within the strings. So the 2
will go before the 10. Look, I click, I have the 1, the 2 then the 10 which goes to the bottom. There,
it's correct. I still have the problem of this demo 5 here with a space. So,
I modify another order. I will ask it to take into account the spaces.
So, it's not the right one,
it's this one. There you go. So here, the 5 goes well here. I have this one left, the dimo 6. So,
why does it stay at the very top? Simply because here, we have a capital D
and a capital D in alphabetical order, it takes priority over the lowercase D. So
You have to ask it, for example, to ignore capital letters. I check
here and so I can get exactly the order I want, ignoring capital letters,
ignoring spaces before, after or within strings and taking numbers into account.
So to be really thorough about this sorting tool, I would just like to draw your
attention to the last one here. Do not use identifiers. So what is this for? Well,
it's specific for certain columns like the list columns of, how to
say, suppliers or manufacturers. So, we're going to put these two columns.
I don't know if I defined suppliers of manufacturers on this basis. We'll look.
So, we have some but apparently there aren't many. The manufacturers here either. So,
it's not very relevant in this case. Well, I won't be able to do a real demo,
but I'll still explain to you how it works. In fact, these columns,
when you click on their title to sort in ascending order of supplier
manufacturer, in fact, it will sort in ascending order of the identifier, that is to say of the
number of the supplier or manufacturer and not in ascending order of the name of the value. So
if you want to change this behavior and you obtain a sort in ascending or descending alphabetical order
on the supplier or manufacturer column from the name, well
in the sorting options you must check not to use identifiers. So everything I just
showed you reorders the products displayed in Merlin but only in Merlin. It has no
impact at all on the display of Prestashop. What determines the display in Prestashop
is like for categories, it is the value of each product in the column or the
position section. And this position value of each product and the functions of each category.
That is to say, a product will have a given position in a given category in which it
is associated, it will have the same or another position value in another category.
So we really work category by category when it comes to adjusting the
position of products. So how do we do that in Merlin? Well, it's a bit like
in Presta category, excuse me, in the category view of Merlin which was called Presta
Category before. In fact, you have a button here position. So when I click on this button,
you have a window that appears, I'll show it in a moment.
And then, uh, a warning or rather an instruction. Uh, Merlin tells us that it must
automatically reconfigure the interface in order to choose the right columns
and make certain adjustments necessary for using the position tool. So I
'm going to ask it to do that. So it refreshes my display and tells me that it's finished.
And here, I have my position adjustment window. So what did Merlin do? In fact, it
redisplayed the products to me, but as you can see, it went into a particular mode
where for each of the selected categories, in fact, it created a group showing me all the
products associated with these different categories. And so I have my products here, let's say classified or
I don't know how to say grouped by associated category. So if I want to modify, uh, the order
of the products in a given category, well, I go into this group here, for example, category
4, and I will be able to modify my positions here. You can also see in each of these groups
the products have been reorganized alphabetically, sorry, by ascending position value.
And as I was saying, some products, you will find them several times. So,
try to find an example. There you go. For example, this one, product 5 here, actually, it
's associated with my category 11, but it's also associated here with my category 3. And in each of
these two categories, it has a different position value. Here, it's in 3rd position, or more
precisely 4th since we always start with zero in 4th position. And here, it's in position one or
0 when we talk about value. And so we can now reorder our products. So
how does it work? In fact, this button or this position button or this position window
allows you to reorder the products in different ways, either by a simple drag and drop.
So for that, this is what we call the manual method which is explained here. And it's
like for the categories. I take my product, for example this one and I move it. If I
put it here at the top, there you go, my product has moved to the first position on the display.
Here, if I take this one, I move it, it goes here. So there, I have a change in
the display of the products in my block on the screen. Note, however, that this has not yet modified
the position value. It has not recalculated it. It's just a drag and drop on the screen.
or second way, what we call sorting by column. So that corresponds exactly to what
I showed you before, that is to say, I click on any of the columns, for
example the name. And at that point, I have my rows here which are reordered in
ascending or descending alphabetical order according to the names. Or for example, I can click on reference as
I showed you just before to sort in ascending order of the reference crescents.
There you go. So already two ways to reorder the products in their category when displayed.
Then once that's done, in fact, we're going to use this interface to automatically
recalculate the position values ​​here to respect the order we obtained on the screen.
So for that, we move on to step 2, sorry, step 3. So there, currently, I showed you
step 2, eh, the manual method or by sorting. So step 3, I select the products for
which I want to obtain an automatic calculation of the position value. So, it can be either
all my rows. So, I can click here on select all. It will do this on all the
products in all the categories. Okay, why not? Well, I only want to work on this block
. So I can either manually select these three products, or also click on this little
button here. You see the little rectangle that will automatically select the three products
in this block. And so once my selection is made, I will ask it to do
this incremental calculation here. Now, this is not very relevant as an exercise because it is already
classified. So I will ask it to sort by something else. I will sort for example by name.
It's the same maybe by category. No, I will get something. So what I
will do, I will move by hand as I just showed you. There, I would like
it to sort the products like this. So I reselect them. Once again, my goal is
to get 0, 1 and 2 here. So my products are selected. I go to step 4. Here I can
enter the value I want to give to the first line of my selection. So by default
it's zero but it can be something else because I can very well at a given moment select
only two lines this one and this one and ask it here to start counting from
10. It's entirely possible. I'm going back to the basic explanation again. Most of the time,
you will select your three lines, in all your lines and you will start with the value zero.
Then when it's done, you apply. At that moment, you will see here the positions
have been recalculated and I can close or continue working on another block if
I wish. In fact, what is the point of this tool? Well, it's to be able to reorder
in store, eh, I mean in store on Prestashop. So that is to say recalculate
the value of the positions by playing on the order of display on the screen in Merlin. In particular,
by clicking on one or more columns to organize your display in the order
you want. This way, you can achieve quite sophisticated, quite complex sorting
in just a few clicks. There you go. So I'll give you a little summary. Perhaps
that I was a bit long but so basically we open this window with the position button.
We visually order the products on the screen, either by using the
column sorting method, that is to say by clicking on column titles, possibly,
as I showed you earlier by also acting on the sorting options, eh,
by right-clicking and to obtain a sort taking into account spaces or ignoring spaces,
capital letters, numbers and so on. or we sort manually by dragging and dropping
the lines. Then, we select either all the products, or only those
for which we want to have a recalculation of the position value. Then, we choose the
value of the first selected line. In principle, it is the value zero, but it can
be something else. And we apply to obtain a recalculation of these position values ​​on
all the selected lines. And then when it is finished, well we close the window.
So, this position column or this position section exists in other places in the
Prestashop database. You have it in particular in the characteristics step. So when we
display the characteristics here, uh so you have a position column at the level of the
characteristics names and I think from memory, I'm not sure no you don't have it at the level of the values,
I think it's at the level of the attributes. So I go to image variation in the
attribute tab, I display my attributes. And here, you see, you also have a position column
on the values ​​of the attributes of your different attribute groups. And I think that's it,
that's it. You also have it at the level of the name, finally what we call the
attribute group itself. You also have the possibility of defining your positions. So,
in these tables uh the management of this order is very very easy. You just have to
click on the title of the column and then uh drag and drop uh your positions
like this. Okay? And so there, you get a different order, recalculated on all the lines,
which will reflect the display order in the store. So the same here on the
position column of the list of values ​​and also at the characteristics level.
On the characteristics. In the tutorial talking about the characteristics tab, I
gave you a fairly detailed exercise on how to use Magic Edit. So I remind you,
Magic Edit is a tool that you get with the right click, it's this one. And in Magic Edit,
you have different functions. So in Magic Edit, you can use the counter here,
what we call the index. to fill lines from numbers with
numbers counted one by one or by things like that. So we can use this tool here for automatic
calculation line filling to fill these values ​​here on several lines
in the position columns. So the idea is, for example, to sort in
ascending alphabetical order of the characteristics. So by clicking here on the title. So here I
am in ascending alphabetical order. My order here doesn't necessarily match. See, the 8 is there.
I select all my rows. I use Magic Elite. So I launch
Magic Elite in the entire column and I ask it two things: complete deletion of the
content and to count from, let's say, 1, a 1 by 1, possibly with a reset
after a break if you have breaks in your table. I apply and I save.
And there, I have, you see, my positions which have been recalculated from 1 to 8 in ascending
alphabetical order. So you can use that on this table here. You can also use it,
so I was thinking about the attribute tables in this column or in this one.
Note that it is very common that in the columns of attribute groups or attribute values
​​or even characteristic values, we use a mixture of capital letters, spaces,
numbers, etc., and when we want to sort in ascending order of these values, we don't get
always the result you want. Well, it's like just now, if you
right-click in this column, in the menu you have here, then you don't see it, it's a
little lower down, but so in this type of menu, on all these columns, you have the same function
here, sort option, which allows you to activate or deactivate taking into account the accents of the
capital letters, take into account the numbers and so on in your sorting. So that's very practical here
on these columns to really sort your values ​​according to the order you want before using
Magic Edit to automatically fill with an index that will count from 0 to x in the
position column. So just now when we used the position function here,
remember uh automatically, I'm going to do it again, Merlin added separators
here. These famous orange lines there, these are what we also call breaks. In fact,
breaks are lines that are added that allow you to group
products by common value. Here, they are grouped by common associated category.
Well, you should know that you can finally define breaks like that in
your tables on one or more levels. So, it's not quite what we call a sort,
but it does allow you to display or group products in the way you
want. So, I'm going to show you some examples. So, we're going to make a little space.
So I asked it to group me or set up a break by category.
A bit like when you click on the position button. At that point,
I go to my category column anywhere. I right-click and ask it to add
a break. So you can either add breaks, or delete a break in
a list, or delete all breaks. There you go, I add a break and you see,
I actually have a grouping of my products, of my three or more categories
here grouped by main category. So I have two products in my default category.
And know that you can add as many levels as you want. So if for example you
had in the category here products from different suppliers, for example this one, uh,
it doesn't have a supplier and this one does. Well, you put in this supplier column,
right-click, add a break again on this column and I get a second
level. So here, you see for example in my summer dress category and well, I have two
groupings. First grouping with one product, second grouping here with two products.
There you go. And you can reject again and again endlessly. So a fairly simple way to group your
products, to structure your displays by adding breaks. Also note that when there are
a lot of breaks in a table, especially when there are a lot of lines,
in the elevator here, the elevator with the orange bar here, markers will appear that
will show you where your different breaks are located throughout the height of the table.
And by clicking on these little brown markers, eh, the same color as break, you can
quickly move from one block to another. So that's also quite practical, uh, for
quickly navigating through a large list of lines. And as I was saying, you can of course delete
the breaks that you have set up. Just right-click and either delete
the break you want, or delete them all. Here, I'm going to first delete, for example, the
second supplier. More directly, I'm going to delete the first to show you that
the second will remain, but it will become the first-level break. There you go, I'm
more than grouped by supplier. So another view, another way to order your products. And
lastly, delete all the breaks. At this point, I return to the default display.
So this type of break, you have it of course in the product table,
but in almost all tables. Uh for example, if I return to my characteristic,
Here, you see, I had selected all my characteristics. So here, I have all the
characteristic values. It's a bit messy. I can go to the name column,
which actually contains the name of the characteristic. Right-click. Add a break, and at that point,
I have a much cleaner classification of my characteristic values. It's
also good to know these famous breaks, they are memorized in your column settings,
configuration if you prefer. For example, here, so you see, I'm in mode finally,
I created a configuration called basic repair. I'm going to put my break back
on my category column. Well, if I go to another view or another configuration here by
tag and keyword, you see, I no longer have my break on my category column. I could very well
put it on another column, for example the list of tags here. There you go. So here,
I have my products grouped according to their tag. When I go through, I go back more precisely
to my previous setting, repair base, and well you'll see how I'm going to find,
you see my break on my ID column, finally category name. And that's also true for
the famous sorting there, eh, the fact of clicking on the column titles to sort your products. That
too is memorized in your column configuration. So with all these tools, uh mixed together,
you have plenty of ways to really create very personalized views of your different
tables depending on the type of work you want to do. These are not very
well-known functions. Uh every time I take control remotely on your configurations, it's very rare
that I see people use these breaks. And yet, I assure you that when I
work on my database, I really abuse it because it's really very, very practical when
you're used to working with it. The one I certainly use the most is at the
level of the variations table. Uh when we display the variations of several
products. So that's what I do here. See here, everything is in bulk. So I don't like that at all.
Almost systematically, I set up a break here on sorry here on the name of the
product. There you go. And like this, I really have here the easy way to
quickly find the variations of this or that product. By default, I have the name which is displayed here in the break. Uh
I didn't say it, you can also delete your breaks here with the little trash can. Uh and of
course, I showed you this earlier in the tutorial on positions, you can click on
this type of button here, the little rectangle to select all the lines uh of a block at
once without selecting the lines of the other blocks, eh. There you go. And then here is the
trash can, I'm going to show you how to quickly delete the breaks directly in your
tables. So, there is another tool which is very practical and complementary to this notion of sorting.
position and break, these are the filters, the column threads. Right-click here, filter
on this column or then select filtered on this column which is our sort type or even
the pre-filters. And so to not overload this tutorial too much, I will do another tutorial dedicated to these
pre-filters, these filters. That's it for this tutorial. Thank you and see you soon for another tutorial.