Business Tools

Built with Next.js 15 and React 19.

The Data Processing Lab serves as a centralized hub for business data processing workflows. The clean, modern interface presents three core tools designed to handle the most common spreadsheet processing challenges in e-commerce and inventory management.

The application provides professional-grade tools for barcode generation, price management, and order fulfillment. Each tool is designed to work independently while maintaining a consistent user experience across the platform.

The Barcode Replacer tool streamlines the process of transforming invoice data with article numbers into comprehensive barcode catalog entries. This eliminates the manual work of cross-referencing product codes with barcode databases.

Users simply upload their invoice Excel file containing article numbers, delivery information, and net amounts, along with a catalogue Excel file containing barcode mappings. The tool automatically processes both files and generates a complete dataset with proper barcode associations.

The Price Replacer tool automates the tedious process of updating packing list prices using current invoice data. This ensures pricing accuracy across all business documents and eliminates discrepancies between different data sources.

The tool supports multiple file uploads for both packing lists and invoices, automatically matching products by barcode and updating prices with the most current information from invoice data.

The Order Matcher provides sophisticated order fulfillment capabilities by matching products from packing lists with client orders using barcode validation. This streamlines the fulfillment process and reduces shipping errors.

The tool processes both packing list Excel files and client order files, automatically identifying matches and highlighting any unmatched products. This ensures complete order accuracy and helps identify potential inventory discrepancies before shipping.

Built with Next.js 15 and React 19.

The Email Extractor system begins with a secure GitHub authentication process, ensuring only authorized users can access the order management functionality. This authentication layer protects sensitive customer and order data.

The system integrates seamlessly with existing workflows, requiring users to authenticate before accessing any of the order processing tools.

The main Email Extractor interface provides a clean, intuitive file upload system for processing .eml email files. Users can select multiple email files simultaneously for batch processing.

The interface includes navigation to three core modules: Email Extractor for data processing, Orders Management for tracking fulfillment, and Shipping Labels for generating carrier-specific labels.

After processing email files, the system displays comprehensive extracted data with full editing capabilities. Each order shows complete customer information including order number, client details, phone, email, delivery carrier, and location.

The interface provides powerful batch operations with "Select All" functionality and options to export selected orders to Excel or save directly to the database. Individual orders can be edited inline with dedicated save and cancel controls.

Product details are displayed in a structured table format with individual copy and remove controls for each item, allowing precise inventory management and order corrections.

The Orders Management module provides a comprehensive overview of all processed orders with advanced filtering capabilities. Users can filter by carrier (All Carriers, SmartPosti, Omniva, DPD, SmartPosti Courier) and view orders by fulfillment status.

Each order displays key information including order number, client details, phone, email, location, and product count. The interface supports bulk operations with expandable product lists and individual order actions.

Orders can be marked as Fulfilled, Partially Fulfilled, or Deleted directly from this interface, with real-time status updates and Excel export functionality for downloading the current orders.

The Shipping Label Generator streamlines the shipping process by allowing users to input multiple order numbers (one per line or comma-separated) for batch label generation.

The system automatically categorizes orders by carrier (SmartPosti, Omniva, DPD, SmartPosti Courier) and displays a real-time summary showing how many orders were found for each shipping method.

The shipping interface provides detailed order breakdown by carrier with comprehensive validation. Supported carriers display customer information, delivery locations, and location codes with validation warnings for missing data.

DPD orders are processed separately for invoice generation only (as these are not mass-imported into DPD's system), while other carriers benefit from automated batch label processing. The system tracks selected orders and provides carrier-specific actions and fulfillment status updates.

Error handling includes location code validation with clear warnings when carrier location codes are missing, ensuring shipping accuracy and preventing delivery issues.

Built with Next.js 15 and React 19.

The Tracklist Formatter provides a clean, intuitive interface for processing music tracklists. Users simply enter a 13-digit barcode and select the disc number using the convenient increment/decrement controls.

The main textarea accepts raw tracklist data copied from various sources like music websites, CD databases, or promotional materials. The tool is designed to handle different input formats and automatically detect the structure of the tracklist data.

For more complex processing needs, users can access the Full Formatter directly from this page, which offers advanced batch processing capabilities and comprehensive editing controls for handling multi-disc releases and complex track data. More on Full Formatter in the "Advanced Features" section below.

Once the barcode and tracklist data are entered, users can see exactly what will be processed. The interface shows the raw input data with track numbers, titles, and any additional metadata like "Hörprobe Track" preview information.

The tool intelligently parses different tracklist formats using advanced regex pattern detection, whether they include numbered tracks, unnumbered lists, or mixed content with preview samples and promotional text.

After processing, the tool generates perfectly formatted output ready for Magento import. Each line contains the barcode, disc number, track number, and clean track title in the exact format required by the e-commerce platform.

The formatted results eliminate manual formatting work and ensure consistency across all product entries. Users can easily copy the formatted data with a single click, dramatically reducing the time needed to update product catalogs.

The tool handles edge cases like duplicate track titles, special characters, and varying input formats, ensuring reliable output regardless of the source material quality.

The Full Formatter offers advanced batch processing capabilities with comprehensive controls. Users can choose between automatic multi-disc processing or manual single-disc mode, with real-time tracking of the current disc being processed.

Additional features include a "Start New Batch" option for clearing all data and beginning fresh projects, plus automatic and manual processing modes to handle different workflow requirements.

The Full Formatter handles complex tracklist data with mixed formats, including numbered tracks, preview samples, and promotional content. The interface maintains the barcode and disc settings while processing multiple track entries.

The tool automatically detects track sequences using regex pattern matching and handles various input patterns, from simple numbered lists to complex formats with artist information and preview track annotations.

The preview section displays formatted tracks in a clean, structured layout before final processing. Each track is properly formatted with the correct barcode, disc number, track number, and title.

Users can review the parsed results and make adjustments if needed before confirming the batch. The preview ensures accuracy and allows for quality control before final output generation.

The Full Formatter includes comprehensive editing capabilities, allowing users to modify individual track entries after processing. Each track can be edited inline with dedicated save and cancel controls.

This feature is essential for handling edge cases or making corrections to automatically parsed content, providing full control over the final output quality.

The final output provides multiple export options including Excel and TXT formats (saved in UTF-8), making it easy to integrate with different systems and workflows. The formatted data maintains perfect consistency across all entries.

Download options ensure compatibility with various e-commerce platforms and inventory management systems, while preserving the precise formatting required for automated imports.