Print the price tags of document forms. Printing price tags, receipts, coupons from the MS Excel database. How to print your own price tag templates

Download to Phone 31.07.2021
Download to Phone

In retail, to indicate the price and a brief description of the product, use price tag templates. They have certain requirements, which we will discuss below.

In 2019, the design of price tags is easiest to do in a special program. MySklad has a free and convenient editor, you don't need to download it - work online. You can use ready-made price tag templates, or you can make your own by adding a company logo, barcode, product image, or other details. Try it now: it's simple, fast and free.

In the free editor of MySklad, you can choose the format: A4 - for a regular printer, thermal tape - for a roll label printer. There is a preview mode: you can check how the result will look like. You can save and download price tag templates in Excel or PDF.

Price tag requirements: sample 2019

The last time the rules for designing price tags were changed in 2018 (Government Decree No. 55). Rospotrebnadzor monitors their observance. On the price tags, you need to indicate the name of the product and the price per weight or unit, and in Russia it is mandatory in rubles. The seller must issue price tags according to the rules. It ensures their uniformity.

This means that all price tags must have the same:

  • production material: paper, wood, etc.,
  • way of applying information: for example, if you use printed price tags, then there should not be handwritten ones among them,
  • design: content, layout, etc.

Promotional price tags must also be of the same color and style. You can add the word "Promotion" or "Discount" to them and specify the size or percentage.

Price tags: sample for printing

It is most convenient to make price tags through our free. It is designed specifically for this, and you can also make labels in it. Any design in the editor is set in a few clicks, and ready-made price tags are conveniently placed on a sheet for economical printing.

You can also issue price tags in Excel (for this, download the free one). This is handy if you need tables or columns. But usually such difficulties are not required, and in the online editor everything is easier and much faster.

Free download sample price tags in excel

You can also make price tags in Word. It's easy if you always use the same template. But resizing and placing price tags on the sheet can be more difficult.

Free download price tag templates in Word

Recommendations for making your own price tag templates

Customers remember labels and pay attention to them. Therefore, it will be better for consumers if:

  • You will add additional information to the price tag, for example, about the country of origin of the product.
  • Choose an easy to read font.
  • You will use noticeable price tags on sales, for example, you can install several large ones on baskets with the goods “‎All for 99 rubles”‎.
.

Can they be punished for wrong price tags?

Yes, the compliance of price tags with the requirements is checked by Rospotrebnadzor. There are penalties for violations:

  • IP - 300-1500 rubles,
  • store directors - 1000-3000 rubles,
  • legal entities - 10,000-30,000 rubles.

Allows you to send MS Excel spreadsheet data to an MS Word document.

This article discusses the option when it is necessary to place data from several table records on the page of a Word document. According to the above algorithm, you can generate pages for printing receipts, coupons, business cards, cards and other similar small-sized documents

Consider an example. Suppose there is a certain price list of the furniture store "World of sofas".

Let's also assume that there has been a price change and you need to print new price tags. Six price tags can be placed on an A4 sheet. More or less like this

Let's walk through the process of creating price tags step by step. It is assumed that the database in Excel, on the basis of which the price tags will be created, already exists. How to prepare an Excel file for merging, you can read in the article. In short, a table to be merged must meet certain requirements:

  • the table must not contain merged cells;
  • all columns must have unique names to be used in the merge.

It should be remembered that for more convenient further work when merging, it is recommended in Word Options - Advanced - set the parameterField shading into position Is alwaysto distinguish pasted merge fields from plain text. If this option is enabled, the fields are displayed with a gray background. This background, of course, is not printed on print.

Step 1. Designing the Document Layout

On the tab Newsletters under the button Start Merge choose an option stickers. A dialog box opens Sticker Options, in which you can select a layout or create a new one based on existing ones.

Choose the most suitable layout and click the button Create(or Setting). A dialog box opens in which the quantity, size and location of future price tags are specified. For our example, the values ​​​​shown in the figure were set.

If the vertical and horizontal pitch is equal to the height and width of the sticker, respectively, then they will be located close to each other. In our case, there will be a gap of 5 mm between the stickers.

Click OK, return to the previous window and there too OK. After that, the markup appears on the page in accordance with the specified parameters. Strictly speaking, the markup is a table, in the cells of which the price tags will be located.

Step 2. Selecting a data source

On the tab Newsletters under the button Select recipients choose an option Use existing list, in the dialog box we find the prepared Excel file and click Open. If there are several sheets in the Excel workbook, then in the next window you should select one with the table of interest to us -- OK. After that, the service fields of the merge will appear on the sheet in the markup NEXT. They are required to move to the next record, so you CANNOT delete them!

In addition, after selecting the source under the button Insert Merge Field tab Newsletters a list of fields in the source table appears.

Step 3: Formatting the Label

This step is the longest, since it is here that we form the appearance of the future price tag. Since the content does not automatically spread to all cells of the table at once, it is recommended to completely format the label in one cell, and then copy it to the rest. To view the appearance of the price tag in the process of work, use the button View Results tab Newsletters.

