WEBVTT Kind: captions Language: en-US 00:00:10.880 --> 00:00:17.040 Hello, I'm Franck Bugnet, director of Sitolog. This short video on Merlin 00:00:17.040 --> 00:00:22.120 Backoffice is the first in a long series. It is dedicated exclusively to 00:00:22.120 --> 00:00:27.560 the first start, to the first use of Merlin Backoffice. So 00:00:27.560 --> 00:00:34.040 I'm going to show you, we're going to say the essential things to know. When Merlin launches, 00:00:34.040 --> 00:00:39.040 the first thing is to choose the right interface language. So 00:00:39.040 --> 00:00:43.760 here you have a French or English flag or finally American, sorry. So I put it in 00:00:43.760 --> 00:00:49.920 French. That's the first thing to do. The second thing is to unlock the application. 00:00:49.920 --> 00:00:55.520 So you must enter here the email of the account you used to purchase the software and 00:00:55.520 --> 00:01:00.680 here a 4 x 4 digit serial number that you should have received by email 00:01:00.680 --> 00:01:04.120 and if you haven't received it you will find it on the download and license page on 00:01:04.120 --> 00:01:11.160 the site. Once you have entered these two pieces of information, you click on unlock. 00:01:11.160 --> 00:01:14.480 Once the application is unlocked, you will find yourself in this window called the 00:01:14.480 --> 00:01:19.600 connection window. We will create a first connection. Here, you just need to give it a name. 00:01:19.600 --> 00:01:24.520 For example, give you the name of your site, I'll call it my site. You just need 00:01:24.520 --> 00:01:33.560 three pieces of information: The URL of the store, so either HTTP 2.2 point, or HTTPS if you are in 00:01:33.560 --> 00:01:40.280 secure mode, and the address with or without the ww following your domain name of your 00:01:40.280 --> 00:01:44.640 store. So, it is the URL of the store, it is not the URL of the store administration 00:01:44.640 --> 00:01:51.880 . And then the email of your employee account on your Prestashop administration as well as its 00:01:51.880 --> 00:01:57.080 password. Once these three pieces of information are entered, you click connect to 00:01:57.080 --> 00:02:03.120 launch the connection to your store. A first tip to know right away. 00:02:03.120 --> 00:02:10.080 If this screen is too small, unreadable, etc., go to the full interface, which 00:02:10.080 --> 00:02:15.880 brings up other tabs here. Go to advanced settings. I'm asking you to ignore all these 00:02:15.880 --> 00:02:20.240 settings for now, but just focus on this one, display zoom, 00:02:20.240 --> 00:02:27.720 which actually allows you to specify, for example, I'm going to set it to 120%, 00:02:27.720 --> 00:02:33.640 you see a display factor for your window's magnification. So this factor will be applied 00:02:33.640 --> 00:02:41.080 to all successive Merlin windows. I'm going to set it back to 100% for this tutorial. 00:02:42.640 --> 00:02:46.480 Once Merlin Backoffice is connected to your database, you should see a window that looks something 00:02:46.480 --> 00:02:50.720 like this. It may be a little different. For example, maybe you have a 00:02:50.720 --> 00:02:57.480 panel like this that has appeared or on the right. Let's see what it's all about. So, 00:02:57.480 --> 00:03:01.880 you have two main parts. You have the top part, which is often called 00:03:01.880 --> 00:03:09.680 the main table, and then below what is called the sub-tabs part. 00:03:09.680 --> 00:03:14.400 In Merlin, there are two different views. A view called the product view, which is the one 00:03:14.400 --> 00:03:20.680 we currently see, and another view called the category view. As their name suggests, 00:03:20.680 --> 00:03:26.520 the category view will allow you to work on categories by creating, 00:03:26.520 --> 00:03:32.200 editing, modifying, duplicating them, and so on. And then the product view 00:03:32.200 --> 00:03:38.400 will allow you to work, of course, on the products in these different categories. 00:03:39.800 --> 00:03:43.120 You have two panels, what we call side panels, the left panel, which is 00:03:43.120 --> 00:03:47.600 also called the control panel. So the panels can be opened either by clicking on the 00:03:47.600 --> 00:03:54.000 orange bar here on the side, or on the cadna. The cadna has the advantage of opening the panel and keeping it 00:03:54.000 --> 00:03:59.240 open and shifting everything else. So here, I'm going to open, for example, the two panels. 00:03:59.240 --> 00:04:03.320 So we still find the central part, the main table at the top, which will allow us 00:04:03.320 --> 00:04:08.960 to display the products here, and here we find in our left control panel different what 00:04:08.960 --> 00:04:15.680 we call drawers. So a drawer that lists the categories, a drawer that allows you to choose 00:04:15.680 --> 00:04:20.040 a store among several for those who are multi-stores, a display drawer 00:04:20.040 --> 00:04:28.560 that allows you to adjust the display mode. For example, you can zoom in and out 00:04:28.560 --> 00:04:33.640 , and do various things like that. You can also choose the language. 00:04:33.640 --> 00:04:38.000 Here's an interface, finally the choice of interface. Currently, we're in the getting started interface 00:04:38.000 --> 00:04:42.560 , which is mainly used to learn and use the software. You have a so-called 00:04:42.560 --> 00:04:48.320 simplified interface, which is already quite usable, which allows you to do quite a few things, and then a 00:04:48.320 --> 00:04:51.560 complete interface, which will be the one you'll use most often once you 00:04:51.560 --> 00:04:55.840 're familiar with using Merlin. So you see, when I'm in the complete interface, 00:04:55.840 --> 00:05:00.840 I have a lot more tabs here. I have a lot more buttons, a lot more functionality. 00:05:00.840 --> 00:05:07.520 I'm going to go back to the getting started interface for the duration of this tutorial. Below the display, 00:05:07.520 --> 00:05:12.240 you have other drawers that we'll see later. And finally, at the very bottom, 00:05:12.240 --> 00:05:17.800 you should know, you have help. So, it's not as valuable help as the video tutorials, 00:05:17.800 --> 00:05:23.840 but you already have a lot of textual information on the use of the 00:05:23.840 --> 00:05:31.280 different parts of the interface. Basically, each tab here is described in this help. 00:05:33.480 --> 00:05:38.800 I'm going to unfold the first drawer, which is called category, to show you how to display 00:05:38.800 --> 00:05:44.320 products. So, all you have to do is select one or more categories. So, 00:05:44.320 --> 00:05:51.640 for example, here, I'm going to select these three dress categories. I see that 00:05:51.640 --> 00:05:55.160 the interface is in English for now. Well, my data is in English, it doesn't matter. 00:05:55.680 --> 00:05:58.480 So I select my different categories, 00:05:58.480 --> 00:06:05.160 either with a click plus shift click, or the control click key. And then here, 00:06:05.160 --> 00:06:08.280 you see the display button flashing to tell me that the data needs 00:06:08.280 --> 00:06:14.640 to be refreshed. So I click on it and I end up with the display of my data 00:06:14.640 --> 00:06:21.920 here in this table. So the products that are displayed are the products in these categories. 00:06:23.920 --> 00:06:27.960 So, I also wanted to show you that the side panels, both the right 00:06:27.960 --> 00:06:33.000 and the left, are detachable. So, by clicking on the title bar of a panel here, 00:06:33.000 --> 00:06:38.000 if I take it, I move it, see, it detaches. So that's handy for 00:06:38.000 --> 00:06:41.760 moving them around and putting them on a second or third screen, right? You can do that very well, 00:06:41.760 --> 00:06:46.000 if you have very wide screens or a multi-screen setup, and organize 00:06:46.000 --> 00:06:51.200 your environment as you like. If it often happens that people tell me the panel 00:06:51.200 --> 00:06:54.880 there is useless, well it's a bit we don't really know where. They don't know why. So it's simply 00:06:54.880 --> 00:06:59.480 because they moved it by accident. If that happens to you, well yes, to reattach it, 00:06:59.480 --> 00:07:04.280 it's simple: you click either on the paperclip here to put it back in place, 00:07:04.280 --> 00:07:09.880 or on the padlock to both put it in place and anchor it, right? That is to say, once again 00:07:09.880 --> 00:07:16.400 , the anchor is there and everything that is below it is actually shifted 00:07:16.400 --> 00:07:21.400 to the right. So the paperclip, I'll show you the paperclip again, the panel overlaps, 00:07:21.400 --> 00:07:26.520 well is superimposed on what is below it. It hides itself, it reappears on top. 00:07:26.520 --> 00:07:31.400 And as the cadna, the panel snaps into place and everything on the right here is shifted to the 00:07:31.400 --> 00:07:41.080 right. And it's exactly the same thing on the left and right panel, excuse me. 00:07:41.080 --> 00:07:45.600 So, you can adjust the area or surface allocated to each panel, 00:07:45.600 --> 00:07:50.840 eh. You have dividers here, dividers here. I can widen or not, 00:07:50.840 --> 00:07:55.320 each area as well. The left panel can be widened. Uh another thing, 00:07:55.320 --> 00:08:03.440 if you ever have, uh, the interface which is also in bulk with the dividers, 00:08:03.440 --> 00:08:08.440 it looks like nothing more or you can no longer see certain parts. Uh know that 00:08:08.440 --> 00:08:13.040 you can reset everything by double-clicking on these bars here. There you go. So 00:08:13.040 --> 00:08:17.000 if I double-click on any of these dividers, for example this one, you see, 00:08:17.000 --> 00:08:21.640 in fact all the dividers go back to the default position. I'm going to start again. 00:08:21.640 --> 00:08:28.400 There you go, I shift everything. I double-click on this divider and everything goes back into place. 00:08:29.560 --> 00:08:33.360 So I'm going to make a little more space to show you the 00:08:33.360 --> 00:08:39.160 product table more precisely. So I'm going to start by hiding the right panel. So I can see 00:08:39.160 --> 00:08:43.760 that here I have some columns. So the first thing to understand is that the columns or the 00:08:43.760 --> 00:08:48.400 The data displayed in the tables is configurable. This is called 00:08:48.400 --> 00:08:55.520 view configuration, table configuration. You can do this by selecting a configuration 00:08:55.520 --> 00:09:01.040 here in the list and you can create as many configurations as you want. By default, 00:09:01.040 --> 00:09:07.680 you only have configuration 1 and here I have created for this tutorial different types of displays, 00:09:07.680 --> 00:09:13.120 different configurations. For example, I'm going to select photo. Well, I'm 00:09:13.120 --> 00:09:17.400 already in it, excuse me. I'm going to select the purchase prices only. I don't know 00:09:17.400 --> 00:09:21.680 what I put in there. There you go. And so I have an automatic display of the table updated 00:09:21.680 --> 00:09:27.040 with the columns I chose for displaying prices. I could see a 00:09:27.040 --> 00:09:31.960 configuration for displaying fields and so on. So depending on the type of work 00:09:31.960 --> 00:09:35.600 you need to do with Merlin, you will choose, finally, you will create and 00:09:35.600 --> 00:09:41.040 choose your different configurations. To create or modify column configurations, 00:09:41.040 --> 00:09:47.520 you click on the column button here at the top right. So that opens another window 00:09:47.520 --> 00:09:52.680 called the table configurator that allows you to choose one of the configurations or 00:09:52.680 --> 00:09:58.680 create new ones, delete them, rename them, duplicate them, etc., and then work on 00:09:58.680 --> 00:10:02.480 the lists of columns that you want to put in your tables. So you have a list for 00:10:02.480 --> 00:10:06.880 the products, that's the list here on the right, you have a list for the variations table, 00:10:06.880 --> 00:10:12.240 we'll see that later, the categories table and also specific prices. If I want 00:10:12.240 --> 00:10:17.400 to configure the products table, so here I have the list of columns currently displayed 00:10:17.400 --> 00:10:23.000 as part of this text configuration. If I want to add, for example, the 13, I just have to 00:10:23.000 --> 00:10:27.560 take it and drag it to the right where I want. For example, I'll put it right after 00:10:27.560 --> 00:10:32.320 the name here. So I end up with my column. You can of course take several at once 00:10:32.320 --> 00:10:38.760 and drag them to remove columns. For example, if I'm going to remove the two references, 00:10:38.760 --> 00:10:43.360 reference and go-getter reference, I take them and drag them to the right and let go. When I 00:10:43.360 --> 00:10:48.240 'm happy with my configuration, I validate and I have an automatic refresh of 00:10:48.240 --> 00:10:56.800 my display with the columns that I added. Here the 13bn and so on. 00:10:56.800 --> 00:11:02.480 So, I changed the view, I put myself in config mode 1 and I reconfigured the software, I 00:11:02.480 --> 00:11:08.320 put myself in full interface mode simply to show you other features. So, 00:11:08.320 --> 00:11:13.160 a little tip, but let's suppose that I'm going to see all the products in the database. I just have 00:11:13.160 --> 00:11:18.560 to click on the button here all in the category drawer to select all 00:11:18.560 --> 00:11:23.840 the categories recursively. Recursive means that we select the categories, 00:11:23.840 --> 00:11:29.800 the subcategories, subcategories and so on. So since I selected the home page, 00:11:29.800 --> 00:11:34.320 effectively all the home subcategories are selected at the same time. I click on 00:11:34.320 --> 00:11:41.640 display and there I find myself listing all the products in my current database. What 00:11:41.640 --> 00:11:47.200 is important to master fairly quickly with Merlin is the concept of the prefilter. 00:11:47.200 --> 00:11:53.680 Here prefilter. This prefilter allows you to choose which products will be displayed, 00:11:53.680 --> 00:11:58.920 which will be listed. By default, it is set to prefiltered by default category. 00:11:58.920 --> 00:12:04.280 This means that the products listed here are those whose default category 00:12:04.280 --> 00:12:10.400 is one of the categories selected on the left. The second choice, called 00:12:10.400 --> 00:12:17.200 prefiltered by associated category, shows us the products that are associated with one of the categories 00:12:17.200 --> 00:12:22.000 selected on the left. The difference between a default category, main category 00:12:22.000 --> 00:12:27.160 , and associated categories is fundamental. It's important to understand this from the start. 00:12:27.160 --> 00:12:32.720 Associated categories, or the associated category view, basically, correspond to the view you have 00:12:32.720 --> 00:12:37.680 in your store. A product is associated with a category. So when we choose this 00:12:37.680 --> 00:12:42.760 category in the store, we see the product. The default category is different. A 00:12:42.760 --> 00:12:47.320 product has one and only one default category. This is where it is stored in the database. It 00:12:47.320 --> 00:12:52.680 is not necessarily associated, not necessarily visible in this category by default. 00:12:54.200 --> 00:13:00.760 You have other prefilters accessible by the button here other prefilter which allow you 00:13:00.760 --> 00:13:05.520 to list the products or filter the products that you want to see or not see. For example, 00:13:05.520 --> 00:13:10.320 you can ask it to show you only the products of a certain supplier. 00:13:10.320 --> 00:13:15.640 I'm going to take Vapor, I don't know if there are any. I refresh. Well, I don't have any. There you go. 00:13:15.640 --> 00:13:21.400 So these prefilters allow, try to find another example fashion supplier. There you go, 00:13:21.400 --> 00:13:26.520 I have the product associated with the supplier Fashion Supplier. When a prefilter is in place, 00:13:26.520 --> 00:13:31.920 you see it here indicated in orange. So you can quickly sort on uh the 00:13:31.920 --> 00:13:36.880 suppliers or the manufacturers. Also see only the products with or without variations, 00:13:36.880 --> 00:13:42.720 but you can sort your products on any factor. for example a 00:13:42.720 --> 00:13:50.960 prefilter whose sales price excluding tax is greater than or equal to €10 and I validate. There you go, 00:13:50.960 --> 00:14:00.960 you can see that our sales prices are all higher than my prefilter of €10. 00:14:00.960 --> 00:14:04.920 So prefilters are an important concept that allows you to quickly search for a product. 00:14:04.920 --> 00:14:11.440 You can very well type the reference directly in a prefilter. Reference equals to type 00:14:11.440 --> 00:14:17.560 the value of this reference and at that moment you will directly find the product regardless 00:14:17.560 --> 00:14:28.120 of its location in the categories since I have selected them all here on the left. 00:14:28.120 --> 00:14:32.000 Displaying the products is good but of course it's just a start, it's not enough. 00:14:32.000 --> 00:14:36.840 The advantage of a tool like Merlin is to be able to modify the data. So the data 00:14:36.840 --> 00:14:41.240 can be modified directly in the tables. For example, here these products that have a 00:14:41.240 --> 00:14:48.080 somewhat generic name, I can absolutely rename them. There you go. Call this one an orange skirt. So I 00:14:48.080 --> 00:14:52.960 can work directly cell by cell, modify the rows, finally the data in the 00:14:52.960 --> 00:14:59.120 cells, by modifying its price. Here, the data that you modify is saved when 00:14:59.120 --> 00:15:03.440 you change rows. So you see if the hourglass that turned for a half was 00:15:03.440 --> 00:15:08.320 the writing time in the database. So here, if I refresh my data, my Orange skirt is 00:15:08.320 --> 00:15:13.680 indeed called Orange skirt. If you go to see the product directly in the database, directly on the site, 00:15:13.680 --> 00:15:18.400 which is also possible by right-clicking here and clicking on view web page, 00:15:18.400 --> 00:15:24.040 there, you will see that your product has been renamed Orange skirt and a purchase price of €90. 00:15:25.040 --> 00:15:29.680 So, you can modify it cell by cell, line by line, but above all 00:15:29.680 --> 00:15:34.360 you can make mass modifications. For example, I can very well say that my 00:15:34.360 --> 00:15:37.760 purchase price here is 10, I want to apply it to all these products, 00:15:37.760 --> 00:15:44.920 all these lines. I select them all. I right-click on the 10. So, 00:15:44.920 --> 00:15:49.000 maybe you don't see it here. I'm going to try to move the screenshot. 00:15:49.840 --> 00:15:55.640 Uh well, you may barely see it in fact, you have to select here in the menu, uh 00:15:55.640 --> 00:15:59.240 the parameter pasted 10 in the whole column or here in all the cells. I'm going to do it 00:15:59.240 --> 00:16:04.160 on another column, it might be easier. There you go, I'm going to copy the reference here. 00:16:04.160 --> 00:16:08.640 There you go. So if I want to take this reference, copy it to all these other products, I choose 00:16:08.640 --> 00:16:13.680 this option here in the menu. It shows me what it's going to copy. It's going to copy the yellow value 00:16:13.680 --> 00:16:20.440 into the cells here in dark gray. I validate and it makes the copy for me. And that's instantaneous 00:16:20.440 --> 00:16:28.680 in the database. Another method, uh, we can also do calculations. So we select the lines 00:16:28.680 --> 00:16:34.520 on which we're going to do a calculation. We go to grouped action. Here we have different possibilities. 00:16:34.520 --> 00:16:39.400 I'm just going to choose modify by calculation. This opens what we call the calculator here, 00:16:39.400 --> 00:16:43.080 which allows me to do a lot of things. I'm going to go very quickly. I just say I'm going to multiply 00:16:43.080 --> 00:16:50.800 my prices by 2. I choose my purchase price column and I click on multiply, and 00:16:50.800 --> 00:16:55.360 you'll see the values ​​multiplied by 2. That's done. See, it's instantaneous, 00:16:55.360 --> 00:17:02.440 it's very fast, and we can work on hundreds or even thousands of products. 00:17:02.440 --> 00:17:06.400 The grouped action button has a different role. It acts on all 00:17:06.400 --> 00:17:10.320 the selected rows. So right-click on the columns and the grouped action on the 00:17:10.320 --> 00:17:17.120 rows. For example, if I want to activate these five products, these four products, 00:17:17.120 --> 00:17:20.520 I select them, I select the four rows, I do grouped action and 00:17:20.520 --> 00:17:26.240 I click on activate. And you will see here the activation that is done. 00:17:26.240 --> 00:17:30.600 So in grouped action, you have a whole bunch of possibilities, of course, activate, 00:17:30.600 --> 00:17:35.160 deactivate, duplicate products. So make X copies, modify them by calculation, so 00:17:35.160 --> 00:17:39.240 that's what I showed you by modifying the purchase price. Here, you can round prices, 00:17:39.240 --> 00:17:46.560 finally a whole bunch of things as well, do exports, labels, catalogs and so on. 00:17:46.560 --> 00:17:52.600 So, I'm going to hide the calculator. There you go. And we're going to focus on the bottom part. 00:17:52.600 --> 00:17:58.560 So here, you have different tabs. We call them sub-tabs more precisely. The first one, 00:17:58.560 --> 00:18:02.880 the one you'll probably use first, is the one that lets you work 00:18:02.880 --> 00:18:07.080 product by product. So here, if I ask for the display, it tells me to select a single 00:18:07.080 --> 00:18:11.080 product because actually, I already have four to select and this tab 00:18:11.080 --> 00:18:15.920 is single-product. So I choose a product, I click on display and there I find myself 00:18:15.920 --> 00:18:19.760 with a bit like in Prestashop the product sheet. So I can modify its name, 00:18:19.760 --> 00:18:26.520 its manufacturer, things like that. You can also edit the summary and the description 00:18:26.520 --> 00:18:34.080 in an HTML editor with a complete view, we call it Wiwig of the description. This one 00:18:34.080 --> 00:18:41.600 may not be relevant. There you go, this one is a little better. So the advantage of this tab of the 00:18:41.600 --> 00:18:47.240 sheet is that you can move from one product to another quickly here by clicking on the 00:18:47.240 --> 00:18:54.120 next or previous buttons with an automatic saving system. So if I type text, I 00:18:54.120 --> 00:19:00.920 format it, and in fact, when I move to the next product, to the previous product, or even when I change 00:19:00.920 --> 00:19:07.320 the language, I return to the same product in two clicks. I find my data. So no 00:19:07.320 --> 00:19:11.000 button. Finally, there is a Save button, it's optional, but what I mean 00:19:11.000 --> 00:19:15.440 is that from the moment automatic saving is activated, you navigate from one 00:19:15.440 --> 00:19:20.160 product to another with automatic saving of data modifications. So there you have 00:19:20.160 --> 00:19:25.320 a third level of tab here to access all the product parameters. 00:19:25.320 --> 00:19:29.640 So the sheet tab is very useful for quickly modifying these products. We 00:19:29.640 --> 00:19:35.440 also use it when we create new products to quickly enter, in particular, the 00:19:35.440 --> 00:19:42.680 summary and the description. And then other other tabs, for example this one, 00:19:42.680 --> 00:19:47.920 the suppliers, which will allow you to see all the suppliers and make 00:19:47.920 --> 00:19:55.400 cross-associations. For example, I can select three products at the top and click on associate here, 00:19:55.400 --> 00:19:59.600 I don't know, on this supplier. I'm going to select two, this one and this one. 00:20:00.200 --> 00:20:05.040 Simply clicking here automatically associates these three products with these 00:20:05.040 --> 00:20:10.480 two suppliers. Well, there are many other things we can do here, but that's 00:20:10.480 --> 00:20:15.600 typically the use of this kind of tab. So you can work on 00:20:15.600 --> 00:20:21.120 suppliers, on specific prices. So you can both view them but of course 00:20:21.120 --> 00:20:28.680 also modify them. You have a specific mass price editor. You also have 00:20:28.680 --> 00:20:35.080 here something that allows you to view the characteristics and associate 00:20:35.080 --> 00:20:39.840 characteristics with products in a table. You simply make selections and 00:20:39.840 --> 00:20:48.400 click on the button and you have associations and automatic modifications. 00:20:48.400 --> 00:20:54.000 So, each of these tabs will be the subject of independent training specialized in 00:20:54.000 --> 00:20:57.920 English functionalities. So I invite you to consult them as soon as they are 00:20:57.920 --> 00:21:02.600 available. In the meantime, you have equivalent training on Presta Pressing 00:21:02.600 --> 00:21:06.640 and Presta Category on our site. These tabs already existed in these 00:21:06.640 --> 00:21:12.160 slightly older modules and are still quite relevant to familiarize you with the use of the same ones. 00:21:12.160 --> 00:21:20.400 features in Merlin. The interface changes a little, but the basic functions remain the same. 00:21:20.400 --> 00:21:26.640 So then, what you need to know in this quick overview is the tab, well, not 00:21:26.640 --> 00:21:31.720 the tab, excuse me, the right-hand panel, what we call the target categories. So 00:21:31.720 --> 00:21:37.280 you can, I remind you, bring up the orange bar by clicking on it or by anchoring it 00:21:37.280 --> 00:21:43.080 directly in the interface by clicking on the duck. So, in this part, on the right, 00:21:43.080 --> 00:21:49.480 you will find the same thing as here on the left, namely the list of different categories. 00:21:50.360 --> 00:21:56.600 uh that we find in the database and you will be able to associate and disassociate the products from 00:21:56.600 --> 00:22:03.520 these categories. So, you can do this either by selecting them, selecting a product, 00:22:03.520 --> 00:22:10.160 selecting one or more categories and uh by clicking on these buttons. So 00:22:10.160 --> 00:22:13.880 here you have buttons to move the products, so change their position, buttons to 00:22:13.880 --> 00:22:18.680 associate them and a button to disassociate them. This is one way of working. There is another 00:22:18.680 --> 00:22:23.040 one that is interesting and new in Merlin. Click on the view association button 00:22:23.040 --> 00:22:28.040 here and in fact you will end up with columns, uh other columns that 00:22:28.040 --> 00:22:33.480 show you, uh what are finally what is the default category of each 00:22:33.480 --> 00:22:38.760 of the products and what are the categories with which they are associated. Here it's the same, 00:22:38.760 --> 00:22:42.000 you will be able to make associations very quickly. You just have to select 00:22:42.000 --> 00:22:48.280 the lines, uh of categories in which you want to associate the products and you 00:22:48.280 --> 00:22:52.120 right-click. Not a right click, a click, excuse me, quite simply. So there, 00:22:52.120 --> 00:22:57.240 if I click, I confirm and at that moment, I have my association of my two products in 00:22:57.240 --> 00:23:03.240 my four categories which is done instantly. There you go. So the part that we call category C 00:23:03.240 --> 00:23:08.760 for the association of products or the mass movement of products in the categories. 00:23:10.560 --> 00:23:16.360 So if I now switch to category view, 00:23:16.360 --> 00:23:20.960 what changes is that the category tree that was here on the left is actually in the 00:23:20.960 --> 00:23:25.920 center. So here I am with my complete tree structure and what I 00:23:25.920 --> 00:23:31.960 showed you about the products, namely being able, for example, to directly modify the name of a product, 00:23:31.960 --> 00:23:35.800 uh I will be able to do it here on the categories as well. So if I want to remove the word, 00:23:35.800 --> 00:23:40.200 finally the letter S in woman, I said it directly here. I have an automatic save. If I want 00:23:40.200 --> 00:23:44.520 to make mass edits, copy and paste, I can also do it on the columns of the 00:23:44.520 --> 00:23:48.800 category table here. And finally, the columns that you can display in this table, it's 00:23:48.800 --> 00:23:54.640 like for the products. You can go to column. Uh here, you have the category tab 00:23:54.640 --> 00:24:01.840 and you can therefore add, modify uh columns, headings in your display in 00:24:01.840 --> 00:24:07.480 order to work on them. There you go. So here, I added my description column, it appears my 00:24:07.480 --> 00:24:13.000 tree and so on and I can modify them en masse individually as for the products. And at the bottom, 00:24:13.000 --> 00:24:18.160 you have well it's a bit the same principle of the tabs specific to the categories. So 00:24:18.160 --> 00:24:22.960 the same goes for the tab, which allows me to display and modify the description of categories and 00:24:22.960 --> 00:24:28.840 other information. And here too, we'll move from one category to another with just one click. 00:24:30.120 --> 00:24:34.560 You also have, as for the products, I haven't shown you, but a tool for sending 00:24:34.560 --> 00:24:40.440 images in bulk. You have other specific tabs. The 00:24:40.440 --> 00:24:45.720 translation tab, so the multilingual display of categories here in French, in English. I see 00:24:45.720 --> 00:24:50.920 that it's not translated yet. So for example, if I want to translate the name here, 00:24:50.920 --> 00:24:58.920 I can do it quickly. If I want the same thing in German, in French as in German, and 00:24:58.920 --> 00:25:02.480 in this language, I don't know what it is. If I put women everywhere by default, 00:25:02.480 --> 00:25:10.280 I right-click and I click at the very bottom, copy and paste, and I have my paste. Okay? 00:25:12.360 --> 00:25:18.800 The customer group here is a particularity of the category view, it allows you to 00:25:18.800 --> 00:25:21.640 see the different customer groups that exist in your database as a visitor, 00:25:21.640 --> 00:25:26.000 Guest, customer, and you will also be able to manage the associations between categories and 00:25:26.000 --> 00:25:34.040 customers in the part here, uh, on the right, so in our target category part, 00:25:34.040 --> 00:25:39.120 when we are in category view, what you will be able to do is a little different. You will 00:25:39.120 --> 00:25:44.800 actually be able to manage, uh, the movements and copies of categories. That is to say, 00:25:44.800 --> 00:25:50.760 I will be able, for example, to say I want to take this category here and put it in this one. 00:25:50.760 --> 00:25:55.600 So I click on the original category, on my target category, and I use one of the buttons. 00:25:55.600 --> 00:25:59.520 So you have movement buttons, duplication buttons, things like 00:25:59.520 --> 00:26:08.400 that. So here, if, for example, I make a move, I will end up with my accessory 2 category 00:26:08.400 --> 00:26:13.160 here, which is in the dress, right where I wanted to put it. So you can do it on one 00:26:13.160 --> 00:26:16.120 category at a time, but more importantly, you can do it on a selection of categories or even 00:26:16.120 --> 00:26:21.080 on an entire branch. I can very well take the entire dress with all its subcategories 00:26:21.080 --> 00:26:28.440 and put it in the top. I move, I move, and now in dress in top, sorry, 00:26:28.440 --> 00:26:33.600 I end up with the entire dress tree. There you go. So you have unparalleled flexibility to 00:26:33.600 --> 00:26:38.640 really reorganize an entire tree structure in just a few clicks, the way you want. 00:26:39.520 --> 00:26:44.280 And then in this right-hand part as well, you will be able to manage 00:26:44.280 --> 00:26:49.720 here in this reduction column the reduction amounts to apply to the different 00:26:49.720 --> 00:26:57.600 customer groups by category. For example, here, I see that top has a 5% discount for the 00:26:57.600 --> 00:27:04.160 guest customer group. And so, you can modify its percentages, its values, 00:27:04.160 --> 00:27:06.960 its discounts, and so on directly here. You can do it in bulk, 00:27:06.960 --> 00:27:12.880 it's the same. You can right-click. Uh, I'll take all three. I'll take this one, 00:27:12.880 --> 00:27:17.400 I'll take these three. I'll right-click here and I'll be able to copy and paste my 00:27:17.400 --> 00:27:23.680 percentage. Also interesting, you can define the associations between groups and 00:27:23.680 --> 00:27:28.520 categories. For example, I take top here, I take client and I can say that 00:27:28.520 --> 00:27:35.560 client will no longer have access to top by clicking on the delete association button. 00:27:38.200 --> 00:27:42.240 I closed the right panel. I'm going back to the left panel, control panel, just to 00:27:42.240 --> 00:27:48.360 quickly show you some of the possibilities offered here. So in the part then we 00:27:48.360 --> 00:27:52.520 already saw display quickly earlier, you will be able to modify, I told you for example 00:27:52.520 --> 00:27:59.200 the zoom uh here is the display zoom in the step if it is if it is too small and you will be able 00:27:59.200 --> 00:28:03.440 to modify different ways of displaying things like the size of the photos for example 00:28:03.440 --> 00:28:10.440 or other equivalent things. in the part just below the calculation option. There, 00:28:10.440 --> 00:28:15.800 you have quite a few parameters, we will say advanced which will allow you to define 00:28:15.800 --> 00:28:20.360 how to display the data. In particular, you will be able to choose to display the 00:28:20.360 --> 00:28:26.680 data uh the prices including tax of the data, the prices of finally with tax for a given country. 00:28:27.240 --> 00:28:31.760 Uh, so simulate the fact of being, for example, not in France but in another country 00:28:31.760 --> 00:28:36.120 with different tax rules. To even do it for a group of 00:28:36.120 --> 00:28:41.360 specific customers or even choose a different date. Why choose a 00:28:41.360 --> 00:28:46.880 different date? Because the software is capable of displaying your prices taking into account discounts, 00:28:46.880 --> 00:28:51.600 calling up specific prices and doing it on a certain date. So, with 00:28:51.600 --> 00:28:59.200 Merlin, you can very well set up your discounts, your sales well before the sales period and view all 00:28:59.200 --> 00:29:06.240 the prices of your products, working as if you were already in the sales period. 00:29:06.240 --> 00:29:12.080 You also have functions to manage prices in certain warehouses 00:29:12.080 --> 00:29:16.200 , only if you work in advanced inventory management mode in a particular mode of Prestash 00:29:16.200 --> 00:29:20.440 Shop. So I'm not going too far into that for now, I'll let you see that in the 00:29:20.440 --> 00:29:26.040 tutorial dedicated to advanced inventory management. And you also have different calculation modes here 00:29:26.040 --> 00:29:31.560 for what we call margins. So, Merlin is capable when you modify your prices 00:29:31.560 --> 00:29:37.440 purchasing to automatically recalculate your selling prices to maintain the current margin rate 00:29:37.440 --> 00:29:45.600 or to establish a certain margin rate that you want. In the import and script section. 00:29:45.600 --> 00:29:49.880 Here, you have a whole bunch of tools, let's say additional tools that allow you to perform 00:29:49.880 --> 00:29:55.520 additional actions. For example, you can repair the database. 00:29:55.520 --> 00:29:58.320 So that's a pretty powerful tool. I can't show you everything here, 00:29:58.320 --> 00:30:03.320 but to repair a broken structure, tree structures that no longer display, really messy sites 00:30:03.320 --> 00:30:10.720 . There you have a whole bunch of tools of this type. Uh and you also have here, and above all, 00:30:10.720 --> 00:30:15.760 a very important button that many of you use in Prestap Racing, which is the 00:30:15.760 --> 00:30:24.120 XLS or CSV file import function. So, I'm not going to present it to you in detail, 00:30:24.120 --> 00:30:28.760 but there you have it, it's presented a bit like this with a five-step tool, uh, 00:30:28.760 --> 00:30:34.240 that allows you to do imports. We'll choose our file, we'll map it, 00:30:34.240 --> 00:30:39.400 so we'll match the file's columns to Prestashop sections, 00:30:39.400 --> 00:30:46.400 then read it, select the lines we want to import or not, possibly filter them, 00:30:46.400 --> 00:30:50.160 modify them, we really do what we want. It's really a visual tool. 00:30:52.600 --> 00:31:00.160 And then, uh, then choose the import parameters, uh, for example, to create or not the 00:31:00.160 --> 00:31:03.320 products, import or not the images, calculate prices automatically, 00:31:03.320 --> 00:31:06.720 finally a whole bunch of possibilities. You don't have to configure everything, 00:31:06.720 --> 00:31:12.000 practically everything is optional. And then finally the tool to either send 00:31:12.000 --> 00:31:18.560 the import or schedule it. Schedule means to program, uh, automations, 00:31:18.560 --> 00:31:25.200 finally, automatic imports on certain dates on a recurring basis, for example. 00:31:28.200 --> 00:31:32.160 So, in the important sub-tabs, there's one that's really fundamental, it's this one 00:31:32.160 --> 00:31:38.040 called image variation and in fact it has two functions. Both to process, to 00:31:38.040 --> 00:31:42.560 work on what we call product variations. So the product variations, 00:31:42.560 --> 00:31:47.640 I'm showing you, well, these are the different variants of one or more products. So 00:31:47.640 --> 00:31:52.400 here, this orange skirt exists in different sizes, for example. 00:31:53.080 --> 00:31:55.440 Uh, so that allows you to work on one product 00:31:55.440 --> 00:31:59.240 but also on several products, as many as you want, in fact. 00:31:59.880 --> 00:32:05.760 Uh, and there you will be able to modify these variants in this tab, but also generate them 00:32:05.760 --> 00:32:12.520 thanks to the famous generator, which is a complementary option of Merlin, which allows me, I 00:32:12.520 --> 00:32:16.360 won't explain it to you in detail, but which allows you to create new variants 00:32:16.360 --> 00:32:21.200 , modify existing ones, recalculate the impacts, duplicate the variations of a 00:32:21.200 --> 00:32:28.040 product to other products, etc. And then you also have a very high level 00:32:29.120 --> 00:32:34.680 here that will allow you to work on, well, first of all, what we call the attributes. 00:32:34.680 --> 00:32:38.080 So the attributes are what define the variations, for example, the sizes, 00:32:38.080 --> 00:32:42.240 the colors with their different values ​​here. So you can create a new size, 00:32:42.240 --> 00:32:46.960 a new color, new attributes as much as you want, make 00:32:46.960 --> 00:32:52.760 mass duplications, well as usual, a whole bunch of possible edits. And then you have what 00:32:52.760 --> 00:32:58.720 I wanted to show you especially the tab here image which is a very powerful tool for adding 00:32:58.720 --> 00:33:05.280 images to different products. And there are lots of different methods uh for sending 00:33:05.280 --> 00:33:10.400 local images, images through FTP addresses. You even have tools that allow you to 00:33:10.400 --> 00:33:15.080 automatically find in a folder the right images associated with the right products by 00:33:15.080 --> 00:33:20.680 comparing for example the reference of the products with the name of the files. that kind of thing. For 00:33:20.680 --> 00:33:27.920 uh a quick example, to uh add photos uh to certain products, you just have to go 00:33:27.920 --> 00:33:36.320 uh well on your browser uh uh excuse me, on your browser uh Windows Explorer, 00:33:36.320 --> 00:33:41.160 I can do it. Uh select the images you want, you do a simple drag and drop and the 00:33:41.160 --> 00:33:46.680 images are automatically added to the list here uh of images that it will have to send on 00:33:46.680 --> 00:33:52.920 the server. Uh we select them, we click on the send button and the images are 00:33:52.920 --> 00:33:58.600 automatically transferred en masse. Important to mention, during the transfer of the photos, uh the tool remains 00:33:58.600 --> 00:34:03.800 perfectly usable because the transfer of the photos is done in what we call a background task. 00:34:03.800 --> 00:34:08.640 So transparently for you, you keep all the I you do not 00:34:08.640 --> 00:34:15.000 need to wait for the images to be transferred to be able to continue working. 00:34:15.000 --> 00:34:18.520 There is also a new feature of Merlin, that is to say that it did not exist in Presta Pressing and 00:34:18.520 --> 00:34:23.840 Presta Category which I think is important to show you even in this introduction. Uh it is the 00:34:23.840 --> 00:34:30.840 notion of filtered selection. In fact, previously, when we searched for a category, for example 00:34:30.840 --> 00:34:37.240 , the dress categories, uh if we had to unroll the branches, search for the categories, 00:34:37.240 --> 00:34:43.160 select them or tap with the loop icon at the top to uh hope to find the first 00:34:43.160 --> 00:34:47.760 dress category. It was not very practical. In Merlin, you have a much more 00:34:47.760 --> 00:34:51.000 interesting function that you can use on other tables, not just on the table 00:34:51.000 --> 00:34:57.600 here of categories, which is called filtered selection, so it launches like this with a right click, 00:34:57.600 --> 00:35:01.120 so here in the column in which I want to search. So I put myself in the column no, 00:35:01.120 --> 00:35:06.800 I right-click anywhere in the column and I choose this function here 00:35:06.800 --> 00:35:14.120 filtered selection. In fact, it is a filter, uh, so of type well, a bit what you want, contains, 00:35:14.120 --> 00:35:18.400 begins, superior and so on. So here, I will simply put contains and I will type the 00:35:18.400 --> 00:35:25.480 word dress. I validate and see what happens. In fact, the tool is going to search in the database, 00:35:25.480 --> 00:35:32.200 uh, all the categories, uh, regardless of their location, their level and so on, which contain 00:35:32.200 --> 00:35:36.800 the word dress, uh, spelled the same way or with a capital letter, it doesn't matter, 00:35:36.800 --> 00:35:42.200 with or without s, it doesn't matter. And selected them. So we could very well, like 00:35:42.200 --> 00:35:47.600 this, on a store with 3,000 categories that contains, I don't know, car spare parts, 00:35:47.600 --> 00:35:52.240 automatically select all the categories that contain the word brake 00:35:52.240 --> 00:35:57.560 , regardless of the car brand. So, in a few clicks, you have a quick selection sign, uh, and 00:35:57.560 --> 00:36:01.720 what allows me, if I then display the products, to see all the dresses, in fact, all the 00:36:01.720 --> 00:36:07.240 products in the categories selected here. There you go. And so, as I was saying, this 00:36:07.240 --> 00:36:15.880 selection function, uh, uh, I can't do it anymore. Selective search selection. There you go, I'll get there. 00:36:15.880 --> 00:36:20.200 Uh, it can be done on any column. For example, here in the product table. 00:36:20.200 --> 00:36:24.840 Al, for example, I'm going to take all the categories here. So I have a lot more products 00:36:24.840 --> 00:36:29.440 displayed. If I want to see all the products and only the products that contain, well, the 00:36:29.440 --> 00:36:34.560 letter 7, I right-click in the name column. I select filtered, contains the word 00:36:34.560 --> 00:36:39.400 set or doesn't start. Anyway, it doesn't matter, once again, I validate. There, I have a lot more than the 00:36:39.400 --> 00:36:44.440 products that contain the word set. The others haven't disappeared, eh? It's not a filter, 00:36:44.440 --> 00:36:49.240 it's really a filtered selection. So in fact, it selected all the products that contained 00:36:49.240 --> 00:36:54.920 the letter 7 or the number 7. And from there, I can do whatever I want. 00:36:54.920 --> 00:37:00.240 Typically, if I, for example, want to round my selling price, which is here, my selling price 00:37:00.240 --> 00:37:05.400 before discount on these products only, I do my grouped action, round the prices. 00:37:06.000 --> 00:37:14.880 I have my rounding window, I'm going to round to the nearest currency and I apply it. There, 00:37:14.880 --> 00:37:20.160 you can clearly see my selling prices here, they are all rounded to the euro, but only on the 00:37:20.160 --> 00:37:27.880 products that were preselected with the filtered selection operation. 00:37:27.880 --> 00:37:31.120 So, there are still plenty of other tabs that I haven't had time to show you that will be 00:37:31.120 --> 00:37:37.080 the subject of specific training. I'll just list them quickly. So, I showed you, 00:37:37.080 --> 00:37:41.720 I think, the supplier table, the specific prices. You can also 00:37:41.720 --> 00:37:44.920 create new characteristics, characteristic values, 00:37:44.920 --> 00:37:49.800 Mass associate them with different products, uh of course, display them and then 00:37:49.800 --> 00:37:55.320 mass associate them. Uh you have a tab to manage your tags. I don't think there are any tags 00:37:55.320 --> 00:38:01.880 here. If I already have some. So the same, you can take products, select different tags 00:38:01.880 --> 00:38:08.480 or create new ones with one click, associate them or products selected above. You have a 00:38:08.480 --> 00:38:13.080 very important tool here for those who manage products associated with other products. For 00:38:13.080 --> 00:38:17.960 example, I don't know, someone recently told me that they were selling brushes and wanted to 00:38:17.960 --> 00:38:22.160 associate certain brushes with certain types of paint. So that's the notion of accessory. 00:38:22.160 --> 00:38:26.120 Well, you can make these cross-associations quickly with this tab 00:38:26.120 --> 00:38:32.000 here accessory. Uh a tab to manage carriers, so the associations between the 00:38:32.000 --> 00:38:37.960 different carriers and the products. Uh I think I showed you this tab 00:38:37.960 --> 00:38:42.760 in the table, you saw it, categories, so that allows you to manage the translations of 00:38:42.760 --> 00:38:48.800 articles in any language. Uh, so here, there are few columns displayed, 00:38:48.800 --> 00:38:54.640 but of course, you can add more by working in the column configurator. 00:38:54.640 --> 00:39:01.200 And finally, a tab here to manage attachments, attached documents associated with the product. Well, 00:39:01.200 --> 00:39:05.920 there are still plenty of other things. I'll stop there. Uh, I wasn't comprehensive, far from 00:39:05.920 --> 00:39:11.120 it. So the goal was to give you an overview, an overview of what Merlin is, how to 00:39:11.120 --> 00:39:16.280 use it. You can of course call me, eh, support is free, it's important. 00:39:16.800 --> 00:39:21.320 Uh, there's a remote support tool in Merlin that allows you to share your screen 00:39:21.320 --> 00:39:26.400 and show you how to do something you can't do yourself. Of course, 00:39:26.400 --> 00:39:31.680 there are the training courses, these tutorials that I'm currently creating and which will soon cover 00:39:31.680 --> 00:39:36.720 all the software features. There you go, enjoy your discovery and see you soon.