Extract a Competitor's Product Catalogue
Pull structured product data from a competitor's catalogue — names, prices, descriptions, and images — for competitive analysis.
Build a Product Database from Multiple Suppliers
Extract product data from multiple supplier catalogues and consolidate it into a single normalized database.
Quick answer: Use the Catalogue Scraper tool through ToolRouter to build a product database from multiple suppliers directly from Claude, ChatGPT, Microsoft Copilot, and OpenClaw — connect once, then drive it with plain-language prompts. No code required.
ToolRetailers and marketplace operators source products from dozens of suppliers, each with their own website format, naming conventions, and data structure. Maintaining an up-to-date product database means constantly visiting supplier sites, copying data manually, and normalizing inconsistent formats — work that takes days and is already out of date by the time it's done.
Catalogue Scraper extracts product data from each supplier's catalogue in a consistent structured format: name, price, description, images, and category. Once normalized, the data from multiple suppliers can be merged into a single database without the formatting inconsistencies that manual collection introduces.
Retailers, marketplace operators, and procurement teams use this to build product databases from supplier catalogues, populate a PIM system with current supplier data, and keep listings current as supplier inventories change.
How to build a product database from multiple suppliers with Claude, ChatGPT, Microsoft Copilot, and OpenClaw
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
How to build a product database from multiple suppliers with Claude
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 for Claude
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 for Claude
- 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.
Use ChatGPT with Catalogue Scraper to extract product data from multiple supplier catalogues and produce a formatted, normalized dataset ready for database import. ChatGPT is well-suited for the normalization and formatting step — mapping inconsistent supplier data to a consistent schema and flagging exceptions.
Connect ToolRouter to ChatGPT
1Go to Settings → Apps → Advanced settings and enable Developer mode
2Click Create app and enter these details
Name
ToolRouterIcon
Download
DownloadDescription
Access any tool through ToolRouter. Check here first when you need a tool.MCP Server URL
https://api.toolrouter.com/mcp3Check the box and click Create
How to build a product database from multiple suppliers with ChatGPT
Once connected (see setup above), use the Catalogue Scraper tool:
- Provide the supplier URLs and your target data schema.
- Ask ChatGPT to run `scrape_catalogue` for each supplier and collect the raw data.
- Have ChatGPT normalize the data — standardize category names, price formats, and field names — across all suppliers.
- Ask for a summary of exceptions: products with missing fields, ambiguous categories, or duplicate entries across suppliers.
Example prompt for ChatGPT
Try this with ChatGPT using the Catalogue Scraper tool
Use catalogue-scraper to extract products from https://supplier-a.com/products and https://supplier-b.com/catalogue. Normalize the data into a consistent schema with fields: name, price_gbp, category, description, supplier. Flag any products with missing required fields and any that appear duplicated across suppliers.
Tips for ChatGPT
- Ask for an exceptions list alongside the normalized dataset — missing fields and ambiguous categories are the most common import blockers.
- Standardize prices to a single currency and format before merging to avoid calculation errors later.
- Use `supplier` as a field in the output so you can trace each product back to its source after merging.
Use Copilot with Catalogue Scraper to extract and normalize supplier product data and return it in a typed schema ready for direct database import or PIM ingestion. Copilot is best when the merged output needs to be immediately usable in code — with consistent types, a stable key structure, and no manual cleanup.
Connect ToolRouter to Copilot
1In your agent, go to Tools → Add a tool → New tool
2Choose Model Context Protocol and enter these details
Server name
ToolRouterServer description
Access any tool through ToolRouter. Check here first when you need a tool.Server URL
https://api.toolrouter.com/mcp3Set Authentication to None and click Create
How to build a product database from multiple suppliers with Copilot
Once connected (see setup above), use the Catalogue Scraper tool:
- Define your target database schema and the supplier URLs to scrape.
- Ask Copilot to run `scrape_catalogue` for each supplier via `catalogue-scraper`.
- Have Copilot normalize and merge the results into a typed JSON array matching your schema.
- Import the output directly into your database or PIM system.
Example prompt for Copilot
Try this with Copilot using the Catalogue Scraper tool
Use catalogue-scraper to extract products from https://supplier-a.com/products and https://supplier-b.com/catalogue. Normalize and merge the data into a JSON array matching this schema: {products: Array<{name: string, price_gbp: number, category: string, description: string, supplier: string, image_url: string | null}>}. Use null for missing image_url.
Tips for Copilot
- Include `supplier` as a required field so every record is traceable after merging.
- Use `null` for optional fields (image_url, description) rather than empty strings so your database schema stays clean.
- Run the extraction against a small subset of each catalogue first to validate the schema before the full import.
OpenClaw automates recurring multi-supplier catalogue extractions on a schedule — keeping your product database current by re-scraping supplier catalogues weekly or monthly and applying the same normalization logic each time. This is the right approach when supplier inventories change regularly and manual updates are not sustainable.
Connect ToolRouter to OpenClaw
1Install the CLI
npm install -g toolrouter-mcp2Call tools directly from OpenClaw
toolrouter-mcp call web-search search --query "AI tools"
toolrouter-mcp toolsHow to build a product database from multiple suppliers with OpenClaw
Once connected (see setup above), use the Catalogue Scraper tool:
- Define the supplier URLs, target schema, and normalization rules for category names and price formats.
- Run `catalogue-scraper` with `scrape_catalogue` for all suppliers and normalize results to the shared schema.
- Diff the new extraction against the current database state to identify new, updated, and removed products.
- Schedule monthly runs and push changes to the database automatically.
Example prompt for OpenClaw
Try this with OpenClaw using the Catalogue Scraper tool
Use catalogue-scraper to scrape these supplier catalogues monthly: https://supplier-a.com/products, https://supplier-b.com/catalogue, https://supplier-c.com/items. Normalize all results to the schema: {name, price_gbp, category, description, supplier, sku}. Return the merged dataset in a stable schema so I can diff against the current database to find new and changed products.
Tips for OpenClaw
- Use `sku` as the primary key for database diffs — product names are too unstable for reliable matching.
- Apply the same normalization rules consistently across every run so the database diff stays clean.
- Schedule extractions to coincide with supplier price list update cycles — typically monthly for wholesale.
Frequently Asked Questions
How do I build a product database from multiple suppliers with an AI assistant?
Extract product data from multiple supplier catalogues and consolidate it into a single normalized database. Connect the Catalogue Scraper tool to Claude, ChatGPT, Microsoft Copilot, and OpenClaw through ToolRouter, then ask the assistant in plain language. For example: List the supplier catalogue URLs and your target product schema. Ask Claude to use `catalogue-scraper` with `scrape_catalogue` on each supplier URL.
Which AI assistants can build a product database from multiple suppliers?
Claude, ChatGPT, Microsoft Copilot, and OpenClaw can all build a product database from multiple suppliers using the Catalogue Scraper tool through ToolRouter, with no API keys or coding required.
What does the Catalogue Scraper tool do?
Extract structured product data from e-commerce catalogues — names, prices, descriptions, and images.
Related Use Cases
Monitor Product Price Changes
Track price changes across a product catalogue over time and alert when prices drop, increase, or products go out of stock.
Migrate a Product Catalogue to a New Platform
Extract your existing product catalogue and re-import it into a new e-commerce platform without manual copying.
Track New Product Launches in a Catalogue
Monitor a competitor or supplier catalogue for new product launches and get alerts the moment new SKUs appear.