Smoking Cat

To eliminate data discrepancies and manual work by creating an intelligent synchronization system between Odoo and Shopify—ensuring accurate stock, pricing, and product status across platforms, even at scale.

E-commerce brands face major hurdles when their ERP and storefront systems aren’t aligned:

• Inconsistent Stock Visibility Odoo’s default fields, like qty_available, often misrepresent actual sellable inventory on Shopify.
• Variant-Level Mismatches Unpublished or masked product variants frequently cause items to appear incorrectly on the storefront or go missing altogether.
• Disjointed Communication Limited integration logic, inconsistent API behaviors, and lack of webhook triggers meant frequent sync delays and listing errors.
• Heavy Manual Workloads Teams had to step in repeatedly to correct product data, restock items, or manually reconcile pricing.

Smoking Cat was engineered as a custom app to streamline, synchronize, and stabilize inventory and product data between Odoo and Shopify:

• Custom Field Mapping for Precision Sync

  We restructured the sync logic to use free_to_use_quantity instead of qty_available, offering a more accurate reflection of in-stock, customer-ready items. This shift alone drastically reduced false availability or oversell issues.

• Dynamic Variant Filtering & Masking Logic
  The app actively detects variant publication status and uses intelligent masking rules to hide invalid, deprecated, or unpublished variants from the Shopify frontend—maintaining a clean and accurate storefront.

• Real-Time Inventory & Price Matching

  Smoking Cat continuously monitors Odoo for pricing and stock changes, syncing updates to Shopify without delays. Merchants no longer worry about outdated prices or missing variants mid-sale.

• Enhanced API Collaboration with Odoo
  We worked closely with the Odoo integration team to troubleshoot and resolve schema mismatches. This paved the way for long-term stability, clarified field behaviors, and opened up possibilities for webhook-based event triggers to replace polling methods.

• Foundation for Future Automation
  Beyond inventory and price sync, the architecture was designed to scale. Smoking Cat is future-ready for additional modules like order synchronization, fulfillment workflows, and customer-specific pricing structures.

• 99%+ Sync Accuracy Achieved
  Post-implementation, stock and price discrepancies across platforms were nearly eliminated, leading to smoother operations and better customer experiences.

• Massive Reduction in Manual Intervention
  Where previously product teams had to constantly correct issues, most sync tasks now run automatically—saving hours of labor each week.

• Stable & Scalable Infrastructure
  With clear data flows and consistent API behavior, the app supports a growing catalog and lays the groundwork for automation across order and fulfillment channels.

• Improved Cross-Platform Trust
  With Shopify and Odoo data now in sync, businesses gain full confidence that what’s listed online reflects what’s actually available—minimizing oversells and backorders.

• Technical Transparency & Collaboration
  Better understanding between development teams improved field mapping consistency and API efficiency, reducing sync failures and unnecessary calls.

Smoking Cat is more than a connector—it’s a smart engine designed to simplify, stabilize, and scale e-commerce data between ERP and storefront platforms. With precision mapping, intelligent sync rules, and a strong foundation for automation, it delivers the operational clarity merchants need to grow confidently in a multichannel world.