
Dropship Catalog Sync & Validation
Validate, deduplicate, and sync dropship catalogs across suppliers
What You Can Do
You can upload product feeds from multiple dropship suppliers and Claude will validate data integrity, detect duplicate products across suppliers, identify pricing and inventory conflicts, and generate a clean, deduplicated catalog ready for your storefront. The skill prevents overselling by flagging inventory mismatches and ensures stale listings are removed when products are discontinued at suppliers.
Features
Checks product records for missing required fields, format errors, and data type mismatches across all supplier feeds
Identifies duplicate products across suppliers by matching SKUs, product names, and attributes to prevent multiple listings of the same item
Flags and suggests resolutions for pricing discrepancies, inventory count mismatches, and conflicting product attributes between suppliers
Compares supplier inventory levels against your storefront counts and flags overselling risks and stock-outs
Identifies products that are no longer available at suppliers so you can remove stale listings before customer orders fail
Maps supplier-specific product codes and naming conventions to a unified internal schema
Generates pre-export validation reports showing which products are safe to publish to marketplaces
Example Output
Input: Three supplier CSV files (Supplier A: 450 products, Supplier B: 320 products, Supplier C: 280 products)
Output:
Validation Summary
─────────────────
✓ Total records processed: 1,050
✓ Valid records: 987
✗ Records with missing required fields: 32
✗ Format errors detected: 18
✗ Discontinued at supplier: 13
Duplicate Findings
──────────────────
• Product SKU-4521 listed by Supplier A ($29.99, 150 units) & Supplier B ($32.50, 89 units)
• Product SKU-7834 appears in Supplier B & C with 3-week variance in stock counts
• 7 near-duplicate matches (95%+ name similarity, different SKUs)
Conflict Resolution Recommendations
───────────────────────────────────
1. SKU-4521: Recommend listing Supplier A (lower price, higher inventory)
2. SKU-7834: Inventory variance suggests supply chain delay—flag for manual review
3. 18 products: Missing description field—provide template for bulk import
Ready for Export
────────────────
✓ 912 products cleared for storefront publication
✓ 45 products require manual review before listing
What's Included
- SKILL.md: Complete catalog sync workflow with validation logic, conflict resolution framework, and deduplication methodology
- Data Ingestion Template: Standardized product feed format and supplier mapping worksheet to normalize diverse catalog structures
- Validation Checklist: Required fields, data type rules, and quality thresholds for each product category
- Conflict Resolution Matrix: Decision tree for resolving pricing, inventory, and attribute conflicts between suppliers
- Pre-Export Audit Report Template: Checklist for validating catalogs before publishing to storefronts, marketplaces, or channels
Who It's For
- Dropship managers — Syncing catalogs across multiple supplier feeds daily or weekly
- E-commerce operations teams — Preventing catalog errors that lead to customer complaints and lost sales
- Marketplace sellers — Preparing deduplicated catalogs for Amazon, eBay, or Shopify multi-channel publication
- Supply chain coordinators — Auditing supplier inventory accuracy and identifying discontinued products
- Catalog data analysts — Maintaining data quality across distributed product databases
Best For
- Onboarding new suppliers with 100+ products requiring validation before publication
- Regular catalog maintenance (weekly/monthly sync validation) across 3+ suppliers
- Merging overlapping product lines from competing suppliers to create a single clean catalog
- Detecting price discrepancies and inventory mismatches before they reach customers
- Preparing catalog exports for multi-channel marketplaces (Shopify, Amazon, eBay)
- Auditing which products are active vs. discontinued at suppliers to prevent overselling







