Setting up sales is one of the common problems facing businesses. We will see in
this training how to set up sales or discounts in different ways with Merlin back-office.
We will already see how to use its brute force call, that is to say,
directly modify prices by applying a decrease or an increase in price in
bulk. This is not the best method since it changes in a definitive way. Prices are
really created, what we call crossed-out prices. Second phase, we are good. We will create what we
call specific prices, special prices or crossed-out prices, always with Berlin. We will also see the
concept of decreasing prices, which is a form of special prices based on purchase quantities. We
will also see how to import special prices or crossed-out prices from a
CEO file. Excellent. And finally, we will also see the concept of prices by customer groups. This is
not quite what we call a discount or sales type, but permanent discounts
or permanent differentiated prices based on each customer group by category. All
this can be done in bulk with Merlin. So the first method is the modification. in bulk of
prices so for that you have to start by displaying your products and include in our display the
columns that you want to modify so either you have inked a configuration where it has already been created you
choose the configuration that corresponds when it contains the columns like hulu modifies for
example here it is a configuration that I created especially for the prices here I have
my column so sale price let's imagine that I want to increase all contempt or decrease all
contempt by 5% so I display all my products I select them the all button and so I will
apply a calculation to apply a calculation we click on grouped actions and in
grouped action we have a tool modified by calculation so which is displayed here I take the opportunity to show the fact
that you also have in image variation if you display the variations of the
selected products also so in the grouped action button you also have the calculator
the function modification by calculation it will allow you to modify the impacts on the
sale price excluding tax and including tax dia this tool we will do it simply on the products at
first so I spent some 10-year variations of that we will gain a little space
so on this calculator how it works you just have to choose here its percentage for example
my 5% of well you put in value percentage in parameter percentage and not in amount or
in value I will apply a percentage it is not simply 5 euros then you choose the
column on which you want to act I want to act on the sales prices including tax the values ​​here which
are grayed out indicates the fact that quite simply the columns are absent from the display can
only work this tool on the columns present so if you parents to work
on the unit price ratio leave here to dig but it will be necessary to go in the
column configurator to select it so I take sales price including tax and I apply the modification either
I add but 5% or I remove my 5% we can also do other things like divided pupil
or apply a direct value so I do less merlin show me the result so we will go
here from 39,124 to 37.64 identically for the other values ​​if that me suitable I suffer here
the backup is done in the base to the loans have been modified so I have thus on the fact that
we have modified the prices but will not appear information of the type in sales or prepare
on your products it is really a definitive notification once again it is not the best
method to set up floors it is certainly the best method if you take
your purchase prices globally have been modified or are modified once a year for example and you
want to modify all the prices of your site then this method another disadvantage is that it
requires displaying the products so if we have like here a small ten it is fine but
if you have tens of thousands of products it can slow down your workflow considerably
so there is another method very close to this one without the display of the products I will
show you so I deactivate in display has nothing more in my product table and I go
directly to my control panel in my English kate there would be products is here you
have a grouped action button on products I click on it in which you
also find modified product by calculation and you find yourself here with the same type of calculators
in this tab is in fact this calculator here will act on all the products of the categories which
were selected above without needing to have needed to display as typically g
do the same operation I take five smoked in percentage I chose what I want
to work on for example the selling price including tax and I click on my - is itself asked for
confirmation I continue or I cancel so there we are in mode we will say blind we do not see the
result you have to trust berlin to do the calculation correctly but we really save
time on this kind of processing once again we do not need to display the products
the second approach therefore consists of creating what we call specific prices or special prices so
in merlin it happens here in the tab of the same name specific price which allows in this table
here firstly to display by clicking on display the already existing prices the
already existing special prices and selected products if I select all my products I see here
the different special prices a tip or an interesting possibility is to separate or
group the different lines here by product to do that we put what we call a break
so I will go to the heidi pr column which means and 10 of the products I
right click and I want to tell it to add a break this column and you see so I have
a grouping of the lines like here by product I can unroll roll up the special prices by
product so it is up to you allows you to view the current special prices as for the table
of products or other tables you can customize the display of the columns so in
columns here you have a specific price tab with on the right the columns already present in my
table and on the left the one that you can add so if for example I want to have the final price
or crossed out prices out taxes or including tax here taken part and including tax I add it to the place where I want
my configuration and I validate I have my price including tax crossed out it is added somewhere here here
I will display all my lines you can modify the data directly in this
table it is for example I will modify are said here hans % it is simply enough
of lilith is therefore a special price a notion of prestashop it is a price in celebration which is
defined by characteristics of the type in which store this price applies it
can all or a store in particular on which currency it applies
in which country for which groups of customers for a specific customer if you wish then it is
most often made up of a reduction amount which can be either defined as a percentage or in value
in euros in dollars for example in currencies if it is in amount in value at that time
you can choose if it is a value including tax or excluding tax so by checking this option
when we actually put a reduction of this type there these are percentage or in value
it will create a price crossed out in your site this crossed out price it could be applied permanently
or from a given date to another date so it is the start date to
end date modified copy here and finally it can be defending depending sorry on a certain quantity
to buy so by default these quantities 1 but you can very well but two three
axes field which means that you will have a decreasing price in this case and finally you have
another important parameter which is called the new base price which since prestashop 1.5
I believe at least one which means that the base price is not modified the base price is
the sale price of the product by default it is not modified but on this sale price we apply
a percentage discount or value if on the other hand you modify the new base price column
at that time the price that you will put here for example if I enter instead of
-1 if I lie I enter without that means that I have modified my selling price of the product to 100
so according to the conditions that I put here my country my group mad meeddat and it is my
foaming product and on which I can apply or not a discount if I do not have a discount here
like these at that time it means that young I only apply a new
base price to my product that is to say that I modify my selling price of my
product but I do not create a discount so I do not create crossed out prices so for this
product there for this line if on the site the price will not be paris but simply
modified replace without giving information to the buyer that it is not the original price
then with merlin it is of course quite possible to modify several lines at the same
time it is the notion of mass modifications which is the essence same of whiting so let's suppose
that for example on this product there finally this price there this one this one I want we will
do two different things first operation is to copy an amount in other lines or
copy a property in other lines for example copied say and of course these three
other specific prices it is enough to click on the say with the right mouse button is
at the bottom of my menu there I can't show you my found the way you have to click on
the option which is called package 10 in all the selected cells of this column so it is
at the bottom of the menu merlin shows me what will do as an operation that is to say copy the value here
in orange in the values ​​in dark blue if I like it I continue there it is saved in the database
and it's finished another way of doing well it's like for earlier we have here
the function modification by calculation so who would pay me which allows me on the section which
interests me for example the reduction to choose to apply a calculation operation for example
I multiplied by two in value so I take 2 in value and I click on multiply it will
multiply by 2 May reduction of 10 I go before and if I like it I modify that's it so
could do this type of operation on different columns of course the numeric columns but
also the example and date a group copy the dates from a column end of a cell to
other cells of the same column so to modify the special prices it's good but you
also have to be able to write it so let's imagine that we are not at all so I will delete everything sorry
the gipa all selected so I select everything I delete everything and we will start from scratch so
I have all my products which are selected to add a specific price and well you have to click
here on this blue link change adds kim displays a creation form a modification of the
special prices so in this form we find what we call the conditions headings
so checkout under which conditions the price applies so that once we find the choice of
the store of the external currencies of the group of customers or even the search for a
special customer the famous new base price which is worth less one by default the purchase quantity on which
the price applies the reduction in percentage or in value the choice excluding taxes and including taxes and finally
the application dates so let's imagine that I want to apply on this product if and on this one
the third 5% discount I put my 5% in five sets chosen for percent the other parameters
please me so no special conditions applies everywhere from the quantity a set
made modify or add so it will create two lines in my table but bothered this time that
I want to create a second discount but this time a discount of specific type from the
quantity 10 I will apply 15 euros in value including taxes I changed my parameters again if
I wanted to apply a data group or a particular customer or a given country and it is enough for me
to choose it in my list choose Germany and I apply here so here I created two
special prices of specific loan for my two products imagine this time that I want to apply
for example this special price here for Germany to apply it to all my products comes it is enough
I just excuse me to select one of the lines containing me took my values ​​and look what
happens when I do it here you see the values ​​in the form change fill
with the data of the line so I select my line with my special price for Germany and
at 15% it automatically fills me in the form selects the products on which I will
apply the same discount for example all I still have my values ​​from my form I
just have to modify or add and my special price of 15 euros pass for Germany
will apply therefore to all my products what we can see here the two products which already had this
price do not end up with a duplicate price a merlin takes care to compare what
already exists and to apply new specific prices only if the same fold does not already exist in the database,
this also allows me to show you something else, let's suppose that this famous 15% here for
Germany, I want to modify it in any tool other than Merlin, you would have to
go to modify to search for these special prices and modify them one by one, product by product, in
Merlin it's very different, you just have to take any one of them, once again
the form is filled with the properties of this line and there I can modify my value,
for example m 11 to go from 15 to 11 in value, then selected goods, all the products on
which I will apply the modification and click on modify added and in fact what
Merlin does is that it searches in my carpet if all the lines which contain exactly
the same filter on the specific prices, so the same shops, same foreign currencies, the same
quantity and especially the same, the same date period and they apply the modification, so
here I take my 11, I apply and see all my special prices corresponding to the
same application criteria are modified en masse because we have just created these are
specific prices for the product which applies to all their variations and
we see it here one year the variation thread marked all also here in the variation column
all you need to know that you can also create special prices by variation so
to do that it's simple you always select the same where the products on which you
apply the prices so I will take only one in this example I go to the
variation tab images I display my variations and I select those which interest me good
game could for example use a filter we will do it to keep that I choose filtered
on this column those which contain the word orange so that the variations range in my
case I validate there they are filtered I select them all and I return to my
specific price and this time before applying took me for example what interests me
is a price of 20% on everything east especially its orange colored t-shirts 20 in percentage
on all the countries maybe I put a particular date so so there the format of the
dates where this American form so 2018 we will say go from 12 12 to 0 until 2019
15 so it is the month first so 0.1 including January 15 and so I come back to my point I want
to apply this discount only on the variations that I have selected only on the
range variations so I choose here in variation those which are currently selected a small oversight
game but one on my quantity so it is really a similar price that I want and not a
decreasing fold by quantity and I apply and here so on this product if we see well here we have
three new special prices have been created which only apply to my three orange color
variations so I added the final price column including tax of a my table of specific prices
to show you another very interesting feature which consists of being able to round
these final prices in bulk after discount so for that it is enough to select the lines that I
wish to round to go to grouped action choose the tool round the prices it is a
window which opens allowing to round so we took care of sale including tax before
me is the final folds including tax after discount so there is what interests me then to choose
the type of rounding which interests me for example to the currency higher or lower loans or the
closest is to apply there you see the final prices including tax rounded so what did
merlin do to be able to obtain his prices we call that psychological and well in fact he recalculated
precisely the amount of the reduction whether in percentage or in value to obtain my
very particular price well rounded you should know that you can also display in the duo table
a lot of information concerning vorbis so we will do it I go to my
column configurator I go to my product English and in my product English you have a part
which is called discount and I'm going to add some important sections so this one calls for a single
question mark I'm going to explain to you what it's for and I'm going to add my crossed out price
including VAT my final sale price is also the amount of the discount do not confuse
the amount of the discount with the percentage reduction that you have here who do not know that they
only existed in prestashop a 1.4 or before since 1 4 we have the discount chin which can
contain either the value or the percentage so I apply and I therefore find myself in the
top table as I indicated to you with this data if the sales amount including VAT or the crossed out price is
grayed out as is the case here this means that the product actually has variations and as
it has variations in fact it has as many prices if final sales prices as two variations
so if I go to variation image that I display the variations of this product we
are not worth here and we therefore also have a sale price per variation crossed out and final
so two things that I wanted to show you the first is this section on sale
here that you can check in bulk like this allows you to display the logo in ground on
the images of the products so to indicate to your customers who has a discount that applies
how often people ask me but how to sort the products that are discounted
so to sort the products that are revised in an absolutely can check this parameter
on sale often the safest and most relevant is in your column configuration always
the same in the discount part is to include this section identifying specific applicable prices
I put it in my table and this column will therefore contain a number when the price
is crossed out in what there is a specific price that is displayed see this one this one exists and
so if you sort in relation to this section for example by filtering on this column
but different from nothing I delete fishing valid so different nothing works I have the
products that have a specific price that applies to today's date is so once filtered
I just have to select my products and check if this is not already done the logo in sales
at the display level so you will have understood that a given product can have several
specific prices including prices which will apply different dates to sales periods or
promotional periods which overlap or not and it is therefore merlin finally prestashop to a management
of this type of conflict quite particular based on the notion of priority so you will be able to
configure the fact that prestashop will first use the specific price for 1 2 bags not
for a given country before using the one for a certain screw on the contrary give priority
to groups of external customers but above all the notion of date is the most important the price
which will apply is the one which was finished on the date of the day so how to do in
Merlin display the prices in the tables that we attack duo for example the date of January 15th
while we are in the month of December and well you can do it in the control panel in
calculation options here and if you go down you will see that here you can check the parameter
other date to ask it to display here the prices on a given date so in 2010 January 9th for
example January 15th well then that you want it doesn't matter so by setting like these
Merlin and well all the prices of the table of products the table of variations this field
will take into account the specific prices applicable to this date 6 likewise you will be able in the same
place here to ask it to indicate the prices for a group of particular customers
see a particular customer so that is very useful specifically for for example to generate
pdf catalogs for a group of customers in advance before the sales or there you go to all sorts
of criteria not necessarily applicable to the dates on today's date but at a later date
methods now to create your discounts consists not of working from the more
specific tab directly but to import your data via a csv or excel file then we
are not going to redo a training on the import that is not the goal I refer you for that or
dedicated tutorial we will just launch the import window and I will just indicate some small tips
on the use of this tool for specific loans in particular so I prepared
for this tutorial an example that I called words here so an xls file in this case is what I
will show you right away it is the mapping so in the mapping what I want on
what I want to insist on is that you have in your list of headings map abl here a whole
bunch of parameters specific to the specific prices which are here and which we can recognize thanks
precisely to the indication in parentheses specific price see e-boutique heidi currency
specific price heidi country and the customer groups new base price from the quantity
amount discount rate type of reduction including tax and the two dates so in fact we find exactly
the same parameters as in the English form specific price so it You just need
to have data corresponding to its columns corresponding to this data
and the maps and its particular headings to import your specific loans which you
do not need everything of course in fact it is enough to create a specific price in
bulk to have a column containing the amount or the round of the discount just that it is enough by
default it will consider that it is a percentage if it is not a percentage at that time you
include the column type of reduction to indicate either the word people of age or the word amount
in English that is to say to mount there I am sorry so that is an internal language of
prestashop so it is really nobody task in English or a mood that must be put it is not a
value of type 1 or 2 it will not accept so here are these two columns are enough most of the
time or even simply this one and then if it is a decreasing price you can
put from so to put the quantity necessary to apply this specific price if
it is an amount possibly you can put the column including tax which is a checkbox that
contains heroes of a by default it is zero so it is tax-free and finally the
application dates if you do not specify the application dates so if you do not kill
these 2 columns at that time these are specific prices that apply all the time
and finally you have filters of the type limit to a store limited data a given currency
or a country a group of customers or even a customer you can in the same way use
the new base price column without already explained to modify the base price of the product
so if this column is absent the new base price will be worth less 1 that is to say that
we do not apply a modification to the price of the product what we do is that we apply a discount
on the base price if you have a new base price column in the contract this new
base price will replace the sale price of the product before applying or not a discount on this price
not then a particularity is that merlin is able to analyze the title of the column
for example like this price 100-200 or price 200 500 to anticipate and try to understand
what you are asking him here by analyzing these titles there he understood that it was a
new base price of specific price from the quantity without desert that he took the first
number of the text to understand that it was from a certain quantity here he did
the same thing price of 105 100 he filled all alone from the quantity of blood you can
also define prices or reductions without specifying in the title the quantity while it
presents here then there the quantity was specified reduction ps pc prg ps specific advancing in
fact before that we mean from 0 to 100 so at that moment in this field here Thursday 10 finished
that I tell him that it is a minimum quantity defined by the column from the quantity
moreover basically by default it is from 1 but if I have a column from the quantity
here it is so franck comptines so there I have a column from the quantity which will contain
a number so maybe 1 or maybe more and well typically this reduction here will apply
from the quantity defined in this column while this one by this new base price
here will apply from the quantity of 200 which were recognized automatically thanks to the
new numbers 200 in the title so what I wanted to show you is you can thus
have several columns in the same file to define your decreasing prices that is to say
different base prices or different discounts from the different quantities so this is the case
here we see that we have a base price from meaning we have another base price from 200
we have an amount or a discount rate to part to the quantity meaning and we have somewhere our
famous quantity which will define the amount at the discount rate from this quantity
finally our type of reduction here is typically an example of a rather complicated import this one of
specific price and new base prices to know as when using English
specific loan merlin does not create a duplicate when we import specific prices it will
look in the database if there are already specific prices identical to your words which apply
in the same conditions same currency same country same date same quantity so really
the same criteria and if it is the case it will update its specific prices that is to say
that it has modified the amount or the new low price which is indicated in the file but in
no case it will create a duplicate I think that it is obvious but it is better by saying it
it is possible to create specific prices two variations via the import so there what we
have just shown you is that it will create specific prices lobo to the product since we are in
product mode of which which applies to all their variations and if I switch to
variations mode like these and I indicate in one place for example with its 2 columns
heidi product attribute laïdi of the variation or in another way at that time by with
the reference or the coast barack steira but from the moment when the program is able
to identify the variations at that time the specific price which will be created in the same way
as seen previously will only apply to this variation finally only to the variation defined
for each of the lines so to complete this part on the specific prices I will
show you now how with merlin to store the products in a category called sales or
promotions technical quite common during the sales periods of January or July for
example so to do that we go to the category view we will already create our category in
ground so I was rolling my tree to choose where jules instead and I hear to realize that
my data is in English it's not a big deal we'll switch to French I didn't pay attention
I go to a display here you have the language I switch to French and I think
so I unfolded my tree I chose where I put my category for example in welcome
then I remove the recursive mode to be able to choose a single category here you have a
new button and I create my category for example I will call it promotion
so that's I remind you of a technique here to create categories category names
automatically using the name of the store using the name of the category but review
its identifier and if you just want to give a nonsense more technicality you just put the
name in beginning in the middle or end like that there we can choose lots of other parameters I
went to the essential I create my category it's finished I close there I have my
promotion category I come back to product view so we will close the display is ready specific we no longer
need I will activate my control panel I like the inked you know the technique for
their cave always open I will choose everything but category which activates the recursive mode here
I only have two products why because remember I had set up my filter
indicating or limiting the list of products to those which have a specific price therefore a discount
and remember this filter it is dependent on the criteria here defined in calculation options
in particular the date so I will remove its hosts this other date this film other dates
in order to see all the products which have a specific price on today's date
so here we have two I select them all and so all these products there what I would like
is to associate them with my promotion category so I will see target categories I
unfold I choose promotion then I have two techniques either I click on this tab here
which will make the association or I click on the see associations button in order to display
a column showing me which category the selected products are associated with and being able
to make multiple associations in a single operation so I will take this second
technique I put myself on promotion I click here I ask myself if I want to keep the associations
other than those made to promotion so those which are already done I say yes so basically
products visible in the other categories and it's finished my association affects so if
now I go to my promotion category on the site is there I will see these two products
we will now talk about the notion of price by groups of customers so already a little reminder
in the specific prices that I think if it is possible to define a group therefore to
say such and such specific prices apply to such and such group of customers so we already have
this notion of two groups of customers by specific price but the problem is that
if we use this technique there to define prices for a whole group of customers for all the
products it will be necessary to do it product by product or even variation by variation so even if we
have a tool here to create it in mass it will be fast but there will be a lot of lines and
to create in notable specific loan if we have a lot of products so another solution is
not to define specific prices at the level of the notion of specific price of prestashop therefore
product by product but I define it at the global level of groups or possibly
categories therefore at one or two levels higher so To do this, we go to the category view and
we go to customer group, so in Merlin, in customer group, we can see the
existing customer groups, we can associate them with the category, so say such group will have access to the products
of such categories will not have access to them, so we can do it here by working one category at a
time, remove the recursive mode, so for example, if I want customers to say stupid things,
wings and guests, there is no access to the promotion category, I choose my cadet
hugo promotion and I uncheck access to the source category, so that's one of the first functions.
of this tab but the second function of this tab is to define discounts by group
so here in this column you have the discounts that will apply among these the 5% to
customers in the default group and visitors on this promotion category but also all
the others that is to say this group discount column applies to all the cathedrals
of the entire site so 5% for the visitor 15% for the customers so this is not a
promotion type discount it will not create crossed out prices simply the prices that will be displayed on
the site for such and such group will be the prices defined at the product level - the group discounts
so that is the first method second method more we will say in more detail
is that we can define discounts of the same type but category by category so for that
we do it here in what is called the target categories window and you see when I
am in the customer groups tab here in this table an additional column is displayed
which is called group reduction and there I can define for a group to give one for a
year a group of customers given a specific discount rate for each category I can very
well tell him for example that for the columns the years the comfort dresses it will have not
five but seven percent for the evening dresses it will be another amount for example if yes
percent and then if I leave like this is good for all the other categories this group of
visiting customers will have 5% so there we are really at the level of the category here we are at the level
of the group for all the categories and finally the specific prices that we saw its defined at the level
of the products so much more fine here so at three different levels we can define like
these particular entry prices its chop the big difference I insist is that this type
of price that we call group prices that they are defined at the level of the categories like
these high level globally of the whole site here does not create crossed out prices the customer does not have
the impression of having a discount it is really the price that applies for this curve of customers
on the store so he does not even see that he has a promotion that there is in any case a discount
compared to the guest typically the guest and the oil at higher prices since he does
not have a discount the one who is a customer has 15% but at the limit does not know so I prefer
to use this technique it is necessary I want to say almost exclusively for the sites which
have a price list for individuals and a price list for professionals in
this case it is well adapted you indicate for the professionals that here the prices are lower
I do not know by 15% at the individual price but you do it in a global way
last little info while I am there at the level of the groups of customers of the categories
I showed you that here we could associate associates a group of a category selected
here in target categories we can do it in bulk thanks to its two buttons for example I
can say that rob and hop I will take these two with the shift sorry I will put myself
even in recursive mode like that I select children of these categories and well I can choose
here one or two groups for example take them visitor is invited and so with this button if
I can associate create a link between all these selected categories and my two
customer list groups and with this button here scissors I will be able to associate that is to say remove
the fact that these customer groups have access to these categories one last little thing when
you choose a single category in the source category tree at this time you can
also here directly in the table enter the discounts for this source category for
example 6 6% you are not obliged to use this English there I hope to have been complete on this
notion of specific price discount of promotion and so see you soon for a new tutorial