How to Build a Product Database from Multiple Suppliers with Claude
Build a Product Database from Multiple Suppliers with Claude and ToolRouter. Extract and normalize product data from multiple supplier catalogues.
Tool
Use Claude with Catalogue Scraper to pull product data from multiple supplier catalogues and identify normalization challenges before they compound in the database. Claude can compare naming conventions, flag inconsistent category structures, and help you define a unified schema before data merging begins.
Connect ToolRouter to Claude
1Open connector settings Open Settings
2Add a custom connector with these details
Name
ToolRouterURL
https://api.toolrouter.com/mcp3Let Claude set you up Open Claude
Steps
Once connected (see setup above), use the Catalogue Scraper tool:
- List the supplier catalogue URLs and your target product schema.
- Ask Claude to use `catalogue-scraper` with `scrape_catalogue` on each supplier URL.
- Ask Claude to compare the data structures across suppliers and identify normalization issues — conflicting category names, different price formats, missing fields.
- Have Claude produce a normalized merged dataset using your target schema.
Example Prompt
Try this with Claude using the Catalogue Scraper tool
Use catalogue-scraper to extract products from these three supplier catalogues: https://supplier-a.com/products, https://supplier-b.com/catalogue, https://supplier-c.com/items. For each supplier, extract name, price, category, and description. Then identify the key normalization challenges across suppliers and produce a merged dataset with consistent category names and price format.
Tips
- Ask Claude to identify category naming conflicts before merging — the same product type often has three different names across three suppliers.
- Define your target category taxonomy first and ask Claude to map each supplier's categories to it.
- Flag products that appear in multiple supplier catalogues so you can track pricing differences across sources.