Agrorutec · Inventory and Sales System

The Project

Agrorutec is a retail agricultural distributor specializing in technified irrigation solutions: pipes, accessories, valves, and fittings for agricultural irrigation systems. They needed to centralize their catalog — previously scattered across spreadsheets — and unify the commercial cycle: product registration, stock control, sales records, and catalog publication on their institutional website.

The development is carried out as a freelance full stack developer, in short iterations, deploying continuously to agro.januz.net.

Architecture

• TALL Stack (Tailwind, Alpine.js, Laravel, Livewire) as the foundation of the monolith, avoiding the overhead of an SPA when the client team does not need complex interactions in the panel.
• Administration Panel with Livewire + Tailwind: management of products, variants, stock, sales, and web content from a single interface, without page reloads and with reactive validation.
• Public Institutional Website maintained in jQuery + Bootstrap for compatibility with the client’s legacy integrations and to reuse components already approved by their marketing team.
• Flexible Variant Model: each product supports configurable technical attributes (diameter, nominal pressure, SDR, material) stored as a polymorphic relationship to add new attributes without migrations.
• MySQL as the main database engine, with queries optimized for the filterable catalog listings.

Featured Module: Products and Variants

The core of the system is the product catalog with technical variants. Each SKU is modeled from a parent product and a unique combination of attributes:

• Configurable technical attributes: diameter (mm), nominal pressure (PN), SDR, material, connection type.
• Stock by variant, not by product: the client can check the exact availability of, for example, PE 32mm PN10 SDR17 pipe without it being confused with that of 50mm PN16.
• Automatic Code Generation based on the combination of attributes.
• Cascading Filters in the admin panel to find variants by any combination of attributes.

Results

• Single Catalog for inventory, sales, and web: a single source of truth for 40+ products and their variants, eliminating inconsistencies between spreadsheets and the previous web.
• Stock Traceability by Technical Variant, avoiding selling references without actual stock.
• Active Development Project, with continuous deployments and direct feedback from the client to iterate on the sales and reporting module.