In this tutorial, we're going to talk about PrestatShop product variations. So, you
probably know what a variation is. I'll show you one for example. These are
the variants of a product. For example, this dress printed here can be available in size
L and in orange. Other sizes as well, this one has several
different colors and several different sizes. So different combinations of these sizes and
colors. These are called combinations. So in Merlin, as you can see,
the variations are displayed here in the tab of the same name, image variation. To
do this, simply select the products at the top and click on display to see your different
variations. Nothing really special in the list of columns that you can display. So,
it's like for products, like for other tables. So this list of columns
is variable, you define it. So you go to column up there and you choose
you create your configuration. You can create as many configurations as you want.
And here in the variation tab, you have the entire list of possible columns that
you can include in your display. Currently here on the right, it's all
the ones that are already displayed in my table. So, there's not much to say about them. These are
columns that you should recognize yourself. Perhaps the one that's important to mention
is this one, the one at the very bottom, one column per attribute. I'm going to include it
and I'm going to show you what happens when we display it. There you go. So it's refreshing
the display. Here, for example, I select two products and look at the bottom in my
list of variations. Here, I have two columns that have been displayed. One for sizes,
one for colors. In fact, dynamically, this section that I just included
in my configuration allows me to have a column for each attribute. We call it
an attribute group that is associated with my different selected products.
So, I deliberately started talking about this. Why? Because these columns, finally
this type of column is really important during your exports to be able to reimport
your variations with the right attributes. Without these columns, we cannot import.
That is to say that basically this column here, list of attributes, has an informative function but does
not have a function allowing you to reimport the data. And likewise here, we cannot modify
the data directly in this column. It is purely informative. These columns also
allow you to sort or filter. If I click on size, well, I will first have
the sizes L then M and so on. So that's what we call a sort. And then I will
also be able to filter, right-click, uh, filter on this column, choose a size to only have
these sizes in question. Very quickly, of course, this table here allows you to make
modifications, entries, eh. I can absolutely enter a purchase price here, line by line,
I can enter a sales price impact here and so on. So, work manually
cell by cell. You can, as with the product table, copy and paste. So
here, for example, I select three rows, I right-click on the 10 and I go
to the bottom of my list. You can't see here, but I copy 10 to the entire cell, the entire
column, sorry. In this case, I have my 10 everywhere. If I want to copy this 100 here to these three rows,
I do the same thing, but I paste 100 into the selected cells. At that point,
I'll have my 100 here, which will be copied to these two cells. There you go. So edits like
this by copy and paste. You can also use the grouped action button here to launch
the modifier by calculation and therefore perform calculations on your numeric columns. For example,
if I'm going to modify my price impact, which is here excluding tax, so which is worth 10 on these three rows,
I multiply by 2, for example, and I highlight 2. I click on multiply, it shows me
the result. If I like it, I validate. Okay? So you can work on the values ​​like this.
You can work in percentage, that is to say, for example, increase by 10%. So I put 10
percentage on my price impact and I do more. And well, on these three lines here, the same, I
'm going to go from 20 to 22. You can also, of course, thanks to the first column called default
, and decide product by product what the main variation will be. So here it's this one.
If I want to change, if I want to take this one, I select and click here. You can of
course also play with your quantities by including the quantity available for sale column here and
modify your quantities one by one or in bulk as I just did for the prices.
And then, of course, you can also delete variations. Just select them,
go to bulk action and choose delete. You also have a label generator function
. So here, I invite you to watch the tutorial on this part.
Price labels, eh, sale labels, barcode labels, and so on. You have a catalog function to print
a PDF catalog of your products with their variations and a function here to round the
final sales prices, uh, taking into account the price impacts and the base prices of the products.
And finally, an export function. Here too, we have already created a tutorial on exporting.
So I invite you to go see this tutorial for more information on using this function.
It might also be useful to mention that if you are working in a
multi-store configuration, so like here where I have four stores, if you select several
stores and you do not activate the multi-store modification mode, at that time,
you will have for each of the variations that exists in the various stores,
you will have several lines. You will have one line per variation and per associated store. And so,
you will be able to work with the data, either one store at a time
or several lines at a time. So several stores at once. And finally, if you activate
the multi-store modification mode, at that point, you will have only one line per
variation, but the modifications are then saved in all the selected stores
at the same time. So that's an important concept to understand. I invite you to watch or rewatch the
tutorial on multi-store to fully master this part. What really concerns us
for this tutorial is to see how to create new variations with possibly
new attribute groups and new attribute values. So for that, we will start
with a list of products which are here. While I had imported in a previous tutorial, it's
a list of photos which allowed me to automatically create products, eh. It's a
function for photographers if you don't know. From here, a photo folder,
we can automatically create products and thus market photos, photos
of sporting events for example. So here, we're going to take two of these products for example to
show you that we can work in multi-product mode, of course. And then I go to image variation,
I'm going to display to show you that for the moment they don't have any variation at all.
So I'm going to manually add variations to them first. So for that,
I'm simply going to click on the new button. If you have this error message,
don't worry, it's normal. The first time we use it, we need to add
a very specific column to our configuration called action in the out-of
-stock frame, which is necessary to be able to generate variations manually like this. So
I'm going to add it quickly. So I go to the column configuration, I go to product,
I go to the stock URL section, custom accessory searches for stocks. Here it is. And here you have
action in case of out-of-stock. You add this to your table. products and that's enough.
So the products refresh the variations here. I'm going to reselect my two products and
this time I'm creating a new one. There's no more error message. So it asks me how many
variations I want and I'm going to create, for example, four variations in each. So
I ask for four variants. My variations are then created. So I have
four variants for the first product and four variants for the second. However, you can notice right away
that these variants are not differentiated in the attribute list column. Here, I don't have
any attributes and I don't have a column at the end containing my different attributes either. So,
we'll have to manually define what we call attributes, characteristics
, or properties if you prefer. For example, here, these are products for a
photo seller. Well, we're going to be able to create variations of different photo sizes,
10, 15, 20, 30, etc., and then maybe also photos with frames or
photos without frames. So for that, we need attributes and associate them with these variations.
So we're going to start by creating the attributes. So for that, I'm going to the bottom part here. So
we're going to make a little space. We're going to move the products section up like this to the top.
To have as much space as possible. And so in this image variation tab, in the bottom part, you
have two sub-tabs, one for attributes, one for images. So you go to the one
called attribute, you click on the view button. So at that point, all the
attribute groups that already exist in your database are displayed here. And if you choose one or more,
you have here on the right the different attribute values ​​of these attribute groups selected
here. So we're going to create an attribute group defining the different print formats
and then another for the frames. So for that, I go to my attribute group here,
I click on new. This allows me to create a new group. I'm going to call it dimension.
I'm going to click here to copy the word dimension to the public name. I could have said that it's
a color group, but that's not the case here. However, if you actually define a group
containing different color values, I advise you to check that. And here for the group,
you can choose the type of selection in the product pages: select, radio, or color. Here,
I'm going to settle for a selection type group and I validate. So I have my new group
appearing here: dimension. I'm going to immediately create a second one that I'm going to call frame
and I validate. For the frame, I'm going to create two values. So for that, I'm going to click
here on new or new more precisely. And the first value, I'm going to put yes. If
it's ever a color, that's not the case. At this point, you are invited to click on this
button here to open the color picker and automatically select a color. And
then I'm going to create another second value that I'm going to call name, which I validate. Then,
I'm going to take my other attribute group here that I created. I'm also going to create two
attribute values. So one that I'm going to call 10 15, it's the dimension of my photos.
I validate, and a last one that I'm going to call 2030. I validate. There you go. So here,
we have, sorry, frame and dimension, our four attribute values ​​that have been created. Before
going further and associating these different attributes with my variations here, just
to show you some other properties. So here in the values, you see that we can
once again modify the color of each of these values ​​when it comes in particular to
color type attributes. So for example, if I choose one here that already exists, see here these
are colors and each of these colors has a color, right? So that corresponds,
you know, to the little square for selecting attributes in the product pages. Another
thing, you have here a column indicating the position of each of these values ​​in the
group. We'll see later how to modify these positions, so reorder the values ​​in a
different way than the order of creation. And then here, you have a column per store
to define for each of your values ​​which store they belong to. So if, for example,
I uncheck these three values ​​in store 2, at that point in store 2, we will no longer have the
variations containing these different colors. So a very easy way to differentiate the
types of products available depending on the stores. So you have it here for the values,
but you also have it for the entire attribute groups. H so for example here this
group here 8 which corresponded to the dimensions, well I see that precisely uh I only created it in
store one as well as my group here the other group which corresponds to the frame. Why does it
only exist in store one? Because when I created my two groups
here in my control panel in my store tab, I had only selected
store one. If I had selected several stores, any stores, well my
group, my newly created groups would have been automatically associated with these stores.
At the group level, you have other properties that you can play with.
You have a column allowing you to define whether the group contains colors and another
property here a little hidden which allows you to define the type of selection in the product page.
I showed you earlier when I created my two groups. I defined them as
select type but you can change it after the fact, eh, switch to radio type or
color type. So in principle when we select color here, which indicates once again
that the values ​​are colors. Often, we choose the selector of type color,
it's still more practical. And finally for the groups, you also have a position argument
which allows you to define the display order of the groups in the product pages, eh. So
in how to say, it will allow you to define when someone wants to buy a product
the order in which they must choose the different attributes. Maybe you ask it to
first choose the size before choosing, for example, the color. So you're going to define that
here. And I'll show you later how to modify that in bulk. So here, I worked
in a single language. But if your Prestashop is multilingual, your store is multilingual,
know that here you have a language button that allows you to display other tables that were a
little hidden here which are the translation table. So for each of your values, sorry,
your attribute values, here you can define a translation per language. So here,
I only have French, but if I had several languages, I would have several rows and I could
work in my different translations here. And the same thing here for your group names. You
have a column here with the language, the language, sorry, and your two names, the computer name, let's
say, and the public name of your attribute group. So, know, it's important that these tables
allow you to make mass edits with the right click and then the famous Magic Edit function that I already explained in
my review. So there, you can fill in, modify your group names, your
value names with the Magic Edit tools. You have another very interesting function,
not very well known. Let's imagine that in addition to your color group here, you want to create a
second group that you will call color 2. For example, if you have sets of
pieces that are composed of two different colors, one for the top, one for the bottom,
well you can create a second group of colors. For example, I will call color
color bottom for example that I will define this time of type color and type with a
selection of type color. I validate. And once your group is selected, normally
I would have to start again here to recreate all my values. Well, it's not necessary. In
Done, you just have to select the other color group, select the colors
that you want to copy from the first group to the second. So for example, I'm going to select
a few. So it can be all of them of course. Here, I'm going to take these six.
And once they are selected, I'm going to click here on the clone button. And I could
also, before doing it, select a third group, eh. That is to say, you can
copy from one group to a multitude, sorry, of other groups. Here, I click on
clone, it tells me that it's going to duplicate. And so now, if I select my color group below,
you see, I have the six colors that I retrieved from my other group. So
a very quick function like that to fill groups of properties, let's say similar. You
can also of course select and delete colors, finally attributes, or even
groups of attributes. So you have a delete button here, eh. So you make a multi-line selection
and you click delete here to delete the values. Or here you take
a new color group and you click delete here to delete it. So,
let's see now that you know how to create attribute groups and attribute values,
how to associate them with variations. So, I'm going to start by simplifying the display a little.
I'm going to take my variations here. For example, I'm going to take the first two of
this product. I'm also going to take the first two of the second product to show that we
can work on several products at the same time. And then for these four variations,
I'm going to associate a dimension with them. So I go to dimension and I take my 10 15. Here, I
select it and I'm going to associate it. So for that, it's very simple. Here you have a column,
you see with a string marked variation. Well, all you have to do is click in this checkbox
for the association to be made. So I see it here. So I have the information that attribute
36, so it's this one, that is to say, which is called, which contains the value 10 15, is currently
associated with my selected declinations. So I see it there or I see it here. Here it flashes
to indicate to me that the attribute list here has not been refreshed. So if I obey it,
I do a refresh, you see, I find my values ​​which were associated with my
four declinations. So, we will sort according to this to find them grouped like that, it's cleaner
. Now, I will take my four other declinations. So, these two, it's these
two as well. And I will click here on the 2030 to associate them. Now that that's done,
I will take a 10 15, a 20 30 15 30 and I will take my group, I look for it, uh, frame.
There you go. And for these four, I will choose a frame. And then for the other four,
I'm going to refresh so I don't get lost. So here I'm getting a little lost because I have what
we call breaks. So I'm going to delete these breaks. We're going to click here. There you go. And then
I'm going to re-sort by product. So I go into Product ID and I'm going to put it here and ask for
a break on this column. So I'm finding my way around better. So I've grouped my lines by
product. I see here the 20 30 and 10 15. Here 20 30 and 10 15. And this one has a frame. Okay, so I
haven't chosen one yet for this one and this one. I mean I'm taking a frame and then I'm going to
take the others, this one and this one. And then this one and this one. And then I ask and say
that I don't want a frame. There you go, normally that's it. I'm refreshing. I've made my
attribute association. It works. However, we agree, it's still quite long. Here,
I really worked manually practically variation by variation. So we get there
but we get there if we have a number, let's say, relatively limited number of variants. So the interest
of Merlin anyway in manual mode is that there I worked on two products but I could have
work on many more products at the same time. However, there is still a
much more efficient method which consists of using what is called the generator. So that's what
we'll see in a moment. However, before launching the generator, I'm going
to show you an interesting feature. When you select a variation line here,
well automatically at the bottom in both tables, you are shown the properties, the
attributes of the selected variation or variations. So here, if I take two, so
there is a color code to indicate to me that so here in blue for example, it tells me that both,
you see, both are in 10 15. I have a blue check mark here with a V. When I have an orange square check mark
, it tells me that we have different values ​​for the two. So indeed there,
it's the same. There, I have a yes, I have a no. So there, it's orange for both. It tells me that
at least one of the two has a yes value, at least one of the two has a no value.
If I take this one and this one for example, well it tells me that both have a no value
for the frame property. And that not only allows you to quickly see the
common attributes of the different variations in this table, but above all it allows you to modify it.
If for example this one, I wanted to change it from 10 15 to where is my dimension? Here it is at 2030,
I just have to check here and automatically the change is made. So there, it may
not be relevant for this variation. We will start again on another product to show you
the interest of this. Here, for example, I choose my chiffon dress. My chiffon dress,
it exists in green and yellow. Do we agree? I could manually have fun changing the
properties, redoing my variations and so on if ever I had a color change. But in
fact, it's simpler, for example, to say I'm going to take all the green variations. So
here, you can filter on the color, excuse me, I'm filtering,
I'm going to make it equal to or contains, whatever the word green is. So I have all the
green variations that appear and only this one. I select them all. There you go. Here, I choose
my property or my color attribute group. It shows me well, so I don't know if I can
show it to you, I no longer have the elevator. Here, my color is green. But if, for example,
I wanted to replace all the green variations with another color, for example red,
I click on red and that's it. All my variations of my product have become red
instead of green. So, we're going to refresh, show. So there, I no longer have anything appearing
because of my filter. Precisely, we're going to delete the filter. I'm going to do it here. You don't know.
Delete all the column threads. There you go. And you can see that now I have red or yellow dresses
, but I no longer have green. So a very quick tool, simply by clicking in this
column, to modify the value of an attribute on an infinite number of variations of an infinite number
of products at once. So this time, I'm going to do the same operation, namely creating four
variations on two products, but I'm going to do it with the generator so you can see the difference
in speed. So I'm going to take two products like before. The same thing. We can see
that they don't have a variation yet, are we okay? I'm going to quickly choose my two
properties here, so my two groups of attributes, frames and dimensions. I select them both
. I click on everything here to select my four different values, and I launch the
generator either with this button or this one. So, I'm going to take this one because it has
the advantage of automatically filling the generator with the lines that I've already
selected. So, I launch my generator. There you go, it opens. So, I'm not going to explain it to you
in detail right now, I'll just show you the usage quickly. In step one, I choose
the generator. In step 2, I ask it to delete the existing variations or
possibly keep them. Here in the example we are dealing with, it's exactly the same thing
since there aren't any yet. Step 3, normally I fill my table with values. I've
already selected them and by clicking on the generator button here, it filled my table
with my values. I just have to select them to say that I'm going to use them because I
could also decide at that point, for example, not to use the 10 15.
So we still have a second choice if you want or a second level of choice. So I
select my attribute values. I continue. I go to step 4. Step 4 is actually already
done. It's about selecting the products for which I want to generate or modify
variations. It's already done. I go to step 5. I click on generate and it's finished. If I
create my generator, I click on refresh, and I immediately have all my variants
that have been created. So my eight variations have been created, and it took, as you can see, less than
a minute. But besides its speed, this generator has many other advantages. For example, it's very
easy with this generator to take products that already have variations
and modify them without having to delete them and start again. Let's imagine, for example, that at some point
we create a third dimension. So I'll do it quickly. I go to dimension,
I create a new dimension that I'll call 30 40, and I validate. And I would like to add this
dimension to my variations. In any case, recreate variants but with the 3040 in addition.
At that point, I just have to select my 30 40, click on the generator again here,
which adds my value to my generator. So, with the generator still open,
you have a button here to access it quickly. So I click there and you see, I end up
with the same tool as before with it memorized my settings and I have my value 30 40
here which was added. Well I take my attributes, I go directly back to my step 5
and I generate again. It's finished. I come back here, it flashes, I refresh and I see that it
has indeed added two variations per product, one for with or without frame in 30 40.
But what is important to understand is that the variations that already existed in
2030 and in 10 15, they have not been deleted. That is to say that if you had assigned them a
price or a quantity, at that time, it was kept. Whereas if you try to do the
same thing in Prestashop, it will necessarily delete everything and you will have to recreate
additional variations by also recreating all the ones that it will first delete. So
you're going to lose the properties, whether it's prices, quantities, references, and so on.
So with Merlin, you have what's called an incremental generator, which takes into account the
existing product in addition to being multi-product, as you may have noticed. So here, I've created
two additional variations in each of my two products selected above. Okay,
now that you've seen how to briefly use the variation generator,
I'm going to show you some more advanced functions of this same tool. So,
let's start with another product, for example. This time, I'm going to start with this one.
I'm going to launch the generator this time with this button here, or it's already
open, so it's smarter to click there directly. So the first thing to see
is that this tool is actually two tools in one. You have a generator that we've
already used partially, and then you also have an impact modifier. So I
'll show you the impact modifier later, but briefly explained, the impact modifier doesn't
generate new variations, it only modifies the price impact and/or weight impact of
existing variations. Well, for now, let's stick with the generator. We go to step 2. And
In step 2, there you have several possible options. So the first is to delete
all existing variations of the products we are going to work on and we regenerate
from a blank page. A bit like what Prestaop does. The second option is to recalculate
the impacts of the variations that are already created, that already exist, so that it
is similar to the new variations that we are going to create. That is to say, we will create
new variations by specifying in step 3 price impacts, weight impacts. So in
addition to creating these new variations, those that already exist, they will be maintained,
preserved but their impact will be modified. Typically, if for example you have put
the fact that the 2030 format cost €5 more in step 3, at that point, the variations already
existing in 2030 will also have a modified price impact. So they will also want
€5 more. The third option allows you to keep existing variations unchanged.
So we don't touch them, we don't delete them, and we don't modify their
price impact or their weight impact. And we will only regenerate the new ones that we request.
This is the old manual mode that still exists out of habit, but in fact, it
comes down to exactly the same thing as using the new button here that I showed you
earlier, which allows you to create new lines empty of any attributes. So you will
probably never use this. But there you go, it's kept here for those who are used to working
like this. And finally, you have a fourth mode, a fifth mode, sorry, which is not recommended when
you have to create a lot of variations, but which is very practical when you simply want
to duplicate some of the variations of a product to other products. Again,
it works well when you're working on a limited number, but don't use this tool, this
function on I would say more than a hundred variations, it would take too much time. Then,
whatever mode you choose here, you have options for automatically filling
your variations. For example, you can define a quantity for them. So all new
variations will have a quantity of 5. You can also fill the quantity by taking the
current quantity of the product. So if my product behind has a quantity here of 10,
well when I generate the variations on this product,
each of my variations will have a quantity of 10. So if I
generate 10, my product will have a quantity of 10 x 10 100.
And 3rd option, only the default quantity, excuse me, only the default variation
of the product will take as its quantity that of the product. So if I take the same product
which has a quantity of 10, well one of these variations, the one that is created first,
which will be the default variation will have a quantity of 10 and all the others will have
a quantity of zero. So with this mode, we respect the initial quantity for the product.
The product will always have a quantity of 10 overall. And the second line allows you
to fill in the reference of these variations. So you can either, for example, with this option,
copy the current reference of the product into the reference of your variations or, on the contrary,
put a reference that you fill in by hand, like "dream" for example, followed by something,
for example, followed by nothing, or followed by the PrestaShop identifier number of the variation created.
So a number or a counter, a counter that starts at 1 and counts as
the variations are created. And then here you have the separator. So typically, if I
take this, for example, I will have my references that will be filled with a dash and then the
number of the variation. Let's take an example. I'm going to ask it to delete the
existing variations and recreate them. So for that, I'm going to take a product that already has some.
We agree, it has some variations. I go back to my generator. So I choose
the delete option. I go here and I'm going to ask it to only use the 10 15
and then and then no, I'm not going to do that. I'm only going to take 10 15 and 20 30 and I
don't want to take the frames. I go to my step 5, I generate. So, it tells me, it warns me,
it tells me "That's weird, I didn't select all the attribute values ​​that were filled
in step 3." It doesn't matter. I say to continue like this. There, it's finished. What happens
now? I have more than two variations. The 2030, list 15. We agree, it
deleted everything that existed. It started again with only the values ​​chosen here. Well
now, I'm going to do something else. I'm going to choose the second mode. In the second mode,
it keeps the variations already created and it recalculates their price impact in relation to the data
that we will enter in step 3. And then it creates the new ones requested. So for example here, I
'm going to ask him for a variation, or rather an additional attribute. She asked him to create
the variations using this attribute. And then I'm going to tell him that for 2030, I want a
price impact. So with a tax of 20, I want a price impact of 10, that is to say a price impact excluding tax
of 833. Then I select the three attributes. All I have to do is generate to recalculate the
impacts of the existing variations and create the new one, that is to say the one in 30 40.
But before doing that, I'm going to come back here in my main window to look at the number
of the variations to show you that they don't change, they are not replaced
but they are simply updated. See, it's 805 and 804. So I come back here, I go to
my step 5 and I generate. Remember 805 804. I continue. There you go, it's generated. I'm coming back, I'm
refreshing. What do we see? Here we have our 805 and our 804 which have been modified. Finally
the 805, so the 805 is in 2030, it has recovered the price impact that I asked it to. So it
hasn't been deleted, it has simply been updated and then the 3040, the new variation has
been created. It doesn't have a price impact because I didn't specify one. Step 3 on this line.
So 3rd exercise, this time, I choose the third mode. So I ask it to keep
the existing variations identical and to generate only the variants. So here
for example, we are going to modify the price impact of 2030 or 10, I will set it to 15 and then I will
regenerate. Same here, I will select these three variations. So, I'm not creating new ones,
but I'm regenerating them. And what are we going to see in this case? It might not be relevant to do
that. I'm just realizing, you won't understand. So we're going to recreate another
dimension. So I live in dimension, I create a new one. We're going to create a 40 by 50.
A large size and I validate. Here's this 40 by 50, I want to add it to my generator.
Just select it and click on this button here. I'm going to go back to
my generator. We can clearly see that the 40 by 50 has been added here. So I take it. 40 by 50. I'm
also going to give it a price impact. I'm going to tell it that this one costs €30. I select
my four variants and I generate. And in fact, what I want to show you is that the €15
here is not going to be impacted by the one that already exists. That is to say, this one, I
no longer have its number, excuse me. 805 currently has a value of 10. It will remain at 10 because in
my choice in step 2 here, I asked it to keep the existing variations identical
. There you go, let's try. I generate, I continue, I return to my main window.
We're going to refresh. So this time, we should have an additional variation. So here,
it has 808. So and it is in large size 4050. It has a price impact of 25. And then what
we had said my 805 here the old one which is in 2030, it had an impact of 10, it remained at 10 although
indeed step 3, I had specified a different price for the 2030. It is only
if I had declared new 2030 variations that at this moment it revalues ​​15.
So we're going to do it. For example, I'm going to ask it this time to take this into account.
So it's going to generate a lot more variants for me. And at that point, we'll see that all those
in 2030 will want 15. Step 5. I validate. It's finished. I refresh. There you go. So
we're going to look for one that's 20 30 here. 2030 with Yes. Well, look, it's worth 15.
Whereas my initial variation in 2030, if I find it, here it is. So the 805,
it stayed at €10. Another exercise, I'm going back to the generator and this time
I'm going to show you the duplication mode. So, this duplication mode is used to take
the variations of a product and duplicate them in another or in a selection of others.
So for example here, we're going to take this. We're going to go to step 4. And in step 4, it
asks us to select the items to modify. So it asks us to select from
table A here at the top the products in which the tool must duplicate the combinations as well as
the product containing the existing combinations to clone and then to select the combinations
that we want to duplicate belonging to this last product. So look there, I have a
product that says combination. Let's imagine that I want to duplicate the I don't know, we'll take
the 20 30. Yes and no these two. Okay. But I'm going to duplicate them in other products that
don't have any. So we'll choose other products that don't have any. So I'll take this one
and then I'll take products further down the list. I know they don't have a combination.
Here are the 307 and the 308. Look, I have variations for the 302. We agree,
I don't have any for the 307 and 308. Well, in the 302 now, I'm going to choose the variations
I want to duplicate. So I said I wanted to take this one, the 2030 yes and the 2030 no with
their impact here at €15. There you go, I duplicate that. So for that, I go back to my generator.
So I did my step 4, I go to step 5 and I duplicate. By the way, see that in step 3,
we can't do anything gray them out. Here, we don't need to choose attribute values ​​and so on. In
fact, it's simply the selection we made here in the table that takes into account import parameters
. So, I'm going to step 5 and I generate. So there, it's a little longer. So,
it took 2 seconds instead of 1 second, let's say. But again, if you
do this on a large number of products, a large number of lines, it can be quite slow.
So it's best reserved for moderate use. No matter. I go back to my window.
I click on refresh. This time, I still have my variations of product 302
and you see my products 307 and 308 have received the two variations that I selected
with exactly the same parameters, the same references, also the same prices and so on
. So we're really doing identical duplication. So, I go back to the generator
and this time, we're going to go back to a standard mode, for example, to delete and
create new variations. But I would like to show you the different possibilities we have
in step 3. So, so far, what I've shown you is how to fill the list of
variations here by going to the main window in the list of attributes here by
selecting, I show you different groups of attributes, different
attribute values ​​and then clicking on the generate button. And when we do that, I show you again.
When I click on the generate button, it automatically fills the table here. So
this function is the same as the one you have here. Add the selected attributes
in the main window. When I click there, it takes the attributes that I chose here. If
, for example, I take another one here, the 4050 that I have in my generator, if I click here,
it adds it to my list. Okay? So that's the first method to fill the list
here of variations, sorry, of attributes in order to then produce variations. But there
There's a second method, so I start by deleting. The second method is the one
that consists of adding the attributes of the selected variations. That is, I
return to my main window. Here I have variations. Let's suppose that I take
a few at random. Uh, I'll take this one for example and then this one.
So this one is in 2030 with a frame. This one is in 2030 without a frame. Well, I go back to my
generator and I click here. Well, you see, it fills my attribute table here with
2030. Frame yes, frame no because these are the attributes used by these variations.
So this button allows you to basically retrieve attributes from any variation,
from any product to produce the same variants. So typically, what is it used for? Well,
it's used to duplicate all parts of the variations of a product to other products. For example, I can very
well select all the variations of a product except for a few
attributes. Well, except for some that use attributes that I can use. Then
select them and generate the same variations on other products. There's something
very close to that. So here I'm going to select everything and delete it. It's this button here
and that adds the attributes of the products I select to our list. So here, it's more
global. For example, I come back to my main window, I take a product. So this one,
there are no variations, that's not smart. We'll take one higher up, sorry. So we'll take
this one for example. So it has variations. 20 30 yes. 20 30 no. 10 15 yes and no. Well,
I didn't even display these variations, just to show that we don't need to display them. So
I find myself in my generator, my product is selected and I click here to add the
attributes. Well, here I find my 10 15, my 2030. Yes and no because these are all the
attributes used in the variations of this product. I'll show you the 2030 in yes no,
the 10 15 in yes no. We've recovered the same attributes and this tool can go a little
further. That is to say, from here, I can select them all and use this button here which
will fill the table with the price and weight impacts of the attributes here taken from the product that
is selected below, provided of course that it has impacts. So does it? It
may not be relevant. So this one has no impact. You see, I don't have a price impact
here. So I'm going to take another one. I think we created one from memory in this one
either. There you go. Wait, what we're going to do at this point is we're going to select them all.
We're not going to bother. So here, I have all my products selected and then we're going to scroll down a
little and find a product. Here, this one, you see, has impacts. So, I don't really know
what impact it has. I don't know if the price here, the 25, comes from the yes or from the 4050. Most likely from the
4050 because we find it there. But it doesn't matter. Basically, I just need to select my
product at the top. So here, it's product 302. So I'm going to take just this one. There,
I select it. I go to my generator. We're going to start the process again completely. So I
'm going to delete everything. So first, I add the products, the attributes, sorry, of the
selected product 302. There they are all. I select them and I click on replace
impacts. And there, you see, I automatically retrieve in my table my impacts excluding
tax and including tax of my product. What use is that to me? Well, simply generate other
equivalent variations on any other product. For example, this one and this one. So 309 and
310 don't have variations. I go back to my generator. I've retrieved the attributes and
impacts of another product. All I have to do is go to step 5 to generate. There you go, it's done.
I come back here, I refresh and you see, I've generated exactly identical variations with
the same impacts. So to summarize, what I just showed you is that by using
Any of these three methods here, using these buttons here, this one and this one,
we could retrieve attributes and impacts from another product or from a selection of
variations of another product. to duplicate them in other products. So it's a
duplication tool, but very flexible, eh. You can choose the attributes yourself, you can choose
the variations you want to duplicate yourself, and it's very fast. The script behind it is very
powerful, it runs in a few seconds. So it's another method, perhaps a little
more complicated to implement, but much faster to execute, to duplicate
variations of a product to other products. It replaces the other method we
saw earlier, which was this one. So there's a duplication function that doesn't require you
to choose the attributes, etc. It simply requires you to select the variations you
want to copy. We take two variations for example, that's enough. We have nothing else to do.
We will then choose another product. Step 5, we duplicate and we have a duplication, a clone of
these variations. So this is a method, we will say simple to implement but a little slower
to execute so to be reserved for the number of products and small variations. Otherwise when we
have a lot of them, at that time, we will use one of the three modes among these. And then,
in step 3, we will retrieve the attributes with this button of certain variations or retrieve all
the attributes of a product with this button. Then retrieve the impacts with this other button on
the lines that we want. I didn't specify this but for example, uh, we will start all over again to show you
again. If I delete everything, I retrieve all the attributes. Well, when I use this button
here, I can execute it only on certain lines. So we just need to select only lines
here. And when I click here, it fills in the attributes and finally the impacts only on these
two attributes. So this allows you to make cross-editing by recovering certain
impacts but not others. Basically, you have great flexibility to produce
variation equivalents with or without the same prices. So these tools can go even
further. Look, I'm going to delete everything again. Before clicking on add
the attributes of the selected products, I can actually select several products up there,
not necessarily just one. For example, I'm going to choose these two items of clothing.
Here, I click here to recover the attributes. There you go, I've recovered the
sizes and colors. Well, when I click on this button to recover the
price impacts of these different attributes of these different products, it's possible that it will find
a different impact on the first product compared to the second. So at that point,
it will have to choose. Well, that's what this allows you to do. You will be able
to choose between the two products the impacts, either of the largest values, or on the contrary
the smallest values ​​and you will also be able to exclude the null values ​​at the level
of these impacts. So a great flexibility again here also to duplicate attributes,
variations of certain products to other products with a very free choice on the
calculation of the impacts that this will generate. So, I am well aware that in explaining all this to you
it may seem a little confusing, perhaps a little theoretical and difficult to memorize,
but the best thing is still to have fun with this tool, eh, to try, to do tests,
to try the different options, to select several products, to create dummy test products
and fill them with variations by copying, by generation and so on. Play with the different
options on the impacts to fully understand all the possibilities that the tool offers you.
Then so in this tool, I come back to the step, remember, we actually have two tools in one,
the generator and the impact modifier. So far I have only shown you the generator.
So this time we're going to focus on using the modifier. Basically, modifier
is a little simpler. It won't allow you to create or generate new
variations, but only to recalculate the price and weight impact of the existing one.
How do you use it? So, we choose modifier. In step 2, we just choose whether
we want to modify the weight impact or the price impact, or both. By the way, I didn't mention it, but
this choice also exists when we're in generator mode. We can also decide not to
modify this or that impact. So here, for example, I'm going to modify the price impacts. You'll be
able to choose to act on all the variations of product A that I've selected, that is,
all the variations of my products in general, or act only on the one I've
selected. So basically, I'll be able to say, well, for example, here, I put a filter, I want
the small sizes, I select them and at that moment the impact modifier will
modify the impacts only of this one and not of the other two. For example, I
go back to my generator in step 3. So, let's suppose that it's empty here. We'll do it again.
I delete everything. Okay, delete everything and I'll retrieve the attributes of my products. So,
I add attributes. There, I have all my attributes. I select them all.
I will retrieve or not, I don't have to, my impacts.
Here they are. So in fact, there aren't any. So it doesn't matter, there aren't any but I want to
add some. So for example, I decided that the large would be more expensive. So I'm going
to give it an impact of Okay, we'll put €50. Here I select everything. In step 4,
it asks me to select the items to modify. It's already done. Step 5, modify.
It's going very, very quickly. What happened? If I refresh, I'll see that some
products here have increased significantly. In fact, we find our impact of €50 on sizes L
on my two products. So, basically, with the generator in
impact modifier mode, I simply retrieve my attributes in step 3, retrieve or not the existing impacts. If there are
any, we will refill the table to reuse them. We can modify some. If there
was no impact to use during the generation of serious, we can modify them or add some and
we launch the generation and quite simply it will modify our prices and possibly our weights
of our variations without having to regenerate them, delete them, reproduce them, etc. So a
very quick tool to recalculate your prices, uh, without having to redo your variations. Al, I hope
not to be too heavy, but I would have insisted on one point. When you use this generator or
this impact modifier, so in step 5, in fact, they only act on the lines
that are selected here. That is to say, if for example, uh here, I switch the price back,
I set it to 40 instead of 5 years, okay? And I select, uh, I
don't know, and I launch the impact generator, sorry, the impact modifier. Well, on the one hand,
it warns me, it tells me, hey, that's weird, you haven't selected all the lines, but
it doesn't matter, you have the right to do so. It simply warns you. Why? Because
in some cases, when we want to generate variations, well, we often need to
select all the attributes that we have pre-selected in our list. Well,
that's not the case. For me, it's intentional. I only want to modify two impacts out of the three.
So I continue. Well, in this case, if I refresh, we'll do it, but I'll show you
first. In fact, my 50 here won't change because I didn't select the L attribute before
launching the modification. So I'll show you my L. Here we still have our impact of 50, right.
Why? Because here I didn't select my L line with my impact modified to 40.
If I want to modify my impact of 40, I have to at least take this line and I can
take that one if I want. So there, I restart, I continue and this time,
on the contrary, my lines with an L attribute went through with a price impact of 40.
I'm going to stop there for the generator. I'm simply going to come back to
something that I quickly skimmed over earlier and I promised to come back to it with
more information. In fact, it was about changing the position or display order of
attribute groups on the product pages and the values ​​in the product pages as well.
Hey, you remember, I showed you that here, we had a column called position
which allows us to order the display of attribute groups in the pages on the site. And so,
this allows this column, sorry, is editable allowing us to modify this order. How do we
do it? So, the first operation to do is to click on the title of the column
to first order the display according to this order. And then you have several
possible methods. The simplest is to take a line here, for example 4 and move it. So
my new colors go to position 2. If for example, I want my frame here
to go to position one, I put it at the very top. If I want to move two lines at the same time,
I take them and I move them. And all the others are recalculated.
So, another way to do that is for example if you want to order them alphabetically
automatically. So at that point, the simplest is to click on
the title of the column group group attribute so that you have this order on the screen, sorry
alphabetically. If you ever have numbers in there or other things other than text, you
can also, I'll tell you about it quickly, with a right click in the menu here to see the sorting options
. So, we're going to try to bring all that up a bit so you can see more clearly what I
'm going to show you. So, if I right-click here, sort option, see, you have different
types of sorting possible. The default sort, but which is actually an alphabetical sort but
insensitive to case, so to capital letters, numeric, accents, and spaces.
And then you can check these options to take accents into account or not, take
numerics into account or not, uh, in strings, and so on. So with all these possibilities, you should be able
to order your values ​​with a simple click on the title of a column according to what interests you. There you go.
And then once you've done that, the easiest way to now apply this order
would be to fill in the numbers here, 0 to the bottom, by hand. But there's still a faster way.
You can use Magic Edit. So I right-click here, I launch Magic Edit in the entire
column. And in Magic Edit, so this isn't a course on Magic Edit that I'm going to give you here,
but just to show a possible use. I'm simply going to activate the last tool
in Magic Edit here, which is called adding an index. In fact, it's a sequence of numbers. I
'm going to ask it to start counting at 1, to increment one by 1 without an addition separator.
And I apply. What happened? Automatically, Magic Edit, so it's almost
that it actually filled my values ​​with 1 2 3 et cetera on the left digit here on the
right, sorry. But it left me some numbers from before. I actually forgot to ask it before
filling to delete. So I ask it to delete the content and then fill by counting
from 1. I apply and there you go. There, I have my numbers, my positions which are ordered and
I save. So by using Magic Edit like this, you can quickly order your attribute groups
according to any column. It could have been the IDs, it could have been the values,
it could have been I don't know anything. And what I did here on
the attribute groups, I can also do it the same way on the other table here on the
positions of my attribute values. huh. So if I'm going to order them, for example, my shoe sizes
Here, so the values ​​are there, I would like my positions to reflect my points, so I'm going to
click on I sorted in ascending order here on the value column. I'm going to select all my
rows in my group. And likewise, I'm going to use Magic Edit here in the entire column with the same
setting as before. Delete, add a counter, while I'm going to put one back each time and
I apply. And here I end up with my positions 1 2 3 4 5 6 et cetera which are
generated. So, I must have made a mistake and then I'm going to cancel because I launched
Magic Edit on the entire column. What I wanted was only these values. So
I select it and in my menu here, it's not Magic in the entire column that
I have to take but only in the selected cells. There you go. So only this one,
I reapply my result, finally my operation. Apply 1 2 3 and that and I like it. I save.
There you go. So, I absolutely wanted to show you this handy little tool for
quickly reordering attribute values ​​or attribute groups in alphabetical, numerical
, or any other order. You can use that here. But you can also use this trick
in product characteristics. In these tables here, we have a bit of the same
problem. We also have a position column here, and sometimes you may need to reorder the
positions in an order of your choice. So you can use exactly the same technique for
that. That concludes this long training on the concept of attribute declination,
attribute group on the generator. I hope you enjoyed it. You've seen
that it opens up great perspectives, great power, very fast calculation of the generator
to create new variants on one or more products at a time in addition,
increment, or replacement mode of remote declinations. Thank you and see you soon for another tutorial.