Wishlist & Favorites - Price Drop Alerts Odoo

The Ecommerce Wishlist module adds comprehensive wishlist functionality to your Odoo e-commerce store. Customers can save their favorite products, view them later, and easily add them to cart when ready to purchase.

Built with modern web technologies, this module offers instant AJAX operations, beautiful responsive design, and enterprise-grade security. Works perfectly on desktop, tablet, and mobile devices.

Improves Customer Experience: Customers can save products while browsing, reducing cart abandonment and encouraging return visits. Perfect for stores with large product catalogs.

Secure & Private: Each customer has their own private wishlist stored securely in the database. Authentication required with full record-level security rules.

For Customers

• Heart Icon: On all product pages for easy access
• Instant Feedback: AJAX operations without page reload
• Dedicated Page: Beautiful wishlist view at /shop/wishlist
• Stock Status: See real-time product availability
• Smart Notifications: Integrated "Notify Me" button for out-of-stock items
• Shareable: Generate unique links to share your wishlist with friends
• Direct Add: Add wishlist items to cart with one click
• Bulk Actions: Add entire wishlist to cart in seconds
• Remove Anytime: Easy item removal with confirmation
• Counter Badge: Header shows wishlist item count
• Empty State: Beautiful message when wishlist is empty

For Store Owners

• Customer Insights: Track which products are most desired
• Advanced Analytics: Backend Pivot & Graph views for wishlist data
• Inventory Planning: See what customers want to buy
• Ecosystem Integration: Works seamlessly with Stock Notification module
• Recover Sales: Encourage return visits from wishlist users
• Engagement Tool: Improve customer retention
• Easy Configuration: Enable/disable via settings
• Data Management: Clear wishlist data when needed
• Security Built-in: User-specific access controls

Smart Variant Detection:

The wishlist intelligently captures specific product variants when customers add items. If a customer selects "Red T-Shirt - Size Large", that exact variant is saved - not just the generic product.

How It Works:

• Dynamic Detection: JavaScript automatically reads the selected variant from Odoo's configurator
• Real-time Updates: When users change color/size dropdowns, the wishlist captures their final choice
• Attribute Display: Wishlist shows full variant name: "T-Shirt (Red, Large)"
• Unique Constraint: Prevents duplicate product+variant combinations

What Gets Saved:

• Product Variant ID: The exact variant they selected
• All Attributes: Color, size, material, etc.
• Variant Price: Specific pricing for that configuration
• Variant Stock: Availability of their exact choice

Benefits:

• Better UX: Customers see exactly what they saved
• Accurate Notifications: Stock alerts for their specific variant
• Price Tracking: Monitor price changes for exact configurations
• No Confusion: Clear distinction between "Red S" and "Red XL"

Settings Screen - Main Features

Access all wishlist configuration options from Settings → Website. The module provides a beautifully organized settings interface with four main sections for complete control over your wishlist functionality.

Main Settings Panel: Enable/disable wishlist functionality, smart stock alerts, price drop alerts, and wishlist reminders - all with intuitive toggle switches. The clean interface makes configuration simple and straightforward.

Take full control over whether customers can add out-of-stock wishlist items to their cart. This powerful setting gives you the flexibility to match your business model - whether you allow backorders or prefer to prevent purchases of unavailable items.

Setting Disabled - Strict Stock Control

When Disabled:

• Stock Badge Shown: Out-of-stock items display "Agotado" (Out of Stock) badge
• No Cart Button: Add to Cart button is hidden for unavailable items
• Clear Communication: Customers immediately see product availability status
• Prevents Frustration: No false expectations about purchasing unavailable items
• Best For: Stores that don't allow backorders or pre-orders

Setting Enabled - Flexible Purchasing

When Enabled:

• Cart Button Always Shown: Add to Cart available regardless of stock status
• Flexible Ordering: Customers can purchase items even when out of stock
• Backorder Support: Perfect for stores that accept pre-orders or backorders
• No Lost Sales: Capture orders even when temporarily out of stock
• Best For: Drop-shipping, made-to-order, or pre-order business models

Guest User Protection:

When a guest user (not logged in) clicks the "Add to Wishlist" button, they see an elegant modal dialog prompting them to log in or create an account. This ensures all wishlist data is securely associated with authenticated user accounts, preventing data loss and improving customer tracking.

Automatic Login Redirect:

When a non-authenticated user clicks the heart icon button, they are seamlessly redirected to the /web/login endpoint. After successful login, users can return to the product and add it to their wishlist. This smooth authentication flow encourages account creation and improves conversion rates.

Thoughtful Design:

• Friendly Message: "Your wishlist is empty" with welcoming icon
• Clear Call-to-Action: "Start Shopping" button to drive engagement
• Modern Styling: Clean, attractive design that matches your store theme
• Helpful Context: Encourages users to browse products and save favorites

