Build a complete e-commerce product content system via OpenClaw Ultra. From creating listings from supplier data and writing unique descriptions to optimizing SEO and keeping catalogs in sync across channels, manage your entire product content operation from a single chat interface.
Core System Overview
💎 INFO:
This is a closed-loop e-commerce operations workflow. OpenClaw Ultra handles product import, content enrichment, category classification, SEO optimization, multi-channel syndication, catalog maintenance, health auditing, and content iteration, so you can keep your product catalog accurate and competitive across every sales channel without switching between admin panels and spreadsheets.
| System Layer | Core Function | Final Output |
|---|
| Import Layer | Supplier data ingestion, CSV/API import, record creation | Clean product records with verified fields |
| Enrichment Layer | Description writing, attribute filling, image alt text | Enriched product profiles |
| Classification Layer | Category mapping, taxonomy alignment, attribute standardization | Properly categorized catalog |
| SEO Layer | Title optimization, meta description generation, keyword insertion | SEO-ready product pages |
| Syndication Layer | Multi-channel formatting, compliance checks, listing publishing | Live listings on all connected channels |
| Maintenance Layer | Bulk price/description updates, stock sync, metafield edits | Current listings across all channels |
| Audit Layer | Catalog health scanning, gap detection, suppression monitoring | Catalog quality report with flagged items |
| Optimization Layer | Underperformer content refresh, process tuning, next-cycle improvements | Improved catalog content next cycle |
Prerequisites
| Item | Requirement |
|---|
| OpenClaw Ultra | Installed and running |
| E-commerce Platform Account | Active store on Shopify, WooCommerce, or BigCommerce |
| Platform API Credentials | API key with product read/write permissions |
| Product Catalog | Existing product list with SKUs (can be incomplete or from supplier) |
| Multi-channel Accounts | (Recommended) Amazon, Walmart, or other marketplace seller accounts for syndication |
| Supplier Data | (Recommended) CSV exports or API access to supplier product feeds |
Step 0 — Initialize Your E-commerce Operations System
Set up OpenClaw Ultra as your dedicated product content operations manager.
Operation Steps
- Open a new chat session on OpenClaw Ultra
- Prepare your platform API credentials, product catalog data, and any supplier feeds
- Paste the initialization prompt
- For sourcing new products to stock alongside the ones you already manage, see the Lead Generation Workflow
Ready-to-Use Prompt
Act as my e-commerce operations manager.
My store:
- Platform: [Shopify / WooCommerce / BigCommerce]
- API credentials: [API key or token]
- Current SKU count: [number]
- Active sales channels: [list — e.g., Shopify store, Amazon, Walmart, eBay]
My biggest content operations problems:
- I'm managing [number] SKUs and most descriptions are copy-pasted from the manufacturer, which kills my SEO
- I spend [10-25] hours a week manually updating product data across [number] channels
- I have no way to check which listings are suppressed or missing attributes until a customer complains
- My category structure is a mess — products are in the wrong collections and I don't have a standard way to tag attributes
Build me a product content management system that:
- Imports supplier data and creates proper product records with validated fields
- Writes unique, accurate descriptions for every SKU so I stop getting penalized for duplicate content
- Checks every listing for missing attributes and suggests fixes before I publish
- Formats product data correctly for each sales channel so listings don't get suppressed
- Scans my catalog weekly and flags problems before they cost me sales
- Keeps a single source of truth so I'm not juggling five spreadsheets
Step 1 — Onboard Products into Your Catalog
Bring products in from supplier data or create them from scratch with complete, accurate records.
1.1 Import Supplier Data and Create Listings
Prompt
I just got a supplier export for [number] new products. Clean it up and turn it into proper product records.
Source file: [paste CSV data or attach file]
For each row:
1. Standardize the title format: [Brand] [Product Name] — [Key Attribute] (e.g., "Nike Air Max — Running Shoe, Size 10")
2. Pull the description, specs, price, SKU, category, and image URL
3. Flag any row with missing critical fields (price, SKU, main image)
4. Check for duplicate SKUs against my existing catalog
Return a table with cleaned records and a separate section listing data gaps. For each gap, tell me exactly what info I need and where I'd find it (supplier spec sheet, product page, physical package). Don't guess on missing data.
1.2 Rewrite Manufacturer Descriptions to Be Unique
Prompt
I have [number] products with descriptions straight from the manufacturer. Every store selling these has the same text, and Google is de-ranking my pages because of duplicate content.
Rewrite each description so it's unique. Here are two examples of descriptions I've written myself so you can match my style:
[paste 1-2 examples of your writing]
Rules:
- Keep all specs, dimensions, and materials accurate
- Don't add features the product doesn't have
- Write for someone who [knows the product category / is new to this type of product]
- Each description must be at least [50] words and no more than [200]
- If the product has multiple variants (size, color), write one base description that works for all variants
Return a table: SKU, old first 50 characters, new description, word count.
⚖️ INFO:
Duplicate product descriptions are one of the most common reasons e-commerce sites lose organic traffic without realizing it. Scandiweb reports that Google and other search engines quietly demote listings with near-identical descriptions, and the traffic drop looks like seasonality until you compare content uniqueness against ranking trends.
Step 2 — Enrich Product Descriptions and Images
Fill in missing product attributes and optimize image metadata so your catalog works for search and for customers.
2.1 Fill Missing Product Attributes
Prompt
Scan my catalog for SKUs with missing attributes: size, color, material, weight, dimensions, country of origin.
I have about [number] SKUs with gaps. For each one:
1. Check if the missing attribute can be inferred from the product title, category, or existing specs
2. If it can be inferred, suggest a value and flag it for my review
3. If it can't be inferred, list it as a data gap and tell me which source I need to check (supplier spec sheet, product packaging, manufacturer website)
Rules:
- Don't invent specs. If you're not sure, mark it as a gap.
- If the attribute doesn't apply (e.g., "color" for a cable that only comes in black), note that rather than leaving it blank.
Return three tables:
1. Inferred attributes ready for my approval
2. Data gaps with recommended source to check
3. SKUs with complete attributes (no action needed)
2.2 Generate Image Alt Text in Bulk
Prompt
I have [number] product images with missing or useless alt text — things like "product.jpg" or "IMG_001" or nothing at all.
Each image has a URL and is linked to a SKU. For each image:
1. Look at the product name, category, and key attributes
2. Write alt text under 125 characters that describes what the image shows
3. Include the product type naturally — don't keyword-stuff
4. If the image is decorative (pattern swatch, texture sample, icon), mark it as decorative and skip alt text
Return a table: image URL, SKU, current alt text (or blank), suggested alt text, and whether it passes the 125-character limit.
Step 3 — Structure Your Catalog with Categories and Attributes
Organize products into a clean category structure with standardized attributes across your entire catalog.
3.1 Restructure Category Taxonomy
Prompt
My current category structure is a mess. Products that should be grouped together are scattered across different collections, and some categories overlap.
Current categories: [paste your current category list]
Products without a category: [number]
Analyze my catalog and:
1. Identify categories that overlap or are redundant
2. Suggest a clean hierarchy with [3-4] top-level categories and subcategories under each
3. Map every product to the new structure
4. Flag products that don't clearly fit anywhere — these might need a new category
Return the proposed category tree and a migration plan showing which products move where. Don't suggest categories that are too broad ("Miscellaneous") or too narrow (one product per category).
3.2 Standardize Product Attributes Across the Catalog
For category-level content beyond individual product pages, such as buying guides and landing page copy, see the SEO Content Workflow.
Prompt
My products have attributes stored in inconsistent formats — some use "oz", some use "grams", colors are sometimes "Red" and sometimes "RED", materials are free-text with no standard list.
Standardize every attribute field across my catalog:
1. Size/weight: convert everything to [metric / imperial] based on my primary market
2. Colors: map to a standard color list (red, blue, green, black, white, etc.)
3. Materials: standardize naming (e.g., "100% Cotton" instead of "cotton 100%" or "pure cotton")
4. All other text attributes: trim whitespace, fix capitalization, remove extra punctuation
Return a summary of changes made and a count of SKUs affected per attribute type. Don't change attribute values that are already correct.
Step 4 — Syndicate Content Across Sales Channels
Format your product data for each marketplace and publish listings that comply with each platform’s requirements.
Showing 5/11 sections. Full content: https://openclaw.aiondesktop.com/tutorials/35