How to create a price list for a beauty salon: rules and tips. Price list: sample Templates for price lists

For almost any trade organization, an important element of activity is the preparation of a price list of the goods or services provided. It can be created using various software solutions. But, as surprising as it may seem to some people, one of the simplest and most convenient ways is to create a price list using a regular Microsoft Excel spreadsheet processor. Let's figure out how you can perform this procedure in this program.

A price list is a table that indicates the name of the goods (services) provided by the enterprise, their brief description (in some cases), and, of course, the cost. The most advanced copies also contain images of products. Previously, traditionally, we more often used another synonymous name - price list. Considering that Microsoft Excel is a powerful spreadsheet processor, compiling such tables should not cause problems. Moreover, with its help you can create a price list at a very high level in an extremely short time.

Method 1: simple price list

First of all, let's look at an example of compiling a simple price list without pictures and additional data. It will consist of only two columns: the name of the product and its cost.

We give a name to the future price list. The name must necessarily contain the name of the organization or retail outlet for whose product range it is compiled.
The name should stand out and catch the eye. Design can be done in the form of a picture or a bright inscription. Since we have the simplest price list, we will choose the second option. To begin with, in the leftmost cell of the second row of the Excel sheet, write the name of the document with which we are working. We do this in uppercase, that is, in capital letters.

As we can see, the name is still “raw” and not centered, since, in fact, there is nothing to place in the center relative to anything. The “body” of the price list is not ready yet. Therefore, we will return to finalizing the design of the name a little later.

After the name, we skip one more line and in the next line of the sheet we indicate the names of the price list columns. Let's call the first column "Name of product", and the second – "Cost, rub.". If necessary, expand the cell boundaries if the column names extend beyond them.

At the next stage, we fill out the price list with the actual information. That is, in the appropriate columns we write down the names of the goods that the organization sells and their cost.

Also, if the product names go beyond the boundaries of the cells, then we expand them, and if the names are too long, then we format the cell with the ability to wrap by words. To do this, select a sheet element or group of elements in which we are going to carry out word wrapping. We right-click, thereby calling up the context menu. Select a position in it "Cell Format...".

The formatting window opens. Let's go to the tab "Alignment". Then check the box in the block "Display" near the parameter "Wordwise". Click on the button "OK" at the bottom of the window.

As you can see, after this, product names in the future price list are transferred according to words if they do not fit into the space allocated for this sheet element.

Now, in order for the buyer to better navigate the rows, we can create borders for our table. To do this, select the entire range of the table and go to the tab "Home". In the toolbox on the ribbon "Font" There is a button responsible for drawing boundaries. Click on the triangle icon to the right of it. A list of all possible border options opens. Select an item "All Borders".

As you can see, after this the price list received boundaries and is easier to navigate.

Now we need to add the background and font color of the document. There are no strict restrictions in this procedure, but there are certain unwritten rules. For example, the colors of the font and background should contrast with each other as much as possible so that the letters do not blend into the background. When designing the background and text, it is not advisable to use colors that are close in spectrum and it is unacceptable to use the same colors. In the latter case, the letters will completely merge with the background and become unreadable. It is also recommended to avoid using aggressive colors that hurt the eyes.
So, hold down the left mouse button and select the entire range of the table. In this case, you can capture one empty row below and above the table. Next, go to the tab "Home". In the toolbox "Font" there is an icon on the ribbon "Fill". Click on the triangle located to the right of it. A list of available colors opens. We choose the color that we consider more appropriate for the price list.

As you can see, the color has been selected. Now you can change the font if you wish. To do this, select the table range again, but this time without a name. In the same tab "Home" in the tools group "Font" there is a button "Text color". Click on the triangle to the right of it. Like last time, a list opens with a choice of colors, only this time for the font. We choose a color according to our preferences and the unspoken rules discussed above.

Again, select all the contents of the table. In the tab "Home" in the toolbox "Alignment" click on the button "Align to Center".

