0 Users and 1 Guest are viewing this topic.

Program for comparing prices in 1C: analysis of prices of suppliers and competitors
Program for Trade Management 11.4, 10.3, KA,
The analyzer generates a price table for items and suppliers in 1C. Supplier prices can be downloaded from price lists or recorded based on receipts.
The main task of the module is to obtain the best price among suppliers, which will be the basis for calculating your selling prices.

In the Megaprice PRO subsystem: Automatic comparison of prices of suppliers, setting your own prices in 1C according to a regulatory task

Using the expanded directory of Types of Item Prices, as well as the Price List Analyzer module, calculations are also carried out in the 1C database.

Main features of Autoprice

Analysis and comparison of suppliers' prices.
Analysis and comparison of competitors' prices.
Directory Extended types of item prices.
Creating extended price types for regular prices.
Creating multiple extended price types for one regular price type.
Different markups with many conditions.
Calculation of prices based on the best prices of suppliers (taking into account balances for Megaprice PRO)
Calculation of prices based on competitors' prices.
Arbitrary formulas for calculating prices.
Breakdown of rules with product selections made by different managers.
Breakdown of rules with selection of items from different suppliers.
Breakdown of rules with product selections when loading supplier price lists on different days.
Convenient table in visual mode.
Lots of transcripts.
Output to a table of balances and sales by item.
Selection by warehouse balances and selection by sales for the period.
Markdown of unsold goods for the period.
Control of work with new products (Megaprice PRO)
Obtaining balances of suppliers and comparing suppliers, subject to the availability of goods (Megaprice PRO)
Setting prices only subject to change.
Automatic prices for arbitrary types, according to a regulatory task.
Setting priorities for advanced price types.
The module is included in the Megaprice PRO kit.

The price of Autoprice includes processing for loading price lists into 1C

Extended loading of price lists into 1C from Excel from A to Z
Using the module, you can manually and automatically download complex price lists and register prices in 1C. Compare nomenclature, work with correspondence with supplier nomenclature.
Typical loading of supplier price lists into Price Registration (external processing).
Automatic downloading of suppliers' price lists (Megaprice PRO).
Loading virtual balances of suppliers (Megaprice PRO).
Control of updating balances and prices for disappearing items from the supplier’s price list (Megaprice PRO)
Registration of new products (Megaprice PRO).
Individual exchange rates (Megaprice PRO).
More than 10 options for precise item search, including fuzzy matching.
A huge database of algorithms that allow you to solve any problem.
A huge number of possibilities for working with downloads.

Official program page

SubSystems.Ru - Automatic loading of price lists into 1C from Excel

Advanced price types allow you to create elements that separate conditions and selections into multiple regular price types, as well as multiple rules for one regular (standard) price type.

Example 1. You have a sales price, but the catalog is huge (different groups, different types of items, etc.). The entire catalog is distributed between different managers. Some managers maintain one part of the catalog (by manufacturer, type, hierarchy, and so on), other managers are responsible for other parts of the catalog.
Products have different pricing and each manager must control his own area without interfering with other items.
Advanced price types allow you to create an unlimited number of elements, which will have different selections, different markup rules, and so on. Moreover, they all generate one single final type of sales prices.

Example 2. Many suppliers. Some suppliers supply some products, other suppliers supply others. At the same time, prices are received at different hours, days, weeks. You need the pricing to work with the division based on this principle. If you create a full revaluation table each time, then each time the full table will be unscrewed, which can cause significant losses in the speed of work and information processing.
By using. For extended types of prices, you can create a setting that contains a list of suppliers, selections, and so on, and specifies a task when you need to perform analysis, compare supplier prices, and set your own prices.

Often there is a need to analyze the prices of counterparties in order to adjust your own prices or set the price for a new product.

Moreover, not only your supplier or buyer, but also a competitor can act as a counterparty.

In this article we will look at the process of price analysis in the 1C: Trade Management program, ed. 10.3" using the example of a study of competitors' prices.

Creating a business partner and price types

Each company whose prices you want to analyze must be created in the “Counterparties” directory.

Menu: Directories – Contractors (buyers and suppliers) – Contractors

Let's add a new counterparty and indicate its name:

If you plan to interact with a new counterparty - buy goods from him or, conversely, sell - check the appropriate “Buyer” or “Supplier” flags. And also fill out other necessary details.

If you need a counterparty only for price analysis, and you do not plan any interactions with him, then filling in the name will be quite enough.

Click the “OK” button to save the counterparty and close it.

In addition to the counterparty itself, you need to create its price types. We want to compare our wholesale prices, so for each competitor we need to create a "Wholesale" price type and set prices. For other price types (eg small wholesale/retail/distributor), separate price types for each competitor would also be needed.

Let’s open the directory “Types of prices for the items of counterparties”.

