AJSP Manager

The Challenge

Amar Jyothi Spare Parts is an automotive parts retail business in Napoklu, Karnataka. For about 15 years, the business tracked inventory on paper notebooks and kept supplier records in physical files. Purchases, payments, and sales were all managed manually — purchases recorded as they happened, but sales tallied only once at the end of each month. Every six months, the entire stock had to be counted by hand: writing down every item name, counting quantities, then calculating the total stock value.

The Approach

I built a full-stack PWA using Next.js and Supabase. The app tracks purchases, payments, and sales — purchases are entered as they happen, payments are recorded and marked when paid, and monthly summaries show total purchases, sales, and payments so the business knows exactly where it stands. For the bi-annual stock count, every item and its name is stored in the system. During a count, you enter only the quantity for each item, and the app calculates the total stock value automatically — eliminating the manual process of writing lists, counting, and calculating by hand. As a PWA, it is installable on mobile devices and accessible directly in the shop.

The Impact

The app is used daily by the family business and has fully replaced the 15-year paper-based workflow. The bi-annual stock count — previously a manual process of listing every item, counting quantities, and calculating values — is now a matter of entering quantities while the system handles the rest. Monthly purchase, sale, and payment tracking gives clear visibility into business performance that didn't exist before.

Tech Stack