Good morning/day/evening. In a nutshell
Basically, a parser is needed to fill in missing data in products, this includes translation into 2 languages, description, characteristics, additional photos (if only 1 or if absent - this often happens), keywords (in two languages) and more, for example, "condition" - new, it should be added to all products as all products are new.
To ensure that products meet the quality requirements for filling in for the ROZETKA and prom.ua marketplaces (100% quality of product filling).
There will be 10 suppliers (providing files in different formats for export and completely different products) and the files will be in xml, xls, xlsx formats - it should be possible to upload these 2-3 files to the parser (it will analyze where there are missing characteristics, descriptions, translations in 2 languages or keywords). Example: 1) medical.clothing.xml - only need to add keywords. 2) Toys.xlsx - need to complete description, characteristics, keywords, and translation for 2 languages. 3) Electronics.xls has everything, but all in Ukrainian only - need to add Russian translation as well and in 50 products there are no photos at all.
Next, these files "medical clothing", "toys", "electronics.xls" need to be divided into marketplaces like: prom.ua/ROZETKA/epicenter/horoshop/allo (merchant center (Google Shopping) not sure if needed), as there are no more popular ones.
It would also be desirable for each file import to have a column "Product Code" where you can specify your prefix: "medical clothing" - I could add the prefix MED-, "toys" - BEL-, electronics.xls - TEX-, dishes.xlm - VALE-
as there will be 5-15 suppliers, so that I can immediately understand which supplier this order is for based on the prefix.
And yes, files will be updated frequently, meaning 100 products are no longer in stock and need to be deleted, and 100 products have been added - descriptions, characteristics, keywords, translation in 2 languages, etc., need to be added to them. Therefore, there needs to be a main database so that each time the products that have not changed - do not need to search the internet each time for their descriptions, characteristics, photos, keywords, etc.
ESSENCE: to parse all this missing data in products - from large marketplaces, to the same prom.ua and ROZETKA, where all these characteristics, descriptions, photos, and everything else are present and very well written.
IN FACT: a product is needed that will turn poorly filled files into a "confection".
also attached is a file from one of my suppliers, to see what to work with.
Need normal flows, quick notes for me.
Oh, you can also simply add "Discount" - 20%, but it should not be a real discount but a label, like the price is not 100 UAH, but the price is 100 UAH -20%, (old price 125 UAH) and so on with any %.
something like that.
by the way, I will attach the settings supported by prom.ua (there is a lot of unnecessary information).