How to automate the collection of prices from suppliers?

Question

MySQL

Good day to all.
There is a need to automate the process of downloading price lists from suppliers. Now the situation is as follows:
- suppliers send price lists by e-mail in excel format
- data is added to 1C
- 1C uploads updated data to the site database
I want to automate this whole thing.
As I see the solution:
- there is a software / script that can collect prices from the mail
- upload the received price list to the server / save it on the local disk of a computer with 1C
Some kind of ready-made solution Google gave me. Maybe you can tell?

Answer 1

1. Collecting letters from the server is a very trivial task in almost any programming language. Plus, here is the extraction of the attachment from the letter. If I did, I would implement a simple POP3 collector - simple, reliable.
2. Parser excel - I don't know what you have there, but if without formulas and scripts, then again - there are implementations for any language. The main thing is a single output format, clearly marked.
3. Import to 1C - I can’t advise anything here, but if you have already done it manually, then, in theory, half the work in paragraph 2 will be done, all that remains is to complete the auto-import.
If you take the last point upon yourself (but I can try to look for something and help), then I can implement the first two points for you. For me, it will be easiest and most convenient to write in C #, Framework from 3.0 (again, for speed), respectively, Windows.

Answer 2

I wrote a PHP solution for the same problem. Everything is quite simple. Connect via IMAP/POP3, look for letters. Then you pull out the attachment, unpack it, then parse it using PHPExcel. Cheap and cheerful. Works with a bang. Synchronization with 1C through XML exchange.

Answer 3

XML price from the supplier directly on the site. been working like this all my life

Answer 4

About the first questions and so clear.
It is necessary to process prices either by yourself or by a ready-made solution. I recommend "megaprice" from this resource infostart.ru

Answer 5

I liked autoprice24.com solutions for auto products . I am looking for something similar applicable to the stationery trade

Answer 6

Have you tested the online price processing service https://price-matrix.ru ?
It seems like it should be perfect for your task.
But each task has its own nuances, so it's better to talk to the developers and describe your task in full.
There are such price lists that they cannot be processed ... for example, PDF or Word price lists.
I am surprised that in 2020 there are still such suppliers who upload price lists in PDF or Word.
Here you still need to understand whether you are going to have everything set up for you on a turnkey basis or so that you yourself can set up new price lists.

Answer 7

Well, actually, there is such a program and it is called Megaprice PRO https://subsystems.ru/megaprice/
A comprehensive solution from downloading to purchasing in 1C.
The main advantage is that this is not just a primitive - downloaded and compared, but a comprehensive analysis and work with data in 1C. After all, you have your balances in it, sales, orders - all commodity accounting.
That's just Megaprice serves to receive dozens of different reports, and all this in a very convenient form of management and spreads.