Now we need to deal with the column names. We select the sheet elements that contain them. In the tab "Home" in the block "Font" on the ribbon click on the icon "Bold" in the form of a letter "AND". You can also type the hotkey combination instead Ctrl+B.

Now we should return to the name of the price list. First of all, let's place it in the center. Select all sheet elements that are in the same line as the title, up to the end of the table. Right-click on the selection. In the context menu, select the item "Cell Format...".

The already familiar cell format window opens. Moving to the tab "Alignment". In the settings block "Alignment" open the field "Horizontally". Select an item from the list "At the center of the selection". After that, to save the settings, click on the button "OK" at the bottom of the window.

As you can see, now the name of the price list is placed in the center of the table. But we still need to work on it. You should increase the font size a little and change the color. Select the cells that contain the name. In the tab "Home" in the block "Font" click on the triangle to the right of the icon "Font size". Select the desired font size from the list. It should be larger than in other elements of the sheet.

After this, you can also make the font color of the name different from the font color of other elements. We do this in the same way as we changed this parameter for the contents of the table, that is, using the tool "Font Color" on the tape.

At this point we can assume that the simplest price list is ready for printing. But, despite the fact that the document is quite simple, it cannot be said that it looks clumsy or awkward. Therefore, its design will not scare away customers or clients. But, of course, if desired, the appearance can be improved almost indefinitely.

Method 2: creating a price list with permanent pictures

In a more complex price list, next to the names of the goods there are pictures depicting them. This allows the buyer to get a more complete understanding of the product. Let's see how this can be brought to life.

First of all, we should already have pre-prepared photographs of the goods stored on the computer’s hard drive or on a removable drive connected to the PC. It is advisable that they are all located in one place, and not scattered across different directories. In the latter case, the problem will become more complicated, and the time to solve it will be significantly increased. Therefore, it is recommended to organize.

Also, unlike the previous table, the price list can be a little more complicated. If in the previous method the name of the product type and model were located in one cell, now let's divide them into two separate columns.

Next, we need to choose which column the product photos will be in. For this purpose, you can add a column to the left of the table, but it will be more rational if the column with images is located between the columns with the name of the model and the cost of the product. In order to add a new column on the horizontal coordinates panel, left-click on the sector in which the column address is located "Price". After this, the entire column should be highlighted. Then go to the tab "Home" and click on the button "Insert", which is located in the tool block "Cells" on the tape.

As you can see, after this to the left of the column "Price" a new empty column will be added. We give it a name, for example "Product Image".

After that, go to the tab "Insert". Click on the icon "Drawing", which is located on the ribbon in the toolbox "Illustrations".

The insert picture window opens. We go to the directory where our pre-selected product photos are located. Select the image that corresponds to the first product name. Click on the button "Insert" at the bottom of the window.

After this, the photograph is inserted onto the sheet in its natural size. Naturally, we need to reduce it to fit it into a cell of an acceptable size. To do this, we alternately stand on different edges of the image. The cursor changes to a double-headed arrow. Hold down the left mouse button and drag the cursor to the center of the picture. We perform a similar procedure with each edge until the drawing takes on acceptable dimensions.

Now we need to edit the cell sizes, because currently the height of the cells is too small to properly fit the image. The width, in general, satisfies us. Let's make the elements of the sheet square so that their height is equal to the width. To do this you need to know the width.
To do this, place the cursor on the right border of the column "Product Image" on the horizontal coordinates bar. After this, hold down the left mouse button. As you can see, the width parameters are displayed. First, the width is indicated in certain conventional units. We do not pay attention to this value, since this unit for width and height does not coincide. We look and remember the number of pixels indicated in brackets. This value is universal for both width and height.

Now you should set the same size for the height of the cells as it was specified for the width. To do this, select with the cursor on the vertical coordinate panel with the left mouse button held down those rows of the table that should be expanded.

After that, on the same vertical coordinate panel, we stand on the lower border of any of the selected lines. In this case, the cursor should transform into the same bidirectional arrow that we saw on the horizontal coordinates panel. Hold down the left mouse button and drag the arrow down. Drag until the height reaches the same size in pixels as the width. After reaching this value, immediately release the mouse button.

