From Excel spreadsheets to an online store with real-time stock on Odoo

El Poder del Vapor managed its catalog, price lists, and stock in separate Excel spreadsheets, which meant heavy manual effort and a recurring risk of inconsistencies in prices, stock, and product references. Working this way made it hard to open an online channel, because there was no single source of truth for products and inventory.

The store saw a clear opportunity: consolidate all its information on one platform, gain real-time stock control, and launch an online store that would extend its reach beyond the physical point of sale. The challenge was to make the transition without interrupting daily operations, building on the team's know-how and keeping the personal touch the store is known for.

The project was organized into several coordinated workstreams on Odoo:

• Online store on Odoo with integrated eCommerce: a responsive website and online store were designed and configured to match El Poder del Vapor's brand and deliver a simple, secure shopping experience. The eCommerce was connected directly to the product and inventory database so that the prices, descriptions, and stock shown on the site are always current.
• Data migration from Excel to Odoo: the import from the existing spreadsheets was prepared, consolidating products, variants, categories, and price lists in a single database. The process made it possible to remove duplicates, standardize names and structures, and establish a robust data model for managing the catalog going forward.
• Real-time warehouse and inventory management: Odoo's Inventory module was activated to record stock levels, movements, and adjustments, along with minimum-stock alerts. The store gained traceability of inbound and outbound stock, reduced stockouts, and improved purchase planning.
• Promotions, discounts, and pricing rules: pricing rules, coupons, and time-limited campaigns were configured, allowing El Poder del Vapor to launch promotions quickly, measure their impact, and adjust its commercial policy without editing spreadsheets by hand.
• Integrated sales operations: payment gateways and shipping methods were integrated, and confirmations, emails, and customer notifications were automated. The order–payment–shipping flow is now tracked inside Odoo, which makes follow-up and after-sales service easier.
• Team training and support: staff were trained in the day-to-day use of the catalog, orders, logistics, and promotions, to secure adoption of the tool and reduce reliance on Excel.

Certain technical details have been adapted or omitted to comply with NDAs and information security policies.

• Centralized control of the catalog and inventory in a single database, free of the duplicates and errors that came with managing them in Excel.
• A new online channel, with a clear, measurable shopping experience connected to real stock, extending reach beyond the physical store.
• Commercial agility: the ability to launch promotions, adjust prices, and manage discounts from Odoo in a matter of minutes, with no files to rework.
• Operational efficiency: an estimated 20–30% reduction in the time spent on manual catalog updates and stock control, plus better traceability of orders and stock.
• Support for growth: an integrated system that lets the business scale order volume and expand the catalog while keeping control and service quality, both in the physical store and online.

With this project, El Poder del Vapor has moved from fragmented, spreadsheet-based management to a solid platform on Odoo that underpins its commercial and operational development in the medium and long term.