EfoZol

opma - Open Market - Making Retailer Prices Open

Open Grocery will make retailers produce prices accessible and available to the public. The project’s first goal is to create a tool that allows each user to compare the cost of their personal shopping bag with all big retailers, including the ability to filter based on geo-location. This way, we can all easily know where to do our shopping.

As a second goal, and after collecting the data over time, we wish to publish some analysis of the Israeli market. For instance, we believe we could supply information on topics such as increase or decrease in the price of produce for the manufacturer, identifying food cartels and price fixing, analyzing the food cost with accordance with living area, predicting price changes for certain holidays (Passover, Shavuot, Independence Day etc.) and agricultural events.

Web Server instalation

• Install PostgreSql
• Restore DB (found in backend/sql)
• Run

cd frontend 
bower install
cd backend`
npm install`
node index.js

The code is now running the server at http://localhost:5000 Frontend stuff is at ./frontend

Technology Stack

1. AngularJS (1.4)
2. NodeJS
3. ExpressJS
4. PostgreSql

Main API

1. Pull API
2. add store (auth)
3. add branch
4. add product
5. add price (product/branch/time)
6. Get API
7. get products (by name)
8. get branches (by location)
9. get prices (branches * products, ordered by price)

Teams(R&D)

1. Client
2. Web (Javascript, Angular) 1. Boaz 2. Nirit 3. Michael B
3. Android
4. Nitzan
5. iOS
6. Web Server
7. API (NodeJs) 1. Daniel C 2. Michael B 3. Nirit
8. db (PostgreSql) 1. Xenia
9. DevOps
10. Docker 2. Boaz
11. Cloud
12. Testing
13. Parsers
14. Big Data
15. UI/UX
16. Rotem A.
17. Documentation
18. Readme.MD 1. Elad K 2. Ronen R

Teams(Business)

1. PR
2. Law
3. Finance
4. Marketing

Knowledge base

• Knowledge base (0 - none, 1 - poor, 2 - medium, 3 - good)
• Want to know (a - nope, b - medium, c - excited)

Name	Github	JS	Python	R	SQL	NoSql	Angular	Node	Docker
Elad Katz	eladrk	3	a	b	3	3	3	3	2 c
Michael B	mberaz	3
Ronen Rothfarb	kanija	1 c	0	0	1 b	0	0 b	0 c	0 b
[your name]

Links

1. Trello
2. Efo-ZolHasadna Github page
3. Fields of knowlege and/or interest.
4. Documents
5. Teams
6. Presentation
7. 
8. Stackoverflow links

Architecture

1. Scraping Server

2. Scrapes the XMLs from all the different servers.

3. Nomalize data

4. Insert data to WebServer through API.

5. App Web Server

6. Exposes API to insert Raw Data. (in the future it will allow small retailers to insert their data as well)

7. Insert Data to the PostgreSql database

8. Expose normalized API to explore all data in the server (allowing others to plug into our system, and to continue our work)

9. Expose a subset of the full API to the web, Android and iOS clients.

                          /-- Data Magic (Machine Learning etc.)
                         /
   

XML > Parsers > RawData JSON -- /-- Web Client \ / -- Normalizers --> API --> WebServer --> API ------ iOS Client
-- Android Client

FAQ