We type from the keyboard the text that will be present in all price tags, insert the merge fields in the right places using the button Insert Merge Field, format the price tag, if necessary, edit the codes of the merge fields. For example, in our document, we need to modify the field codes the date and Price.

Merge fields are code that can be seen by right-clicking on the field and selecting the command Codes/Field values. For example, field code the date will look like this (MERGEFIELD "Date") . Let's add a format to the code to display the date in the usual way ( MERGEFIELD "Date"\@"DD.MM.YYYY"}

Field code Price edit so that the price is displayed in monetary format (MERGEFIELD "Price"\# "# ##$0.00" ) .

After the desired result is achieved, copy the contents of the first cell to other table cells without deleting the field NEXT.

- click to enlarge the image

Step 4. Formation of the final file with price tags for printing

At the last step under the button Find and merge choose either option Printing Documents, and then all sheets are immediately sent to the printer, or Edit Individual Documents, and then a new Word document is created, in which you can see and, if necessary, edit the completed price tags

- click to enlarge the image

In conclusion, it can be added that the same steps can be performed using Merge Masters, which is launched from under the button Start Merge.

Good day! Today, at the request of my visitors, I decided to write an article about retail price tags in 2016-2017.

And in fact, this topic is of interest to many entrepreneurs and directors of organizations who have.

I wonder how I missed her, because I have my own store and about the price tags in 2016 I actually know everything.

Price tags for retail trade in 2016-2017

In general, I should have written this article about price tags for trade on December 23, 2015, since it was at that time that changes were made to the appearance of price tags.

The bill came into force on 01/01/2016, before that I don’t remember at all (although I have been in business for 13 years) that any bills passed by price tags.

Appearance of price tags from 2016

You probably paid attention to the fact that in stores quite often there are different price tags. Both printed and handwritten, and often just a sticky price tag (they come in skeins of 100 pieces) on which the price is written.

Moreover, even such price tags could be of all colors of the rainbow and no one complained about it. As for me, it doesn’t matter what the price tag is, the main thing is that the price on it is affordable.

But still, without hurrying, everything is put in order.

Now simple sticky price tags cannot be used, for a simple reason, the price tags should not just have a price, but the name of the product, the seller, etc.

What information should be on price tags from 2016

And so, since 2016, price tags in retail should have a single look:

  1. Seller's name. For example, MontazhZhilStroy LLC, and for the following type of IP, IP Zhumataev A.O.;
  2. The name of the goods being sold;
  3. Brand, model, grade, etc.;
  4. The cost of goods for 1 piece, kg;
  5. The date;
  6. Seller's signature.

Here's what should be on the price tags now. Well, at least there is no specific sample. The data on the price tag can be both printed and handwritten.

The only condition for everything to be the same, if you write the price tags by hand, then all the price tags must be written by hand, in the case when you print on a printer, then all the price tags in the store must be printed.

This is what should be in retail stores, but we also have a peddling and delivery trade:

Price tags for retail and delivery trade

If you are engaged in peddling or distribution trade, then you should have a price list on hand indicating the name of the product and its cost.

The price list must be certified by the signature of the responsible person and stamped if any.

Responsibility for price tags 2016-2017

Once there is a law, then naturally there is a punishment for its violation.

Of course, the punishment is administrative and, as always, is divided according to the form of ownership.

So let's consider what responsibility awaits those whose price tags will not be brought into proper form:

  • IP () - a fine of up to 1500 rubles;
  • Store manager - a fine of up to 3,000 rubles;
  • LLC () - a fine of up to 30,000 rubles.

As always, it is clear that a simple entrepreneur suffers the least, but a legal entity receives the full program.

Agree that it's quite a shame to get a fine of 30,000 for the fact that your price tags are not the same.

Download free price tags for trading

Naturally, when I started writing this article, I originally planned to post sample price tags on my Yandex.Disk: download price tags for free.

For those who use the 1C program, there will be no problems at all. Since this program has such a function as printing price tags (here's another plus for you to purchase this program). You can buy plastic holders for price tags at http://www.neoneo.ru/pos.shtml

Electronic price tags

Well, technology has already gone ahead, no one forbids you to install electronic price tags that have appeared on sale in your store, but their cost is so high that it is better to print them on a computer in the old fashioned way.

It was ridiculous to go through 2 search pages and couldn’t download a single price tag, there was only one scam around, I wanted to find an EXEL version, but after spending almost an hour I’ll post the price tags that I had in the store until I bought a laptop with the 1C program for an accountant.

Just replace my data with yours. That's all, as always, I accept all questions in the comments to the article or in my group in contact "

To make and print price tags on your own, we want to please you - you can download a huge number of useful and convenient applications. For example, you should pay attention to such an application as MiniMax-plus - it will allow you to develop and print understandable, beautiful, stylish, professionally executed within a few minutes. One of the positive features of the software is that users can add the logo and advertising of their own enterprise, as well as key features of the product, to attract customers.

If you download the MiniMax-plus program for free, then you can use ready-made templates and developments, the number of which exceeds two dozen. It should be remembered that the MiniMax-plus utility has flexible settings and parameters, as a result of which users can develop their own unique design using their own drawings, images, and design elements. If you download the software, then it can be used as a program for printing conventional labels and labels. In general, MiniMax-plus is a high-quality price tag printing program that will leave you with the most positive emotions.


If you wish, you can install another free utility that allows you to create in manual or semi-automatic mode. The software is designed for use in both large enterprises and small companies. Among the positive qualities, it is worth highlighting the possibility of adding logos and advertising of the company, which will positively affect the image of the trade enterprise. If you need a simple and convenient utility for creating price tags, then try to install the indicated application - you will not be disappointed.

A few words must be said about the e-Price List program. This is a specialized software, among the capabilities of which one can note the accounting of goods and price lists. If you download the utility, you will be able to maintain an automated directory, as well as store large amounts of information related to goods, storing it in the most convenient form for further use.


e-Price book allows you to synchronize prices for goods in directories and price lists. Users can choose a unique font for each label, as well as add descriptions and barcodes. So if installed, then you can create and print beautiful and informative for a variety of products.

You can quickly fill in price tags online and simply print if you use special programs. We offer an overview of programs for printing price tags: free or inexpensive.

Printing price tags: requirements

Government Decree No. 55 (namely, Article 19) contains requirements for the design of price tags. Firstly, information about goods must be written in Russian. Secondly, there is a list of required data.

So, the price tag should explain to the buyer:

    what is for sale (you must specify the name of the product);

    what kind of commodity (if it can be done, for example, “high-grade flour”);

    what is its capacity or weight (for example, the weight is 956 grams (for a pack of milk) or 1 liter (for mineral water);

    composition of the product;

    manufacturer.

The rest of the requirements that were spelled out in the laws before 2016, for example, the mandatory stamp on everyone, are no longer valid in 2018. Creating and multiplying price tags has become easier. Usually the price tag is installed on the shelf, and the label is attached to the product itself.

What is the difference between a price tag and a label? The price tag must contain the price and the name of the product. On the label - the main characteristics of the product, the price may be indicated on it, but this is not necessary

In addition, government documents do not say what the price tag should look like: be handwritten or or created using a printer to print price tags and labels.

You can develop your own price tag templates and edit ready-made ones in the Business.Ru program. It allows you to add a company logo, characteristics and description of the goods to the price tags, as well as to instantly print price tags when prices change.

The table below shows the mandatory requirements for printing price tags in 2018:

There are requirements for price tags and labels of non-food products. Such as:

    clothes, shoes - a mandatory label, where the size, article is written;

    complex technical goods - data on a specific model with a list of characteristics. For example, for monitors, you need to write the diagonal, contrast, brightness, response time;

    articles made of precious metals and stones - information about the sample and size, weight and type of stones;

    printed publications - the price can be indicated on them with a pencil or you can put a price tag with information only about the cost of a unit of goods (since the rest is already written in the book). However, if the book is sealed in a plastic package, it cannot be opened, the price tag should be the same as for goods without a grade definition - with the name and price per unit.

It is worth noting that there are no requirements for the font size on the price tag. The main thing: the information should be well read.

Multiple prices are allowed:

    the full cost of the goods;

    the price of goods for promotions and special offers.

Knowing the requirements for printing price tags, you can configure their printing yourself. This will help programs for printing price tags, distributed for free.

Professional automation of goods accounting in retail. Tidy up your store

Take control of sales and track the performance of cashiers, outlets and organizations in real time from any convenient place with an Internet connection. Form the needs of outlets and purchase goods in 3 clicks, print labels and price tags with a barcode, making life easier for yourself and your employees. Build a customer base with a ready-made loyalty system, use a flexible discount system to attract customers during off-peak hours. Operate like a big store, but without the cost of specialists and server hardware today, start earning more tomorrow.

Overview of software for printing price tags

Programs that can automatically print labels and price tags greatly facilitate the work of Russian entrepreneurs. Some programs allow editing, deleting and adding information. Most of the programs described are free to use.

Business.Ru

Additional features:

    automatic calculation of sales prices, taking into account the markup;

    printing discounts on goods for members of the loyalty program or owners of discount cards.

You can print price tags on both a regular and a special label printer.

The business accounting system "Business.Ru" has several tariffs, including free. Allows you to send price tags for online printing for free and immediately in groups. Paid versions of Business.Ru (from 375 rubles per month when paid for two years) do not have a limit on the number of goods.

The paid version provides pictures and barcodes, and the ability to save the database on a computer without the Internet.

The program runs in the cloud. However, there is also a free version for installation on a computer. With it, you can print up to four price tags per day without restrictions.

e-price tag

The "e-Price tag" program also provides for the possibility of printing price tags. However, it does not have a long free version - only a trial period of 30 days.

The difference between “e-Price List” and other programs is that it provides a large number of free and paid templates. For example, now the site advertises templates for price tags in the pavilions of the Moscow Metro.

An entrepreneur can order the development of a price tag template, which costs more than a thousand rubles.

The price of a perpetual license of the program itself is 1250 rubles.



We recommend reading

Top