Combine prices

All welcome.

The challenge is to combine prices of different suppliers, but with different logic and structure. Format konvertnut not a problem, but what to do with the structure and logic is not clear.

The first problem is how to determine the category for items that have all different providers of nesting and the names of headings.
The second problem, how to understand that the product is single, if it is written all in different ways.

Please tell me that you can read(see examples) regarding the Association of different structures(trees)?

To do under each vendor your processor is, in principle, a way out, but I want something more versatile.
October 8th 19 at 01:18
4 answers
October 8th 19 at 01:20
When will universal realize that in the end you need to adjust to each vendor. The best method is to make a universal synchronizer", but at each vendor individually to configure. Otherwise You will get a lot of problems. How to understand that the product is the same — there is need to look for that and adjust the matching. Do not attempt to write an expert system is always worse than specialized tasks. Unless you are ready to pour in the separated product to find similar products.
Most likely You will have a maximum of 5 prices. Not 100 right? Therefore, I strongly recommend to use the solution which You want to bypass. Don't do task where You don't need.
If it were 5, it would be all the easier. And dozens of them.
And constantly new ones arrive.
And many do not even internal numbering, and a lot of the same names that the string does not look.
And there are those that each time the price is altered, then the fields will change, in the name of the product colour or material add etc. - maci85 commented on October 8th 19 at 01:23
October 8th 19 at 01:22
In the late nineties launched the analogue of the ru price in one of the banana republics. Now perhaps have thought of something else, but that's what we did. Began to develop its own product database with its structure. Put that initially hand-hammered all of our database making, matching item from our database with the item in the price list. Then he went on, did the table of synonyms. In the end, after several months of this work, somewhere between 80 and 90 percent of prices were driven and compared fully automatically, the remaining 10-20 percent of the alas as well in the manual. Six years later a similar problem was solved by writing the billing for the classic and IP telephony, but there was a reference to the codes, so everything was easier...
To make the base of the signs, and then Podlaska spread, in principle, exit.
But too resource-intensive looks.

Interestingly, price.ru and yandexmarket how to do? - maci85 commented on October 8th 19 at 01:25
In Yandex-market of via YML - maci85 commented on October 8th 19 at 01:28
no matter what format, I'm yml from any xml or csv will do

it is important how they handle this yml is used on the headings and to guess one card the prices of goods with different spelling to collect - Leila commented on October 8th 19 at 01:31
October 8th 19 at 01:24
Doing something similar for about a third of their working time the past 5 years. About 30 different vendors, the composition is changing and growing. Range of products — clothes, lingerie, CNI.
In the beginning was done on each vendor's individual handler and then left. Even the big brands regularly change the format of the — location of speakers, and the schema name of the product to the parts the names of each individual cloth. And it was very important that our database is one and the same product were always the same. It turned out that I longer checked the correctness of the output and rewrite algorithms for each modification were used on them. As a result, several stable suppliers is a personal loaders parsing the input file, and for most only handles reloadable base of the "long string in a free form from the vendor invoice" -> set our internal fields. The conversion of a file format to suitable for this treatment also olurotimi.
Some even in this form drive fails.
However, if you are not afraid of constant zadvoenie lines, it all becomes sharply simpler.
what you eventually decided to do with all my price lists? I have the same problem. can you charge this? because it will be possible to solve something - maci85 commented on October 8th 19 at 01:27
October 8th 19 at 01:26
hi, have you found a solution for merging lists? How to contact you and resolve this issue?

Find more questions by tags PythonE-commerce