As you can see, after this the height of all selected lines increased, despite the fact that we dragged the border of only one of them. Now all the cells in the column "Product Image" have a square shape.

Next we need to place the photo that we previously inserted into the sheet into the first element of the column "Product Image". To do this, hover the cursor over it and hold down the left mouse button. Then drag the photo to the target cell and place the image on it. Yes, this is not a mistake. A picture in Excel can be placed on top of a sheet element, rather than fit into it.

It is unlikely that the image size will immediately coincide with the cell size. Most likely, the photo will either go beyond its boundaries or fall short of them. We adjust the size of the photo by dragging its borders, as we did above.

In this case, the picture should be slightly smaller than the cell size, that is, there should be a very small gap between the borders of the sheet element and the image.

After that, in the same way we insert other pre-prepared product pictures into the corresponding elements of the column.

At this point, the creation of a price list with product images is considered complete. Now the price list can be printed or provided to customers electronically, depending on the selected type of distribution.

Method 3: Create a Price List with Appearing Images

But, as we see, the images on the sheet take up a significant part of the space, increasing the size of the price list several times in height. In addition, to display pictures you have to add one additional column. If you do not plan to print the price list, but are going to use and provide it to clients only in electronic form, then you can kill two birds with one stone: return the table dimensions to those that were in Method 1, but at the same time leave the ability to view product photos. This can be achieved if we place the pictures not in a separate column, but in the notes of the cells containing the name of the model.

Select the first cell in the column "Model" right-click on it. The context menu is launched. In it we select a position "Insert Note".

After this, the notes window opens. Place the cursor over its border and right-click. When hovering, the cursor should transform into an icon in the form of arrows pointing in four directions. It is very important to aim specifically at the border, and not do it inside the comment window, since in the latter case the formatting window will open not the same as what we need in this case. So, after the click has been made, the context menu is launched. In it we select a position "Note format...".

The Note Format window opens. Moving to the tab "Colors and Lines". In the settings block "Fill" click on the field "Color". A list opens with a list of fill colors in the form of icons. But that's not what interests us. At the very bottom of the list is the parameter "Methods of filling...". We click on it.

Another window opens called "Filling methods". Moving to the tab "Drawing". Next, click on the button "Drawing…", located on the plane of this window.

The exact same pattern selection window that we already used when considering the previous method of creating a price list opens. Actually, the actions in it need to be performed completely similar: go to the directory where the images are located, select the desired picture (in this case, corresponding to the name of the first model in the list), click on the button "Insert".

After this, the selected image will be displayed in the fill method window. Click on the button "OK", located at its bottom.

After completing this action, we again return to the notes format window. Here you should also click on the button "OK" for the specified settings to be applied.

Now when you hover over the first cell in a column "Model" The note will display an image of the corresponding device model.

Next, we will have to repeat all the above steps of this method of creating a price list for other models. Unfortunately, there is no way to speed up the procedure, since only a specific photo needs to be inserted into the note for a specific cell. So, if the price list consists of a large list of products, then get ready to spend a significant amount of time filling it with images. But in the end, you will receive an excellent electronic price list that will be both as compact and informative as possible.

Of course, we have not given examples of all possible options for creating price lists. The limiter in this case can only be human imagination. But even from the examples that were indicated in this lesson, it is clear that the price list or, as it is otherwise called, the price list can be either as simple and minimalistic as possible, or quite complex, with support for pop-up images when you hover over them mouse cursor. Which method to choose depends on many things, but first of all, on who your potential customers are and how you are going to provide them with this price list: on paper or in the form of a spreadsheet.

All entrepreneurs involved in trade know what a price list is and why it is needed in business. This is a document that provides the entire range of products with indicated prices, which helps to more quickly purchase goods and become familiar with the range. Nowadays it is impossible to imagine any large company without a price list. Today, we will tell you how to make a price list correctly so that it is effective and convenient.

How to make a price list?

Creating a price list requires great responsibility and a lot of time. Here are a few rules with which you can create a good, customer-friendly price list without any problems.

