search

open-source-ideas / ideas

💡 Looking for inspiration for your next open source project? Or perhaps you've got a brilliant idea you can't wait to share with others? Open Source Ideas is a community built specifically for this! 👋
6.56k stars 221 forks source link

A geospatial database of goods and suppliers #287

Open KOLANICH opened 3 years ago

KOLANICH commented 3 years ago

Project description

Sometimes one needs to buy a good. And he wants an optimal good for himself. Under optimal I mean that goods have numeric quantities describing them, from these quantities one can create an expression, and he needs a good which has the optimal value of the expression.

There are also constraints, such as money and minimal quantities being shipped.

OK, let's assumme we have chosen the optimal good satisfying the constraints. But there is a chance that the supplier refuses to ship it. So we still need to contact multiple suppliers parallelily.

So we need the database and the software:

  1. crawling the Internet and extracting the needed data from web pages and normalizing it. The data is the properties of goods and the contacts of suppliers.

  2. Storing them into DB.

  3. returning a slice of the db with the needed data via API

  4. the easiest part - calculating user-provided expression against each (good, supplier) tuple and sorting them and generating wnd sending emails for each of them, asking for a quote.

Relevant Technology

Complexity and required time

Complexity

Required time (ETA)

Categories

HamedPourjafar64 commented 3 years ago

Hi, I was wondering what kind of goods are you considering here?

KOLANICH commented 3 years ago

Mostly not the ones that can be found in aggregators like market.yandex.ru. Aggregators have the goods explicitly registered there by companies and of certain categories, usually of mass consumption, such as phones, laptops, PC parts, clothing, food ...

If one needs something that is not for mass consumption, such as electronic components, chemicals, other industrial consumables, parts of industrial equipment, repairing and maintaince services, etc.., there will be problem. Often such companies are not registered in aggregators and their catalogue is on their website only (or maybe even a pdf file), and the logistic information is on a dedicated contact us page. All in own format. Sometimes even to get a quote I have to email them and wait several days for an answer

So, when I wanted to buy something, I have to google the goods, then visit the websites and manually fill in the table with info about goods and suppliers, then sort it according to some criteria (usually in a form of a python script), than choose the supplier.

Gasoid commented 2 years ago

there are a lot of companies for supplier and procurement management.