ERP Migration and Marketplace Integrations for a Global Water Filter Supplier

Customer profile
DiscountFilterStore.com is a US-based global online retailer of water filtration and related home and commercial products. The company sells through its own online store and major marketplaces, including Amazon, eBay, and Walmart. With a high volume of orders, the business relies on a stable ERP to ensure fast, accurate fulfillment.

Challenge
To reduce ERP costs and gain flexibility, the client decided to migrate core business processes from Oracle’s NetSuite to Odoo while keeping all channels fully operational.
Key challenges included:
- Extracting and transferring all product, customer, and historical order data
- Maintaining data consistency between both ERPs during the transition period
- Preserving complex marketplace integrations (Amazon, Walmart, eBay, and others)
- Retaining compatibility with the current warehouse management system (WMS)
- Ensuring system stability and performance under high order volume
- Executing the migration around a strict cut-off date, with minimal risk and no interruption to ongoing operations
The client’s objective was to reduce ERP and infrastructure costs while maintaining all critical business processes.
Solution
SaM Solutions designed a controlled ERP migration that combined a custom data sync utility, optimized integrations, workflow adaptation, and cloud deployment.
Key implementations
- Custom NetSuite → Odoo sync utility
Built a dedicated migration tool to sequentially import products, customers, orders, invoices, deliveries, receipts, and historical records, ensuring data integrity, continuity, and full traceability. - Marketplace integration optimization
Adapted existing integrations for Amazon, eBay, Walmart, and other platforms to use Odoo as the system of record, improving stability, error handling, and monitoring. - Client workflow alignment
Configured and extended Odoo to mirror familiar ERP workflows and preserved integration with the existing WMS so that internal teams could continue working with minimal process changes. - Deployment on Odoo.sh
Implemented separate environments on Odoo’s cloud platform Odoo.sh with more predictable deployment cycles and better visibility into resource usage and performance, resulting in reduced infrastructure management overhead.
This combination of controlled data migration, a robust integration layer, and managed hosting allowed the client to switch from NetSuite to Odoo without downtime or data loss.

Services
Technologies
Odoo, NetSuite
Python, Odoo framework, XML, APIs
PostgreSQL, Redis
HTML5, CSS3, JavaScript
Odoo.sh, AWS
Success
After the migration, the client now runs core ERP processes on a more flexible and cost-effective platform, ensuring alignment between all marketplace channels and warehouse operations.
Key results:
- Up to 10× reduction in costs after moving from NetSuite to Odoo
- Improved stability and performance across all marketplace integrations
- Higher transparency in order processing and data flows between channels, ERP, and WMS
- Zero data loss, ensured by the sequential sync utility
- A more scalable and controllable ERP environment, with significantly lower resource usage
The roadmap includes upgrading from Odoo version 16 to 18 and gradually migrating warehouse management into Odoo to create a single, centralized system.
SaM Solutions continues to support the client as a long-term technology partner, ensuring the ERP landscape remains aligned with the company’s growth strategy.
Need to tackle a similar challenge?
Let’s talk about how we can support your next project