As a rule, in retail stores, price tags are printed based on a certain template (layout).
Let's figure out how to create your own layout - place the company logo and change the standard appearance price tag.
In particular, consider:
Applicability
The article was written for the editors of 1C: Retail 2.1 . If you use this edition, great - read the article and implement the considered functionality.
If you plan to start implementing 1C: Retail, then most likely a more recent edition will be used. Interfaces and functionality may vary.
Therefore, we recommend taking the course 1C: Retail 2 for store automation and service companies, this will help you avoid mistakes and loss of time/reputation.
Create a standard price tag
To store templates of price tags and labels in the system 1C: Retail a special guide “Templates of labels, price tags and KKM checks” is intended.
To call the directory list form, you must first go to the section Administration and choose a team Printing forms, reports and processing (see Fig. 1).
Rice. 1 Calling the window “Print forms, reports and processing”
A special form will open (see Fig. 2), in which the command for opening the “Labels, price tags and KKM receipt templates” directory is available.
Rice. 2 Calling the form of the list of the directory “Templates of labels, price tags and receipts of KKM”
In the opened form of the list of templates (see Fig. 3) using the button Create you can create a new template.
Rice. 3 Form of the list of the directory “Templates of labels, price tags and receipts of KKM”
In the form for creating a template (see Fig. 4), only two fields are required to be filled in: Template type and Name. Template type can take on multiple values. AT this case select the value "Label (price tag) for the product".
Specify an appropriate name for the template. Before further editing, the created element should be recorded by pressing a special button in the form of a floppy disk.
Fig.4 Template creation form
Please note that both the price tag and the label are of the same template type. This is due to the fact that the actions during the creation of both objects will be similar.
If we talk about the difference between labels and price tags, then their difference is only in purpose.
It is assumed that the price tags are cards of medium and large size. They use large fonts. Typically, price tags do not contain barcodes, because designed to be placed on showcases for customer review.
As for labels, the situation is different. Typically, a label is an adhesive card for a product. Labels are used in small and medium sizes, large labels are rarely available.
The label must have a barcode. Sometimes an additional price is indicated. Moreover, labels are glued for each unit of goods, unlike price tags, which are usually created and placed one for each type of product.
Labels are actively used when reading goods at the checkout and during inventory. Those. the label is the product identifier when working with barcode reading equipment.
In the form of the saved directory element, click the button Edit Layout(see Fig. 4). A special form for editing templates will open (see Fig. 5).
Rice. 5 Template editing form for labels and price tags
The label and price tag template editor has a small set of tools. Consider the main components of this editor. On the right are the parameters of the edited template. Here you can set specific barcode printing options (Code Type, Display Text, Font Size and Angle of Rotation).
But these parameters are mainly used for labels. A little higher are two parameters that allow you to determine the number of price tags placed on one page horizontally and vertically.
The left side of the editor contains a list of fields available for use in layouts. Here there is information about the prices of the item, store, organization, current time and current user.
There is also information about the product itself: nomenclature, characteristics and barcode. It should be noted that when used in the program Retail 2 additional properties that you create, they are also available in this list. For example, an additional property was created in our database Floor, access to which is present (see Fig. 6).
Rice. 6 Fragment of the list of available fields
The third area of the editor (main area) − spreadsheet document to draw the layout. In principle, we will work with a spreadsheet document, which is used to display printed forms of all documents in the system. 1C: Retail.
You can create your own price tag layout based on a standard template specially provided in the configuration Retail 2.
To do this, in the editor form, click on the button Download default template and select from the drop-down menu price tag(See Fig. 7).
Rice. 7 Selecting a default template
System 1C: Retail will issue a confirmation request to replace the edited template with the default template (see Fig. 8)
Rice. 8 Confirmation request to replace the template being edited
AT this moment the template is empty, so we agree with the system's proposal. A standard price tag layout will appear in the spreadsheet document (see Figure 9).
Rice. 9 Fragment of a spreadsheet document. Standard price tag layout
Please note that in the template editing form, in addition to the ability to select a default template, there are two more commands: for importing a template from a file and exporting to a file.
Using these commands, you can export the created layout to an external file and load it either into another template, or even into another system. 1C: Retail.
In addition, the import and export mechanism can have another useful application, which will be discussed in the next article when creating a layout for labels.
Editing text elements of the price tag
Consider what the default price tag template consists of. This is a standard spreadsheet document, which consists of cells of a certain size and a certain content.
The standard template displays: the name of the organization, the name of the product and its characteristics, the manufacturer of the product, the price. The footer of the template displays information about the code, article number and name of the product packaging.
In addition, the current date (the day on which price tags are printed) is indicated.
All in all, the standard layout satisfies the needs of the store quite well. Only some adjustments may need to be made. To begin with, let's look at how the fields available on the left side are displayed from the list to the template layout.
For example, in this layout we will display more information about the store. Let's place this information below the organization at the top of the layout. First, let's expand the area between the organization and the nomenklatura.
To do this, place the mouse cursor on the line with the nomenclature and select the command from the context menu push apart(see fig. 10).
Rice. 10 Creating free space between lines
In the form that appears, select the option "Vertical".
An additional line will appear between the line with the organization and the line with the nomenclature (see Fig. 11)
Fig 11. Standard price tag with an added line
In the resulting empty area of the price tag, copy the cell for the organization. It is important that this copies the cell format (see Figure 12).
Rice. 12 Copy layout cell format
Now, by activating the new cell and pressing the button on the keyboard Delete clear it of text. To display information about the store, activate an empty cell and double-click the left mouse button on the field available in the list Name for the store, add it to a free cell (see Fig. 13).
Rice. 13 Adding Store Name Information to the Layout
In addition, it may be necessary to place some static text in the layout, which will not change in any way when the price tag is printed. In the standard template, this cell is the signature cell. This is exactly the text that will be the same for all price tags.
Let's consider what is the difference between a signature cell and any other cell that displays some property from the list of available fields. These cells differ fundamentally, as they belong to different types of cells.
Cell properties can be viewed through the context menu (item Properties) or using the keyboard shortcut alt + Enter. The Properties Palette of the current cell opens, in which you can edit these properties.
Notice the property filling. For the cell in which the field is displayed Store.Name, this property has a value Sample. It is this property that characterizes the cell type. There are three values available for selection: Text, Parameter and Sample(see fig. 14).
Rice. 14 Cell Properties Palette
When a new, not yet filled cell is selected, the property filling takes on the value Text. cells with type Text are used just to display some static information.
Still, the main ones are the cells in which the value somehow changes, since price tags for an unlimited number of goods will be printed based on one layout.
Therefore, it is necessary that each price tag is somehow modified and displays information about a specific product, price, store, organization, etc.
You can specify the cell type Parameter. In that case, the system 1C: Retail defines the text that will be displayed in this cell, by the name of the parameter. The parameter name can be entered directly into a cell with a fill type Parameter.
In this case, it will be displayed in the Properties Palette of this cell (see Fig. 15). There are certain restrictions on the parameter name. It must be a single word containing only letters, numbers, and underscores.
Rice. 15 Cell properties palette with fill type Parameter
To fill in data from the list of available fields, cells with the fill type are used Sample. Sample is a shared type. In such a cell, you can specify both static text and some parameters that will change dynamically.
The cell is filled in as follows: we can enter arbitrary text, use spaces, and where it is necessary to enter some kind of dynamic component (that is, some parameter), you should enter the name of the parameter in square brackets.
After the parameter, you can again put a space, enter some text, and after that another parameter, and so on.
Dynamic cells (with type Parameter and Sample) are visually distinct and are displayed in triangular brackets. Triangle brackets system 1C: Retail puts herself. This can be seen in the price tag layout.
An important property of a cell is Format. In the standard template, this property is used to display CurrentTime(dates) (see Fig. 16).
Rice. 16 Filling in the Format property
Default current time contains the date and time. Printing on price tags only requires information about the date. The format is filled in the Cell Properties Palette.
You can use the button to fill in Choose with a three-dot icon. At the same time, the form of the format string constructor will appear (see Fig. 17).
Rice. 17 Format string constructor
This constructor is designed to define the output format for values of the type Number, the date and boolean. In figures 16 and 17, the date format is set, in which there is no time value, and the year is displayed in two digits.
If necessary, this format can be overridden, for example, display the full year (dd.MM.yyyy) or display the month not as a digit, but as its full alphabetic name, and at the same time replace the separating points with spaces (dd MMMM yy).
In addition to changing the format manually, you can select the date representation of interest from the drop-down list. In this case, the value of the format string will be filled in automatically (see Fig. 17).
When forming the layout, another cell property is often used, which allows you to determine the behavior of the cell if the text that we display in it does not fit in size.
This property is called Accommodation. It can be assigned one of the following values: Auto, crop, score and transfer(see fig. 18).
Rice. 18 Filling in the Placement property
When choosing a value Auto the text that does not fit in the cell is placed in subsequent cells. But this happens only if the cell next to the right does not contain any value. Otherwise, text that is not included in the main cell will simply be cut off.
Meaning crop means that text that does not fit in the main cell is always cut off. Meaning score means that if the text does not fit in a cell, then all the text in this cell is filled with hash marks (#########). The value of the cell itself is not visible.
Wrap means that if the text does not fit in this cell, then the cell is stretched in height so that the text fits completely. At first glance, this is the most convenient option for placing text, but it is fraught with a certain problem.
When using text wrap, the size of the layout can become uncontrollable, i.e. it can easily deviate from the given original size in height.
In the future, when printing, stretching one price tag may lead to an unreasonable increase in the vertical dimensions of neighboring price tags for other products.
To resolve this issue, you will need to disable automatic layout row height adjustment.
To do this, call the context menu in the digital row header and select the Row height item (see Figure 20).
Rice. 20 Calling the “Row height” form
The line height form will appear (see Figure 21).
Rice. 21 form row height
This form must be unchecked. auto height line and set the desired constant value of the line height. In this case, if the cell height allows you to place two or more lines of text, the text will still wrap to the next line, but the cell height will be constant. Text that does not fit will be cut off.
It should be noted that both the beginning of the text and its end can be cut off. It depends on another property of the cell - the position of the text in the cell (namely, the position Vertically).
In order to cut off the lower lines, you need to select the value for this property. Top(see fig. 22). Nearby adjusts the horizontal position of the text.
By default, this property is set to Auto, and the text is aligned to the left of the cell. By choosing other values, you can center the text in the cell, right-align or justify.
Rice. 22 Fragment of the Cell Properties Palette (Position property group)
It is also possible to change the font of the text in a cell. In the Properties Palette under Decor there is a corresponding property Font. It is possible to select a specific font, its size and style (see Fig. 23).
Rice. 23 Fragment of the Cell Properties Palette (property group Appearance)
Adding a company logo
Let's add the company logo to the price tag layout. The logo will be inserted between the name of the store and the name of the product. Let's expand the corresponding area by analogy, as we did earlier (see Fig. 10 and 11).
The resulting additional area consists of several cells. They should be merged. To do this, select them with the mouse and select the command in the context menu Merge(see fig. 24)
Rice. 24 Merge Free Area Cells
The logo will first be inserted into one of the free cells under the price tag. Then we adjust the free area to the desired size and move the logo into it.
So, we activate with the mouse one of the cells under the price tag. To insert an image, main menu select item Table – Drawings – Picture(see fig. 25).
Rice. 25 Calling the form for choosing a picture
A form for selecting a picture will appear (see Fig. 26).
Rice. 26 Form Select picture
The picture can be selected from the Library or from File. Since the logo is stored in an external file, you should click on the button in the form Choose from file. A dialog box will open for selecting a picture file (see Fig. 27)
Rice. 27 Picture File Selection Dialog Box
After selecting a file, the image will be displayed on the form Picture selection. Below the picture will be indicated its dimensions. In practice, it was found that the dimensions are indicated with a small margin (see Fig. 28).
The vertical size is desirable to write out or remember. Then you can click on the button OK.
Rice. 28 Completing picture selection
Quite often during work retail store there is a need to print new price tags and labels for the goods. For these purposes, the Trade Management 11 program has a built-in processing "Printing price tags and labels", which allows you to print price tags and / or labels for any item in the database according to pre-configured layouts. In this article, we will look at the processing interface, the nuances of creating and setting up a layout, and we will analyze what to do if the label does not print correctly.
Processing Interface
Processing "Printing price tags and labels" can be found in the "Sales" and "Warehouse and delivery" sections in the "Service" subsection.
The processing itself looks like this:
Let's take it in order.
There are three buttons for managing processing settings on the command panel
Printing price tags
Printing labels and price tags
Label printing
Show selection - the command opens the selection setting, with which you can automatically fill in the tabular section with all the nomenclature that matches the specified conditions.
Show filling mode - the command displays additional settings for filling the columns "Number of labels" and "Number of labels".
Set print mode - allows you to set the print mode for processing. There are three print modes available:
The input fields following the command line are required to fill in the data indicated in them in the processing tabular part and in the price tag (label) layout.
By price type - a specific price type is indicated, according to which prices will be filled in the tabular section and the layout.
By store - the retail price type of the store will be selected as the price type. You cannot select a wholesale warehouse as a store.
Organization - information about the organization for substitution in the layout will be taken from this field. If the field "Organization" is not filled, then empty cells will be displayed in the layout. Despite this, the field is not mandatory.
Price filling settings are responsible for automatic substitution of prices in the tabular part and layout. Filling in prices is available in two ways:
Please note that the price selection is possible for a specific date
Next is the tabular part, which is a list of items for which you need to print price tags (labels). The nomenclature can be added to the tabular section and selected manually, read the barcode using barcode scanners, or fill in the tabular section according to the configured selection.
The "Set" command is responsible for setting the templates and quantity of labels and price tags, as well as for generating a new barcode for the product, if there is none, directly from the processing interface.
Create and customize a layout"Label and Price Templates" is a reference, hidden by default from users. You can go to it directly from the "Print labels and price tags" processing by adding a product to the tabular section, double-clicking on the "Price tag template" or "Label template" column and clicking the "Show all" command.
In addition, the directory can be added to the panel of the "Reference and Administration" section using the panel settings - the gear in the upper right corner of the panel.
As you may have noticed, the "Label and price tag templates" directory has two commands: "Create" and "Create new". The New command will open the template creation assistant, where you can choose the purpose of the template, the default layout, and the size of the ribbon.
By the "Create New" command, the layout editor will immediately open in front of you, where all the above parameters will need to be filled in manually.
Let's take a closer look at the second option for creating a template. In addition to key data, such as the purpose and size of the layout, there is also a price tag (label) layout editor. All this data can also be filled with predefined values using the "Select a predefined template" command - in this case, the purpose, width, height and layout will be filled by default from a predefined template.
Let's try to create the simplest layout of the price tag template manually. Initially, you need to select the size of the tape, that is, the width and height. This is very milestone, since resizing the layout entails a complete clearing of the table field, so it is better to enter this data before editing the layout.
After specifying the width and height, the layout will shrink to the specified dimensions.
Cell size affects how precisely you can position various data in a layout. The smaller the cell, the more accurate the location. Changing the cell size also entails a complete clearing of the table field.
Filling the layout cells with the necessary data is done by simply dragging data from the "Available fields" table on the left to the table field. The data that is dragged onto the layout in this way are parameters, meaning it will be filled in with real data when it is rendered. printed form. In addition, layout cells can be filled with plain text and a template. The patterns are bundles: "<параметр>+ text" and "<параметр> + <параметр>" in any order and with any number of terms.
Let's fill the layout with data and look at them in more detail.
As you can see, only three fields will be displayed on the price tag: item name, barcode and price. In this case, the name of the item in this case is a parameter, as well as a barcode, but the price is a template, that is, the current price specified in the processing will be substituted for the [Price] inscription, and the inscription "rub." and will remain so, as it is plain text.
With the "Print sample" command, you can see how the layout will look with real data.
Let's try to print the created price tag for the item list.
Note that a label template cannot be used as a label template and vice versa. This limitation is related to the principle of outputting layouts to the printer. The label template is designed to be printed on a label printer. If a label printer is not connected and printing is done with a regular printer, then each label will be printed on a separate sheet. The price tag template can be printed both on a label printer and on a regular printer on an A4 sheet.
What should I do if the price tags (labels) are printed incorrectly?
Sometimes users have to deal with situations when price tags (labels) are printed with curves, cut off, or even on several labels. These problems happen only with label printers, when printing on A4, such problems were not noticed.
In most cases, this is due to an incorrectly configured label printer and incorrect settings in the layout. What to do in such cases?
First, you need to open the database in the thin client. You can read how to do this and what it is in the following article:, or simply contact our technical support, and IT specialists will help you set everything up. Working through a thin client will allow 1C to work with a printer driver on your local computer. This means that all settings made in the driver will be automatically pulled by the program, which does not happen when working through an RDP connection.
Second, make sure the label size is correct in the printer driver. If the printer sends the wrong tape size to 1C, then it is not possible to correctly set up the label in 1C.
When the thin client is configured and the driver settings are completed, you can start setting up the layout in 1C.
The first thing to do is to make sure that the size of the layout in the driver and in 1C are the same. If this is not the case, then the layout will have to be adjusted again, as changing the size of the ribbon will clear the layout, as discussed earlier. After setting the layout size, you can check the label output. To do this, it is not necessary to print a label, just open the preview. If the label looks correct in the preview, it is not cut off and does not go beyond the boundaries of one sheet, then you can try to print. Please note that if the label looks correct in the preview, but it still prints incorrectly, then you need to check the label size in the printer driver again, and also make sure that 1C pulls up the correct driver settings. You can do this using the Page Setup command.
If adjusting the tape sizes did not help, and the label is still displayed incorrectly, then go to the page setup settings. There are only two parameters here that can affect the label output for printing. This is the scale and margins. Try toggling the zoom switch to "Fit Page Width" or zoom out and see how the label looks in print preview and print. As a rule, these actions are enough to correct the printing of the label. In rare cases setting field values to 0 helps.
If none of these steps helped, then contact the service technical support, and experts will help you fix the print layout error.
There is no barcode in the standard price tag template in 1C: Retail, but it is easy to add it, while the base will remain standard. How to do this, read further in the instructions.
IMPORTANT!
You will only be able to print price tags for an item if it has been delivered to the warehouse and prices have been set for it.
If everything is ready, go to the section Marketing, Further Pricing - Item prices.
A list of documents will open Setting item prices. It is from these documents that we will print price tags. Select a document with current prices, click Printing - Price tags.
A form opens with the same products that were in the selected item Price setting document. You can print price tags for all positions, and only for selective ones. You can also choose the type of prices that will be printed on the price tag: to do this, set the switch on the button "According to prices" and select the required price type, as shown in the figure below.
A window opens Templates for labels, price tags and KKM checks. Our next step is to develop a price tag template. Click on the button Create.
Choose Template type - Label (price tag) for the product, set the name, for example "Price tag with a barcode". Next, click on the button Edit Layout.
A window has opened Editing a price tag template (labels).
We won't create a template from scratch, we'll just modify the built-in example. This will help save time.
We press the button Download default template, choose from the list price tag.
A standard price tag template has opened, there is no barcode in it.
As you can see, the 6th line serves as a free interval, we will increase it in height and add a barcode there.
We put the cursor in the 10th line, in the list on the left, select Barcode.
A dialog pops up Add barcode like a picture, click Yes.
The barcode appeared in the template, but it is compressed in the cell. To enlarge the barcode image, select it and stretch it to the cells added earlier.
Now the barcode is clearly visible on the price tag.
The best option: 2 horizontally and 4 vertically, for a total of 8 price tags on an A4 sheet.
Click OK and in the next window Write and close.
As you can see, the Print Template column is filled with the name of our new template. Next, press the button Seal.
Ready. This is what our barcodes will look like
This lesson shows you how to create print templates and print labels and price tags for a selected product group.
The procedure for printing both price tags and labels is identical, so I will show the process using the example of printing labels.
Create a label template (SE)
Labels and price tags are printed according to templates, let's open the list:
We create a new one:
Specify the name, size of the printed tape, select the destination from the list:
The tape size is also selected from the list:
In field For what a specific nomenclature card is selected, on the example of which it will be possible to generate a test print.
If the proposed SE does not suit you and you want to modify it, open the editor using the hyperlink:
In the upper part of the editor, the label dimensions and cell size are indicated, in the left part there is a list of fields available for adding to the template. The addition itself is carried out by double-clicking on the selected available field (or by clicking on the selection button located to the right of the list of available fields).
In the central part of the editor, the edited SE itself is located. When a cell is selected, a palette of properties for this cell is displayed on the right side of the editor (in which, for example, you can set the font format, set borders, etc.):
You can create a new SE in the editor based on the predefined:
Let's add its article number to the header before the name of the product. Additionally, using the properties palette, change the font:
When printed, we get the following picture:
SE is a regular spreadsheet document (complete analogy with Excel). For example, let's clean up the SE completely and create our own:
Let's add the article, name, barcode and print time:
After making all changes to the SE, it must be recorded.
If for different types different nomenclatures are used, this can be configured in the card of types of nomenclature:
If specific label or price tag templates are used when printing specific products, this can be configured in the item card:
Label printing
After creating the SE, we proceed directly to printing labels, for this we open workplace group printing of labels and price tags:
First of all, set the print mode:
In order to print labels not for all, but only for the selected item, you need to configure the selection. Suppose we are only interested in the nomenclature with the form Furniture and only the one for which prices are set with the type Retail:
After setting the selection, fill in the table of goods:
We see that the SE was filled in automatically:
By default, the number of labels is equal to the inventory balance of the item, but if necessary, you can set the number manually:
When printed, we see the following picture:
When printing a label for the Bedside table product, a barcode error occurred (because I set it arbitrarily, by entering random numbers, ignoring the formation rules), in real life this should not happen.
Price tags in 1C enterprise
Price tags and product labels are an integral part of retail. They are needed for window dressing and designation of product information. Barcode labels allow you to automate the sales process and identify the product.
The 1C program provides the function of creating labels. To do this, you need a configuration - Trade Management. Required Tools are located in the Nomenclature section. A format is available for a standard A4 printer and specialized for labels.
Preparing for printing
First of all, you need to assign a price to the products. Fill in barcode nomenclature.
The label can display the price and barcode. To do this, check the box "Display price".
Instruction
The procedure for processing the printing of price tags is as follows:
Selection (selection of goods for printing) → Setting parameters (format, paper type) → Viewing results (selected items) → Printing
All in order:
section Marketing - Item prices
You need to print the price tags of goods with set price. Locate the price data document in the list.
Printing price tags
Select a file from the list - Item price settings. Click “Print” → Price tags. Price data will be added automatically.
creating a new template
Install → Price tag template, set the type and name of the template. Click "Edit Layout". In the template editor that opens, click “Load default template”.
Edit ready template easier than building one from scratch. Once you've mastered the templates, you'll be able to design your own.
price tag (template type)
If the barcode on the label is not needed, then the setup is complete. Start printing. If a barcode is needed, we continue the setup.
barcode area preparation
Highlight the sixth line. Right-click to select Expand.
barcode insertion
Putting the cursor on the ninth line, click "Barcode". Stretch the barcode on the lines prepared earlier.
deleting extra lines - highlight, click "Delete". Specify the number of labels per sheet.
preservation
label printing
Returning to the "Print Labels" window, select all items (Ctrl+A). Click "Install - Price List". Select the created template. Click on the "Print" button.
Help at work
When printing labels, the element 1C - Printing barcodes is used. This control is installed from the ITS disk.
Got a question? Our consultants will help you. You can contact us via online chat or by phone.