Difficult task for data composition

Data Parsing, Databases & SQL — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original Good morning, there is a rather not trivial and difficult task, the essence of it lies to the fact that the existing products on the site should be assigned to EAN Now more detailed At the entrance there is 1 .22,000 goods that we sparked from the hotline, broke into our format and put on our website The 2ndEach product has a brand and name, but since the hotline was stored, sometimes there is a lot of waste in the name(a product of some particular store, or the manufacturer's code, personally I haven't found the pattern) 3 .Acquired access to the barcodes base to which I connect by ARI https://www.barcodelookup.com/api-documentation and by different parameters I can search for the same I need EAN Problems 1 .ARI barcodes are far from perfect, and if you give it a waste name - it gives it the waste accordingly. Also, it sometimes differently seeks the same name, and sometimes the shorter it is the better it seeks, the example below: The Question: Enter the brand: Asus Enter the model: TUF-RTX4070-O12G-GAMING Answer to: Product Name: ASUS TUF GAMING NVIDIAR GEFORCE V2 Videocard TUF-RTX3060-O12G-V2-GAMING Brand: ASUS Category of: The Manufacturer: Barcode: 195553310222 Barcode: UPC-A 195553310222, EAN-13 0195553310222 MPN: 90YV0GC0-M0NA00 Here's the same query without "GAMING" at the end Enter the brand: Asus Enter the model: TUF-RTX4070-O12G The Perfect Answer Product Name: ASUS TUF Gaming TUF-RTX4070-O12G-GAMING NVIDIA GeForce RTX 4070 12 GB GDDR6X Brand: Asus Category: Electronics > Electronics Accessories > Computer Components > I/O Cards & Adapters > Video Cards & Adapters Manufacturers: Asus Barcode: 4711387128176 Barcode: EAN-13 4711387128176 MPN: 90YV0IZ0-M0NA00 That is, the main problem is the formation of a pattern, by which you can ask for all names to then transmit them by ARI and get the desired result. Considering that access itself is quite not cheap, and a decade of times to go away is not an option. Another problem: checking the results, how to do so that it is clear what the result is needed?especially when it is at the scale of 22 thousand goods, and especially when we plan these 22 thousand to expand to 50 thousand. The output options I see: 1 .As I wrote above, one of the options to create some pattern, it should be developed by brands, by categories, by brands and categories, and I’m not at all in that direction. The 2ndEach of my goods has a dedicated link to the hotline, maybe from there you will be able to extract something, or some additional parameter still there to find which will be the nearest to form a request. 3 .Also my goods are on the E-Catalogue, and on the E-Catalogue on the part of the goods even are prescribed EAN and MPN(because on the MPN it is easy to find EAN), but there are a few problems, I didn't find in the feed and somewhere else attach specifically my goods to the E-CATalogue(parsits I don't know) and 4.Per your genetic option. So here is the question, who knows and likes to swim with data, parsite, almost everything you need to know Python (but maybe not binding) and has the desire to spend a couple of nights, ready to thank you well Well, at the end of the worst option I just write a console and hire people who will be stupid manually searching for these EAN by different forming requests, but I don’t have so much time unfortunately, and I believe that somewhat automating it will come out(as not somewhat and without EAN and MPN hotline and E-Catalog is wise to acquire from buying different stores all in one card of goods) I will be grateful for the backlink and I will be happy to get to know who can solve this task because this is just the first step towards a lot of tasks that will need to be carried out.

Proposals 8

Yaroslav Smirnov

3 1

Projects 3
Rating -
Rating 294

Budget: 5000 UAH Deadline: 3 days

Great experience in parsing (Selenium, BS4, API)

Great experience in Python. Django, Flask and FastAPI

Work with any databases (mySQL, PostgreSQL, Oracle, MongoDB) and file types.

Clean code according to all PEP8 instructions.

The project was very interested in 100% compliance with my stick - I love copying in the data, cleaning them and working with them.

The term - the previous, you need to look at your DB

If you are interested, write!

Sergey Shostka

48 1

Projects 44
Rating -
Rating 1 102

Budget: 5000 UAH Deadline: 10 days

Good day .
To implement your project, you need:
Access to FTP
URL of the database
- Access to the hosting administrator to set up CRON
- paid PROXY - somewhere $30 I'll indicate what to order
- EAN will be selected from the Google search for the name or item of the goods (it may be better to pass 2 and by the name and by the item), if EAN coincide means that and is your EAN.

Denis S.

11 0

Budget: 6000 UAH Deadline: 5 days

Good day .
I have experience analyzing such a big data and is sufficient to find a solution to any problem. Here we divide the task from simple cases to more complex, gradually reducing the volume of bad data.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Ihor Iliuk
Kyiv, Ukraine
BSFB

Projects 35
Rating 5.0
Rating 1 762

Difficult task for data composition

Yaroslav Smirnov

Sergey Shostka

Denis S.

Proposals are currently absent

Current freelance projects in the category Data Parsing

Online toy store on WordPress

Database parsing

It is necessary to parse a database of masters for keratin hair straightening, with phone numbers.

Integration of Solomono + SalesDrive: transferring UTM to orders

1C programmer