Product Catalog Management System

Project Description

Inventory Importa is a web-based backend application built using Laravel to manage product data centrally and structurally. This system acts as the single source of truth for Importa's product catalog data, which is then synchronized to the main WordPress (WooCommerce) website.

Problems

• Scattered and unstructured catalog management across various channels.
• Manual catalog update process in WordPress is slow and error-prone, especially for products with many variants.
• No clear role-based access control (RBAC).
• Lack of traceability and audit trail for product data changes.
• No bulk operation mechanism for large-scale data entry or updates.
• Data synchronization to the main website is not integrated automatically.

Solutions Built

• CRUD Product module complete with Product Description, Product Data, Short Description, Image, Gallery, Categories, Tags, and Brands sections. Supports simple and variable product types with SKU variants.
• WordPress Sync system via Public API with per-SKU acknowledgement mechanism (is_synced, synced_at), plus cron job for scheduled synchronization.
• Group-Based Permission system with capability context and permission caching for performance.
• Audit Trail and Stock History tables recording every stock change including qty_before, qty_after, delta, actor_id, and created_at.
• Import & Export Product feature based on Excel/CSV template with validation preview, upsert support (insert/update), and taxonomy-based filtering.
• Public Sync API protected by API key and domain allowlist, plus per-SKU detail endpoint for WordPress website consumption.

Project Goals

• Build a single source of truth for product data before synchronization to publication channels.
• Improve catalog operational efficiency through bulk import/export.
• Implement governance and group-based access control.
• Provide full traceability over data changes.
• Support product scalability with variants and unique SKU per variant combination.

Tech Stack

Backend: Laravel, PHP 8.3, Livewire, Maatwebsite Excel, Intervention Image, GuzzleHTTP, Spatie Sluggable, Spatie Image Optimizer.
Frontend: Vue.js 3 (compat mode), Bootstrap 4.6, jQuery, Sass, Vite, GLightbox.
Database & DevOps: MariaDB, Redis, Docker, Nginx, PHP-FPM, Supervisor, Ubuntu 24.04.

Timeline

Period: March 2026 – May 2026 (~1.5 months)
Phase: Init & Documentation → Core Feature Development → Dockerization & CI/CD → Stabilization & Refinement.