WEBVTT Kind: captions Language: en-US 00:00:10.600 --> 00:00:15.280 In this tutorial, we're going to talk about PrestatShop product variations. So, you 00:00:15.280 --> 00:00:19.360 probably know what a variation is. I'll show you one for example. These are 00:00:19.360 --> 00:00:24.200 the variants of a product. For example, this dress printed here can be available in size 00:00:24.200 --> 00:00:30.200 L and in orange. Other sizes as well, this one has several 00:00:30.200 --> 00:00:35.920 different colors and several different sizes. So different combinations of these sizes and 00:00:35.920 --> 00:00:40.000 colors. These are called combinations. So in Merlin, as you can see, 00:00:40.000 --> 00:00:45.680 the variations are displayed here in the tab of the same name, image variation. To 00:00:45.680 --> 00:00:51.160 do this, simply select the products at the top and click on display to see your different 00:00:51.160 --> 00:00:57.480 variations. Nothing really special in the list of columns that you can display. So, 00:00:57.480 --> 00:01:01.560 it's like for products, like for other tables. So this list of columns 00:01:01.560 --> 00:01:06.880 is variable, you define it. So you go to column up there and you choose 00:01:06.880 --> 00:01:11.280 you create your configuration. You can create as many configurations as you want. 00:01:11.800 --> 00:01:16.560 And here in the variation tab, you have the entire list of possible columns that 00:01:16.560 --> 00:01:21.680 you can include in your display. Currently here on the right, it's all 00:01:21.680 --> 00:01:27.040 the ones that are already displayed in my table. So, there's not much to say about them. These are 00:01:27.040 --> 00:01:33.160 columns that you should recognize yourself. Perhaps the one that's important to mention 00:01:33.160 --> 00:01:37.160 is this one, the one at the very bottom, one column per attribute. I'm going to include it 00:01:37.160 --> 00:01:42.000 and I'm going to show you what happens when we display it. There you go. So it's refreshing 00:01:42.000 --> 00:01:49.720 the display. Here, for example, I select two products and look at the bottom in my 00:01:49.720 --> 00:01:54.800 list of variations. Here, I have two columns that have been displayed. One for sizes, 00:01:54.800 --> 00:02:00.600 one for colors. In fact, dynamically, this section that I just included 00:02:00.600 --> 00:02:05.440 in my configuration allows me to have a column for each attribute. We call it 00:02:05.440 --> 00:02:09.600 an attribute group that is associated with my different selected products. 00:02:10.360 --> 00:02:15.080 So, I deliberately started talking about this. Why? Because these columns, finally 00:02:15.080 --> 00:02:22.320 this type of column is really important during your exports to be able to reimport 00:02:22.320 --> 00:02:27.040 your variations with the right attributes. Without these columns, we cannot import. 00:02:27.040 --> 00:02:33.720 That is to say that basically this column here, list of attributes, has an informative function but does 00:02:33.720 --> 00:02:39.280 not have a function allowing you to reimport the data. And likewise here, we cannot modify 00:02:39.280 --> 00:02:44.600 the data directly in this column. It is purely informative. These columns also 00:02:44.600 --> 00:02:48.560 allow you to sort or filter. If I click on size, well, I will first have 00:02:48.560 --> 00:02:53.480 the sizes L then M and so on. So that's what we call a sort. And then I will 00:02:53.480 --> 00:02:59.600 also be able to filter, right-click, uh, filter on this column, choose a size to only have 00:02:59.600 --> 00:03:05.040 these sizes in question. Very quickly, of course, this table here allows you to make 00:03:05.040 --> 00:03:10.200 modifications, entries, eh. I can absolutely enter a purchase price here, line by line, 00:03:10.200 --> 00:03:15.880 I can enter a sales price impact here and so on. So, work manually 00:03:15.880 --> 00:03:20.920 cell by cell. You can, as with the product table, copy and paste. So 00:03:20.920 --> 00:03:27.000 here, for example, I select three rows, I right-click on the 10 and I go 00:03:27.000 --> 00:03:32.600 to the bottom of my list. You can't see here, but I copy 10 to the entire cell, the entire 00:03:32.600 --> 00:03:39.680 column, sorry. In this case, I have my 10 everywhere. If I want to copy this 100 here to these three rows, 00:03:39.680 --> 00:03:44.400 I do the same thing, but I paste 100 into the selected cells. At that point, 00:03:44.400 --> 00:03:50.600 I'll have my 100 here, which will be copied to these two cells. There you go. So edits like 00:03:50.600 --> 00:03:57.240 this by copy and paste. You can also use the grouped action button here to launch 00:03:57.240 --> 00:04:02.840 the modifier by calculation and therefore perform calculations on your numeric columns. For example, 00:04:02.840 --> 00:04:09.720 if I'm going to modify my price impact, which is here excluding tax, so which is worth 10 on these three rows, 00:04:09.720 --> 00:04:15.640 I multiply by 2, for example, and I highlight 2. I click on multiply, it shows me 00:04:15.640 --> 00:04:22.400 the result. If I like it, I validate. Okay? So you can work on the values ​​like this. 00:04:22.400 --> 00:04:26.560 You can work in percentage, that is to say, for example, increase by 10%. So I put 10 00:04:26.560 --> 00:04:30.920 percentage on my price impact and I do more. And well, on these three lines here, the same, I 00:04:30.920 --> 00:04:37.200 'm going to go from 20 to 22. You can also, of course, thanks to the first column called default 00:04:37.200 --> 00:04:42.920 , and decide product by product what the main variation will be. So here it's this one. 00:04:42.920 --> 00:04:48.360 If I want to change, if I want to take this one, I select and click here. You can of 00:04:48.360 --> 00:04:54.160 course also play with your quantities by including the quantity available for sale column here and 00:04:54.160 --> 00:05:00.040 modify your quantities one by one or in bulk as I just did for the prices. 00:05:00.040 --> 00:05:04.680 And then, of course, you can also delete variations. Just select them, 00:05:04.680 --> 00:05:10.240 go to bulk action and choose delete. You also have a label generator function 00:05:10.240 --> 00:05:16.520 . So here, I invite you to watch the tutorial on this part. 00:05:16.520 --> 00:05:20.960 Price labels, eh, sale labels, barcode labels, and so on. You have a catalog function to print 00:05:20.960 --> 00:05:27.120 a PDF catalog of your products with their variations and a function here to round the 00:05:27.120 --> 00:05:34.920 final sales prices, uh, taking into account the price impacts and the base prices of the products. 00:05:34.920 --> 00:05:39.760 And finally, an export function. Here too, we have already created a tutorial on exporting. 00:05:39.760 --> 00:05:45.640 So I invite you to go see this tutorial for more information on using this function. 00:05:45.640 --> 00:05:49.440 It might also be useful to mention that if you are working in a 00:05:49.440 --> 00:05:54.600 multi-store configuration, so like here where I have four stores, if you select several 00:05:54.600 --> 00:06:00.520 stores and you do not activate the multi-store modification mode, at that time, 00:06:00.520 --> 00:06:05.080 you will have for each of the variations that exists in the various stores, 00:06:05.080 --> 00:06:10.200 you will have several lines. You will have one line per variation and per associated store. And so, 00:06:10.200 --> 00:06:13.880 you will be able to work with the data, either one store at a time 00:06:13.880 --> 00:06:18.480 or several lines at a time. So several stores at once. And finally, if you activate 00:06:18.480 --> 00:06:22.920 the multi-store modification mode, at that point, you will have only one line per 00:06:22.920 --> 00:06:27.240 variation, but the modifications are then saved in all the selected stores 00:06:27.240 --> 00:06:32.320 at the same time. So that's an important concept to understand. I invite you to watch or rewatch the 00:06:32.320 --> 00:06:37.360 tutorial on multi-store to fully master this part. What really concerns us 00:06:37.360 --> 00:06:43.560 for this tutorial is to see how to create new variations with possibly 00:06:43.560 --> 00:06:47.800 new attribute groups and new attribute values. So for that, we will start 00:06:47.800 --> 00:06:55.080 with a list of products which are here. While I had imported in a previous tutorial, it's 00:06:55.080 --> 00:07:00.760 a list of photos which allowed me to automatically create products, eh. It's a 00:07:00.760 --> 00:07:05.480 function for photographers if you don't know. From here, a photo folder, 00:07:05.480 --> 00:07:09.240 we can automatically create products and thus market photos, photos 00:07:09.240 --> 00:07:15.080 of sporting events for example. So here, we're going to take two of these products for example to 00:07:15.080 --> 00:07:20.160 show you that we can work in multi-product mode, of course. And then I go to image variation, 00:07:20.160 --> 00:07:25.040 I'm going to display to show you that for the moment they don't have any variation at all. 00:07:25.040 --> 00:07:30.160 So I'm going to manually add variations to them first. So for that, 00:07:30.160 --> 00:07:35.320 I'm simply going to click on the new button. If you have this error message, 00:07:35.320 --> 00:07:39.160 don't worry, it's normal. The first time we use it, we need to add 00:07:39.160 --> 00:07:42.560 a very specific column to our configuration called action in the out-of 00:07:42.560 --> 00:07:46.800 -stock frame, which is necessary to be able to generate variations manually like this. So 00:07:46.800 --> 00:07:52.640 I'm going to add it quickly. So I go to the column configuration, I go to product, 00:07:52.640 --> 00:08:01.920 I go to the stock URL section, custom accessory searches for stocks. Here it is. And here you have 00:08:01.920 --> 00:08:12.400 action in case of out-of-stock. You add this to your table. products and that's enough. 00:08:12.400 --> 00:08:20.240 So the products refresh the variations here. I'm going to reselect my two products and 00:08:20.240 --> 00:08:25.920 this time I'm creating a new one. There's no more error message. So it asks me how many 00:08:25.920 --> 00:08:32.040 variations I want and I'm going to create, for example, four variations in each. So 00:08:32.040 --> 00:08:39.960 I ask for four variants. My variations are then created. So I have 00:08:39.960 --> 00:08:45.440 four variants for the first product and four variants for the second. However, you can notice right away 00:08:45.440 --> 00:08:51.800 that these variants are not differentiated in the attribute list column. Here, I don't have 00:08:51.800 --> 00:08:58.160 any attributes and I don't have a column at the end containing my different attributes either. So, 00:08:58.160 --> 00:09:03.200 we'll have to manually define what we call attributes, characteristics 00:09:03.200 --> 00:09:08.680 , or properties if you prefer. For example, here, these are products for a 00:09:08.680 --> 00:09:14.160 photo seller. Well, we're going to be able to create variations of different photo sizes, 00:09:14.160 --> 00:09:19.280 10, 15, 20, 30, etc., and then maybe also photos with frames or 00:09:19.280 --> 00:09:24.600 photos without frames. So for that, we need attributes and associate them with these variations. 00:09:24.600 --> 00:09:29.360 So we're going to start by creating the attributes. So for that, I'm going to the bottom part here. So 00:09:29.360 --> 00:09:36.840 we're going to make a little space. We're going to move the products section up like this to the top. 00:09:38.000 --> 00:09:44.680 To have as much space as possible. And so in this image variation tab, in the bottom part, you 00:09:44.680 --> 00:09:48.840 have two sub-tabs, one for attributes, one for images. So you go to the one 00:09:48.840 --> 00:09:56.120 called attribute, you click on the view button. So at that point, all the 00:09:56.120 --> 00:10:02.800 attribute groups that already exist in your database are displayed here. And if you choose one or more, 00:10:02.800 --> 00:10:08.320 you have here on the right the different attribute values ​​of these attribute groups selected 00:10:08.320 --> 00:10:16.040 here. So we're going to create an attribute group defining the different print formats 00:10:16.040 --> 00:10:20.120 and then another for the frames. So for that, I go to my attribute group here, 00:10:20.120 --> 00:10:28.040 I click on new. This allows me to create a new group. I'm going to call it dimension. 00:10:32.640 --> 00:10:37.080 I'm going to click here to copy the word dimension to the public name. I could have said that it's 00:10:37.080 --> 00:10:40.840 a color group, but that's not the case here. However, if you actually define a group 00:10:40.840 --> 00:10:45.360 containing different color values, I advise you to check that. And here for the group, 00:10:45.360 --> 00:10:51.240 you can choose the type of selection in the product pages: select, radio, or color. Here, 00:10:51.240 --> 00:10:57.240 I'm going to settle for a selection type group and I validate. So I have my new group 00:10:57.240 --> 00:11:04.920 appearing here: dimension. I'm going to immediately create a second one that I'm going to call frame 00:11:04.920 --> 00:11:11.240 and I validate. For the frame, I'm going to create two values. So for that, I'm going to click 00:11:11.240 --> 00:11:18.120 here on new or new more precisely. And the first value, I'm going to put yes. If 00:11:18.120 --> 00:11:22.200 it's ever a color, that's not the case. At this point, you are invited to click on this 00:11:22.200 --> 00:11:28.000 button here to open the color picker and automatically select a color. And 00:11:28.000 --> 00:11:34.560 then I'm going to create another second value that I'm going to call name, which I validate. Then, 00:11:34.560 --> 00:11:40.240 I'm going to take my other attribute group here that I created. I'm also going to create two 00:11:40.240 --> 00:11:45.800 attribute values. So one that I'm going to call 10 15, it's the dimension of my photos. 00:11:45.800 --> 00:11:55.200 I validate, and a last one that I'm going to call 2030. I validate. There you go. So here, 00:11:55.200 --> 00:12:04.560 we have, sorry, frame and dimension, our four attribute values ​​that have been created. Before 00:12:04.560 --> 00:12:09.800 going further and associating these different attributes with my variations here, just 00:12:09.800 --> 00:12:15.080 to show you some other properties. So here in the values, you see that we can 00:12:15.080 --> 00:12:20.360 once again modify the color of each of these values ​​when it comes in particular to 00:12:20.360 --> 00:12:25.960 color type attributes. So for example, if I choose one here that already exists, see here these 00:12:25.960 --> 00:12:30.680 are colors and each of these colors has a color, right? So that corresponds, 00:12:30.680 --> 00:12:36.160 you know, to the little square for selecting attributes in the product pages. Another 00:12:36.160 --> 00:12:42.640 thing, you have here a column indicating the position of each of these values ​​in the 00:12:42.640 --> 00:12:48.480 group. We'll see later how to modify these positions, so reorder the values ​​in a 00:12:48.480 --> 00:12:54.240 different way than the order of creation. And then here, you have a column per store 00:12:54.240 --> 00:13:01.280 to define for each of your values ​​which store they belong to. So if, for example, 00:13:01.280 --> 00:13:05.480 I uncheck these three values ​​in store 2, at that point in store 2, we will no longer have the 00:13:05.480 --> 00:13:11.560 variations containing these different colors. So a very easy way to differentiate the 00:13:11.560 --> 00:13:15.920 types of products available depending on the stores. So you have it here for the values, 00:13:15.920 --> 00:13:20.240 but you also have it for the entire attribute groups. H so for example here this 00:13:20.240 --> 00:13:26.840 group here 8 which corresponded to the dimensions, well I see that precisely uh I only created it in 00:13:26.840 --> 00:13:33.160 store one as well as my group here the other group which corresponds to the frame. Why does it 00:13:33.160 --> 00:13:40.360 only exist in store one? Because when I created my two groups 00:13:40.360 --> 00:13:45.800 here in my control panel in my store tab, I had only selected 00:13:45.800 --> 00:13:52.040 store one. If I had selected several stores, any stores, well my 00:13:52.040 --> 00:13:59.520 group, my newly created groups would have been automatically associated with these stores. 00:13:59.520 --> 00:14:03.680 At the group level, you have other properties that you can play with. 00:14:03.680 --> 00:14:10.240 You have a column allowing you to define whether the group contains colors and another 00:14:10.240 --> 00:14:17.480 property here a little hidden which allows you to define the type of selection in the product page. 00:14:17.480 --> 00:14:20.240 I showed you earlier when I created my two groups. I defined them as 00:14:20.240 --> 00:14:25.360 select type but you can change it after the fact, eh, switch to radio type or 00:14:25.360 --> 00:14:30.720 color type. So in principle when we select color here, which indicates once again 00:14:30.720 --> 00:14:36.640 that the values ​​are colors. Often, we choose the selector of type color, 00:14:36.640 --> 00:14:43.320 it's still more practical. And finally for the groups, you also have a position argument 00:14:43.320 --> 00:14:49.400 which allows you to define the display order of the groups in the product pages, eh. So 00:14:49.400 --> 00:14:54.560 in how to say, it will allow you to define when someone wants to buy a product 00:14:54.560 --> 00:14:57.800 the order in which they must choose the different attributes. Maybe you ask it to 00:14:57.800 --> 00:15:02.160 first choose the size before choosing, for example, the color. So you're going to define that 00:15:02.160 --> 00:15:06.560 here. And I'll show you later how to modify that in bulk. So here, I worked 00:15:06.560 --> 00:15:11.440 in a single language. But if your Prestashop is multilingual, your store is multilingual, 00:15:11.440 --> 00:15:16.160 know that here you have a language button that allows you to display other tables that were a 00:15:16.160 --> 00:15:23.600 little hidden here which are the translation table. So for each of your values, sorry, 00:15:23.600 --> 00:15:29.280 your attribute values, here you can define a translation per language. So here, 00:15:29.280 --> 00:15:32.640 I only have French, but if I had several languages, I would have several rows and I could 00:15:32.640 --> 00:15:38.880 work in my different translations here. And the same thing here for your group names. You 00:15:38.880 --> 00:15:46.320 have a column here with the language, the language, sorry, and your two names, the computer name, let's 00:15:46.320 --> 00:15:52.400 say, and the public name of your attribute group. So, know, it's important that these tables 00:15:52.400 --> 00:15:59.080 allow you to make mass edits with the right click and then the famous Magic Edit function that I already explained in 00:15:59.080 --> 00:16:05.240 my review. So there, you can fill in, modify your group names, your 00:16:05.240 --> 00:16:12.280 value names with the Magic Edit tools. You have another very interesting function, 00:16:12.280 --> 00:16:17.800 not very well known. Let's imagine that in addition to your color group here, you want to create a 00:16:17.800 --> 00:16:23.560 second group that you will call color 2. For example, if you have sets of 00:16:23.560 --> 00:16:28.080 pieces that are composed of two different colors, one for the top, one for the bottom, 00:16:28.080 --> 00:16:34.880 well you can create a second group of colors. For example, I will call color 00:16:34.880 --> 00:16:41.160 color bottom for example that I will define this time of type color and type with a 00:16:41.160 --> 00:16:46.760 selection of type color. I validate. And once your group is selected, normally 00:16:46.760 --> 00:16:51.120 I would have to start again here to recreate all my values. Well, it's not necessary. In 00:16:51.120 --> 00:16:56.880 Done, you just have to select the other color group, select the colors 00:16:56.880 --> 00:17:02.320 that you want to copy from the first group to the second. So for example, I'm going to select 00:17:02.320 --> 00:17:07.480 a few. So it can be all of them of course. Here, I'm going to take these six. 00:17:07.480 --> 00:17:12.400 And once they are selected, I'm going to click here on the clone button. And I could 00:17:12.400 --> 00:17:16.560 also, before doing it, select a third group, eh. That is to say, you can 00:17:16.560 --> 00:17:22.160 copy from one group to a multitude, sorry, of other groups. Here, I click on 00:17:22.160 --> 00:17:28.560 clone, it tells me that it's going to duplicate. And so now, if I select my color group below, 00:17:28.560 --> 00:17:34.000 you see, I have the six colors that I retrieved from my other group. So 00:17:34.000 --> 00:17:41.080 a very quick function like that to fill groups of properties, let's say similar. You 00:17:41.080 --> 00:17:47.280 can also of course select and delete colors, finally attributes, or even 00:17:47.280 --> 00:17:52.600 groups of attributes. So you have a delete button here, eh. So you make a multi-line selection 00:17:52.600 --> 00:17:57.040 and you click delete here to delete the values. Or here you take 00:17:57.040 --> 00:18:02.000 a new color group and you click delete here to delete it. So, 00:18:02.000 --> 00:18:05.960 let's see now that you know how to create attribute groups and attribute values, 00:18:05.960 --> 00:18:11.120 how to associate them with variations. So, I'm going to start by simplifying the display a little. 00:18:11.120 --> 00:18:16.040 I'm going to take my variations here. For example, I'm going to take the first two of 00:18:16.040 --> 00:18:19.880 this product. I'm also going to take the first two of the second product to show that we 00:18:19.880 --> 00:18:24.720 can work on several products at the same time. And then for these four variations, 00:18:24.720 --> 00:18:31.680 I'm going to associate a dimension with them. So I go to dimension and I take my 10 15. Here, I 00:18:31.680 --> 00:18:37.960 select it and I'm going to associate it. So for that, it's very simple. Here you have a column, 00:18:37.960 --> 00:18:43.960 you see with a string marked variation. Well, all you have to do is click in this checkbox 00:18:43.960 --> 00:18:52.040 for the association to be made. So I see it here. So I have the information that attribute 00:18:52.040 --> 00:18:57.360 36, so it's this one, that is to say, which is called, which contains the value 10 15, is currently 00:18:57.360 --> 00:19:03.360 associated with my selected declinations. So I see it there or I see it here. Here it flashes 00:19:03.360 --> 00:19:10.160 to indicate to me that the attribute list here has not been refreshed. So if I obey it, 00:19:10.160 --> 00:19:16.840 I do a refresh, you see, I find my values ​​which were associated with my 00:19:16.840 --> 00:19:24.000 four declinations. So, we will sort according to this to find them grouped like that, it's cleaner 00:19:24.000 --> 00:19:32.800 . Now, I will take my four other declinations. So, these two, it's these 00:19:32.800 --> 00:19:40.160 two as well. And I will click here on the 2030 to associate them. Now that that's done, 00:19:40.160 --> 00:19:54.320 I will take a 10 15, a 20 30 15 30 and I will take my group, I look for it, uh, frame. 00:19:54.320 --> 00:20:02.440 There you go. And for these four, I will choose a frame. And then for the other four, 00:20:02.440 --> 00:20:10.560 I'm going to refresh so I don't get lost. So here I'm getting a little lost because I have what 00:20:10.560 --> 00:20:17.160 we call breaks. So I'm going to delete these breaks. We're going to click here. There you go. And then 00:20:17.160 --> 00:20:23.240 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 00:20:23.240 --> 00:20:28.880 a break on this column. So I'm finding my way around better. So I've grouped my lines by 00:20:28.880 --> 00:20:39.000 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 00:20:39.000 --> 00:20:46.560 haven't chosen one yet for this one and this one. I mean I'm taking a frame and then I'm going to 00:20:46.560 --> 00:20:53.920 take the others, this one and this one. And then this one and this one. And then I ask and say 00:20:53.920 --> 00:20:59.440 that I don't want a frame. There you go, normally that's it. I'm refreshing. I've made my 00:20:59.440 --> 00:21:07.920 attribute association. It works. However, we agree, it's still quite long. Here, 00:21:07.920 --> 00:21:13.200 I really worked manually practically variation by variation. So we get there 00:21:13.200 --> 00:21:18.120 but we get there if we have a number, let's say, relatively limited number of variants. So the interest 00:21:18.120 --> 00:21:22.040 of Merlin anyway in manual mode is that there I worked on two products but I could have 00:21:22.040 --> 00:21:26.800 work on many more products at the same time. However, there is still a 00:21:26.800 --> 00:21:31.320 much more efficient method which consists of using what is called the generator. So that's what 00:21:31.320 --> 00:21:36.040 we'll see in a moment. However, before launching the generator, I'm going 00:21:36.040 --> 00:21:42.440 to show you an interesting feature. When you select a variation line here, 00:21:42.440 --> 00:21:48.880 well automatically at the bottom in both tables, you are shown the properties, the 00:21:48.880 --> 00:21:56.480 attributes of the selected variation or variations. So here, if I take two, so 00:21:56.480 --> 00:22:02.000 there is a color code to indicate to me that so here in blue for example, it tells me that both, 00:22:02.000 --> 00:22:09.160 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 00:22:09.160 --> 00:22:14.480 , it tells me that we have different values ​​for the two. So indeed there, 00:22:14.480 --> 00:22:18.560 it's the same. There, I have a yes, I have a no. So there, it's orange for both. It tells me that 00:22:18.560 --> 00:22:23.040 at least one of the two has a yes value, at least one of the two has a no value. 00:22:23.040 --> 00:22:31.080 If I take this one and this one for example, well it tells me that both have a no value 00:22:31.080 --> 00:22:37.360 for the frame property. And that not only allows you to quickly see the 00:22:37.360 --> 00:22:41.480 common attributes of the different variations in this table, but above all it allows you to modify it. 00:22:41.480 --> 00:22:50.640 If for example this one, I wanted to change it from 10 15 to where is my dimension? Here it is at 2030, 00:22:50.640 --> 00:22:56.240 I just have to check here and automatically the change is made. So there, it may 00:22:56.240 --> 00:23:02.600 not be relevant for this variation. We will start again on another product to show you 00:23:02.600 --> 00:23:07.400 the interest of this. Here, for example, I choose my chiffon dress. My chiffon dress, 00:23:07.400 --> 00:23:15.960 it exists in green and yellow. Do we agree? I could manually have fun changing the 00:23:15.960 --> 00:23:20.280 properties, redoing my variations and so on if ever I had a color change. But in 00:23:20.280 --> 00:23:27.000 fact, it's simpler, for example, to say I'm going to take all the green variations. So 00:23:27.000 --> 00:23:31.400 here, you can filter on the color, excuse me, I'm filtering, 00:23:31.400 --> 00:23:36.520 I'm going to make it equal to or contains, whatever the word green is. So I have all the 00:23:36.520 --> 00:23:43.360 green variations that appear and only this one. I select them all. There you go. Here, I choose 00:23:43.360 --> 00:23:51.320 my property or my color attribute group. It shows me well, so I don't know if I can 00:23:51.320 --> 00:23:57.600 show it to you, I no longer have the elevator. Here, my color is green. But if, for example, 00:23:57.600 --> 00:24:02.760 I wanted to replace all the green variations with another color, for example red, 00:24:02.760 --> 00:24:07.800 I click on red and that's it. All my variations of my product have become red 00:24:07.800 --> 00:24:12.960 instead of green. So, we're going to refresh, show. So there, I no longer have anything appearing 00:24:12.960 --> 00:24:19.840 because of my filter. Precisely, we're going to delete the filter. I'm going to do it here. You don't know. 00:24:19.840 --> 00:24:26.080 Delete all the column threads. There you go. And you can see that now I have red or yellow dresses 00:24:26.080 --> 00:24:32.360 , but I no longer have green. So a very quick tool, simply by clicking in this 00:24:32.360 --> 00:24:39.320 column, to modify the value of an attribute on an infinite number of variations of an infinite number 00:24:39.320 --> 00:24:43.680 of products at once. So this time, I'm going to do the same operation, namely creating four 00:24:43.680 --> 00:24:48.600 variations on two products, but I'm going to do it with the generator so you can see the difference 00:24:48.600 --> 00:24:52.600 in speed. So I'm going to take two products like before. The same thing. We can see 00:24:52.600 --> 00:24:59.600 that they don't have a variation yet, are we okay? I'm going to quickly choose my two 00:24:59.600 --> 00:25:04.760 properties here, so my two groups of attributes, frames and dimensions. I select them both 00:25:04.760 --> 00:25:10.880 . I click on everything here to select my four different values, and I launch the 00:25:10.880 --> 00:25:16.200 generator either with this button or this one. So, I'm going to take this one because it has 00:25:16.200 --> 00:25:19.880 the advantage of automatically filling the generator with the lines that I've already 00:25:19.880 --> 00:25:26.920 selected. So, I launch my generator. There you go, it opens. So, I'm not going to explain it to you 00:25:26.920 --> 00:25:30.800 in detail right now, I'll just show you the usage quickly. In step one, I choose 00:25:30.800 --> 00:25:36.400 the generator. In step 2, I ask it to delete the existing variations or 00:25:36.400 --> 00:25:41.920 possibly keep them. Here in the example we are dealing with, it's exactly the same thing 00:25:41.920 --> 00:25:49.160 since there aren't any yet. Step 3, normally I fill my table with values. I've 00:25:49.160 --> 00:25:55.680 already selected them and by clicking on the generator button here, it filled my table 00:25:55.680 --> 00:26:01.400 with my values. I just have to select them to say that I'm going to use them because I 00:26:01.400 --> 00:26:04.920 could also decide at that point, for example, not to use the 10 15. 00:26:05.480 --> 00:26:08.640 So we still have a second choice if you want or a second level of choice. So I 00:26:08.640 --> 00:26:14.560 select my attribute values. I continue. I go to step 4. Step 4 is actually already 00:26:14.560 --> 00:26:18.760 done. It's about selecting the products for which I want to generate or modify 00:26:18.760 --> 00:26:25.480 variations. It's already done. I go to step 5. I click on generate and it's finished. If I 00:26:25.480 --> 00:26:31.920 create my generator, I click on refresh, and I immediately have all my variants 00:26:31.920 --> 00:26:38.120 that have been created. So my eight variations have been created, and it took, as you can see, less than 00:26:38.120 --> 00:26:43.560 a minute. But besides its speed, this generator has many other advantages. For example, it's very 00:26:43.560 --> 00:26:49.520 easy with this generator to take products that already have variations 00:26:49.520 --> 00:26:55.680 and modify them without having to delete them and start again. Let's imagine, for example, that at some point 00:26:55.680 --> 00:27:02.520 we create a third dimension. So I'll do it quickly. I go to dimension, 00:27:02.520 --> 00:27:10.440 I create a new dimension that I'll call 30 40, and I validate. And I would like to add this 00:27:10.440 --> 00:27:16.760 dimension to my variations. In any case, recreate variants but with the 3040 in addition. 00:27:16.760 --> 00:27:22.680 At that point, I just have to select my 30 40, click on the generator again here, 00:27:22.680 --> 00:27:28.360 which adds my value to my generator. So, with the generator still open, 00:27:28.360 --> 00:27:33.760 you have a button here to access it quickly. So I click there and you see, I end up 00:27:33.760 --> 00:27:38.800 with the same tool as before with it memorized my settings and I have my value 30 40 00:27:38.800 --> 00:27:46.520 here which was added. Well I take my attributes, I go directly back to my step 5 00:27:46.520 --> 00:27:54.800 and I generate again. It's finished. I come back here, it flashes, I refresh and I see that it 00:27:54.800 --> 00:28:04.080 has indeed added two variations per product, one for with or without frame in 30 40. 00:28:04.080 --> 00:28:07.880 But what is important to understand is that the variations that already existed in 00:28:07.880 --> 00:28:14.080 2030 and in 10 15, they have not been deleted. That is to say that if you had assigned them a 00:28:14.080 --> 00:28:19.040 price or a quantity, at that time, it was kept. Whereas if you try to do the 00:28:19.040 --> 00:28:23.960 same thing in Prestashop, it will necessarily delete everything and you will have to recreate 00:28:23.960 --> 00:28:29.360 additional variations by also recreating all the ones that it will first delete. So 00:28:29.360 --> 00:28:34.160 you're going to lose the properties, whether it's prices, quantities, references, and so on. 00:28:34.160 --> 00:28:39.640 So with Merlin, you have what's called an incremental generator, which takes into account the 00:28:39.640 --> 00:28:45.480 existing product in addition to being multi-product, as you may have noticed. So here, I've created 00:28:45.480 --> 00:28:49.720 two additional variations in each of my two products selected above. Okay, 00:28:49.720 --> 00:28:53.920 now that you've seen how to briefly use the variation generator, 00:28:53.920 --> 00:28:58.400 I'm going to show you some more advanced functions of this same tool. So, 00:28:58.400 --> 00:29:03.080 let's start with another product, for example. This time, I'm going to start with this one. 00:29:03.080 --> 00:29:08.200 I'm going to launch the generator this time with this button here, or it's already 00:29:08.200 --> 00:29:13.640 open, so it's smarter to click there directly. So the first thing to see 00:29:13.640 --> 00:29:17.800 is that this tool is actually two tools in one. You have a generator that we've 00:29:17.800 --> 00:29:22.320 already used partially, and then you also have an impact modifier. So I 00:29:22.320 --> 00:29:27.960 'll show you the impact modifier later, but briefly explained, the impact modifier doesn't 00:29:27.960 --> 00:29:33.480 generate new variations, it only modifies the price impact and/or weight impact of 00:29:33.480 --> 00:29:39.880 existing variations. Well, for now, let's stick with the generator. We go to step 2. And 00:29:39.880 --> 00:29:46.400 In step 2, there you have several possible options. So the first is to delete 00:29:46.400 --> 00:29:51.320 all existing variations of the products we are going to work on and we regenerate 00:29:51.320 --> 00:30:00.680 from a blank page. A bit like what Prestaop does. The second option is to recalculate 00:30:00.680 --> 00:30:07.720 the impacts of the variations that are already created, that already exist, so that it 00:30:07.720 --> 00:30:15.120 is similar to the new variations that we are going to create. That is to say, we will create 00:30:15.120 --> 00:30:25.320 new variations by specifying in step 3 price impacts, weight impacts. So in 00:30:25.320 --> 00:30:29.400 addition to creating these new variations, those that already exist, they will be maintained, 00:30:29.400 --> 00:30:34.920 preserved but their impact will be modified. Typically, if for example you have put 00:30:34.920 --> 00:30:42.720 the fact that the 2030 format cost €5 more in step 3, at that point, the variations already 00:30:42.720 --> 00:30:47.640 existing in 2030 will also have a modified price impact. So they will also want 00:30:47.640 --> 00:30:54.200 €5 more. The third option allows you to keep existing variations unchanged. 00:30:54.200 --> 00:30:58.600 So we don't touch them, we don't delete them, and we don't modify their 00:30:58.600 --> 00:31:07.000 price impact or their weight impact. And we will only regenerate the new ones that we request. 00:31:07.000 --> 00:31:12.920 This is the old manual mode that still exists out of habit, but in fact, it 00:31:12.920 --> 00:31:18.240 comes down to exactly the same thing as using the new button here that I showed you 00:31:18.240 --> 00:31:22.240 earlier, which allows you to create new lines empty of any attributes. So you will 00:31:22.240 --> 00:31:27.160 probably never use this. But there you go, it's kept here for those who are used to working 00:31:27.160 --> 00:31:33.920 like this. And finally, you have a fourth mode, a fifth mode, sorry, which is not recommended when 00:31:33.920 --> 00:31:37.960 you have to create a lot of variations, but which is very practical when you simply want 00:31:37.960 --> 00:31:43.720 to duplicate some of the variations of a product to other products. Again, 00:31:43.720 --> 00:31:48.080 it works well when you're working on a limited number, but don't use this tool, this 00:31:48.080 --> 00:31:54.840 function on I would say more than a hundred variations, it would take too much time. Then, 00:31:54.840 --> 00:32:00.160 whatever mode you choose here, you have options for automatically filling 00:32:00.160 --> 00:32:06.240 your variations. For example, you can define a quantity for them. So all new 00:32:06.240 --> 00:32:12.160 variations will have a quantity of 5. You can also fill the quantity by taking the 00:32:12.160 --> 00:32:22.040 current quantity of the product. So if my product behind has a quantity here of 10, 00:32:22.040 --> 00:32:26.600 well when I generate the variations on this product, 00:32:26.600 --> 00:32:30.280 each of my variations will have a quantity of 10. So if I 00:32:30.280 --> 00:32:34.520 generate 10, my product will have a quantity of 10 x 10 100. 00:32:37.240 --> 00:32:44.200 And 3rd option, only the default quantity, excuse me, only the default variation 00:32:44.200 --> 00:32:49.320 of the product will take as its quantity that of the product. So if I take the same product 00:32:49.320 --> 00:32:53.840 which has a quantity of 10, well one of these variations, the one that is created first, 00:32:53.840 --> 00:32:58.040 which will be the default variation will have a quantity of 10 and all the others will have 00:32:58.040 --> 00:33:02.720 a quantity of zero. So with this mode, we respect the initial quantity for the product. 00:33:02.720 --> 00:33:08.480 The product will always have a quantity of 10 overall. And the second line allows you 00:33:08.480 --> 00:33:14.600 to fill in the reference of these variations. So you can either, for example, with this option, 00:33:14.600 --> 00:33:19.600 copy the current reference of the product into the reference of your variations or, on the contrary, 00:33:19.600 --> 00:33:24.360 put a reference that you fill in by hand, like "dream" for example, followed by something, 00:33:24.360 --> 00:33:32.800 for example, followed by nothing, or followed by the PrestaShop identifier number of the variation created. 00:33:32.800 --> 00:33:38.560 So a number or a counter, a counter that starts at 1 and counts as 00:33:38.560 --> 00:33:44.040 the variations are created. And then here you have the separator. So typically, if I 00:33:44.040 --> 00:33:51.160 take this, for example, I will have my references that will be filled with a dash and then the 00:33:51.160 --> 00:33:56.560 number of the variation. Let's take an example. I'm going to ask it to delete the 00:33:56.560 --> 00:34:00.800 existing variations and recreate them. So for that, I'm going to take a product that already has some. 00:34:00.800 --> 00:34:08.000 We agree, it has some variations. I go back to my generator. So I choose 00:34:08.000 --> 00:34:14.000 the delete option. I go here and I'm going to ask it to only use the 10 15 00:34:14.000 --> 00:34:17.680 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 00:34:17.680 --> 00:34:26.520 don't want to take the frames. I go to my step 5, I generate. So, it tells me, it warns me, 00:34:26.520 --> 00:34:30.280 it tells me "That's weird, I didn't select all the attribute values ​​that were filled 00:34:30.280 --> 00:34:37.400 in step 3." It doesn't matter. I say to continue like this. There, it's finished. What happens 00:34:37.400 --> 00:34:43.280 now? I have more than two variations. The 2030, list 15. We agree, it 00:34:43.280 --> 00:34:48.080 deleted everything that existed. It started again with only the values ​​chosen here. Well 00:34:48.080 --> 00:34:52.880 now, I'm going to do something else. I'm going to choose the second mode. In the second mode, 00:34:52.880 --> 00:34:58.080 it keeps the variations already created and it recalculates their price impact in relation to the data 00:34:58.080 --> 00:35:04.360 that we will enter in step 3. And then it creates the new ones requested. So for example here, I 00:35:04.360 --> 00:35:09.000 'm going to ask him for a variation, or rather an additional attribute. She asked him to create 00:35:09.000 --> 00:35:14.600 the variations using this attribute. And then I'm going to tell him that for 2030, I want a 00:35:14.600 --> 00:35:20.960 price impact. So with a tax of 20, I want a price impact of 10, that is to say a price impact excluding tax 00:35:20.960 --> 00:35:29.880 of 833. Then I select the three attributes. All I have to do is generate to recalculate the 00:35:29.880 --> 00:35:35.880 impacts of the existing variations and create the new one, that is to say the one in 30 40. 00:35:35.880 --> 00:35:40.760 But before doing that, I'm going to come back here in my main window to look at the number 00:35:40.760 --> 00:35:44.200 of the variations to show you that they don't change, they are not replaced 00:35:44.200 --> 00:35:51.200 but they are simply updated. See, it's 805 and 804. So I come back here, I go to 00:35:51.200 --> 00:36:01.280 my step 5 and I generate. Remember 805 804. I continue. There you go, it's generated. I'm coming back, I'm 00:36:01.280 --> 00:36:10.520 refreshing. What do we see? Here we have our 805 and our 804 which have been modified. Finally 00:36:10.520 --> 00:36:16.400 the 805, so the 805 is in 2030, it has recovered the price impact that I asked it to. So it 00:36:16.400 --> 00:36:22.080 hasn't been deleted, it has simply been updated and then the 3040, the new variation has 00:36:22.080 --> 00:36:29.680 been created. It doesn't have a price impact because I didn't specify one. Step 3 on this line. 00:36:29.680 --> 00:36:34.120 So 3rd exercise, this time, I choose the third mode. So I ask it to keep 00:36:34.120 --> 00:36:39.760 the existing variations identical and to generate only the variants. So here 00:36:39.760 --> 00:36:48.680 for example, we are going to modify the price impact of 2030 or 10, I will set it to 15 and then I will 00:36:48.680 --> 00:36:52.640 regenerate. Same here, I will select these three variations. So, I'm not creating new ones, 00:36:52.640 --> 00:36:57.120 but I'm regenerating them. And what are we going to see in this case? It might not be relevant to do 00:36:57.120 --> 00:36:59.840 that. I'm just realizing, you won't understand. So we're going to recreate another 00:36:59.840 --> 00:37:10.080 dimension. So I live in dimension, I create a new one. We're going to create a 40 by 50. 00:37:10.080 --> 00:37:15.560 A large size and I validate. Here's this 40 by 50, I want to add it to my generator. 00:37:15.560 --> 00:37:19.280 Just select it and click on this button here. I'm going to go back to 00:37:19.280 --> 00:37:24.680 my generator. We can clearly see that the 40 by 50 has been added here. So I take it. 40 by 50. I'm 00:37:24.680 --> 00:37:34.240 also going to give it a price impact. I'm going to tell it that this one costs €30. I select 00:37:34.240 --> 00:37:39.320 my four variants and I generate. And in fact, what I want to show you is that the €15 00:37:39.320 --> 00:37:46.920 here is not going to be impacted by the one that already exists. That is to say, this one, I 00:37:46.920 --> 00:37:54.680 no longer have its number, excuse me. 805 currently has a value of 10. It will remain at 10 because in 00:37:54.680 --> 00:37:59.000 my choice in step 2 here, I asked it to keep the existing variations identical 00:37:59.000 --> 00:38:06.840 . There you go, let's try. I generate, I continue, I return to my main window. 00:38:06.840 --> 00:38:13.120 We're going to refresh. So this time, we should have an additional variation. So here, 00:38:13.120 --> 00:38:21.400 it has 808. So and it is in large size 4050. It has a price impact of 25. And then what 00:38:21.400 --> 00:38:28.160 we had said my 805 here the old one which is in 2030, it had an impact of 10, it remained at 10 although 00:38:28.160 --> 00:38:34.560 indeed step 3, I had specified a different price for the 2030. It is only 00:38:34.560 --> 00:38:41.120 if I had declared new 2030 variations that at this moment it revalues ​​15. 00:38:41.120 --> 00:38:47.280 So we're going to do it. For example, I'm going to ask it this time to take this into account. 00:38:47.280 --> 00:38:52.120 So it's going to generate a lot more variants for me. And at that point, we'll see that all those 00:38:52.120 --> 00:39:04.360 in 2030 will want 15. Step 5. I validate. It's finished. I refresh. There you go. So 00:39:04.360 --> 00:39:13.320 we're going to look for one that's 20 30 here. 2030 with Yes. Well, look, it's worth 15. 00:39:13.320 --> 00:39:23.000 Whereas my initial variation in 2030, if I find it, here it is. So the 805, 00:39:23.000 --> 00:39:28.840 it stayed at €10. Another exercise, I'm going back to the generator and this time 00:39:28.840 --> 00:39:33.600 I'm going to show you the duplication mode. So, this duplication mode is used to take 00:39:33.600 --> 00:39:38.440 the variations of a product and duplicate them in another or in a selection of others. 00:39:38.440 --> 00:39:46.840 So for example here, we're going to take this. We're going to go to step 4. And in step 4, it 00:39:46.840 --> 00:39:52.560 asks us to select the items to modify. So it asks us to select from 00:39:52.560 --> 00:39:58.000 table A here at the top the products in which the tool must duplicate the combinations as well as 00:39:58.000 --> 00:40:03.800 the product containing the existing combinations to clone and then to select the combinations 00:40:03.800 --> 00:40:10.160 that we want to duplicate belonging to this last product. So look there, I have a 00:40:10.160 --> 00:40:15.920 product that says combination. Let's imagine that I want to duplicate the I don't know, we'll take 00:40:15.920 --> 00:40:20.480 the 20 30. Yes and no these two. Okay. But I'm going to duplicate them in other products that 00:40:20.480 --> 00:40:25.520 don't have any. So we'll choose other products that don't have any. So I'll take this one 00:40:25.520 --> 00:40:28.600 and then I'll take products further down the list. I know they don't have a combination. 00:40:28.600 --> 00:40:35.680 Here are the 307 and the 308. Look, I have variations for the 302. We agree, 00:40:35.680 --> 00:40:40.880 I don't have any for the 307 and 308. Well, in the 302 now, I'm going to choose the variations 00:40:40.880 --> 00:40:47.120 I want to duplicate. So I said I wanted to take this one, the 2030 yes and the 2030 no with 00:40:47.120 --> 00:40:54.600 their impact here at €15. There you go, I duplicate that. So for that, I go back to my generator. 00:40:54.600 --> 00:41:00.800 So I did my step 4, I go to step 5 and I duplicate. By the way, see that in step 3, 00:41:00.800 --> 00:41:04.840 we can't do anything gray them out. Here, we don't need to choose attribute values ​​and so on. In 00:41:04.840 --> 00:41:09.320 fact, it's simply the selection we made here in the table that takes into account import parameters 00:41:09.320 --> 00:41:14.240 . So, I'm going to step 5 and I generate. So there, it's a little longer. So, 00:41:14.240 --> 00:41:17.160 it took 2 seconds instead of 1 second, let's say. But again, if you 00:41:17.160 --> 00:41:20.920 do this on a large number of products, a large number of lines, it can be quite slow. 00:41:20.920 --> 00:41:26.480 So it's best reserved for moderate use. No matter. I go back to my window. 00:41:26.480 --> 00:41:31.720 I click on refresh. This time, I still have my variations of product 302 00:41:31.720 --> 00:41:37.040 and you see my products 307 and 308 have received the two variations that I selected 00:41:37.040 --> 00:41:41.560 with exactly the same parameters, the same references, also the same prices and so on 00:41:41.560 --> 00:41:47.400 . So we're really doing identical duplication. So, I go back to the generator 00:41:47.400 --> 00:41:54.120 and this time, we're going to go back to a standard mode, for example, to delete and 00:41:54.120 --> 00:41:58.080 create new variations. But I would like to show you the different possibilities we have 00:41:58.080 --> 00:42:04.440 in step 3. So, so far, what I've shown you is how to fill the list of 00:42:04.440 --> 00:42:12.440 variations here by going to the main window in the list of attributes here by 00:42:12.440 --> 00:42:18.200 selecting, I show you different groups of attributes, different 00:42:18.200 --> 00:42:26.440 attribute values ​​and then clicking on the generate button. And when we do that, I show you again. 00:42:26.440 --> 00:42:32.440 When I click on the generate button, it automatically fills the table here. So 00:42:32.440 --> 00:42:39.120 this function is the same as the one you have here. Add the selected attributes 00:42:39.120 --> 00:42:45.840 in the main window. When I click there, it takes the attributes that I chose here. If 00:42:45.840 --> 00:42:52.160 , for example, I take another one here, the 4050 that I have in my generator, if I click here, 00:42:52.160 --> 00:42:56.600 it adds it to my list. Okay? So that's the first method to fill the list 00:42:56.600 --> 00:43:01.320 here of variations, sorry, of attributes in order to then produce variations. But there 00:43:01.320 --> 00:43:06.600 There's a second method, so I start by deleting. The second method is the one 00:43:06.600 --> 00:43:13.640 that consists of adding the attributes of the selected variations. That is, I 00:43:13.640 --> 00:43:21.360 return to my main window. Here I have variations. Let's suppose that I take 00:43:21.360 --> 00:43:28.640 a few at random. Uh, I'll take this one for example and then this one. 00:43:28.640 --> 00:43:34.720 So this one is in 2030 with a frame. This one is in 2030 without a frame. Well, I go back to my 00:43:34.720 --> 00:43:42.840 generator and I click here. Well, you see, it fills my attribute table here with 00:43:42.840 --> 00:43:48.800 2030. Frame yes, frame no because these are the attributes used by these variations. 00:43:48.800 --> 00:43:52.600 So this button allows you to basically retrieve attributes from any variation, 00:43:52.600 --> 00:43:59.080 from any product to produce the same variants. So typically, what is it used for? Well, 00:43:59.080 --> 00:44:05.240 it's used to duplicate all parts of the variations of a product to other products. For example, I can very 00:44:05.240 --> 00:44:08.880 well select all the variations of a product except for a few 00:44:08.880 --> 00:44:13.320 attributes. Well, except for some that use attributes that I can use. Then 00:44:13.320 --> 00:44:19.720 select them and generate the same variations on other products. There's something 00:44:19.720 --> 00:44:27.240 very close to that. So here I'm going to select everything and delete it. It's this button here 00:44:27.240 --> 00:44:32.320 and that adds the attributes of the products I select to our list. So here, it's more 00:44:32.320 --> 00:44:37.880 global. For example, I come back to my main window, I take a product. So this one, 00:44:37.880 --> 00:44:45.840 there are no variations, that's not smart. We'll take one higher up, sorry. So we'll take 00:44:45.840 --> 00:44:53.960 this one for example. So it has variations. 20 30 yes. 20 30 no. 10 15 yes and no. Well, 00:44:53.960 --> 00:44:58.080 I didn't even display these variations, just to show that we don't need to display them. So 00:44:58.080 --> 00:45:03.400 I find myself in my generator, my product is selected and I click here to add the 00:45:03.400 --> 00:45:08.520 attributes. Well, here I find my 10 15, my 2030. Yes and no because these are all the 00:45:08.520 --> 00:45:14.840 attributes used in the variations of this product. I'll show you the 2030 in yes no, 00:45:14.840 --> 00:45:20.760 the 10 15 in yes no. We've recovered the same attributes and this tool can go a little 00:45:20.760 --> 00:45:30.840 further. That is to say, from here, I can select them all and use this button here which 00:45:30.840 --> 00:45:41.240 will fill the table with the price and weight impacts of the attributes here taken from the product that 00:45:41.240 --> 00:45:46.040 is selected below, provided of course that it has impacts. So does it? It 00:45:46.040 --> 00:45:49.280 may not be relevant. So this one has no impact. You see, I don't have a price impact 00:45:49.280 --> 00:45:55.600 here. So I'm going to take another one. I think we created one from memory in this one 00:45:55.600 --> 00:46:00.520 either. There you go. Wait, what we're going to do at this point is we're going to select them all. 00:46:00.520 --> 00:46:06.400 We're not going to bother. So here, I have all my products selected and then we're going to scroll down a 00:46:06.400 --> 00:46:14.120 little and find a product. Here, this one, you see, has impacts. So, I don't really know 00:46:14.120 --> 00:46:21.240 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 00:46:21.240 --> 00:46:27.960 4050 because we find it there. But it doesn't matter. Basically, I just need to select my 00:46:27.960 --> 00:46:35.880 product at the top. So here, it's product 302. So I'm going to take just this one. There, 00:46:35.880 --> 00:46:42.160 I select it. I go to my generator. We're going to start the process again completely. So I 00:46:42.160 --> 00:46:48.000 'm going to delete everything. So first, I add the products, the attributes, sorry, of the 00:46:48.000 --> 00:46:54.640 selected product 302. There they are all. I select them and I click on replace 00:46:54.640 --> 00:47:00.440 impacts. And there, you see, I automatically retrieve in my table my impacts excluding 00:47:00.440 --> 00:47:07.680 tax and including tax of my product. What use is that to me? Well, simply generate other 00:47:07.680 --> 00:47:13.720 equivalent variations on any other product. For example, this one and this one. So 309 and 00:47:13.720 --> 00:47:19.720 310 don't have variations. I go back to my generator. I've retrieved the attributes and 00:47:19.720 --> 00:47:29.040 impacts of another product. All I have to do is go to step 5 to generate. There you go, it's done. 00:47:29.040 --> 00:47:36.680 I come back here, I refresh and you see, I've generated exactly identical variations with 00:47:36.680 --> 00:47:43.600 the same impacts. So to summarize, what I just showed you is that by using 00:47:43.600 --> 00:47:50.840 Any of these three methods here, using these buttons here, this one and this one, 00:47:50.840 --> 00:47:56.760 we could retrieve attributes and impacts from another product or from a selection of 00:47:56.760 --> 00:48:02.480 variations of another product. to duplicate them in other products. So it's a 00:48:02.480 --> 00:48:07.640 duplication tool, but very flexible, eh. You can choose the attributes yourself, you can choose 00:48:07.640 --> 00:48:12.760 the variations you want to duplicate yourself, and it's very fast. The script behind it is very 00:48:12.760 --> 00:48:17.560 powerful, it runs in a few seconds. So it's another method, perhaps a little 00:48:17.560 --> 00:48:22.560 more complicated to implement, but much faster to execute, to duplicate 00:48:22.560 --> 00:48:28.000 variations of a product to other products. It replaces the other method we 00:48:28.000 --> 00:48:33.800 saw earlier, which was this one. So there's a duplication function that doesn't require you 00:48:33.800 --> 00:48:39.320 to choose the attributes, etc. It simply requires you to select the variations you 00:48:39.320 --> 00:48:45.080 want to copy. We take two variations for example, that's enough. We have nothing else to do. 00:48:45.080 --> 00:48:50.360 We will then choose another product. Step 5, we duplicate and we have a duplication, a clone of 00:48:50.360 --> 00:48:55.440 these variations. So this is a method, we will say simple to implement but a little slower 00:48:55.440 --> 00:49:00.600 to execute so to be reserved for the number of products and small variations. Otherwise when we 00:49:00.600 --> 00:49:07.840 have a lot of them, at that time, we will use one of the three modes among these. And then, 00:49:07.840 --> 00:49:13.480 in step 3, we will retrieve the attributes with this button of certain variations or retrieve all 00:49:13.480 --> 00:49:20.160 the attributes of a product with this button. Then retrieve the impacts with this other button on 00:49:20.160 --> 00:49:26.840 the lines that we want. I didn't specify this but for example, uh, we will start all over again to show you 00:49:26.840 --> 00:49:32.680 again. If I delete everything, I retrieve all the attributes. Well, when I use this button 00:49:32.680 --> 00:49:37.640 here, I can execute it only on certain lines. So we just need to select only lines 00:49:37.640 --> 00:49:43.640 here. And when I click here, it fills in the attributes and finally the impacts only on these 00:49:43.640 --> 00:49:48.920 two attributes. So this allows you to make cross-editing by recovering certain 00:49:48.920 --> 00:49:53.680 impacts but not others. Basically, you have great flexibility to produce 00:49:53.680 --> 00:50:00.000 variation equivalents with or without the same prices. So these tools can go even 00:50:00.000 --> 00:50:05.280 further. Look, I'm going to delete everything again. Before clicking on add 00:50:05.280 --> 00:50:10.040 the attributes of the selected products, I can actually select several products up there, 00:50:10.040 --> 00:50:17.640 not necessarily just one. For example, I'm going to choose these two items of clothing. 00:50:17.640 --> 00:50:21.520 Here, I click here to recover the attributes. There you go, I've recovered the 00:50:21.520 --> 00:50:28.680 sizes and colors. Well, when I click on this button to recover the 00:50:28.680 --> 00:50:34.560 price impacts of these different attributes of these different products, it's possible that it will find 00:50:34.560 --> 00:50:39.960 a different impact on the first product compared to the second. So at that point, 00:50:39.960 --> 00:50:45.480 it will have to choose. Well, that's what this allows you to do. You will be able 00:50:45.480 --> 00:50:50.040 to choose between the two products the impacts, either of the largest values, or on the contrary 00:50:50.040 --> 00:50:54.240 the smallest values ​​and you will also be able to exclude the null values ​​at the level 00:50:54.240 --> 00:51:00.040 of these impacts. So a great flexibility again here also to duplicate attributes, 00:51:00.040 --> 00:51:05.480 variations of certain products to other products with a very free choice on the 00:51:05.480 --> 00:51:11.280 calculation of the impacts that this will generate. So, I am well aware that in explaining all this to you 00:51:11.280 --> 00:51:17.160 it may seem a little confusing, perhaps a little theoretical and difficult to memorize, 00:51:17.160 --> 00:51:21.680 but the best thing is still to have fun with this tool, eh, to try, to do tests, 00:51:21.680 --> 00:51:26.080 to try the different options, to select several products, to create dummy test products 00:51:26.080 --> 00:51:31.760 and fill them with variations by copying, by generation and so on. Play with the different 00:51:31.760 --> 00:51:37.960 options on the impacts to fully understand all the possibilities that the tool offers you. 00:51:38.600 --> 00:51:45.640 Then so in this tool, I come back to the step, remember, we actually have two tools in one, 00:51:45.640 --> 00:51:50.560 the generator and the impact modifier. So far I have only shown you the generator. 00:51:50.560 --> 00:51:56.560 So this time we're going to focus on using the modifier. Basically, modifier 00:51:56.560 --> 00:52:01.080 is a little simpler. It won't allow you to create or generate new 00:52:01.080 --> 00:52:07.760 variations, but only to recalculate the price and weight impact of the existing one. 00:52:07.760 --> 00:52:13.240 How do you use it? So, we choose modifier. In step 2, we just choose whether 00:52:13.240 --> 00:52:18.480 we want to modify the weight impact or the price impact, or both. By the way, I didn't mention it, but 00:52:18.480 --> 00:52:24.440 this choice also exists when we're in generator mode. We can also decide not to 00:52:24.440 --> 00:52:31.120 modify this or that impact. So here, for example, I'm going to modify the price impacts. You'll be 00:52:31.120 --> 00:52:36.760 able to choose to act on all the variations of product A that I've selected, that is, 00:52:36.760 --> 00:52:41.000 all the variations of my products in general, or act only on the one I've 00:52:41.000 --> 00:52:45.600 selected. So basically, I'll be able to say, well, for example, here, I put a filter, I want 00:52:45.600 --> 00:52:51.440 the small sizes, I select them and at that moment the impact modifier will 00:52:51.440 --> 00:52:57.280 modify the impacts only of this one and not of the other two. For example, I 00:52:57.280 --> 00:53:03.560 go back to my generator in step 3. So, let's suppose that it's empty here. We'll do it again. 00:53:03.560 --> 00:53:11.120 I delete everything. Okay, delete everything and I'll retrieve the attributes of my products. So, 00:53:11.120 --> 00:53:17.960 I add attributes. There, I have all my attributes. I select them all. 00:53:19.200 --> 00:53:27.320 I will retrieve or not, I don't have to, my impacts. 00:53:27.320 --> 00:53:33.000 Here they are. So in fact, there aren't any. So it doesn't matter, there aren't any but I want to 00:53:33.000 --> 00:53:38.440 add some. So for example, I decided that the large would be more expensive. So I'm going 00:53:38.440 --> 00:53:46.520 to give it an impact of Okay, we'll put €50. Here I select everything. In step 4, 00:53:46.520 --> 00:53:51.920 it asks me to select the items to modify. It's already done. Step 5, modify. 00:53:51.920 --> 00:53:59.560 It's going very, very quickly. What happened? If I refresh, I'll see that some 00:53:59.560 --> 00:54:09.160 products here have increased significantly. In fact, we find our impact of €50 on sizes L 00:54:09.160 --> 00:54:15.480 on my two products. So, basically, with the generator in 00:54:15.480 --> 00:54:21.680 impact modifier mode, I simply retrieve my attributes in step 3, retrieve or not the existing impacts. If there are 00:54:21.680 --> 00:54:27.880 any, we will refill the table to reuse them. We can modify some. If there 00:54:27.880 --> 00:54:34.880 was no impact to use during the generation of serious, we can modify them or add some and 00:54:34.880 --> 00:54:40.000 we launch the generation and quite simply it will modify our prices and possibly our weights 00:54:40.000 --> 00:54:46.680 of our variations without having to regenerate them, delete them, reproduce them, etc. So a 00:54:46.680 --> 00:54:55.160 very quick tool to recalculate your prices, uh, without having to redo your variations. Al, I hope 00:54:55.160 --> 00:55:00.080 not to be too heavy, but I would have insisted on one point. When you use this generator or 00:55:00.080 --> 00:55:05.840 this impact modifier, so in step 5, in fact, they only act on the lines 00:55:05.840 --> 00:55:11.720 that are selected here. That is to say, if for example, uh here, I switch the price back, 00:55:11.720 --> 00:55:18.200 I set it to 40 instead of 5 years, okay? And I select, uh, I 00:55:18.200 --> 00:55:26.520 don't know, and I launch the impact generator, sorry, the impact modifier. Well, on the one hand, 00:55:26.520 --> 00:55:30.320 it warns me, it tells me, hey, that's weird, you haven't selected all the lines, but 00:55:30.320 --> 00:55:33.760 it doesn't matter, you have the right to do so. It simply warns you. Why? Because 00:55:33.760 --> 00:55:38.240 in some cases, when we want to generate variations, well, we often need to 00:55:38.240 --> 00:55:43.680 select all the attributes that we have pre-selected in our list. Well, 00:55:43.680 --> 00:55:49.280 that's not the case. For me, it's intentional. I only want to modify two impacts out of the three. 00:55:49.280 --> 00:55:54.720 So I continue. Well, in this case, if I refresh, we'll do it, but I'll show you 00:55:54.720 --> 00:56:01.880 first. In fact, my 50 here won't change because I didn't select the L attribute before 00:56:01.880 --> 00:56:09.960 launching the modification. So I'll show you my L. Here we still have our impact of 50, right. 00:56:09.960 --> 00:56:16.400 Why? Because here I didn't select my L line with my impact modified to 40. 00:56:16.400 --> 00:56:20.520 If I want to modify my impact of 40, I have to at least take this line and I can 00:56:20.520 --> 00:56:27.080 take that one if I want. So there, I restart, I continue and this time, 00:56:27.080 --> 00:56:35.880 on the contrary, my lines with an L attribute went through with a price impact of 40. 00:56:36.400 --> 00:56:40.480 I'm going to stop there for the generator. I'm simply going to come back to 00:56:40.480 --> 00:56:46.160 something that I quickly skimmed over earlier and I promised to come back to it with 00:56:46.160 --> 00:56:53.640 more information. In fact, it was about changing the position or display order of 00:56:53.640 --> 00:56:58.680 attribute groups on the product pages and the values ​​in the product pages as well. 00:56:59.200 --> 00:57:05.080 Hey, you remember, I showed you that here, we had a column called position 00:57:05.080 --> 00:57:11.680 which allows us to order the display of attribute groups in the pages on the site. And so, 00:57:11.680 --> 00:57:19.680 this allows this column, sorry, is editable allowing us to modify this order. How do we 00:57:19.680 --> 00:57:24.160 do it? So, the first operation to do is to click on the title of the column 00:57:24.160 --> 00:57:30.920 to first order the display according to this order. And then you have several 00:57:30.920 --> 00:57:39.160 possible methods. The simplest is to take a line here, for example 4 and move it. So 00:57:39.160 --> 00:57:43.400 my new colors go to position 2. If for example, I want my frame here 00:57:43.400 --> 00:57:49.600 to go to position one, I put it at the very top. If I want to move two lines at the same time, 00:57:49.600 --> 00:57:56.040 I take them and I move them. And all the others are recalculated. 00:57:56.760 --> 00:58:02.280 So, another way to do that is for example if you want to order them alphabetically 00:58:02.280 --> 00:58:08.040 automatically. So at that point, the simplest is to click on 00:58:08.040 --> 00:58:13.400 the title of the column group group attribute so that you have this order on the screen, sorry 00:58:13.400 --> 00:58:19.640 alphabetically. If you ever have numbers in there or other things other than text, you 00:58:19.640 --> 00:58:26.080 can also, I'll tell you about it quickly, with a right click in the menu here to see the sorting options 00:58:26.080 --> 00:58:32.640 . So, we're going to try to bring all that up a bit so you can see more clearly what I 00:58:32.640 --> 00:58:38.080 'm going to show you. So, if I right-click here, sort option, see, you have different 00:58:38.080 --> 00:58:45.360 types of sorting possible. The default sort, but which is actually an alphabetical sort but 00:58:45.360 --> 00:58:50.200 insensitive to case, so to capital letters, numeric, accents, and spaces. 00:58:50.200 --> 00:58:55.600 And then you can check these options to take accents into account or not, take 00:58:55.600 --> 00:58:59.400 numerics into account or not, uh, in strings, and so on. So with all these possibilities, you should be able 00:58:59.400 --> 00:59:07.120 to order your values ​​with a simple click on the title of a column according to what interests you. There you go. 00:59:07.120 --> 00:59:13.400 And then once you've done that, the easiest way to now apply this order 00:59:13.400 --> 00:59:21.120 would be to fill in the numbers here, 0 to the bottom, by hand. But there's still a faster way. 00:59:21.120 --> 00:59:26.960 You can use Magic Edit. So I right-click here, I launch Magic Edit in the entire 00:59:26.960 --> 00:59:31.480 column. And in Magic Edit, so this isn't a course on Magic Edit that I'm going to give you here, 00:59:31.480 --> 00:59:36.480 but just to show a possible use. I'm simply going to activate the last tool 00:59:36.480 --> 00:59:40.720 in Magic Edit here, which is called adding an index. In fact, it's a sequence of numbers. I 00:59:40.720 --> 00:59:48.320 'm going to ask it to start counting at 1, to increment one by 1 without an addition separator. 00:59:50.960 --> 00:59:58.120 And I apply. What happened? Automatically, Magic Edit, so it's almost 00:59:58.120 --> 01:00:04.760 that it actually filled my values ​​with 1 2 3 et cetera on the left digit here on the 01:00:04.760 --> 01:00:10.480 right, sorry. But it left me some numbers from before. I actually forgot to ask it before 01:00:10.480 --> 01:00:16.280 filling to delete. So I ask it to delete the content and then fill by counting 01:00:16.280 --> 01:00:23.080 from 1. I apply and there you go. There, I have my numbers, my positions which are ordered and 01:00:23.080 --> 01:00:28.760 I save. So by using Magic Edit like this, you can quickly order your attribute groups 01:00:28.760 --> 01:00:34.080 according to any column. It could have been the IDs, it could have been the values, 01:00:34.080 --> 01:00:39.480 it could have been I don't know anything. And what I did here on 01:00:39.480 --> 01:00:45.800 the attribute groups, I can also do it the same way on the other table here on the 01:00:45.800 --> 01:00:52.480 positions of my attribute values. huh. So if I'm going to order them, for example, my shoe sizes 01:00:52.480 --> 01:00:58.640 Here, so the values ​​are there, I would like my positions to reflect my points, so I'm going to 01:00:58.640 --> 01:01:07.040 click on I sorted in ascending order here on the value column. I'm going to select all my 01:01:07.040 --> 01:01:17.320 rows in my group. And likewise, I'm going to use Magic Edit here in the entire column with the same 01:01:17.320 --> 01:01:23.560 setting as before. Delete, add a counter, while I'm going to put one back each time and 01:01:23.560 --> 01:01:33.800 I apply. And here I end up with my positions 1 2 3 4 5 6 et cetera which are 01:01:33.800 --> 01:01:38.200 generated. So, I must have made a mistake and then I'm going to cancel because I launched 01:01:38.200 --> 01:01:44.560 Magic Edit on the entire column. What I wanted was only these values. So 01:01:44.560 --> 01:01:48.720 I select it and in my menu here, it's not Magic in the entire column that 01:01:48.720 --> 01:01:54.240 I have to take but only in the selected cells. There you go. So only this one, 01:01:54.240 --> 01:02:05.240 I reapply my result, finally my operation. Apply 1 2 3 and that and I like it. I save. 01:02:05.240 --> 01:02:09.400 There you go. So, I absolutely wanted to show you this handy little tool for 01:02:09.400 --> 01:02:14.520 quickly reordering attribute values ​​or attribute groups in alphabetical, numerical 01:02:14.520 --> 01:02:19.200 , or any other order. You can use that here. But you can also use this trick 01:02:19.200 --> 01:02:24.280 in product characteristics. In these tables here, we have a bit of the same 01:02:24.280 --> 01:02:31.240 problem. We also have a position column here, and sometimes you may need to reorder the 01:02:31.240 --> 01:02:34.720 positions in an order of your choice. So you can use exactly the same technique for 01:02:34.720 --> 01:02:41.080 that. That concludes this long training on the concept of attribute declination, 01:02:41.080 --> 01:02:46.280 attribute group on the generator. I hope you enjoyed it. You've seen 01:02:46.280 --> 01:02:52.120 that it opens up great perspectives, great power, very fast calculation of the generator 01:02:52.120 --> 01:02:57.120 to create new variants on one or more products at a time in addition, 01:02:57.120 --> 01:03:02.520 increment, or replacement mode of remote declinations. Thank you and see you soon for another tutorial.