Combine prices

Question

Python

I welcome everyone.

There is a task to combine the prices of different suppliers, but they are different in logic and structure. The format to convert is not a problem, but what to do with the structure and logic is not clear.

The first problem is how to define a category for products, all suppliers have different nesting and category names.
The second problem is how to understand that the product is one, if it is written differently for everyone.

Can you please tell me what you can read (see examples) about combining different structures (trees)?

Making your own handler for each supplier is, in principle, the way out, but I want something more universal.

Answer 1

When you make a universal one, you will understand what needs to be eventually customized for each supplier. The best way is to make a universal synchronizer", but set it up separately for each supplier. Otherwise, you will get a lot of problems. How to understand that the goods are the same - here you already need to look at what kind of goods and adjust the search for matches. Do not try to write an expert system - this is always worse than a highly specialized task Unless, of course, you are ready to pour it into a separate product to search for similar products. Most
likely you will have a maximum of 5 price lists. Not 100 after all? Therefore, I highly recommend that you use the way out of the situation that you want to bypass. Do not make a universal task there where you don't need it anymore.

Answer 2

In the late nineties, he launched an analogue of price ru in one of the banana republics. Now perhaps something else would come to mind, but then I did it like that. He began to develop his own database of goods with his own structure. I planted a person who at first manually drove everything into our database by comparing the item from our database with the item from the price list. Then we went further, made tables of synonyms. As a result, after several months of such work, somewhere 80-90 percent of the price lists were driven in and compared completely automatically, the remaining 10-20 percent, alas, also manually. Six years later, I solved a similar problem when writing billing for classic and IP telephony, but there was a link to codes, so everything was easier ...

Answer 3

I have been doing something similar for about a third of my working time for the last 5 years. About 30 different suppliers, the composition is changing and growing. Assortment - clothes, underwear, clothes.
At the beginning, I made an individual handler for each supplier, then I abandoned it. Even the big brands change the format regularly, from column layouts and product naming schemes to the details of the name of each particular rag. And it was very important for us that the same product always gets into our database in the same way. It turned out that I checked the correctness of the output longer and rewrote the algorithms for each change than I used them. As a result, for several stable suppliers there are personal loaders that parse the input file, and for most, only manually replenished database of the form “a long string in free form from the supplier’s invoice” -> a set of our internal fields. Bringing the file format to a suitable for such processing is also half-handed.
Some people can't even get into that shape.
However, if constant double lines are not terrible, then everything becomes much simpler.

Answer 4

hello, did you find any solution for merging prices? How can I contact you and resolve this issue?