E-commerce Operations Workflow

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

1. Open a new chat session on OpenClaw Ultra
2. Prepare your platform API credentials, product catalog data, and any supplier feeds
3. Paste the initialization prompt
4. 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.

4.1 Format Listings per Channel Requirements

For page-level SEO beyond product descriptions, such as buying guides and category landing pages, see the SEO Content Workflow.

Prompt

I'm selling on [Shopify / Amazon / Walmart / eBay / other] and each platform has different requirements for titles, descriptions, and images.

Format my product catalog for each channel:

Amazon requirements:
- Titles: max [200] characters, format "[Brand] [Product Name] — [Key Features]"
- Bullet points: 5 bullet points, each under [500] characters
- Images: at least [1000]px on the longest side, white background for main image
- Attributes: fill every required attribute for my category

Walmart requirements:
- Titles: max [50] characters, no promotional language
- Description: [2,000] char limit, no HTML
- GTIN: verify every product has a valid UPC or GTIN

Shopify requirements:
- Titles: max [70] characters for SEO
- Meta description: [160] char limit per product
- URL slugs: auto-generate from product titles

Return a table: SKU, current title, Amazon title, Walmart title, Shopify SEO title, and notes on any attribute gaps per channel.

4.2 Publish Listings and Verify Compliance

Prompt

I've prepared my product data for [channels]. Before I publish, run a compliance check on each listing:

Check for:
1. Title length violations per channel limits
2. Missing required attributes that would cause listing suppression
3. Image size or format issues
4. Price or currency mismatches between channels
5. Products priced below minimum or above maximum for their category

Return a table: SKU, channel, status (pass / warning / fail), and the specific issue for warnings and failures. Don't block publishing on warnings — just flag them so I can decide.

Step 5 — Maintain Catalog Health

Keep your listings accurate across all channels with bulk operations and regular health scans.

5.1 Run Catalog Health Scan

Prompt

Scan my entire catalog and flag anything that needs attention. Check for:

1. Products with missing or incomplete descriptions
2. Products without a primary image
3. Products missing category assignment
4. Products with titles under [10] characters or over [200] characters
5. Products where price equals zero or is missing
6. Products with duplicate or missing SKUs
7. Products that haven't been updated in [90] days
8. Products with alt text that's still the default or missing

Rank the issues by impact: pricing and missing images first, then descriptions and categories, then everything else. Return a single table sorted by priority with the SKU, issue type, current value (or blank), and recommendation.

5.2 Fix Flagged Issues in Bulk

Prompt

Based on the catalog health scan, I need to fix [number] issues. Address each category:

1. Missing images: [number] SKUs. I have image files here: [folder path or URLs]. Match each image to its SKU and update the records.

2. Missing descriptions: [number] SKUs. For each one, write a short description using the product title, category, and price as context. Keep each one under [100] words and make them unique — no copy-paste.

3. Incomplete attributes: [number] SKUs missing size or color. For size, check the title for size indicators. For color, use the primary variant color if available.

4. Stale products (no update in [90] days): just flag these — don't change anything. I'll review them manually.

5. Missing alt text: [number] SKUs. Use the product name and category to generate descriptive alt text under 125 characters.

Return a table showing what was fixed per SKU. For anything you couldn't fix automatically, explain why and suggest the next step.

WARNING

A bulk update that goes wrong is worse than no update at all. Always run the health scan first and review the flagged items before running any automated fixes. Shopify app data shows that bulk editing tools with preview-and-undo save more time in the long run than tools that apply changes immediately.

Step 6 — Analyze Catalog Performance and Improve Content

Review what's working and what isn't, then iterate on your product content for the next cycle.

6.1 Run Catalog Performance Analysis

Prompt

Review my catalog performance data and identify where content changes would have the biggest impact.

Available data:
- Product list with SKUs, categories, prices, and creation dates
- Sales data: units sold per SKU in the last [90] days (or mark if unavailable)

Calculate:
1. Coverage gaps — categories with high sales but low-quality content (short descriptions, missing images, few attributes)
2. Bottom performers in each category — products with sales below [X] percentile — flag their content quality
3. Products launched in the last [30] days with incomplete listings
4. Categories where none of the products have unique descriptions

Return a ranked list of the top [10] products that would benefit most from a content refresh, with a one-line reason for each (e.g., "top-selling product in its category but description is only 30 words").

6.2 Refresh Underperforming Product Content

Prompt

Based on the performance analysis, refresh content for these [number] products:

[list of SKUs with issues]

For each product:
1. If the description is too short ([under] words): expand it to at least 100 words using the product specs and category context
2. If the description is manufacturer default: rewrite it to be unique
3. If alt text is missing: generate it
4. If the title is underperforming: suggest an alternative title that includes the product's main differentiator

Don't touch pricing, inventory, or anything that affects orders. Content only.

Return a table: SKU, what was changed (description rewrite / alt text added / title suggestion), old content preview, new content preview.

Step 6 Output

A prioritized content refresh pipeline feeds improved product data back into your catalog for the next syndication cycle.

Final Closed-Loop E-commerce Operations Workflow

Supplier Data → Imported & Cleaned → Descriptions Written → Attributes Filled → Categories Assigned → SEO Optimized → Published to Channels → Health Scanned → Issues Fixed → Performance Reviewed → Content Refreshed → Next Import

Practical Usage Tips

1. Run a uniqueness check every time you import new products. Stores using manufacturer default descriptions across hundreds of SKUs get de-ranked by search engines — scandiweb reports the traffic loss looks like seasonality until you compare content uniqueness against ranking trends.
2. Fix pricing and stock errors first when running a catalog health scan. A wrong price that goes live for 48 hours can trigger marketplace penalties that take weeks to reverse.
3. Set up a weekly scan cadence, not monthly. Base.com reports that listings on four or more channels break silently — a suppression on one platform doesn't alert you on another. Weekly scans catch issues before they compound.
4. Keep image alt text under 125 characters. Screen readers cut off after that, and search engines truncate alt text in image search results.
5. When launching new products, import supplier data into a draft state first, review the generated records, then publish. A single missing GTIN or UPC can block a listing from going live on Amazon.
6. For automating review collection and post-purchase follow-up tied to your product catalog, see Customer Support Automation.
7. For linking product content performance to margin and profitability data, see Finance Tracker Workflow.
8. For promotional email campaigns driven by catalog updates and new arrivals, see Email Outreach Workflow.