User Experience Benefits:

Instead of showing a blank or error page, the empty state provides a positive experience that guides users back to shopping. This reduces bounce rates and keeps customers engaged with your store, even when their wishlist is currently empty.

Three professionally designed email templates automatically notify customers about important wishlist events. All emails feature rich HTML layouts, real product images, brand identity, and smart call-to-action buttons that work perfectly across all email clients (Outlook, Gmail, Apple Mail, Yahoo, etc.).

Back in Stock

Sent automatically when out-of-stock wishlist items become available again. Features a vibrant purple gradient header and displays product images, current prices, and direct "Add to Cart" links.

Still Interested?

Gentle reminder emails sent after a configurable number of days (default: 7) to re-engage customers with items they've saved. Uses a soft pink-purple gradient to maintain a friendly, non-pushy tone.

Price Drop Alert

Alerts customers when wishlist item prices decrease. Shows both old and new prices with clear savings calculation. Features a fresh green gradient header to convey the excitement of a deal.

Price Change %

Percentage change from original to current price. Intelligently averaged (not summed) across multiple products for accurate trend analysis. Ideal for spotting significant discount patterns.

Customer Savings

Total monetary savings available to customers when prices drop below original wishlist price. Calculate aggregate customer benefit and use this data to create targeted "Deal Alert" campaigns.

Last Notified Price

Smart tracking field preventing notification spam. Records the price at which the last alert was sent to customers, ensuring they only receive new alerts when prices change significantly from the last notification.

Demand Tracking:

• Popularity Score: Count of unique users who wishlisted each product
• High Demand Filter: Products wishlisted by 5+ users
• Very Popular Filter: Products wishlisted by 10+ users
• Trend Analysis: Track demand over time with graph view

Use Cases:

• Identify trending products before they sell out
• Plan marketing campaigns around popular items
• Adjust pricing based on demand
• Prioritize product photography/descriptions for high-demand items
• Use popularity data for homepage promotions

Real-World Applications:

Graph View Capabilities:

• Visualize Trends: Bar charts, line graphs, and pie charts for wishlist data
• Time-based Analysis: Track how wishlist metrics change over days, weeks, or months
• Product Comparison: See which products have the highest demand or savings
• Export Data: Download graphs and share with your team

Pivot View Features:

• Multi-Dimensional Analysis: Cross-reference multiple data points simultaneously
• Dynamic Grouping: Group by product, user, date, stock status, and more
• Custom Aggregations: Sum, average, count - choose what matters to you
• Drill-Down: Expand/collapse data hierarchies for detailed investigation

Available Measures:

• Total Current Value - Overall wishlist value
• Total Savings Amount - Customer discount opportunities
• Average Price Change % - Price trend analysis
• Average Days in Wishlist - Engagement timing
• Total Popularity - Product demand count

Model: ecommerce_wishlist.wishlist

Complete wishlist storage with 11 fields:

• product_id: M2O to product.product (required, indexed)
• user_id: M2O to res.users (required, indexed)
• active: Boolean (default True)
• create_date: Datetime (indexed, read-only)
• price_unit: Float (computed, stored)
• product_name: Related field (stored)
• product_image: Related field
• product_description: Related field
• website_published: Related field
• qty_available: Related field

Constraints & Rules:

• Unique Constraint: One product per user (product_user_uniq)
• Cascade Delete: Auto-cleanup when product/user deleted
• Default Ordering: By create_date desc (newest first)

Security Rules:

• Public Users: Read-only (redirected to login)
• Portal Users: Full CRUD on own items
• Internal Users: Full CRUD on own items
• Sales Managers: Full CRUD on all items

Mobile Optimizations:

• Touch-Friendly: Large buttons and tap targets
• Responsive Grid: Cards stack on mobile
• Fast Loading: Optimized for mobile networks
• Swipe Support: Natural mobile gestures
• Orientation: Works in portrait and landscape
• 6 CSS Files: Specialized responsive styling

Responsive Features:

• Product cards adapt to screen size
• Wishlist button accessible on mobile product pages
• Add to cart works perfectly on touch devices
• Empty state displays beautifully on mobile
• Header counter visible on all screen sizes
• Settings screen mobile-friendly

Requirements:

• Odoo Version: 17.0+ (Community or Enterprise)
• Python: 3.8+
• PostgreSQL: 12+
• Browsers: Chrome, Firefox, Safari, Edge (latest versions)
• Mobile: iOS Safari, Chrome Mobile

Required Odoo Modules:

• base
• web
• website
• website_sale
• product
• sale

All standard Odoo modules - no external dependencies required!