Intermediate45 min
Product Catalog API
Transform your product spreadsheet into a clean API with Product schema for rich results.
What You'll Build
A product catalog with cleaned data, Product schema for Google Shopping rich results, and an API for dynamic content.
Data Requirements
Your product data should include:
- Product name and description
- Price (with currency)
- SKU or product ID
- Images (URLs)
- Availability status
- Brand/manufacturer
- Category
Step 1: Clean Product Data
- Normalize prices to decimal format (19.99)
- Ensure all image URLs are https://
- Standardize availability values (InStock, OutOfStock, PreOrder)
- Remove duplicate products by SKU
Step 2: Set Up Product Schema
Map your columns to Product schema fields:
| Your Column | Schema Field |
|---|---|
| name | name |
| description | description |
| price | offers.price |
| currency | offers.priceCurrency |
| image_url | image |
| sku | sku |
Step 3: Enable Rich Results
With proper Product schema, your products can appear with prices, ratings, and availability directly in Google search results.
API Integration
// Filter products by category and price
const products = await fetch(
'https://dataclean.to/v1/products/items?category=Electronics&max_price=100'
).then(r => r.json());