Built with Retool
Senior Product Search and Catalog Audit System
Retoolers .io
Project Title:
Senior Product Search and Catalog Audit System
Project Description:
This project is a Product Search and Catalog Audit System created using Retool, designed for internal use by product sourcing and auditing teams. It helps users (both Juniors and Senior Auditors) efficiently identify profitable products, audit catalog details, and manage purchase orders.
Key Features:
Product Matching Interface:
AI-assisted product matching, with manual "No Match" or "Set Match" controls.
Pack size selection and "Multi-Match" support for complex product bundles.
Stock and Seller Analysis:
Displays stock levels, seller ratings, and product condition across multiple sellers.
Highlights FBA and FBM sellers and identifies Buy Box winners with real-time price tracking.
Audit and Catalog Management:
Automatically audits ASINs with verification status.
Displays important audit flags like missing price or case size.
Allows addition of products directly into a purchase order pipeline.
Product Variations and Statistics:
Lists all variations linked to a parent ASIN, with rank and rating insights.
Includes detailed Buy Box statistics (30, 90, 180, 365 days) to identify winning patterns and market competitiveness.
Cost and Profit Estimation:
Provides real-time profit calculations based on the Buy Box price.
Displays ROI, Margin at Buy Box Price, and Total Profit potential.
Option to input custom costs for more accurate financial forecasting.
Senior Auditor Review Section:
Enables Senior Auditors to approve, reject, or request further review on matched products, along with notes and reason selection.
Technology Stack:
Frontend: Retool
Backend: Retool queries and integrations with Amazon Seller APIs and internal catalog databases.
Use Cases:
Accelerate product sourcing decisions for reselling or retail arbitrage.
Ensure catalog completeness and accuracy before ordering.
Identify top-performing sellers and best opportunities for winning the Buy Box.
Streamline team collaboration between Junior product searchers and Senior Auditors.
Like this project
Posted Apr 27, 2025
Developed a Product Search and Catalog Audit System using Retool for internal auditing teams.
Likes
0
Views
6
E-commerce Performance Dashboard for Shopify, Shopee, and Lazada
Sales, Refunds, and Chargebacks Monitoring Dashboard