Menu: Directories – Nomenclature – Price types for counterparty nomenclature

Let's create a new type of counterparty prices and fill in:

  • Counterparty - Competitor.
  • Name – Wholesale prices.
  • Item price type – the price type of our organization with which we want to compare the counterparty’s price. In this case, this is the wholesale price.
  • Currency – in which prices will be set. You can select any currency, since when comparing prices, they are all converted into one currency selected in the report.
  • Prices include VAT - a sign that VAT is included in the price.

Click the “OK” button to save and close the price type

Important: be sure to specify the price type of the item, otherwise the program will not understand at what priceat the costIn our organization, we plan to compare competitor prices.

Setting competitor prices in 1C

To set counterparty prices for goods, use the document “Setting prices for counterparty items”.

Menu: Documents – Pricing - Setting prices for counterparties' items

Let’s create a new document and fill in the counterparty “Competitor”.

After specifying the counterparty, you can fill in the types of prices to be set. To do this, click on the selection button in the “Price type” field, in the selection window that opens, set the flag for the wholesale price and click “OK”.

Example of a completed document:

Analysis of competitors' prices in 1C

To analyze competitors' prices, use the "Price Analysis" report.

Menu: Reports – Pricing – Price Analysis

In the report, it is better to select the type of prices that you want to analyze, otherwise the program will display all the information at once.

To set up selection, click on the “Settings” button, go to the “Selection” tab and select the price type – “Wholesale” (you can also use quick selections on the form).

On the report form, also set the currency in which you want to analyze prices.

Example of a generated report:

The report on the left displays all products for which wholesale prices have been set. Below are the prices of our company and the date of their installation (01/16/12).

After your own prices, the program one by one displays information about all established prices of competitors. The counterparty's price and its deviation from our price as a percentage are indicated. If the deviation is positive, then the competitor’s price is higher than the company’s price. Conversely, if the deviation percentage is negative, then the competitor’s price is lower than your price.

Thus, you can enter the prices of several of your competitors in the program. After this, you can conduct a price analysis and adjust your price if necessary.

Often there is a need to analyze the prices of counterparties in order to adjust your own prices or set the price for a new product.

Moreover, not only your supplier or buyer, but also a competitor can act as a counterparty.

In this article we will look at the process of installing and analyzing prices in the 1C: Trade Management program, ed. 10.3" using the example of a study of competitors' prices.

Creating a business partner and price types

Each company whose prices you want to analyze must be created in the “Counterparties” directory.

Menu: Directories - Contractors (buyers and suppliers) - Contractors

Let's add a new counterparty and indicate its name:

If you plan to interact with a new counterparty - buy goods from him or, conversely, sell them - check the appropriate “Buyer” or “Supplier” flags. And also fill out other necessary details.

If you need a counterparty only for price analysis, and you do not plan any interactions with him, then filling in the name will be quite enough.

Click the “OK” button to save the counterparty and close it.

In addition to the counterparty itself, you need to create its price types. We want to compare our wholesale prices, so for each competitor we need to create a "Wholesale" price type and set prices. For other price types (eg small wholesale/retail/distributor), separate price types for each competitor would also be needed.

Let’s open the directory “Types of prices for the items of counterparties”.

Menu: Directories - Nomenclature - Price types for counterparties' nomenclature

Let's create a new type of counterparty prices and fill in:

  • Counterparty - Competitor.
  • Name - Wholesale prices.
  • Item price type - the price type of our organization with which we want to compare the counterparty's price. In this case, this is the wholesale price.
  • Currency - the currency in which prices will be set. You can select any currency, since when comparing prices, they are all converted into one currency selected in the report.
  • Prices include VAT - a sign that VAT is included in the price.

Click the “OK” button to save and close the price type

Important: be sure to specify the price type of the item, otherwise the program will not understand at what priceat the costIn our organization, we plan to compare competitor prices.

Setting competitor prices in 1C

To set counterparty prices for goods, use the document “Setting prices for counterparty items”.

Menu: Documents - Pricing - Setting prices for counterparties' items

Let’s create a new document and fill in the counterparty “Competitor”.

After specifying the counterparty, you can fill in the types of prices to be set. To do this, click on the selection button in the “Price type” field, in the selection window that opens, set the flag for the wholesale price and click “OK”.

Example of a completed document:

Analysis of competitors' prices in 1C

To analyze competitors' prices, use the "Price Analysis" report.

Menu: Reports - Pricing - Price Analysis

In the report, it is better to select the type of prices that you want to analyze, otherwise the program will display all the information at once.

To set up selection, click on the “Settings” button, go to the “Selection” tab and select the price type - “Wholesale” (you can also use quick selections on the form).

On the report form, also set the currency in which you want to analyze prices.

Example of a generated report:

The report on the left displays all products for which wholesale prices have been set. Below are the prices of our company and the date of their installation (01/16/12).

After your own prices, the program one by one displays information about all established prices of competitors. The counterparty's price and its deviation from our price as a percentage are indicated. If the deviation is positive, then the competitor’s price is higher than the company’s price. Conversely, if the deviation percentage is negative, then the competitor’s price is lower than your price.

Thus, you can enter the prices of several of your competitors in the program. After this, you can conduct a price analysis and adjust your pricing policy if necessary.

The report is intended for a comparative analysis of prices for goods from various counterparties, including the company’s own prices.


The report is generated in the form of a cross-table, the row headings of which are product items (products), and the column headings are counterparties. The report is generated for a specific date at the prices that are recorded in the information registers “Item prices” and “Counterparty prices”.


To generate a report, you can specify those price types in the “Item Price Types” directory for which the company’s prices were registered. At the same time, for comparison, those types of prices of counterparties are displayed for which the selected type of item prices is indicated in the directory “Types of prices for the item of counterparties”.


If the price type is not specified in the report settings, then the analysis will be carried out for all prices registered at the enterprise and for counterparties.


To compare prices, all prices are recalculated in relation to the base unit of measurement of the item and to the currency selected in the report settings.


Using this report, you can analyze the deviations of counterparties' prices from the company's prices. To analyze deviations, you need to set the flag in the indicator “Deviation from the company price in %”.


For groups of counterparties and items, average prices for contractors and item groups are displayed, as well as average percentage deviation values.


By setting the grouping by price registration date, you can see the date when the current price for a given product was registered.

Often there is a need to analyze the prices of counterparties in order to adjust your own prices or set the price for a new product.

Moreover, not only your supplier or buyer, but also a competitor can act as a counterparty.

In this article we will look at the process of installing and analyzing prices in the 1C: Trade Management program, ed. 10.3" using the example of a study of competitors' prices.

Creating a business partner and price types

Each company whose prices you want to analyze must be created in the “Counterparties” directory.

Menu: Directories – Contractors (buyers and suppliers) – Contractors

Let's add a new counterparty and indicate its name:

If you plan to interact with a new counterparty - buy goods from him or, conversely, sell - check the appropriate “Buyer” or “Supplier” flags. And also fill out other necessary details.

If you need a counterparty only for price analysis, and you do not plan any interactions with him, then filling in the name will be quite enough.

Click the “OK” button to save the counterparty and close it.

In addition to the counterparty itself, you need to create its price types. We want to compare our wholesale prices, so for each competitor we need to create a "Wholesale" price type and set prices. For other price types (eg small wholesale/retail/distributor), separate price types for each competitor would also be needed.

Let’s open the directory “Types of prices for the items of counterparties”.

Menu: Directories – Nomenclature – Price types for counterparty nomenclature

Let's create a new type of counterparty prices and fill in:

  • Counterparty - Competitor.
  • Name – Wholesale prices.
  • Item price type – the price type of our organization with which we want to compare the counterparty’s price. In this case, this is the wholesale price.
  • Currency – the currency in which prices will be set. You can select any currency, since when comparing prices, they are all converted into one currency selected in the report.
  • Prices include VAT - a sign that VAT is included in the price.

Click the “OK” button to save and close the price type.

Important: Be sure to indicate the price type of the item, otherwise the program will not understand what price of our organization we plan to compare the competitor’s prices with.

Setting competitor prices in 1C

To set counterparty prices for goods, use the document “Setting prices for counterparty items”.

Menu: Documents – Pricing - Setting prices for counterparties' items

Let’s create a new document and fill in the “Competitor” counterparty:

After specifying the counterparty, you can fill in the types of prices to be set. To do this, click on the selection button in the “Price type” field, in the selection window that opens, set the flag for the wholesale price and click “OK”:

Example of a completed document:

Analysis of competitors' prices in 1C

To analyze competitors' prices, use the "Price Analysis" report.

Menu: Reports – Pricing – Price Analysis

In the report, it is better to select the type of prices that you want to analyze, otherwise the program will display all the information at once.

To set up selection, click on the “Settings” button, go to the “Selection” tab and select the price type – “Wholesale” (you can also use quick selections on the form):

On the report form, also set the currency in which you want to analyze prices.

Example of a generated report:

The report on the left displays all products for which wholesale prices have been set. Below are the prices of our company and the date of their installation (01/16/12).

After your own prices, the program one by one displays information about all established prices of competitors. The counterparty's price and its deviation from our price as a percentage are indicated. If the deviation is positive, then the competitor’s price is higher than the company’s price. Conversely, if the deviation percentage is negative, then the competitor’s price is lower than your price.

Thus, you can enter the prices of several of your competitors in the program. After this, you can conduct a price analysis and adjust your pricing policy if necessary.