1. The first thing to remember is that the price list is best done in Microsoft Excel. Since the price list is a table with products and prices, it is best to use this program. Of course, it can be done in Worde, but correcting information and adjusting it all the time will be easier to do in Excel.

2. For more convenient use of the price list, it is best to create two of them, one for work, the other for clients. In the working price list we can include not only products, but also their cost, suppliers and other important information. For clients, this information will be hidden, so it will need to be deleted in the client price list. Experience shows that working with price lists occurs almost every day, since everything changes very quickly, prices first of all.

3. Remember that the most important thing in the price list is the products and you should spend the most time on them. Try to come up with unique names for your products so that they are convenient for both customers and you.

4. We also don’t forget about additional information about products. You should indicate as much information as possible, especially about exchange, weight, price; if there are few products, you can add photographs. All this information will help save time not only for you, but also for your clients.

5. Another important issue is the markup. We cannot say what it should be, because each enterprise has different products, different clients, so it is impossible to compare everyone one to one. The only thing worth saying is that in the price list it is better to divide prices into several categories, such as “Retail”, “Wholesale” and “Large Wholesale”. Each category will be distinguished by its pricing policy, for example, “Retail” - up to 30 thousand rubles, “Wholesale” from 30 to 150 thousand rubles, and “Large Wholesale” - over 150 thousand rubles.

There are also several nuances at this stage. Between such price ranges, the difference should be at least 10%, and we also try to set prices no higher than those of competitors.

6. The magic of numbers. It may not be strange, but prices of 999 rubles and 99 kopecks attract people. Most people do not trust round numbers, so we try to use the numbers 5, 7 and 9 as much as possible. If your prices are 3000, or 2000, then knock 20 rubles off the price, and you will see that this system works.

7 . The larger the product range, the more competitive you look in the market. But you should remember that there is no need to add extra positions. Those goods that are identical to those already included in the price list can be called superfluous. This often happens in companies related to jewelry, design and other similar things.

8. Product sorting. For convenient use of the price list, all products can be divided into several windows, especially if there are a lot of them.

9. And the last piece of advice - be sure to indicate your contact information so that the client can immediately contact you and clarify some points, or immediately place their order.

VIDEO. How to make a price list?

A well-written and beautifully designed price list is no less powerful a marketing tool than. The benefits of using price lists are underestimated by many entrepreneurs, which leads to the loss of customers.

What is a price list?

Business dictionaries define a price list as a list of prices for goods or services offered by an organization. This term is borrowed from the English language and comes from the words “price” and “list”. The price list has replaced the previously common word “price list” from use, although the meaning of both words is identical.

Price lists are used by both large suppliers and small entrepreneurs focused, for example, on. Price simplifies the management of the company's assortment, increases the transparency of the company's relationships with clients and increases its profitability.

Price list - how to spell it?

The correct spelling of the word “price list” is hyphenated. This option is used, for example, in the academic spelling dictionary compiled by the Vinogradov Institute of the Russian Language, as well as in the Large Explanatory Dictionary of the Russian Language (2014 edition). As a synonym with a simpler spelling, you can find the word “price book”. In addition, “price list” is often shortened to “price list,” and interlocutors understand that we are talking about a list of prices.

Price list structure

To make a price list, you need to understand the order in which information should be presented in it. The price is, in fact, the company’s offer; its purpose is to push the client to purchase. Therefore, the following price list structure is recommended:

goods or services for which discounts and promotions apply - promotional products, as they attract with the opportunity to benefit from the purchase;
main offer - we are talking about products that are mainly of interest to customers, about what there is the greatest demand for;
additional assortment - this category includes items that support sales of the main assortment;
related products or services - complement the main offer, forming a single complete set with it;
spare parts, components, etc.

This order of supplying the assortment is considered the most convenient and helps to increase sales after the client familiarizes himself with the price list. Speaking about what can be included in the price list, in addition to the list of goods and prices itself, it should be noted:

Company name;
logo;
reference information about the company;
additional information about goods and services.

How to make a price list?

