Client Background
Dr. Natural USA, a health and wellness brand, needed a tailored ERP solution that could streamline its buying, selling, and forecasting operations. Their existing systems lacked the flexibility to manage supplier lead times, container tracking, and sales forecasting while ensuring smooth integration with NetSuite and SPS Commerce.
Business Challenges
- Manual processes and fragmented data across QuickBooks, NetSuite, and third-party systems.
- Limited visibility into container statuses, supplier lead times, and order tracking.
- Lack of real-time dashboards for decision-making.
- Inability to generate accurate sales forecasts based on historical trends.
Our Solution:
We designed and implemented a custom web-based ERP software that seamlessly integrates with NetSuite and SPS Commerce. The solution provided Dr. Natural with a single source of truth for their operations, from procurement and container tracking to sales forecasting and reporting.
Key Features Delivered
- Administration & Security: Role-based authentication and user management.
- Comprehensive Dashboard: Combined view of purchases, sales, container statuses, and PO tracking in a calendar format (daily/weekly/monthly).
- NetSuite Data Sync: Customers, inventory items, stock, suppliers, POs, sales orders, and invoices synced automatically.
- Container Management: Document tagging (e.g., Proforma Invoice, ISF, BOL, Packing Slip), real-time status updates, ETA tracking, and audit trail
- Product & Supplier Management: Lead time/ship time comparison, multi-supplier tagging per product, and historical attribute tracking.
- Purchase & Sales Orders: Ability to update statuses, maintain audit trails, and log call notes.
- Advanced Reporting:
- Sales forecasts based on historical data and customer-specific trends.
- Inventory recommendations (“what to order and when”).
- Pre-purchase planning based on supplier ETA and lead times.
Technology Stack
- Backend: Microsoft ASP.NET Core, Entity Framework
- Database: SQL Server
- Frontend: HTML5, CSS3, Bootstrap4, JavaScript, jQuery
