WEBVTT Kind: captions Language: en-US 00:00:10.200 --> 00:00:14.160 Hello, this is Franck from Sitolog. I'm going to talk to you today about accessories in 00:00:14.160 --> 00:00:20.360 Merlin. So, in Merlin, we have at least three ways to manage accessories. The first 00:00:20.360 --> 00:00:24.840 is via the accessories tab, which we'll spend most of the time on in this 00:00:24.840 --> 00:00:29.960 tutorial. The second way is at the top table, the product table. We'll see that 00:00:29.960 --> 00:00:36.400 we can copy accessories from one product to other products. And finally, as usual, 00:00:36.400 --> 00:00:41.960 I'll also show you in the import section here how to import accessories 00:00:41.960 --> 00:00:48.000 at the same time as you import or update products. So the first part, 00:00:48.000 --> 00:00:52.080 the accessories tab. So, as a preface, I'd like to remind you that an accessory 00:00:52.080 --> 00:00:57.120 is not the same thing as a pack. A product pack is when you sell two or three 00:00:57.120 --> 00:01:01.480 or more products at the same time. So it's actually a product pack, it's the same product, 00:01:01.480 --> 00:01:07.040 a single product that groups other products that are sold together, therefore in a pack. An 00:01:07.040 --> 00:01:13.080 accessory is different. An accessory is another product that appears, that is offered for 00:01:13.080 --> 00:01:18.320 sale on the page of another product, what we call the product per year. So, let's suppose that 00:01:18.320 --> 00:01:24.960 you sell for example this dress here, this printed dress, well you can choose to 00:01:24.960 --> 00:01:31.120 sell at the same time as this printed dress an outlet belt. And so, you are not going to force it 00:01:31.120 --> 00:01:35.120 to be sold, you are going to offer it for sale on the product page and the buyer can 00:01:35.120 --> 00:01:39.840 possibly choose to add it to their cart if they want. So, that's what an accessory is. 00:01:40.640 --> 00:01:44.240 So in this accessories tab, you actually find more or less the same structure 00:01:44.240 --> 00:01:50.600 as in the main window. So in the main window, we have a navigation by category 00:01:50.600 --> 00:01:54.360 then a table to display the products. Well, in the accessories, it's the same, 00:01:54.360 --> 00:02:00.520 we have a navigation here of the different categories and another table which 00:02:00.520 --> 00:02:05.080 also allows you to display the products. So it's basically the same data as above, 00:02:05.080 --> 00:02:10.160 except that the two tables, finally the two parts, are independent. We can navigate, 00:02:10.160 --> 00:02:14.280 so we can choose a category. Here, for example, I can choose to display men's products 00:02:14.280 --> 00:02:19.440 and I can choose at the bottom to display women's products or another category. So we 00:02:19.440 --> 00:02:25.760 are really out of sync. And if I display the products here in this table of this category, 00:02:25.760 --> 00:02:29.480 they are not the same as those above if we are not in the 00:02:29.480 --> 00:02:35.080 same branch. So for this training, I deliberately created two new categories. 00:02:35.080 --> 00:02:39.240 You see here that I called home accessory in which I created two products, 00:02:39.240 --> 00:02:44.640 a belt and a glove, a pair of gloves. And the same in women's accessory, I also created 00:02:44.640 --> 00:02:50.280 a belt and a pair of gloves for women. So what I'm going to do is show you 00:02:50.280 --> 00:02:56.360 how, for example, to associate an accessory product with various products. So here, for example, I am 00:02:56.360 --> 00:03:03.080 in the women's category, I have all my products from the women's category recursively. I 00:03:03.080 --> 00:03:10.120 will select, for example, the different dresses and I will associate the belt with them, uh, 00:03:10.120 --> 00:03:14.640 put online for women. So at the top, I choose my products and at the bottom, 00:03:14.640 --> 00:03:21.120 I navigate to my category or categories that contain my accessories. So I'm going to remove 00:03:21.120 --> 00:03:31.120 the recursive mode that we have here. I'm going to click on women's accessories and I'm going to display my products. 00:03:31.120 --> 00:03:37.600 So here what it displays is the content, we agree, of women's accessories. If 00:03:37.600 --> 00:03:43.480 you don't have anything displayed, remember to check if you don't have a prefilter. So if 00:03:43.480 --> 00:03:49.280 another prefilter here is displayed in orange, that means a prefilter is activated. And in particular, 00:03:49.280 --> 00:03:57.440 by default, normally this prefilter is checked. The one that only lists the products 00:03:57.440 --> 00:04:03.880 here that are already declared as accessories for the products at the top. That is to say, with this 00:04:03.880 --> 00:04:10.520 prefilter checked, if I refresh here, I no longer have anything displayed. This is normal, 00:04:10.520 --> 00:04:14.160 it only displays the women's accessories products that are already 00:04:14.160 --> 00:04:18.120 declared as accessories for my dresses. And for the moment, I still have none. 00:04:18.800 --> 00:04:25.360 So remember to uncheck this filter and refresh if you have this problem. So I have two 00:04:25.360 --> 00:04:30.880 products displayed. To declare them accessories for my dresses, just 00:04:30.880 --> 00:04:33.800 select them. So for now, I'm going to take only one. I'm going to take 00:04:33.800 --> 00:04:43.440 women's belt. And so click on the accessory button here like this. To do the opposite, 00:04:43.440 --> 00:04:50.600 so to remove it from the list of accessories for my products, you have an unlinked button. 00:04:50.600 --> 00:04:56.160 Another method, you have a column here called B is accessory of the selected A. 00:04:56.160 --> 00:05:02.280 So, A and B, what are they? So the table of products A is the one at the top. The table of 00:05:02.280 --> 00:05:06.880 products B is the one at the bottom. So when we say B is accessory of the selected A and 00:05:06.880 --> 00:05:14.120 we check here, it means that the products on which I act here, my table B, have become 00:05:14.120 --> 00:05:19.600 accessories of my products selected at the top in table A. So here, I did it for a 00:05:19.600 --> 00:05:23.640 single product, but as usual, we can do it for a selection of different products. So 00:05:23.640 --> 00:05:30.480 here, I take two. I take, let's say three products at the top. And if I click here, 00:05:30.480 --> 00:05:36.840 well, I added leather gloves as an accessory to these three other products. So, 00:05:36.840 --> 00:05:41.040 as with the other tables that contain columns with checkboxes like that, we have a 00:05:41.040 --> 00:05:49.200 color code. Look, if I select more products, by these three, it tells me here in 00:05:49.200 --> 00:05:56.800 blue that the three products have the women's belt item as an accessory, but that the 00:05:56.800 --> 00:06:01.400 pair of women's leather gloves is only an accessory to some of these products, not all. So, I 00:06:01.400 --> 00:06:07.280 don't know which ones. If I want to know which ones, I would have to select them one by one or 00:06:07.280 --> 00:06:13.040 one after the other. And here, we see that it's the printed summer dress that actually has 00:06:13.040 --> 00:06:19.840 the leather gang product as an accessory. The other two don't have it. So this color here tells me that 00:06:19.840 --> 00:06:24.520 some products are not associated. And that allows you to make corrections, eh. If, for 00:06:24.520 --> 00:06:30.040 example, you wanted G cuirf to always be an accessory for these three products, you 00:06:30.040 --> 00:06:34.200 see this orange color, it's a sign that at least one of the products here is not associated. 00:06:34.200 --> 00:06:40.280 And to correct this, well, I just have to either double-click in the table, or again 00:06:40.280 --> 00:06:45.840 work on these two buttons to associate or disassociate. So, we can 00:06:45.840 --> 00:06:51.960 also work in the other direction, do what we call upward associations. That is to say, 00:06:51.960 --> 00:06:56.360 we can here, you see, you have a column that works the opposite of this one. It's 00:06:56.360 --> 00:07:02.080 the selected A's that are accessories for the B's. So basically, we can define for the products that 00:07:02.080 --> 00:07:06.360 are listed here accessories chosen from the table above. So we work 00:07:06.360 --> 00:07:11.680 in reverse. So what's the point of doing this? I'll show you with an example. 00:07:11.680 --> 00:07:18.120 Let's suppose that you sell computers and computer mice. At some point, 00:07:18.120 --> 00:07:23.240 you have a new mouse that comes into your stock, a new item. Well, you 00:07:23.240 --> 00:07:29.120 would like this new mouse to be an accessory for the same PCs, the same computers as another 00:07:29.120 --> 00:07:34.760 model that was already in your catalog. Well, in this case, you will choose 00:07:34.760 --> 00:07:40.120 your old mouse and your new mouse at the top. You will display the products that are 00:07:40.120 --> 00:07:47.760 parents of the old mouse at the bottom and you will declare them by year of the new mouse. We 00:07:47.760 --> 00:07:51.840 will do it together, for example, with one with dresses and a new belt. Look. 00:07:52.400 --> 00:07:58.880 So here, we agree that this belt here is an accessory for these three dresses. Well, 00:07:58.880 --> 00:08:02.400 I have a new belt that is included in my catalog. So, I go to women's accessories. 00:08:02.400 --> 00:08:09.080 Here, I see my belt here and I have a new one. So, I will create a new one. 00:08:09.080 --> 00:08:16.640 I could also duplicate it, but we will do it like this. I will call this belt 00:08:16.640 --> 00:08:22.120 women's belt. I will call it two. 00:08:22.120 --> 00:08:29.360 Ah, I think I have, I created three. It doesn't matter. I close. I refresh. So I 00:08:29.360 --> 00:08:34.560 actually added three women's belts. Good. Well, I would like these three women's belts, 00:08:34.560 --> 00:08:41.640 these three if here, to have as parent products the same parent products as women's belts. So 00:08:41.640 --> 00:08:46.360 Basically, that women's belt is an accessory of the same products as those that 00:08:46.360 --> 00:08:55.080 already existed. In this case, I select my three products plus the old one. 00:08:55.080 --> 00:09:00.640 There you go. And this time at the bottom, I don't display the women's accessory category, but I'm going 00:09:00.640 --> 00:09:06.920 to search in all these categories for those that contain products for which women's belt is 00:09:06.920 --> 00:09:11.120 accessory 2. So basically, and I don't know where they are. So at that point, I'm going 00:09:11.120 --> 00:09:16.440 to choose everything, I'm going to select everything, but here I'm going to filter. I'm going to ask it to show me 00:09:16.440 --> 00:09:24.000 only the products here, only those with A products as accessories. So I check this 00:09:24.000 --> 00:09:31.920 filter, I select all my categories in recursive mode. So it shows me all the products 00:09:31.920 --> 00:09:38.840 that are actually parents of at least one of the products above. In fact, they are parents, 00:09:38.840 --> 00:09:44.080 not of all of them, but only for the moment of women's belt. All I have to do is select 00:09:44.080 --> 00:09:51.120 all my lines and this time either check twice here, or use well, 00:09:51.120 --> 00:09:55.680 you see these two buttons here which work in reverse of the first two. So for example, if I 00:09:55.680 --> 00:10:02.320 click on parent, my four, sorry, my five dresses here will become parents of my four 00:10:02.320 --> 00:10:06.440 belts. So basically, my four belts will be accessories for my five dresses. There you go, 00:10:06.440 --> 00:10:14.760 I click on parent, I add, and that's it. So this is a method for working backwards 00:10:14.760 --> 00:10:19.600 when you're restocking new products, basically new accessories. So 00:10:19.600 --> 00:10:24.160 Merlin goes even further. It also allows you to work by entire category. For example, 00:10:24.160 --> 00:10:29.680 let's say I go to the women's categories up there, more precisely, I take 00:10:29.680 --> 00:10:35.440 all the dresses. So I take all the dresses in recursive mode, and I would like 00:10:35.440 --> 00:10:41.120 all these dresses to have as accessories all the accessories in the women's accessories category here 00:10:41.120 --> 00:10:47.840 . So I go to my accessories tab, in my second tree, 00:10:47.840 --> 00:10:56.240 I select my women's accessories category here. There you go. Stretch it a little. And this time, 00:10:56.240 --> 00:11:02.480 I'm going to use these two buttons. You see, with the chain, which means association as 00:11:02.480 --> 00:11:06.760 an accessory, or the scissors to ungroup. In fact, it's the same buttons as 00:11:06.760 --> 00:11:13.240 these first two. Except that here, we're going to act on all the categories selected here. So, as 00:11:13.240 --> 00:11:18.440 I was telling you, I take all my products here, all my dresses and I would like them to have 00:11:18.440 --> 00:11:23.480 as accessories all the products that are in women's accessories. I click on this 00:11:23.480 --> 00:11:31.000 association button here, I confirm and it's done. So, we're going to check that this time. 00:11:31.000 --> 00:11:37.800 So I'm going to ask it to display all the products here that are not parents but that 00:11:37.800 --> 00:11:45.440 are actually accessories of something. And I refresh. And there I find all the products 00:11:45.440 --> 00:11:49.320 that were in women's accessories. We can see clearly thanks to this column here which 00:11:49.320 --> 00:11:56.640 indicates to me that they are all accessories of all my products selected above. So, sometimes 00:11:56.640 --> 00:12:01.800 despite using this filter here which lists only the products that are already accessories, 00:12:01.800 --> 00:12:09.560 we have difficulty guessing in which category it is and so we tend to select everything 00:12:09.560 --> 00:12:15.400 and then just leave the filters searched. But here we have two columns that are very practical and 00:12:15.400 --> 00:12:19.080 will give us useful information to find the categories that already contain 00:12:19.080 --> 00:12:24.320 accessories. Unlike the categories that contain accessory products of the 00:12:24.320 --> 00:12:29.480 products listed above. So to activate these two columns that are currently grayed out, 00:12:29.480 --> 00:12:34.360 simply check this option shows the existence of accessories. So it is marked 00:12:34.360 --> 00:12:39.280 can slow down the application because indeed when you have a large number of categories, 00:12:39.280 --> 00:12:44.080 the scripts that are behind this search can be quite long. So here, you see, 00:12:44.080 --> 00:12:52.720 I have all these products that are selected and it tells me that in the accessory category, 00:12:52.720 --> 00:12:58.240 this category contains certain products that are accessories of my dresses. And then 00:12:58.240 --> 00:13:06.160 it also works the other way around. If for example here I come to take women's accessories 00:13:06.160 --> 00:13:14.440 and well I will see that in women here I have categories that contain products 00:13:14.440 --> 00:13:22.600 which are themselves per year accessories listed above. So, I told you in the introduction 00:13:22.600 --> 00:13:26.400 that there are several methods for declaring accessory products for other products. So, 00:13:26.400 --> 00:13:30.760 the first method we saw is by using this tab, but we can also do it 00:13:30.760 --> 00:13:37.000 directly up there in the product table using the copy-paste function or the merge of the 00:13:37.000 --> 00:13:42.160 accessories list between the products. So, to do that, in fact, we need to add new 00:13:42.160 --> 00:13:48.480 columns. So we go to the column configuration and then in the products tab 00:13:48.480 --> 00:13:53.160 here, we will look in this long list here for the columns concerning the 00:13:53.160 --> 00:13:56.960 accessories. So just a little reminder, if you are a little lost in the long list, 00:13:56.960 --> 00:14:02.840 you can click here on the button to roll everything up so as to close all the blocks 00:14:02.840 --> 00:14:08.120 here and so you will find more easily the one that concerns you. So here is the one 00:14:08.120 --> 00:14:12.840 called accessory. So I unroll it with the plus. And so there you have it, here you have different 00:14:12.840 --> 00:14:19.920 columns. So one is called accessory 2 and the other is called accessory list. The 00:14:19.920 --> 00:14:26.320 accessory list is available in several formats. So it will contain either the IDs, 00:14:26.320 --> 00:14:30.800 the numbers of the accessory products, or their name, their reference, supplier reference or 00:14:30.800 --> 00:14:35.160 one of the two barcodes. So it's one of these six columns. You can't have them 00:14:35.160 --> 00:14:38.680 all at the same time or even two, it's not possible. So it's one or the other. 00:14:39.240 --> 00:14:43.920 So for example, I'm going to take the names. So I'm going to put it here and I'm 00:14:43.920 --> 00:14:50.320 also going to take accessory 2 and I validate. So these are two columns that will 00:14:50.320 --> 00:14:56.720 give you information telling you for each of the products what the accessories 00:14:56.720 --> 00:15:02.960 of the other products are. So here, as we are in the category called women's accessories, 00:15:02.960 --> 00:15:07.960 here I have in the column is accessory the number of the other products which are by 00:15:07.960 --> 00:15:13.560 year of my different accessories. And then this one is empty indeed because my women's accessories 00:15:13.560 --> 00:15:18.680 themselves do not have accessories. So we're going to change categories. We're going to take women 00:15:18.680 --> 00:15:25.080 in recursive mode. So here, I have all the products in the women's family and subcategories. And 00:15:25.080 --> 00:15:31.600 here, I can clearly see in the list of accessories the different accessory products for these dresses 00:15:31.600 --> 00:15:39.240 , etc. And we actually find our famous belts that I've associated several times. Well, 00:15:39.240 --> 00:15:44.800 we had several belts, we duplicated them plus the pair of camp. So, what's the point 00:15:44.800 --> 00:15:48.760 of these columns? Well, there are at least three. The first point of interest is to be able to create 00:15:48.760 --> 00:15:53.720 filters, sort products with or without accessories, or sort products that have such and such accessories, 00:15:53.720 --> 00:16:00.280 etc. So, always right-click and then use the filter function on this column, and 00:16:00.280 --> 00:16:06.800 then use a filter like "contains," such and such a word, etc., or such and such an ID. The second point of use 00:16:06.800 --> 00:16:13.320 is to export this data so that you can then reimport it, well, in another 00:16:13.320 --> 00:16:18.640 pressop or when you migrate a pressop. So it's good to retrieve the names, 00:16:18.640 --> 00:16:24.600 the IDs, of the products to be able to reassociate them. So on this subject, I advise you in this case 00:16:24.600 --> 00:16:30.040 to use the notion of ID, exactly like in the accessory ID column and not the names 00:16:30.040 --> 00:16:34.040 because you will see later that the import tool is capable of working with the IDs 00:16:34.040 --> 00:16:39.880 at the accessory level but not with the names. At least not for the moment. And then the third 00:16:39.880 --> 00:16:46.200 use of this is to make mergers. That is to say that we can take the list of accessories of a 00:16:46.200 --> 00:16:52.400 product and say well on the other products or such and such other product, I also want to have these 00:16:52.400 --> 00:16:57.400 accessories. Look, we're going to do an example. I'm going to give new accessories to this 00:16:57.400 --> 00:17:02.680 first product there, the blouse. Uh, I'm going to give it as accessories those that are in 00:17:02.680 --> 00:17:09.040 men's accessories. Okay? Those that are there. So I take my women's category again, I take 00:17:09.040 --> 00:17:15.560 my blouse. Here at the bottom, I go to accessories home. So there, you already know the method. We're 00:17:15.560 --> 00:17:22.960 removing our pre-filter. I'm going to refresh. So here I have all the men's accessories products. 00:17:22.960 --> 00:17:27.240 I select them both. And as I said, I'm going to declare them blouse accessories. 00:17:27.240 --> 00:17:39.000 So, I click on accessory and I declare it here at the top. Refresh is flashing. I refresh and 00:17:39.000 --> 00:17:43.880 I see that my first product actually has two accessories, men's accessories, 00:17:43.880 --> 00:17:47.400 accessories that are not currently associated with the other products. Well, 00:17:47.400 --> 00:17:55.000 if I now select this product and then a few others, as there are two here, I can 00:17:55.000 --> 00:18:02.400 right-click here and paste Home Belt Home Glove into all the selected cells 00:18:02.400 --> 00:18:09.280 in this column, that is, in the next two rows. I do that and confirm. 00:18:09.280 --> 00:18:14.160 At that point, Merlin recognized that I was in the accessories list column. It doesn't 00:18:14.160 --> 00:18:20.280 simply offer me to copy and paste, but either to keep the existing accessories in these 00:18:20.280 --> 00:18:27.600 two products and add the two that are here in yellow, or to delete everything 00:18:27.600 --> 00:18:36.000 here and here and replace with this. If I delete, replace, I do indeed have my 00:18:36.000 --> 00:18:39.200 home accessories which have become accessories for these two other products and the others which 00:18:39.200 --> 00:18:44.920 have been removed. If, on the other hand, I repeat the same operation on these two other products but 00:18:44.920 --> 00:18:56.040 this time I ask it to keep and add. I have, after refreshing 00:18:56.040 --> 00:19:04.320 here, my women's accessories which were already there which have remained and then my men's accessories 00:19:04.320 --> 00:19:10.400 here which have been added to my list. So, know that for the accessories table here, 00:19:10.400 --> 00:19:16.440 you can also use the same pre-filters, same type of pre-filter as for the pre-filters of the 00:19:16.440 --> 00:19:21.760 main table here, eh. So pre-filter to see the products with or without variations, 00:19:21.760 --> 00:19:29.080 you find them here to filter by manufacturer, supplier or any other type of pre-filter on a 00:19:29.080 --> 00:19:36.720 large number of possible sections. Here are some pretty practical tools to precisely, 00:19:36.720 --> 00:19:43.560 uh, limit the list of products which interest you. And also in this area here, uh, I 00:19:43.560 --> 00:19:47.880 just wanted to draw your attention to this little option here which is very practical. So it's 00:19:47.880 --> 00:19:53.720 called also displaying secondary columns. So when this option is checked and you 00:19:53.720 --> 00:19:58.800 refresh at that point, you will see that in your table here, so accessories, you 00:19:58.800 --> 00:20:03.280 will end up with the same columns as those that were chosen at the display level 00:20:03.280 --> 00:20:09.360 in the top table. Basically, the columns chosen in the column configuration here, 00:20:09.360 --> 00:20:15.400 you have them in both tables when this option here is checked. When you don't have it, 00:20:15.400 --> 00:20:19.560 in fact, which columns are displayed? In fact, you ca 00:20:19.560 --> 00:20:25.760 n't define them yourself. These are only certain columns predefined by myself at the 00:20:25.760 --> 00:20:31.160 programming level. So then it will not always be the same display. In fact, 00:20:31.160 --> 00:20:36.520 I defined a list of main columns, let's say about ten columns. And among these 10 00:20:36.520 --> 00:20:41.160 main columns are displayed only those that are also present at the top. If, for 00:20:41.160 --> 00:20:46.000 example, at the top, I remove the default category, at that point, you will not have it at the bottom either. 00:20:46.000 --> 00:20:53.840 Okay? And if you then want to have all the columns or specific columns at the bottom, 00:20:53.840 --> 00:21:00.280 you have to display them at the top, such as the weight or the selling price, and then check this 00:21:00.280 --> 00:21:04.920 option. So, my explanations aren't necessarily very clear, so I invite you to try it out 00:21:04.920 --> 00:21:08.640 and you'll see for yourself. I think you'll understand very quickly how it works. 00:21:08.640 --> 00:21:12.560 So, what's the point of displaying additional columns here? Well, it's going to be, for example 00:21:12.560 --> 00:21:18.280 , to filter, to do searches, and so on. Uh, you can use any 00:21:18.280 --> 00:21:23.960 argument on any column with the function, uh, filtered on this column, which 00:21:23.960 --> 00:21:29.000 is a little further down there. You don't see it in the filter menu on this column to 00:21:29.000 --> 00:21:32.880 select products before associates like accessories. You can also use 00:21:32.880 --> 00:21:38.480 a function that I really like called filtered selection, which actually allows you to search 00:21:38.480 --> 00:21:44.440 for values ​​and automatically select the rows that correspond to the value you 00:21:44.440 --> 00:21:48.760 search. So without needing to set up filters, it can thus select 00:21:48.760 --> 00:21:54.360 a multitude of rows from a large number of rows that are themselves not selected. There you go. 00:21:54.360 --> 00:22:00.920 So a whole bunch of little tools here that are very practical for filtering, selecting, ordering, 00:22:00.920 --> 00:22:08.320 uh, your accessories in this table. Last part of this training on accessories, 00:22:08.320 --> 00:22:13.360 importing. So if you want to create accessories or associate accessories with your 00:22:13.360 --> 00:22:18.560 products via a file, you need a column that will contain any name, it doesn't 00:22:18.560 --> 00:22:24.760 matter. If you want this column to be mapped and automatically recognized by Merlin, 00:22:24.760 --> 00:22:32.520 the correct name is this one: ID-bas accessories. This is the name of the section in 00:22:32.520 --> 00:22:37.320 the Prestashop database. But regardless of the name of the column, what you need in your column, 00:22:37.320 --> 00:22:41.840 this is important to understand, you need the list of numbers or identifiers 00:22:41.840 --> 00:22:50.320 of your products, 10 accessories like here 5,6 5,6,7 et cetera. So products 5 and 6 00:22:50.320 --> 00:22:57.880 here will be defined as accessories of the product that will be created or modified, uh, through 00:22:57.880 --> 00:23:06.080 the first line. So here is a column with the ID numbers and at the level of 00:23:06.080 --> 00:23:11.840 your mapping, well, this column, whatever its name, once again, you need the map 00:23:11.840 --> 00:23:19.240 , so in your list here in this section called list of accessories here. And so this 00:23:19.240 --> 00:23:23.800 column only works by addition, that is, you can add 00:23:23.800 --> 00:23:28.760 accessories to a product using import; you cannot remove them. This is important to understand. 00:23:28.760 --> 00:23:33.520 If you want to remove accessories, well, what you need is to go to the main window, 00:23:33.520 --> 00:23:36.600 in the accessories tab, eh, what we saw just before, delete the 00:23:36.600 --> 00:23:45.320 product accessories and reimport the complete lists, finally complete or different. And then for the moment, 00:23:45.320 --> 00:23:50.400 another constraint, this tool is currently only capable of working with 00:23:50.400 --> 00:23:54.920 lists of IDs. We cannot choose anything other than that here for the moment. So, 00:23:54.920 --> 00:23:58.800 in a future version, here, you will also have a list of names, references, barcodes, 00:23:58.800 --> 00:24:02.680 things like that. So, to be able to work with lists other than just 00:24:02.680 --> 00:24:06.720 product numbers. And for now, that's what you need to do. So, identifier list, 00:24:06.720 --> 00:24:12.880 you check, you map, you continue and thus you will have your accessories associated with 00:24:12.880 --> 00:24:17.360 your products. Once again, in addition. So, if in your list you have products that 00:24:17.360 --> 00:24:22.160 are already accessories, they will of course not be declared twice. Uh, it will only update 00:24:22.160 --> 00:24:29.520 the new accessories. There you go, this part on importing completes this 00:24:29.520 --> 00:24:34.720 long training on the concept of accessories. Thank you and see you soon for another tutorial.