Gerardo Wibmer

Weekly Orders Automation for Ancap

A Django web app built for a gas station chain in Uruguay to automate their weekly purchase order workflow — replacing a manual process of matching products to suppliers and drafting orders one by one.

What it does

Staff upload their weekly sales Excel file through the app. The system parses the data, cross-references every product code against a supplier database, and automatically groups products into per-supplier orders. Conflicts — products that can come from multiple suppliers — are flagged and resolved interactively by the user. Once finalized, orders can be downloaded as formatted PDFs or sent directly to suppliers via WhatsApp. Every order is saved and searchable in a history log.

Features

• Excel file upload with automatic period extraction and product code parsing
• Auto-assigns products to suppliers based on existing database relationships
• Flags and resolves multi-supplier conflicts via an interactive modal
• Inline quantity editing and product removal before finalizing
• Export per-supplier orders as PDF (one page per supplier, styled with company branding)
• Send orders directly to suppliers via WhatsApp integration
• Full order history with search by period, supplier, or product
• Django admin interface for managing suppliers, products, and order records