📜 ⬆️ ⬇️

How to and how not to automate trade

My heart bleeds when I read an article and even more so - comments to it. One mention of 1C environment moguls as a solution for automating the pharmacy network is worth something. Dear habratovarischi, 1C Trade Management In Principle is not suitable for trading in the pharmaceutical business! And noteworthy attempts of his beloved daughter 1C in the field of adaptation. Retails still do not completely solve the main problems of this system. And under this condition, this decision does not have the right to cost such money for which it is sold.
My opinion is just an opinion accumulated in the course of many years of work among pharmaceutical trading enterprises, both retail and wholesale. But since I mentioned that article, it will become clear to my acquaintance that it’s still a matter of the retail part.
So, I will try to explain why my heart is bleeding. In a sense, this post is conceived as a set of recommendations to the author of the article, until completely unjustified money is wasted.
Who cares - welcome under cat. I warn you: not a single picture and a lot of letters.

Equipment and other stuff

Immediately make a reservation: in no case shall I set a goal to correct already done or advise. To begin with at least the fact that in Moscow there have never been any problems with the choice of equipment for reasons of protection by some manufacturers of fiscal technology with local tax authorities. Therefore, at all pharmacies there is a rather standard set of equipment for small Moscow retailers:

Money counters, money checking equipment, air conditioners and heaters are, as you understand, outside the sphere of activity of a competently organized IT department, so it makes no sense to describe them.
It is necessary to have a bespereboynik on a server machine, database backups, protection against viruses on all computers ... Well, it’s not for me, dear habrayusers, to teach the simplest rules for safe sex safe operation of a geographically separate unit.

Data-flow and responsibility of units

In conditions when remote outlets become more than 3-5, control of pricing, procurement and many other operations already makes sense to centralize in the "office". In our case, the office itself does not trade, it is the center of responsibility for document flow, pricing, and distribution of goods. And this is justified, because the outlet must trade, “beat the proceeds”, and not issue documents. People who are at the checkout and earn real money should pay as little attention as possible to the back office, and as much as possible to the buyer. Remember this condition, it will still be mentioned.
In the meantime, it means that the above-mentioned load is transferred to the unit designed for this. The analysis of the residuals is transferred there (not yet in my cases, unfortunately) and, as a result, the centralized order, taking into account the season and market needs (masks and diffusers, we all remember?) invoices are still required to come with the goods to the point of sale, but we then forward them to the “office”).

So, the consignment note came to the office (delay for 1-2 days), pricing was carried out at purchase prices and legal requirements (1 more working day), data on retail prices are sent to a retail outlet (1-2 more days). Total offline version of the work we have a delay in sales for 3-5 days from the receipt of the goods.

And in our, really existing version of automation, we have a sales start about 1-2 hours after it arrived. And this is the industry standard for today. This is achieved as follows:
Most importantly: in the pharmaceutical business, no one has been working with paper documents for a long time. Every self-respecting supplier has channels for delivering information about the contents of documents to the buyer. Most often, this is an electronic ordering program, which includes the ability to deliver so-called Electronic Consignment Notes (EN). This is not an electronic document in my understanding: it is not protected from copying, is not encrypted, does not constitute a legally authentic document. This EN - information about the content of the paper document. But it is usually enough to conduct all non-paper data procedures: the assimilation of information into the accounting system, the processing of this data (read the pricing procedure and distribution by outlets).

Next on the data-flow - data transmission channels of the public network. We have data transmitted in unencrypted packets through a dedicated FTP server. No “internal network”, VPN or other perversions are needed. Who cares about encryption and security of packages - you can encrypt, our system, for example, allows you to add processing of sent and received file packages in any way you like.
Why not VPN? It makes no sense. You can encrypt data before transmission and after transmission to decrypt, and the stability of the VPN in our networks is a very big question. Specifically, I observe numerous problems in the field of data exchange between the office and retail outlets in one friendly pharmacy chain, because of the use of VPN.

By the way, such a nuance immediately follows from the described work scheme: for the sales rate characteristic of pharmacies, it is practically unacceptable to use trade by the barcode (HQ) of the manufacturer. Not only do some products, in principle, do not have them (when did you last see a Russian-made night pot with factory HQ? And a bottle or baby pacifier? And this is all the assortment of a standard pharmacy, and this is not all positions that do not have a factory HQ ). Not only that not for every HQ you can find a description of the goods in the Yuniskan database. Not only is this information not always reliable (and sour cream instead of panadol was obtained, and much more). Well, in the load: which barcode is considered a barcode of a product, if there are three of them on the package? And all in different formats. And also in the load: where (as in the situation with the classifier of goods) take the table of conformity headquarters-name. And from this name still get an indication of the commodity position in our nomenclature database.
In the days of wild youth, I spent 7 (SEVEN) days on the introduction of an automation system in a pharmacy by factory SKS instead of 1 day! In terms of the proceeds of the pharmacy, it was about 350 thousand. P. And nobody considered the payment for the work of employees, who were involved in the process by the entire available staff - about 8 people daily.
Then, the problem of the absence of bindings of factory SKs to commodity items worked (the radar does not contain all the information, and there is no parapharmacy in it, not to mention cosmetics). And then, with a delay, the problem of the absence of bindings of the nomenclature classifiers of suppliers to ours worked. This is when the flow of goods in the normal mode. For without existing bindings, the manager at the acceptance is forced to do them independently. And this procedure is not pleasant - to delve into the details of dosages, the amount in the package, manufacturers.

How is this solved?

Well, the factory SKS is solved very simply: due to the number of problems supplied by the factory SKS, they should not be used. At all. Use only their own "technical" CC. Virtually any modern commercial retail pharma system includes a label display subsystem with service HQs. Remember, we have a label printer at every outlet - that's what we need it for. At least 300 labels are printed per day, so one-off printing options are not suitable. Therefore, the minimum solution for small and medium business is used - BZB2. I will not argue that this is the optimal solution: it has both disadvantages and advantages. But in the caring hands of our operators on acceptance in pharmacies, these printers are not naughty and behave decently.
And once the problem of identification of goods on the parishes of current parishes is solved, the only thing left is the question of the initial implementation of the automation system (this is when you need to take a complete inventory of the goods and shade the entire current range of pharmacies, this is a separate story and a separate article) supplier in the office.
And here is the question of linking the supplier’s classifier to ours - this, as I already wrote, is the headache of any retail pharmacy automation system. There are several options:

Automation software

And now, when you, patient and persistent hacking readers, already have an idea about the basic specifics of farm trading, we can discuss the most interesting: software for trade automation.
Immediately mark my position: I like the system, which I will call only in a private setting, so as not to be accused of advertising. And which I now consider on the Russian market as optimal in terms of price and quality. Moreover, I consider it very inexpensive, provided that the functionality available for this money is very broad and meets all the needs of almost any network - from one to 20, 200 pharmacies. I see no fundamental problems with a large number of outlets, the system scales very well.

Historically, now this system is almost not used, and I have experience in using several others, and therefore I have the opportunity to assess the fundamental flaws that are practically in ANY of them.
So, based on everything that is written above, which is often lacking in current systems:

This is all to the fact that automating a trading network from several outlets is not worth it in a hurry and anyhow. Look at the prices, the terms of service. Do not get fooled by the name and beautiful interface - the cashier does not need beauty, but speed and convenience. Yes, even if it is textual (and there are such in the market), the main thing is that it should not fail. The cashier earns money, he does not have to rummage through the settings and fight the interface.

Source: https://habr.com/ru/post/101917/

All Articles