Creating a price list can be divided into several stages:

Drawing up a document in Microsoft Excel. Excel makes it easy to make adjustments to the document, and the tabular format is optimal for a price list.
Creation of names of goods and services. Each company assigns its own product names. The clearer the names are and the better they allow you to group products, the more convenient it will be for the client to navigate the price list.
Maximum product disclosure. It is recommended to provide the client with as much useful information about products and services as possible, sorting it into separate columns. For example, if we are talking about goods, it is advisable to indicate not only the price, but also color, length, width, weight, etc. - everything that matters when choosing.
Adding pictures. Small images can be inserted into the cells of the column following or preceding the product names - this will simplify the search for the right products when reading the price list.
Dividing the price list into working and client. The working document indicates, among other things, contact details of suppliers and the cost of purchased products. This price list will make the work of employees easier so that they can find the supplier’s phone number for a particular product. Information about suppliers and product costs is removed from the price list for clients. In this case, it is not necessary to maintain two documents separately - you can only fill out the working price list, and before sending the file to clients, simply delete the necessary columns and cells and save the document under a different name.
Definition of markup. If a company is engaged in a commodity business and cooperates with both retail and wholesale clients, several prices should be indicated in the price list at once - for retail, for wholesale and large wholesale. When determining the markup, you need to rely on the prices of competitors in the niche and your desired earnings.
Refusal of “round” prices. This is not a mandatory requirement, but advice that is worth heeding. According to research by psychologists, people trust round price values (14,000, 800, 1,300) less, believing that these numbers were taken at random. Customers respond best to numbers 5, 7 and 9, so it is recommended to indicate a price, for example, not 5000, but 4970.
Removing identical products. You need to make sure that there are no identical items in the price list - this can mislead the client.
Sorting. If you have a large assortment, you can divide it into several sheets. At the same time, it is advisable to highlight the sheets themselves in Excel with some catchy colors so that the client will notice them when working with the price list. You can do this by right-clicking on the sheet tab and selecting the “Tab Color” command.
Point of contact with the client. It is important to remember that the price list is a marketing tool and helps. In order for the price list to fully perform this function, it needs to be beautifully laid out, checked for errors and indicate the company’s contact information. Also on the first sheet you can include a description of the company and a list of advantages over competitors.

The design of the price list plays an important role. The following rules must be observed:

elements related to each other must be located nearby;
all parts of the text must be visually related to each other, this can be achieved using alignment;
if some elements are repeated, their design must match;
the information in the price list should be organized so that it can be quickly read and found the desired item; for this, different colors, outlines, lines, fonts, etc. are used.

How to create a price list online?

You can find many proposals for creating price lists on the Internet. Design and sales specialists offer their services in this area. If your budget allows you to use these services, then it makes sense to turn to professionals.

If you don't want to spend money, you can create a price list online for free and with pictures using the Google Sheets service. It is a spreadsheet editor similar in functionality to Excel. At the same time, Google Sheets makes it possible to make changes online and provide access to viewing or editing documents to an unlimited number of people. Access rights are determined by the document creator.

Beautiful price list - sample

The best way to understand what a price list can and should look like is to use a visual example:

This is an example of a working price list - it shows the purchase price of goods, the products are sorted in alphabetical order, and no additional design elements are used that would help navigate the assortment. But since this is a working price, in this form it is good for company employees.

The goal of any commercial organization is to make a profit. To attract and interest customers, every entrepreneur first of all thinks about how to make a price list. The document performs two functions: the first is to provide information about the company, the second is to form a loyal attitude towards it.

A few rules

Any manager can make a price list for free, without using complex programs. But first you need to consider the standard standards for drawing up a pricing sheet:

