WEBVTT Kind: captions Language: en 00:00:00.000 --> 00:00:16.500 Setting up sales is one of the common problems facing businesses. We will see in 00:00:16.500 --> 00:00:24.150 this training how to set up sales or discounts in different ways with Merlin back-office. 00:00:24.150 --> 00:00:29.250 We will already see how to use its brute force call, that is to say, 00:00:29.250 --> 00:00:35.040 directly modify prices by applying a decrease or an increase in price in 00:00:35.040 --> 00:00:40.140 bulk. This is not the best method since it changes in a definitive way. Prices are 00:00:40.140 --> 00:00:45.240 really created, what we call crossed-out prices. Second phase, we are good. We will create what we 00:00:45.240 --> 00:00:52.500 call specific prices, special prices or crossed-out prices, always with Berlin. We will also see the 00:00:52.500 --> 00:00:59.670 concept of decreasing prices, which is a form of special prices based on purchase quantities. We 00:00:59.670 --> 00:01:05.550 will also see how to import special prices or crossed-out prices from a 00:01:05.550 --> 00:01:12.690 CEO file. Excellent. And finally, we will also see the concept of prices by customer groups. This is 00:01:12.690 --> 00:01:16.950 not quite what we call a discount or sales type, but permanent discounts 00:01:16.950 --> 00:01:25.530 or permanent differentiated prices based on each customer group by category. All 00:01:25.530 --> 00:01:32.550 this can be done in bulk with Merlin. So the first method is the modification. in bulk of 00:01:32.550 --> 00:01:39.270 prices so for that you have to start by displaying your products and include in our display the 00:01:39.270 --> 00:01:47.010 columns that you want to modify so either you have inked a configuration where it has already been created you 00:01:47.010 --> 00:01:53.520 choose the configuration that corresponds when it contains the columns like hulu modifies for 00:01:53.520 --> 00:01:59.710 example here it is a configuration that I created especially for the prices here I have 00:01:59.710 --> 00:02:06.040 my column so sale price let's imagine that I want to increase all contempt or decrease all 00:02:06.040 --> 00:02:16.060 contempt by 5% so I display all my products I select them the all button and so I will 00:02:16.060 --> 00:02:22.000 apply a calculation to apply a calculation we click on grouped actions and in 00:02:22.000 --> 00:02:30.940 grouped action we have a tool modified by calculation so which is displayed here I take the opportunity to show the fact 00:02:30.940 --> 00:02:36.820 that you also have in image variation if you display the variations of the 00:02:36.820 --> 00:02:45.850 selected products also so in the grouped action button you also have the calculator 00:02:45.850 --> 00:02:53.380 the function modification by calculation it will allow you to modify the impacts on the 00:02:53.380 --> 00:03:01.030 sale price excluding tax and including tax dia this tool we will do it simply on the products at 00:03:01.030 --> 00:03:05.380 first so I spent some 10-year variations of that we will gain a little space 00:03:05.380 --> 00:03:17.020 so on this calculator how it works you just have to choose here its percentage for example 00:03:17.020 --> 00:03:24.340 my 5% of well you put in value percentage in parameter percentage and not in amount or 00:03:24.340 --> 00:03:31.090 in value I will apply a percentage it is not simply 5 euros then you choose the 00:03:31.090 --> 00:03:38.890 column on which you want to act I want to act on the sales prices including tax the values ​​here which 00:03:38.890 --> 00:03:44.290 are grayed out indicates the fact that quite simply the columns are absent from the display can 00:03:44.290 --> 00:03:47.380 only work this tool on the columns present so if you parents to work 00:03:47.380 --> 00:03:51.220 on the unit price ratio leave here to dig but it will be necessary to go in the 00:03:51.220 --> 00:04:00.070 column configurator to select it so I take sales price including tax and I apply the modification either 00:04:00.070 --> 00:04:04.570 I add but 5% or I remove my 5% we can also do other things like divided pupil 00:04:05.330 --> 00:04:14.720 or apply a direct value so I do less merlin show me the result so we will go 00:04:14.720 --> 00:04:25.220 here from 39,124 to 37.64 identically for the other values ​​if that me suitable I suffer here 00:04:25.220 --> 00:04:30.080 the backup is done in the base to the loans have been modified so I have thus on the fact that 00:04:30.080 --> 00:04:36.050 we have modified the prices but will not appear information of the type in sales or prepare 00:04:36.050 --> 00:04:40.700 on your products it is really a definitive notification once again it is not the best 00:04:40.700 --> 00:04:45.980 method to set up floors it is certainly the best method if you take 00:04:45.980 --> 00:04:51.530 your purchase prices globally have been modified or are modified once a year for example and you 00:04:51.530 --> 00:04:59.360 want to modify all the prices of your site then this method another disadvantage is that it 00:04:59.360 --> 00:05:05.330 requires displaying the products so if we have like here a small ten it is fine but 00:05:05.330 --> 00:05:11.090 if you have tens of thousands of products it can slow down your workflow considerably 00:05:11.090 --> 00:05:16.070 so there is another method very close to this one without the display of the products I will 00:05:16.070 --> 00:05:22.670 show you so I deactivate in display has nothing more in my product table and I go 00:05:22.670 --> 00:05:30.590 directly to my control panel in my English kate there would be products is here you 00:05:30.590 --> 00:05:36.080 have a grouped action button on products I click on it in which you 00:05:36.080 --> 00:05:42.080 also find modified product by calculation and you find yourself here with the same type of calculators 00:05:42.080 --> 00:05:49.190 in this tab is in fact this calculator here will act on all the products of the categories which 00:05:49.190 --> 00:05:55.580 were selected above without needing to have needed to display as typically g 00:05:55.580 --> 00:06:01.610 do the same operation I take five smoked in percentage I chose what I want 00:06:01.610 --> 00:06:08.690 to work on for example the selling price including tax and I click on my - is itself asked for 00:06:08.690 --> 00:06:16.340 confirmation I continue or I cancel so there we are in mode we will say blind we do not see the 00:06:16.340 --> 00:06:22.770 result you have to trust berlin to do the calculation correctly but we really save 00:06:22.770 --> 00:06:27.060 time on this kind of processing once again we do not need to display the products 00:06:27.060 --> 00:06:35.190 the second approach therefore consists of creating what we call specific prices or special prices so 00:06:35.190 --> 00:06:43.680 in merlin it happens here in the tab of the same name specific price which allows in this table 00:06:43.680 --> 00:06:50.310 here firstly to display by clicking on display the already existing prices the 00:06:50.310 --> 00:06:55.980 already existing special prices and selected products if I select all my products I see here 00:06:55.980 --> 00:07:06.720 the different special prices a tip or an interesting possibility is to separate or 00:07:06.720 --> 00:07:12.930 group the different lines here by product to do that we put what we call a break 00:07:12.930 --> 00:07:18.450 so I will go to the heidi pr column which means and 10 of the products I 00:07:18.450 --> 00:07:25.560 right click and I want to tell it to add a break this column and you see so I have 00:07:25.560 --> 00:07:37.050 a grouping of the lines like here by product I can unroll roll up the special prices by 00:07:37.050 --> 00:07:46.890 product so it is up to you allows you to view the current special prices as for the table 00:07:46.890 --> 00:07:53.250 of products or other tables you can customize the display of the columns so in 00:07:53.250 --> 00:08:02.490 columns here you have a specific price tab with on the right the columns already present in my 00:08:02.490 --> 00:08:09.360 table and on the left the one that you can add so if for example I want to have the final price 00:08:09.360 --> 00:08:17.070 or crossed out prices out taxes or including tax here taken part and including tax I add it to the place where I want 00:08:17.070 --> 00:08:25.620 my configuration and I validate I have my price including tax crossed out it is added somewhere here here 00:08:26.870 --> 00:08:33.680 I will display all my lines you can modify the data directly in this 00:08:33.680 --> 00:08:39.410 table it is for example I will modify are said here hans % it is simply enough 00:08:39.410 --> 00:08:49.070 of lilith is therefore a special price a notion of prestashop it is a price in celebration which is 00:08:49.070 --> 00:08:55.790 defined by characteristics of the type in which store this price applies it 00:08:55.790 --> 00:09:02.510 can all or a store in particular on which currency it applies 00:09:02.510 --> 00:09:09.710 in which country for which groups of customers for a specific customer if you wish then it is 00:09:09.710 --> 00:09:17.960 most often made up of a reduction amount which can be either defined as a percentage or in value 00:09:17.960 --> 00:09:26.630 in euros in dollars for example in currencies if it is in amount in value at that time 00:09:26.630 --> 00:09:31.760 you can choose if it is a value including tax or excluding tax so by checking this option 00:09:31.760 --> 00:09:39.740 when we actually put a reduction of this type there these are percentage or in value 00:09:39.740 --> 00:09:47.540 it will create a price crossed out in your site this crossed out price it could be applied permanently 00:09:47.540 --> 00:09:53.390 or from a given date to another date so it is the start date to 00:09:53.390 --> 00:09:58.760 end date modified copy here and finally it can be defending depending sorry on a certain quantity 00:09:58.760 --> 00:10:03.800 to buy so by default these quantities 1 but you can very well but two three 00:10:03.800 --> 00:10:09.650 axes field which means that you will have a decreasing price in this case and finally you have 00:10:09.650 --> 00:10:16.520 another important parameter which is called the new base price which since prestashop 1.5 00:10:16.520 --> 00:10:22.610 I believe at least one which means that the base price is not modified the base price is 00:10:22.610 --> 00:10:29.690 the sale price of the product by default it is not modified but on this sale price we apply 00:10:29.690 --> 00:10:36.710 a percentage discount or value if on the other hand you modify the new base price column 00:10:36.710 --> 00:10:44.000 at that time the price that you will put here for example if I enter instead of 00:10:44.000 --> 00:10:50.660 -1 if I lie I enter without that means that I have modified my selling price of the product to 100 00:10:50.660 --> 00:10:58.070 so according to the conditions that I put here my country my group mad meeddat and it is my 00:10:58.070 --> 00:11:05.150 foaming product and on which I can apply or not a discount if I do not have a discount here 00:11:05.150 --> 00:11:15.500 like these at that time it means that young I only apply a new 00:11:15.500 --> 00:11:20.060 base price to my product that is to say that I modify my selling price of my 00:11:20.060 --> 00:11:26.060 product but I do not create a discount so I do not create crossed out prices so for this 00:11:26.060 --> 00:11:33.290 product there for this line if on the site the price will not be paris but simply 00:11:33.290 --> 00:11:38.870 modified replace without giving information to the buyer that it is not the original price 00:11:38.870 --> 00:11:45.980 then with merlin it is of course quite possible to modify several lines at the same 00:11:45.980 --> 00:11:51.860 time it is the notion of mass modifications which is the essence same of whiting so let's suppose 00:11:51.860 --> 00:11:58.910 that for example on this product there finally this price there this one this one I want we will 00:11:58.910 --> 00:12:05.660 do two different things first operation is to copy an amount in other lines or 00:12:05.660 --> 00:12:10.070 copy a property in other lines for example copied say and of course these three 00:12:10.070 --> 00:12:17.600 other specific prices it is enough to click on the say with the right mouse button is 00:12:17.600 --> 00:12:25.430 at the bottom of my menu there I can't show you my found the way you have to click on 00:12:26.370 --> 00:12:30.120 the option which is called package 10 in all the selected cells of this column so it is 00:12:30.120 --> 00:12:37.140 at the bottom of the menu merlin shows me what will do as an operation that is to say copy the value here 00:12:37.140 --> 00:12:43.320 in orange in the values ​​in dark blue if I like it I continue there it is saved in the database 00:12:43.320 --> 00:12:48.990 and it's finished another way of doing well it's like for earlier we have here 00:12:48.990 --> 00:12:57.210 the function modification by calculation so who would pay me which allows me on the section which 00:12:57.210 --> 00:13:04.440 interests me for example the reduction to choose to apply a calculation operation for example 00:13:04.440 --> 00:13:10.770 I multiplied by two in value so I take 2 in value and I click on multiply it will 00:13:10.770 --> 00:13:19.050 multiply by 2 May reduction of 10 I go before and if I like it I modify that's it so 00:13:19.050 --> 00:13:24.780 could do this type of operation on different columns of course the numeric columns but 00:13:24.780 --> 00:13:30.930 also the example and date a group copy the dates from a column end of a cell to 00:13:30.930 --> 00:13:37.800 other cells of the same column so to modify the special prices it's good but you 00:13:37.800 --> 00:13:47.880 also have to be able to write it so let's imagine that we are not at all so I will delete everything sorry 00:13:47.880 --> 00:13:54.810 the gipa all selected so I select everything I delete everything and we will start from scratch so 00:13:54.810 --> 00:14:00.600 I have all my products which are selected to add a specific price and well you have to click 00:14:00.600 --> 00:14:08.400 here on this blue link change adds kim displays a creation form a modification of the 00:14:08.400 --> 00:14:15.900 special prices so in this form we find what we call the conditions headings 00:14:15.900 --> 00:14:20.730 so checkout under which conditions the price applies so that once we find the choice of 00:14:20.730 --> 00:14:25.860 the store of the external currencies of the group of customers or even the search for a 00:14:25.860 --> 00:14:34.200 special customer the famous new base price which is worth less one by default the purchase quantity on which 00:14:34.200 --> 00:14:40.870 the price applies the reduction in percentage or in value the choice excluding taxes and including taxes and finally 00:14:40.870 --> 00:14:49.750 the application dates so let's imagine that I want to apply on this product if and on this one 00:14:49.750 --> 00:14:59.290 the third 5% discount I put my 5% in five sets chosen for percent the other parameters 00:14:59.290 --> 00:15:04.990 please me so no special conditions applies everywhere from the quantity a set 00:15:04.990 --> 00:15:12.010 made modify or add so it will create two lines in my table but bothered this time that 00:15:12.010 --> 00:15:18.070 I want to create a second discount but this time a discount of specific type from the 00:15:18.070 --> 00:15:27.880 quantity 10 I will apply 15 euros in value including taxes I changed my parameters again if 00:15:27.880 --> 00:15:33.280 I wanted to apply a data group or a particular customer or a given country and it is enough for me 00:15:33.280 --> 00:15:42.310 to choose it in my list choose Germany and I apply here so here I created two 00:15:42.310 --> 00:15:50.410 special prices of specific loan for my two products imagine this time that I want to apply 00:15:50.410 --> 00:15:56.020 for example this special price here for Germany to apply it to all my products comes it is enough 00:15:56.020 --> 00:16:05.260 I just excuse me to select one of the lines containing me took my values ​​and look what 00:16:05.260 --> 00:16:10.660 happens when I do it here you see the values ​​in the form change fill 00:16:10.660 --> 00:16:18.490 with the data of the line so I select my line with my special price for Germany and 00:16:18.490 --> 00:16:24.310 at 15% it automatically fills me in the form selects the products on which I will 00:16:24.310 --> 00:16:30.850 apply the same discount for example all I still have my values ​​from my form I 00:16:30.850 --> 00:16:37.870 just have to modify or add and my special price of 15 euros pass for Germany 00:16:37.870 --> 00:16:44.140 will apply therefore to all my products what we can see here the two products which already had this 00:16:44.140 --> 00:16:49.810 price do not end up with a duplicate price a merlin takes care to compare what 00:16:49.810 --> 00:16:55.990 already exists and to apply new specific prices only if the same fold does not already exist in the database, 00:16:55.990 --> 00:17:06.880 this also allows me to show you something else, let's suppose that this famous 15% here for 00:17:06.880 --> 00:17:16.240 Germany, I want to modify it in any tool other than Merlin, you would have to 00:17:16.240 --> 00:17:23.500 go to modify to search for these special prices and modify them one by one, product by product, in 00:17:23.500 --> 00:17:29.860 Merlin it's very different, you just have to take any one of them, once again 00:17:29.860 --> 00:17:36.010 the form is filled with the properties of this line and there I can modify my value, 00:17:36.010 --> 00:17:45.820 for example m 11 to go from 15 to 11 in value, then selected goods, all the products on 00:17:45.820 --> 00:17:51.760 which I will apply the modification and click on modify added and in fact what 00:17:51.760 --> 00:18:01.300 Merlin does is that it searches in my carpet if all the lines which contain exactly 00:18:01.300 --> 00:18:07.690 the same filter on the specific prices, so the same shops, same foreign currencies, the same 00:18:07.690 --> 00:18:14.590 quantity and especially the same, the same date period and they apply the modification, so 00:18:14.590 --> 00:18:22.240 here I take my 11, I apply and see all my special prices corresponding to the 00:18:22.240 --> 00:18:28.480 same application criteria are modified en masse because we have just created these are 00:18:28.480 --> 00:18:32.680 specific prices for the product which applies to all their variations and 00:18:32.680 --> 00:18:37.090 we see it here one year the variation thread marked all also here in the variation column 00:18:37.090 --> 00:18:42.250 all you need to know that you can also create special prices by variation so 00:18:42.250 --> 00:18:48.550 to do that it's simple you always select the same where the products on which you 00:18:48.550 --> 00:18:52.870 apply the prices so I will take only one in this example I go to the 00:18:52.870 --> 00:19:00.850 variation tab images I display my variations and I select those which interest me good 00:19:00.850 --> 00:19:08.510 game could for example use a filter we will do it to keep that I choose filtered 00:19:08.510 --> 00:19:13.160 on this column those which contain the word orange so that the variations range in my 00:19:13.160 --> 00:19:19.940 case I validate there they are filtered I select them all and I return to my 00:19:19.940 --> 00:19:25.280 specific price and this time before applying took me for example what interests me 00:19:25.280 --> 00:19:33.320 is a price of 20% on everything east especially its orange colored t-shirts 20 in percentage 00:19:33.320 --> 00:19:42.530 on all the countries maybe I put a particular date so so there the format of the 00:19:42.530 --> 00:19:55.940 dates where this American form so 2018 we will say go from 12 12 to 0 until 2019 00:19:55.940 --> 00:20:11.510 15 so it is the month first so 0.1 including January 15 and so I come back to my point I want 00:20:11.510 --> 00:20:16.820 to apply this discount only on the variations that I have selected only on the 00:20:16.820 --> 00:20:24.380 range variations so I choose here in variation those which are currently selected a small oversight 00:20:24.380 --> 00:20:28.640 game but one on my quantity so it is really a similar price that I want and not a 00:20:28.640 --> 00:20:38.210 decreasing fold by quantity and I apply and here so on this product if we see well here we have 00:20:38.210 --> 00:20:44.480 three new special prices have been created which only apply to my three orange color 00:20:44.480 --> 00:20:51.740 variations so I added the final price column including tax of a my table of specific prices 00:20:51.740 --> 00:20:56.360 to show you another very interesting feature which consists of being able to round 00:20:56.360 --> 00:21:02.960 these final prices in bulk after discount so for that it is enough to select the lines that I 00:21:02.960 --> 00:21:11.480 wish to round to go to grouped action choose the tool round the prices it is a 00:21:11.480 --> 00:21:16.480 window which opens allowing to round so we took care of sale including tax before 00:21:16.480 --> 00:21:21.550 me is the final folds including tax after discount so there is what interests me then to choose 00:21:21.550 --> 00:21:27.370 the type of rounding which interests me for example to the currency higher or lower loans or the 00:21:27.370 --> 00:21:38.950 closest is to apply there you see the final prices including tax rounded so what did 00:21:38.950 --> 00:21:44.680 merlin do to be able to obtain his prices we call that psychological and well in fact he recalculated 00:21:44.680 --> 00:21:51.400 precisely the amount of the reduction whether in percentage or in value to obtain my 00:21:51.400 --> 00:21:57.250 very particular price well rounded you should know that you can also display in the duo table 00:21:57.250 --> 00:22:01.270 a lot of information concerning vorbis so we will do it I go to my 00:22:01.270 --> 00:22:06.790 column configurator I go to my product English and in my product English you have a part 00:22:06.790 --> 00:22:12.460 which is called discount and I'm going to add some important sections so this one calls for a single 00:22:12.460 --> 00:22:17.980 question mark I'm going to explain to you what it's for and I'm going to add my crossed out price 00:22:17.980 --> 00:22:24.550 including VAT my final sale price is also the amount of the discount do not confuse 00:22:24.550 --> 00:22:29.020 the amount of the discount with the percentage reduction that you have here who do not know that they 00:22:29.020 --> 00:22:36.010 only existed in prestashop a 1.4 or before since 1 4 we have the discount chin which can 00:22:36.010 --> 00:22:42.910 contain either the value or the percentage so I apply and I therefore find myself in the 00:22:42.910 --> 00:22:49.390 top table as I indicated to you with this data if the sales amount including VAT or the crossed out price is 00:22:49.390 --> 00:22:56.200 grayed out as is the case here this means that the product actually has variations and as 00:22:56.200 --> 00:23:01.120 it has variations in fact it has as many prices if final sales prices as two variations 00:23:01.120 --> 00:23:08.320 so if I go to variation image that I display the variations of this product we 00:23:08.320 --> 00:23:16.780 are not worth here and we therefore also have a sale price per variation crossed out and final 00:23:19.530 --> 00:23:25.230 so two things that I wanted to show you the first is this section on sale 00:23:25.230 --> 00:23:34.110 here that you can check in bulk like this allows you to display the logo in ground on 00:23:34.110 --> 00:23:37.890 the images of the products so to indicate to your customers who has a discount that applies 00:23:37.890 --> 00:23:46.350 how often people ask me but how to sort the products that are discounted 00:23:46.350 --> 00:23:52.740 so to sort the products that are revised in an absolutely can check this parameter 00:23:52.740 --> 00:24:01.170 on sale often the safest and most relevant is in your column configuration always 00:24:01.170 --> 00:24:08.490 the same in the discount part is to include this section identifying specific applicable prices 00:24:08.490 --> 00:24:17.730 I put it in my table and this column will therefore contain a number when the price 00:24:17.730 --> 00:24:25.560 is crossed out in what there is a specific price that is displayed see this one this one exists and 00:24:25.560 --> 00:24:31.170 so if you sort in relation to this section for example by filtering on this column 00:24:31.170 --> 00:24:44.310 but different from nothing I delete fishing valid so different nothing works I have the 00:24:44.310 --> 00:24:49.350 products that have a specific price that applies to today's date is so once filtered 00:24:49.350 --> 00:24:55.530 I just have to select my products and check if this is not already done the logo in sales 00:24:55.530 --> 00:25:03.270 at the display level so you will have understood that a given product can have several 00:25:03.270 --> 00:25:08.850 specific prices including prices which will apply different dates to sales periods or 00:25:08.850 --> 00:25:15.240 promotional periods which overlap or not and it is therefore merlin finally prestashop to a management 00:25:15.240 --> 00:25:21.290 of this type of conflict quite particular based on the notion of priority so you will be able to 00:25:21.290 --> 00:25:27.860 configure the fact that prestashop will first use the specific price for 1 2 bags not 00:25:27.860 --> 00:25:32.540 for a given country before using the one for a certain screw on the contrary give priority 00:25:32.540 --> 00:25:37.790 to groups of external customers but above all the notion of date is the most important the price 00:25:37.790 --> 00:25:43.880 which will apply is the one which was finished on the date of the day so how to do in 00:25:43.880 --> 00:25:51.260 Merlin display the prices in the tables that we attack duo for example the date of January 15th 00:25:51.260 --> 00:25:57.230 while we are in the month of December and well you can do it in the control panel in 00:25:57.230 --> 00:26:06.860 calculation options here and if you go down you will see that here you can check the parameter 00:26:06.860 --> 00:26:17.480 other date to ask it to display here the prices on a given date so in 2010 January 9th for 00:26:17.480 --> 00:26:24.500 example January 15th well then that you want it doesn't matter so by setting like these 00:26:24.500 --> 00:26:28.610 Merlin and well all the prices of the table of products the table of variations this field 00:26:28.610 --> 00:26:37.250 will take into account the specific prices applicable to this date 6 likewise you will be able in the same 00:26:37.250 --> 00:26:41.420 place here to ask it to indicate the prices for a group of particular customers 00:26:41.420 --> 00:26:52.520 see a particular customer so that is very useful specifically for for example to generate 00:26:52.520 --> 00:27:02.270 pdf catalogs for a group of customers in advance before the sales or there you go to all sorts 00:27:02.270 --> 00:27:08.990 of criteria not necessarily applicable to the dates on today's date but at a later date 00:27:11.520 --> 00:27:16.410 methods now to create your discounts consists not of working from the more 00:27:16.410 --> 00:27:23.580 specific tab directly but to import your data via a csv or excel file then we 00:27:23.580 --> 00:27:28.170 are not going to redo a training on the import that is not the goal I refer you for that or 00:27:28.170 --> 00:27:35.940 dedicated tutorial we will just launch the import window and I will just indicate some small tips 00:27:35.940 --> 00:27:42.510 on the use of this tool for specific loans in particular so I prepared 00:27:42.510 --> 00:27:51.390 for this tutorial an example that I called words here so an xls file in this case is what I 00:27:51.390 --> 00:27:58.740 will show you right away it is the mapping so in the mapping what I want on 00:27:58.740 --> 00:28:08.850 what I want to insist on is that you have in your list of headings map abl here a whole 00:28:08.850 --> 00:28:18.960 bunch of parameters specific to the specific prices which are here and which we can recognize thanks 00:28:18.960 --> 00:28:24.360 precisely to the indication in parentheses specific price see e-boutique heidi currency 00:28:24.360 --> 00:28:29.130 specific price heidi country and the customer groups new base price from the quantity 00:28:29.130 --> 00:28:37.410 amount discount rate type of reduction including tax and the two dates so in fact we find exactly 00:28:37.410 --> 00:28:43.800 the same parameters as in the English form specific price so it You just need 00:28:43.800 --> 00:28:48.630 to have data corresponding to its columns corresponding to this data 00:28:48.630 --> 00:28:53.580 and the maps and its particular headings to import your specific loans which you 00:28:53.580 --> 00:28:58.350 do not need everything of course in fact it is enough to create a specific price in 00:28:58.350 --> 00:29:04.620 bulk to have a column containing the amount or the round of the discount just that it is enough by 00:29:04.620 --> 00:29:09.540 default it will consider that it is a percentage if it is not a percentage at that time you 00:29:09.540 --> 00:29:16.320 include the column type of reduction to indicate either the word people of age or the word amount 00:29:17.720 --> 00:29:22.640 in English that is to say to mount there I am sorry so that is an internal language of 00:29:22.640 --> 00:29:27.230 prestashop so it is really nobody task in English or a mood that must be put it is not a 00:29:27.230 --> 00:29:33.500 value of type 1 or 2 it will not accept so here are these two columns are enough most of the 00:29:33.500 --> 00:29:37.850 time or even simply this one and then if it is a decreasing price you can 00:29:37.850 --> 00:29:44.420 put from so to put the quantity necessary to apply this specific price if 00:29:44.420 --> 00:29:49.220 it is an amount possibly you can put the column including tax which is a checkbox that 00:29:49.220 --> 00:29:54.380 contains heroes of a by default it is zero so it is tax-free and finally the 00:29:54.380 --> 00:30:00.170 application dates if you do not specify the application dates so if you do not kill 00:30:00.170 --> 00:30:05.000 these 2 columns at that time these are specific prices that apply all the time 00:30:05.000 --> 00:30:13.520 and finally you have filters of the type limit to a store limited data a given currency 00:30:13.520 --> 00:30:18.920 or a country a group of customers or even a customer you can in the same way use 00:30:18.920 --> 00:30:24.740 the new base price column without already explained to modify the base price of the product 00:30:24.740 --> 00:30:29.780 so if this column is absent the new base price will be worth less 1 that is to say that 00:30:29.780 --> 00:30:34.520 we do not apply a modification to the price of the product what we do is that we apply a discount 00:30:34.520 --> 00:30:39.800 on the base price if you have a new base price column in the contract this new 00:30:39.800 --> 00:30:46.760 base price will replace the sale price of the product before applying or not a discount on this price 00:30:46.760 --> 00:30:56.360 not then a particularity is that merlin is able to analyze the title of the column 00:30:56.360 --> 00:31:05.150 for example like this price 100-200 or price 200 500 to anticipate and try to understand 00:31:05.150 --> 00:31:11.270 what you are asking him here by analyzing these titles there he understood that it was a 00:31:11.270 --> 00:31:17.810 new base price of specific price from the quantity without desert that he took the first 00:31:17.810 --> 00:31:25.010 number of the text to understand that it was from a certain quantity here he did 00:31:25.010 --> 00:31:32.790 the same thing price of 105 100 he filled all alone from the quantity of blood you can 00:31:32.790 --> 00:31:43.260 also define prices or reductions without specifying in the title the quantity while it 00:31:43.260 --> 00:31:50.970 presents here then there the quantity was specified reduction ps pc prg ps specific advancing in 00:31:50.970 --> 00:31:57.330 fact before that we mean from 0 to 100 so at that moment in this field here Thursday 10 finished 00:31:57.330 --> 00:32:01.470 that I tell him that it is a minimum quantity defined by the column from the quantity 00:32:01.470 --> 00:32:07.500 moreover basically by default it is from 1 but if I have a column from the quantity 00:32:07.500 --> 00:32:12.810 here it is so franck comptines so there I have a column from the quantity which will contain 00:32:12.810 --> 00:32:20.970 a number so maybe 1 or maybe more and well typically this reduction here will apply 00:32:20.970 --> 00:32:26.670 from the quantity defined in this column while this one by this new base price 00:32:26.670 --> 00:32:33.690 here will apply from the quantity of 200 which were recognized automatically thanks to the 00:32:33.690 --> 00:32:38.640 new numbers 200 in the title so what I wanted to show you is you can thus 00:32:38.640 --> 00:32:45.930 have several columns in the same file to define your decreasing prices that is to say 00:32:45.930 --> 00:32:50.790 different base prices or different discounts from the different quantities so this is the case 00:32:50.790 --> 00:32:56.550 here we see that we have a base price from meaning we have another base price from 200 00:32:56.550 --> 00:33:04.980 we have an amount or a discount rate to part to the quantity meaning and we have somewhere our 00:33:04.980 --> 00:33:11.760 famous quantity which will define the amount at the discount rate from this quantity 00:33:13.950 --> 00:33:20.880 finally our type of reduction here is typically an example of a rather complicated import this one of 00:33:20.880 --> 00:33:28.200 specific price and new base prices to know as when using English 00:33:28.200 --> 00:33:32.700 specific loan merlin does not create a duplicate when we import specific prices it will 00:33:32.700 --> 00:33:37.620 look in the database if there are already specific prices identical to your words which apply 00:33:38.380 --> 00:33:46.300 in the same conditions same currency same country same date same quantity so really 00:33:46.300 --> 00:33:50.710 the same criteria and if it is the case it will update its specific prices that is to say 00:33:50.710 --> 00:33:55.720 that it has modified the amount or the new low price which is indicated in the file but in 00:33:55.720 --> 00:34:02.170 no case it will create a duplicate I think that it is obvious but it is better by saying it 00:34:02.170 --> 00:34:08.980 it is possible to create specific prices two variations via the import so there what we 00:34:08.980 --> 00:34:15.400 have just shown you is that it will create specific prices lobo to the product since we are in 00:34:15.400 --> 00:34:19.180 product mode of which which applies to all their variations and if I switch to 00:34:19.180 --> 00:34:25.630 variations mode like these and I indicate in one place for example with its 2 columns 00:34:25.630 --> 00:34:34.390 heidi product attribute laïdi of the variation or in another way at that time by with 00:34:34.390 --> 00:34:38.980 the reference or the coast barack steira but from the moment when the program is able 00:34:38.980 --> 00:34:43.570 to identify the variations at that time the specific price which will be created in the same way 00:34:43.570 --> 00:34:50.050 as seen previously will only apply to this variation finally only to the variation defined 00:34:50.050 --> 00:34:55.930 for each of the lines so to complete this part on the specific prices I will 00:34:55.930 --> 00:35:01.540 show you now how with merlin to store the products in a category called sales or 00:35:01.540 --> 00:35:06.670 promotions technical quite common during the sales periods of January or July for 00:35:06.670 --> 00:35:13.930 example so to do that we go to the category view we will already create our category in 00:35:13.930 --> 00:35:21.460 ground so I was rolling my tree to choose where jules instead and I hear to realize that 00:35:21.460 --> 00:35:25.660 my data is in English it's not a big deal we'll switch to French I didn't pay attention 00:35:25.660 --> 00:35:31.870 I go to a display here you have the language I switch to French and I think 00:35:33.940 --> 00:35:40.330 so I unfolded my tree I chose where I put my category for example in welcome 00:35:40.330 --> 00:35:46.000 then I remove the recursive mode to be able to choose a single category here you have a 00:35:46.000 --> 00:35:52.300 new button and I create my category for example I will call it promotion 00:35:52.300 --> 00:36:01.090 so that's I remind you of a technique here to create categories category names 00:36:01.090 --> 00:36:06.340 automatically using the name of the store using the name of the category but review 00:36:06.340 --> 00:36:13.480 its identifier and if you just want to give a nonsense more technicality you just put the 00:36:13.480 --> 00:36:19.390 name in beginning in the middle or end like that there we can choose lots of other parameters I 00:36:19.390 --> 00:36:26.590 went to the essential I create my category it's finished I close there I have my 00:36:26.590 --> 00:36:35.500 promotion category I come back to product view so we will close the display is ready specific we no longer 00:36:35.500 --> 00:36:41.050 need I will activate my control panel I like the inked you know the technique for 00:36:41.050 --> 00:36:51.670 their cave always open I will choose everything but category which activates the recursive mode here 00:36:51.670 --> 00:36:57.160 I only have two products why because remember I had set up my filter 00:36:57.160 --> 00:37:05.170 indicating or limiting the list of products to those which have a specific price therefore a discount 00:37:05.170 --> 00:37:13.150 and remember this filter it is dependent on the criteria here defined in calculation options 00:37:13.150 --> 00:37:18.640 in particular the date so I will remove its hosts this other date this film other dates 00:37:18.640 --> 00:37:25.000 in order to see all the products which have a specific price on today's date 00:37:25.000 --> 00:37:31.630 so here we have two I select them all and so all these products there what I would like 00:37:31.630 --> 00:37:41.680 is to associate them with my promotion category so I will see target categories I 00:37:41.680 --> 00:37:49.990 unfold I choose promotion then I have two techniques either I click on this tab here 00:37:49.990 --> 00:37:58.120 which will make the association or I click on the see associations button in order to display 00:37:58.120 --> 00:38:05.920 a column showing me which category the selected products are associated with and being able 00:38:05.920 --> 00:38:10.600 to make multiple associations in a single operation so I will take this second 00:38:10.600 --> 00:38:17.080 technique I put myself on promotion I click here I ask myself if I want to keep the associations 00:38:17.080 --> 00:38:22.570 other than those made to promotion so those which are already done I say yes so basically 00:38:22.570 --> 00:38:29.620 products visible in the other categories and it's finished my association affects so if 00:38:29.620 --> 00:38:35.230 now I go to my promotion category on the site is there I will see these two products 00:38:37.960 --> 00:38:42.760 we will now talk about the notion of price by groups of customers so already a little reminder 00:38:42.760 --> 00:38:51.970 in the specific prices that I think if it is possible to define a group therefore to 00:38:51.970 --> 00:38:57.280 say such and such specific prices apply to such and such group of customers so we already have 00:38:57.280 --> 00:39:04.630 this notion of two groups of customers by specific price but the problem is that 00:39:04.630 --> 00:39:09.790 if we use this technique there to define prices for a whole group of customers for all the 00:39:09.790 --> 00:39:14.800 products it will be necessary to do it product by product or even variation by variation so even if we 00:39:14.800 --> 00:39:20.470 have a tool here to create it in mass it will be fast but there will be a lot of lines and 00:39:20.470 --> 00:39:25.510 to create in notable specific loan if we have a lot of products so another solution is 00:39:25.510 --> 00:39:32.650 not to define specific prices at the level of the notion of specific price of prestashop therefore 00:39:32.650 --> 00:39:39.640 product by product but I define it at the global level of groups or possibly 00:39:39.640 --> 00:39:47.290 categories therefore at one or two levels higher so To do this, we go to the category view and 00:39:47.290 --> 00:39:54.430 we go to customer group, so in Merlin, in customer group, we can see the 00:39:54.430 --> 00:40:01.520 existing customer groups, we can associate them with the category, so say such group will have access to the products 00:40:01.520 --> 00:40:08.330 of such categories will not have access to them, so we can do it here by working one category at a 00:40:08.330 --> 00:40:17.870 time, remove the recursive mode, so for example, if I want customers to say stupid things, 00:40:17.870 --> 00:40:22.520 wings and guests, there is no access to the promotion category, I choose my cadet 00:40:22.520 --> 00:40:28.220 hugo promotion and I uncheck access to the source category, so that's one of the first functions. 00:40:28.220 --> 00:40:36.530 of this tab but the second function of this tab is to define discounts by group 00:40:36.530 --> 00:40:44.660 so here in this column you have the discounts that will apply among these the 5% to 00:40:44.660 --> 00:40:52.130 customers in the default group and visitors on this promotion category but also all 00:40:52.130 --> 00:40:56.660 the others that is to say this group discount column applies to all the cathedrals 00:40:56.660 --> 00:41:05.810 of the entire site so 5% for the visitor 15% for the customers so this is not a 00:41:05.810 --> 00:41:12.260 promotion type discount it will not create crossed out prices simply the prices that will be displayed on 00:41:12.260 --> 00:41:19.190 the site for such and such group will be the prices defined at the product level - the group discounts 00:41:19.190 --> 00:41:25.730 so that is the first method second method more we will say in more detail 00:41:25.730 --> 00:41:32.900 is that we can define discounts of the same type but category by category so for that 00:41:32.900 --> 00:41:40.400 we do it here in what is called the target categories window and you see when I 00:41:40.400 --> 00:41:45.470 am in the customer groups tab here in this table an additional column is displayed 00:41:45.470 --> 00:41:52.010 which is called group reduction and there I can define for a group to give one for a 00:41:52.010 --> 00:41:57.170 year a group of customers given a specific discount rate for each category I can very 00:41:57.170 --> 00:42:02.570 well tell him for example that for the columns the years the comfort dresses it will have not 00:42:02.570 --> 00:42:10.280 five but seven percent for the evening dresses it will be another amount for example if yes 00:42:10.280 --> 00:42:16.430 percent and then if I leave like this is good for all the other categories this group of 00:42:16.430 --> 00:42:25.700 visiting customers will have 5% so there we are really at the level of the category here we are at the level 00:42:25.700 --> 00:42:31.100 of the group for all the categories and finally the specific prices that we saw its defined at the level 00:42:31.100 --> 00:42:36.440 of the products so much more fine here so at three different levels we can define like 00:42:36.440 --> 00:42:42.590 these particular entry prices its chop the big difference I insist is that this type 00:42:42.590 --> 00:42:47.000 of price that we call group prices that they are defined at the level of the categories like 00:42:47.000 --> 00:42:54.500 these high level globally of the whole site here does not create crossed out prices the customer does not have 00:42:54.500 --> 00:43:00.230 the impression of having a discount it is really the price that applies for this curve of customers 00:43:00.230 --> 00:43:04.370 on the store so he does not even see that he has a promotion that there is in any case a discount 00:43:04.370 --> 00:43:09.050 compared to the guest typically the guest and the oil at higher prices since he does 00:43:09.050 --> 00:43:16.970 not have a discount the one who is a customer has 15% but at the limit does not know so I prefer 00:43:16.970 --> 00:43:21.410 to use this technique it is necessary I want to say almost exclusively for the sites which 00:43:21.410 --> 00:43:28.040 have a price list for individuals and a price list for professionals in 00:43:28.040 --> 00:43:32.660 this case it is well adapted you indicate for the professionals that here the prices are lower 00:43:32.660 --> 00:43:36.290 I do not know by 15% at the individual price but you do it in a global way 00:43:36.290 --> 00:43:43.340 last little info while I am there at the level of the groups of customers of the categories 00:43:43.340 --> 00:43:48.530 I showed you that here we could associate associates a group of a category selected 00:43:48.530 --> 00:43:55.220 here in target categories we can do it in bulk thanks to its two buttons for example I 00:43:55.220 --> 00:44:04.970 can say that rob and hop I will take these two with the shift sorry I will put myself 00:44:04.970 --> 00:44:11.000 even in recursive mode like that I select children of these categories and well I can choose 00:44:11.000 --> 00:44:18.440 here one or two groups for example take them visitor is invited and so with this button if 00:44:18.440 --> 00:44:23.870 I can associate create a link between all these selected categories and my two 00:44:23.870 --> 00:44:30.380 customer list groups and with this button here scissors I will be able to associate that is to say remove 00:44:30.380 --> 00:44:36.710 the fact that these customer groups have access to these categories one last little thing when 00:44:36.710 --> 00:44:42.560 you choose a single category in the source category tree at this time you can 00:44:42.560 --> 00:44:48.590 also here directly in the table enter the discounts for this source category for 00:44:48.590 --> 00:45:00.300 example 6 6% you are not obliged to use this English there I hope to have been complete on this 00:45:00.300 --> 00:45:06.630 notion of specific price discount of promotion and so see you soon for a new tutorial