Gift & Packaging E-Commerce + ERP Integration
2024
PFL is a Taiwanese gift and packaging supplier, offering sealing bags, gift boxes, packaging materials, decorations, holiday supplies, combo sets, and more, with nearly two thousand product listings.
The client's existing ERP system managed all product and customer data. They wanted to build an e-commerce platform that supports both B2B (distributors) and B2C (consumers), with bi-directional ERP synchronization to eliminate redundant manual data entry.
The entire system is built on Laravel + Filament, integrating ERP modules for products, inventory, customers, and orders, paired with ECPay payment services for online transactions, achieving a fully automated workflow from order placement to ERP accounting.
Bi-directional sync with KTNET TMS ERP system, covering product data (pricing, inventory, descriptions), customer data (B2B/B2C), and orders (creation + status write-back), using HMAC-SHA512 signature authentication
A full-featured e-commerce admin panel built with Filament, managing products, orders, customers, sales reps, and more, with manual ERP sync interface and flowchart visualization
Integrated with ECPay payment services, supporting credit card, ATM transfer, convenience store payment, and more. B2B orders are pushed directly to ERP, while B2C orders sync automatically after payment
Five-tier pricing synced from ERP, automatically matching prices based on customer level. Inventory quantities are updated in real-time from ERP to ensure frontend display matches actual stock
Syncs product names, multi-tier pricing (five tiers), EAN barcodes, inventory quantities, listing status, and more via the ERP vendor API's /product/QueryList and /Stock/QueryList endpoints. Supports manual sync by specifying product codes, or one-click sync for all products marked as syncable.
Customer data supports bi-directional sync: pulling customer lists from ERP (automatically distinguishing B2B Client / B2C Customer by code prefix), and pushing locally created customers back to ERP. Synced data covers basic info, company details, invoice settings, shipping thresholds, bonus points, and more.
Orders use an event-driven architecture: B2B orders are pushed to ERP immediately upon creation, while B2C orders are automatically triggered after ECPay payment completion. Order pushes include master data (customer, address, invoice), line items (product SKU, quantity, unit price), and bonus point deductions. The order number and status returned by ERP are written back in real-time.
Bulk sync operations run in the background via Laravel Queue to prevent blocking frontend operations. The Filament admin panel provides real-time progress tracking, and CLI commands support scheduled automation and manual triggers.
CONTACT US
Whether it's an e-commerce platform, ERP integration, or payment processing, we can build a tailored solution for you.
Contact Us