Information content. The price list remains with the client, and, unlike the manager, he cannot advertise or tell anything additional.
Memorability. The document should stand out from others. The customer receives hundreds of price lists containing information from different suppliers. Given the same price ratio, the client will choose the document that will attract his attention. It is more difficult for a colored sheet to get lost in a pile of identical white papers, so you should refuse to print the document on a regular black and white printer. Another way to “hook” a client is to carry out a price list on a sheet of higher density (up to 160 g/m2).
For example, the presence of a company logo. The client wants to see who he is working with, but he does not have time to look for the name of the organization written in small print. It is advisable to move away from using template fonts (for example, Times New Roman), choosing a more modern one.
No spelling errors. Nobody wants to work with an illiterate manager.
Relevance. Prices must correspond to reality, so it is recommended to indicate the date the sheet was compiled and its validity period.

There are some subtleties in how to make a price list. They concern the content.

The following structural components are distinguished:

Logo and name of the organization (usually located at the top of the sheet and duplicated on all pages).
Block of contact information.
Document title (commercial offer, price list for supplied equipment, price list for placement of services, etc.).
A table with the names of items and their prices, specially highlighting seasonal promotions, bonus and discount programs.

Saving paper is bad manners. Condensing the information to one sheet and writing it in small font will not attract the customer's manager.

Classification

Based on the form of presentation, two types of documents are distinguished.

Paper ones - located in the sales area. The buyer can take such a sheet with prices with him.
Electronic - posted on the organization’s website or sent to clients by e-mail. If the file is in MS Office application format (doc or xls) or is intended for viewing in Acrobat Reader (pdf format), then it is easy to print it, that is, get a paper price list.

There is also a classification in terms of content.

Price list for goods. Represents a table whose columns contain information about the name of goods, their properties (manufacturer, packaging, technical parameters), and price. There can be several columns with prices, for example, for retail and wholesale customers.
Price list for services. This document should not be drawn up as a cost estimate for a specific type of work. It is important to reflect the main types of services in the price list so that the client can estimate his costs as a first approximation. If it is impossible to calculate the costs of services, it is enough to quote the cost of an employee’s hour of work. Overhead and transportation costs, which depend on the cost of the entire job, are estimated as a percentage.

MS Excel: instructions for use

Writing documents on paper by hand is impractical. Maintaining an electronic price list is much easier than its physical counterpart. Inexperienced computer users know how to make a price list using the Word text editor. But this application is not always the best choice for maintaining price specifications.

As the company expands, the range of goods offered and services provided increases, and problems arise in filtering and sorting data. This is where spreadsheet functions come in handy.

Users' question may cause difficulties. The seven-step instructions will resolve them.

Open a new document.
Add information about the company and corporate identity elements.
Write a title.
Come up with a name for the columns. At first, five columns will be enough: “Name”, “Characteristics”, “Quantity in stock”, “Price per unit”. If there are a lot of products, it is advisable to enter the “Product Category” column. Another way is to place products of different categories on separate sheets.
Fill out the price list.
Outline the boundaries of the resulting table.
Highlight important items (for example, promotional items).

How to make a beautiful price list for a website

Price specifications and order forms are necessary attributes of a retail website. The advantages of an online document are accessibility at any time, anywhere, ease of updating and ample visualization capabilities.

Internet page developers offer several options for how to make a price list. The first method is simple; it consists of placing an icon on the website to download a file with prices. The second option is to make a page dedicated to the cost of the company’s services. This solution will require more time to work, but the interactivity of the document will be an advantage.

The price list is necessary for the buyer to study the assortment and make a purchase. Therefore, it is necessary to approach the preparation of a price list responsibly. There are norms and rules for compiling price lists; we will tell you more in our article.

Making a price list

When compiling a price list, an entrepreneur must ensure that the buyer is satisfied with the level and completeness of the information presented in it.

It should disclose the store’s assortment, contain a brief description of goods and products sufficient to make a purchasing decision, and, of course, the price.

How to make a price list if the store offers discounts? They must also be indicated in the price list. Products that participate in promotions, marketing events, or have some kind of bonuses can be highlighted for ease of perception with a color, a different font, etc.

When preparing a price list, we must not forget that it is for the buyer. Therefore, it should be convenient and pleasant to read. No need to write in too small a font.

The information should be detailed, but not excessive. If there are many items on the list, and there is a detailed description for each, the document will be large, and you simply won’t want to read it.

