The Problem

Venta de Colchones, a leading mattress retailer, faced operational challenges that required a robust ERP implementation to streamline their accounting, procurement, inventory, and eCommerce operations. Their multi-company structure presented specific complexities, such as managing financial consolidation, migrating critical data, and ensuring compliance with local regulations. Additionally, they needed to integrate their online PrestaShop platform with Odoo ERP to provide seamless synchronization between eCommerce and backend operations.

The solution aimed to:

  • Ensure that all transactions from the eCommerce platform accurately impacted accounting and inventory in real-time.
  • Enable precise stock management across multiple locations to improve fulfillment speed and inventory accuracy.
  • Optimize the eCommerce connector to handle high order volumes without delays or errors.

Key challenges included:

  • Setting up a compliant accounting system across three companies.
  • Migrating legacy data, including customer and vendor invoices, fixed assets, and opening balances.
  • Centralizing and automating procurement processes to ensure efficient restocking.
  • Organizing product categories for better inventory management and sales reporting.
  • Training staff to operate the new system effectively.
  • Integrate their online PrestaShop platform with Odoo ERP to provide seamless synchronization between eCommerce and backend operations.

Phase 1: Completed Implementation

In the first phase, Venta de Colchones partnered with Odoo Concept to implement Odoo ERP and address their immediate operational needs. Key accomplishments in Phase 1 included:

Accounting Setup

  • Configured a comprehensive accounting module tailored to a multi-company setup.
  • Designed and migrated the chart of accounts for three companies.
  • Registered initial account balances and configured deferred revenues and fixed assets.

Data Migration

  • Migrated open customer invoices, vendor bills, payment terms, and installment plans.
  • Imported fixed assets, bank data, and reconciliation models for streamlined financial operations.

PrestaShop Integration

  • Installed and configured the PrestaShop connector for real-time synchronization of sales, inventory, and customer data between their online store and Odoo.

HR and Employee Management

  • Imported employee data and configured absence types to align with HR policies.

Training and Support

  • Delivered comprehensive training on accounting workflows, procurement processes, and multi-company management, ensuring the team was fully equipped to use the system.


Outcome of Phase 1: Venta de Colchones gained a robust ERP foundation that streamlined their accounting and operational workflows, enhanced financial accuracy, and integrated their online sales with backend operations.  


Phase 2: Ongoing Enhancements

 Building on the success of Phase 1, Phase 2 focuses on further enhancing their operational capabilities. Key tasks currently in progress include:

Product Categorization

  •  Structuring a comprehensive hierarchy of product categories to enhance inventory management and improve reporting for sales performance.

Historical Data Migration

  • Transferring archived invoices and payments to ensure a complete financial record, providing a seamless transition from legacy systems.
  • Setting up tools for visualizing initial balances, giving the accounting team real-time insights into their financial starting points.

Expanded Accounting Features

  • Implementing advanced workflows for Accounts Receivable (AR) and Accounts Payable (AP) to streamline customer invoicing, vendor payments, and financial reporting.

Vendor Catalog Migration

  • Migrating and refining the vendor catalog to improve procurement processes and ensure accurate supplier information.

Replenishment Strategy

  • Designing and implementing a replenishment strategy to automate stock levels and trigger purchase orders based on minimum stock thresholds, ensuring consistent inventory availability.

Procurement Training

  • Conducting training sessions for the procurement team, focusing on Odoo’s purchase flow, vendor management, and replenishment processes.

Expected Results from Phase 2

 Once Phase 2 is complete, Venta de Colchones will benefit from:

1. Improved Inventory Management

  •  Clear product categorization and automated replenishment will enhance stock visibility and reduce stockouts.

2. Comprehensive Financial Data

  • Migrated historical data and enhanced AR and AP workflows will provide a complete and accurate financial picture.

3. Streamlined Procurement

  • Automated stock replenishment and efficient vendor management will save time and reduce manual effort.

4. Enhanced User Capability

  • Procurement training will ensure the team is confident and efficient in managing purchases and inventory.

5. Scalability for Growth

  • The new tools and processes will support future expansion and operational complexities.

Key Takeaways

  • Phased Implementation Ensures Success: Breaking the project into phases allowed Venta de Colchones to address immediate needs first while building toward long-term improvements.
  • Comprehensive Data Management: Migrating both current and archived data ensures operational continuity and financial accuracy.
  • Automation Enhances Efficiency: Automating replenishment and procurement processes reduces errors and improves productivity.
  • Training Drives Adoption: Hands-on training empowers the team to use Odoo effectively and adapt to new workflows.

With the foundation established in Phase 1 and ongoing improvements in Phase 2, Venta de Colchones is on track to achieve a fully integrated, scalable, and efficient operational system tailored to their business needs. 🚀 🛏️