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.
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.
Janice4 answered on 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...
carmela_Goodwin answered on 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.
Malinda_Bergstr answered on October 8th 19 at 01:26
hi, have you found a solution for merging lists? How to contact you and resolve this issue?