Amazon Catalog Items Dashboard
Overview
The Amazon Catalog Items dashboard provides a comprehensive view of all Amazon Seller Central catalog items with filtering, sorting, and status indicators similar to the Amalytix product dashboard.
Accessing the Dashboard
Menu Path: Catalogs → Amazon → Amazon Catalog Items
Direct URL: https://crm.warmlyyours.me:3000/en-US/amazon_catalog_items
Features
Stats Cards
At the top of the dashboard, six stat cards provide a quick overview:
| Card | Description |
|---|---|
| Total Products | Count of all products matching current filters |
| Buy Box Winners | Products where we own the Buy Box |
| Featured Merchants | Products where we're the featured merchant |
| With Issues | Products with active pricing flags/issues |
| Suppressed | Products with Amazon suppression status |
| Fresh Data (24h) | Products with data updated in last 24 hours |
Filters
| Filter | Options |
|---|---|
| Catalog | Dropdown of all Amazon Seller Central catalogs (US, CA, EU markets) |
| Search | Free text search across SKU, ASIN, and Product Title |
| Status | Active, Active + Hidden, Pending Onboarding, All States |
| Buy Box | All, Winners Only, Non-Winners |
| Per Page | 25, 50, 100, 200 results |
Table Columns
| Column | Description | Sortable |
|---|---|---|
| Market | Country flag emoji (🇺🇸, 🇨🇦, etc.) | No |
| SKU | Product SKU (links to catalog item detail) | Yes |
| ASIN | Amazon ASIN (links to Amazon product page) | Yes |
| Product Title | Item name (truncated with tooltip) | Yes |
| Status | State and price change indicators | No |
| Price | Current price with sale price if different | Yes |
| Min/Max | Minimum and maximum allowed seller prices | No |
| BB | Buy Box Winner indicator (🏆 or ○) | Yes |
| FM | Featured Merchant indicator (⭐ or ○) | Yes |
| Issues | Warning icon with popover showing issue details | No |
| Updated | Time since last Amazon data update | Yes |
| Actions | Dropdown with View, Edit, Amazon link options | No |
Status Icons
State Indicators
- ✅ Green check - Active
- 👁️ Yellow eye-slash - Active but hidden
- ⏰ Blue clock - Pending onboarding
- ⏸️ Gray pause - Inactive
Price Change Indicators (shown if changed in last 7 days)
- ↑ Green arrow up - Price was raised
- ↓ Red arrow down - Price was lowered
Other Indicators
- 🚫 Red ban - Item is suppressed on Amazon
- 🏆 Green trophy - Buy Box Winner
- ⭐ Yellow star - Featured Merchant
- ⚠️ Red warning - Has active issues (hover for details)
Data Freshness Colors
The "Updated" column uses color coding:
- Green - Data updated within 24 hours
- Yellow - Data updated within 7 days
- Red - Data older than 7 days
Row Highlighting
- Light red background - Items with active issues
- Light yellow background - Items that are suppressed
Supported Marketplaces
The dashboard shows Seller Central catalogs only:
| Region | Marketplaces |
|---|---|
| North America | 🇺🇸 US, 🇨🇦 CA |
| Europe | 🇬🇧 UK, 🇩🇪 DE, 🇫🇷 FR, 🇮🇹 IT, 🇪🇸 ES, 🇳🇱 NL, 🇵🇱 PL, 🇸🇪 SE, 🇧🇪 BE |
Actions Menu
Each row has an actions dropdown with:
- View Details - Opens the catalog item detail page
- Edit Item - Opens the item editor
- View on Amazon - Opens the Amazon product page (external link)
- Pull Buy Box Status - (Placeholder for future functionality)
Permissions
Access requires can?(:read, CatalogItem) permission.
Related Features
- Amazon Variations - Manage parent/child product relationships
- All Catalogs - View and manage all catalog configurations
- Stores - Manage store configurations
Technical Details
- Controller:
Crm::AmazonProductsController - Helper:
AmazonProductsHelper - Route:
amazon_catalog_items_path - Pagination: Pagy (configurable 25-200 per page)
- Search: Ransack with association traversal