WKS (meaning Wawelska Kooperatywa Spożywcza), is a non-profit organization that connects Krakow residents with local, organic farmers. Once a week, Kooperatywa participants create individual shopping lists (orders) consisting of various vegetables, fruits, herbs, preserves and more. Kooperatywa then collects these lists and collectively orders products from local food producers. Finally, every Wednesday and Thursday, each order is being completed and ready for a personal pick up from a location near Wawel Castle.

This project is a dedicated application for Krakow's Kooperatywa, but it can certainly be adapted by other similar initiatives. The project is in the final development phase, with planned deployment at the end of January 2024.

So far, Kooperatywa has operated on Google Sheets. The growing needs to manage orders, warehouse, deliveries, supplies, dozens of suppliers and over 1,000 products led to the creation of an extremely complex system. Sheets of 100 columns and 1000 rows with formulas referencing other equally complex sheets and files. This system fulfills its basic function, but unfortunately it is very error prone, requires a lot of time to prepare every week and it works very slowly - complex sheets take a long time to load.

The purpose of the application is to replace the old system built on spreadsheets while maintaining the existing functionalities and achieving those:

• improve the workflow of Kooperatywa coordinators
• significantly reduce the number of human errors
• significantly shorten the loading time of the product order form and other operational management modules

This is at least 5th attempt in the history of WKS to transfer operations from google sheets to a web application. Previous attempts failed because of various reasons:

• not enough funds for a dedicated web app
• problem to be solved being complicated in it's nature
• need for lots of functionalities/features
• not being able to adjust ready-to-use e-commerce solutions

Currently, the project has the following functionalities:

• form for placing and editing orders
• product search engine
• supply module
• reporting
• administration panel
• supports logged in users

Future features:

• order history
• supply history

My name is Artur Rączka and I am a Kooperatywa member myself. I was really tired and irritated using the old spreadsheet system so I decided to use my growing web dev skills and build a new, efficient system from scratch. This is my portfolio project I am working on after hours, while aiming to land a software developer job as soon as an opportunity will come.

I built this full-stack web app with Python using Django framework.