Originality of names is a good thing in order to catch the attention of the buyer, but in this case you need to be careful with creativity: it is not always justified to name traditionally well-known and popular products creatively.

The price list must include contact information. No matter how detailed the goods and products are described, the buyer will certainly have additional questions. In this case, they usually leave the phone number or email address of one of the managers.

The CRM system from Business.Ru will help you see an accurate picture of a person’s needs and successfully sell services. Accumulate and systematize information about the client and increase his loyalty with personal offers.

Sorting of goods

Goods and products can and should be divided into categories if necessary, especially for department stores:

1. By type. Food products, non-food products, stationery products, etc. Each type of product can also be divided into segments. For example, food products can be divided into: dairy products, meat and sausages, bakery, confectionery, etc.

Non-food products can be sorted into segments: clothing (can also be divided into men's, women's and children's), household appliances, household chemicals, personal care products, etc.

2. By type of price. Usually prices are retail or wholesale (small wholesale, large wholesale): the first prices are higher, the second are lower. That is, if a person buys not 1 unit, but a batch of small or large wholesale, the goods will cost him less.

This may be reflected in the price list, for example, it is indicated that when purchasing 10 or more pieces, the price will be reduced by 10%.

Or, for example, you can make a note in the price list that if you purchase the total amount (without dividing into types and categories of goods, just the amount) of so many rubles, a 10% discount will be applied to the purchase amount.

Psychological prices

Price psychology is based on perception. This is best shown with an example: 1000 rubles and 999 rubles.

In essence, this is the same price: the difference of 1 ruble is not significant and, ceteris paribus, practically does not affect the financial result of the entrepreneur’s business.

However, this difference is significant for the buyer: a price tag with 999 rubles attracts him more than a price tag with 1000 rubles.

The difference of 1 ruble, which, in fact, is not a difference, for the buyer is a kind of boundary between completely different scales of amounts of money that he will have to give from his own wallet:

999 rubles – this amount is measured in hundreds.
1000 rubles - this amount is already measured in thousands.

Psychologically, the scale of price measurement in the second case is 10 times greater than the scale of measurement in the first case: thousands are 10 times larger than hundreds.

Therefore, prices indicated in this form - 999 rubles, 1999 rubles, etc. - are more attractive for the buyer.

Experts in the field of marketing and retail say that in this case the buyer is more willing to make a purchase because it is easier for him to pay 10 times less money.

In reality, of course, there is no difference, but it seems to a person that there is. Therefore, many experts and specialists recommend indicating prices in this form.

Of course, this should be done in such a way that both the individual prices and the entire price list look and are perceived harmoniously. Therefore, the decision to use such non-round prices must be made based on the specific conditions of conducting a particular business.

Types of price lists:

1. For the buyer. It indicates what a person needs to make a decision: to buy a product or not, if to buy, then how much. In the price list for the buyer, in addition to the price and name, there may be additional information characterizing the product or product.

It depends on the need and on specific situations;

2. Internal price list. It is intended for official use. It may contain more extensive information, including information that is not intended for the buyer, but may be necessary for store employees, for example, sales managers, accountants, marketers and others.

An extended price list may have the following set of information (example):

Name of goods;
Selling price per unit for which the product is sold to the buyer;
Purchase price. There may be cases where managers need this information for all products, so it can be included in the extended version;
Product cost. In addition to the purchase price, it may include other costs that exist in the business;
Opportunities for discounts. In the extended price list intended for managers, you can indicate to what extent they can reduce the price. Naturally, this is the case if the store’s terms and conditions provide for dynamic prices.

Selling price list. Video

Price list in the online service “Business.Ru”

Usually stores have a fairly large assortment of what they sell. Therefore, there is a need to automate the process of preparing price lists.

You can do this using the well-known Excel program (free). In this case, it will be a program for compiling price lists.

It provides many convenient tools for this: sorting, columns, rows and sheets, the ability to apply formulas and relationships between document elements and various documents.

However, using Excel is, if not a manual, but also not a fully automated process.