close

Retail & E-commerce analytics

Retail / Automation

Automation of Analytical Reports for Retail. Turning the routine of consolidating chaotic Excel exports into an instant, error-free process.

99%
Time savings
2 sec
Processing speed
0.1%
Errors

Problem

Task

To turn the routine of consolidating chaotic Excel exports into an instant, error-free process. Previously, analysts spent up to 4-6 hours a week manually cleaning data, matching nomenclature, and finding errors in SKUs. Now it takes 3 seconds.

Problem (Before)

  • Manual VLOOKUP across thousands of rows.
  • Manual correction of "broken" names.
  • Manual consolidation of tables.

Solution

What does the app do?

Togas Analytics is a web application for automatic sales processing. It loads "raw" receipt logs (from sales accounting systems), parses them, enriches them with data from the master catalog, and builds interactive reports.

Main benefits (Business Value)

  • 99% Time Savings: Drag-and-drop files -> Ready report. The engine processes 10,000+ rows in less than 2 seconds directly in the browser.
  • Elimination of Human Error: Built-in "Strict Protection Rules" (Global Rules) automatically correct categorization. Example: If a manager accidentally named a "Kids Rug" simply "Rug", the system will still classify it into the "Kids" category using indirect signs (26 SKU parameters).
  • Intelligent Data Cleaning (Smart Parsing): The system recognizes 26 attribute columns, translates collections (RU -> EN), and normalizes colors and sizes. Identifies conflicts: "Sold as 'Pillow', but listed in the database as 'Pillowcase'".

Technical Stack (Under the Hood)

It's not just a "beautiful table," but a complex engineering solution focused on Performance and UX.

  • Frontend & Logic: React 19, TypeScript
  • Performance: Vite, Client-side processing (without sending data to the server — security!)
  • UI System: Tailwind CSS (Custom "Luxury" Design System), Lucide Icons
  • Data Engine: XLSX (streaming parse), Custom Fuzzy Matching Algorithms
  • AI Integration: Google Gemini (for generating sales summary and insights)

UX/UI Solutions

  • Luxury Aesthetics: Minimalist interface in "Togas" style (Gold/Monochrome).
  • Instant Feedback: Instant file validation upon upload.
  • Drill-Down Analytics: Ability to drill-down from General category -> Collection -> Specific SKU in one click.

Technologies

React 19 TypeScript Vite Tailwind CSS Lucide Icons XLSX Google Gemini