Writing product descriptions for 500+ WooCommerce products is a grind. Each product needs a unique, compelling description that includes key specs, addresses customer pain points, and is SEO-optimized. AI doesn’t eliminate the work, but it transforms weeks of copywriting into days of editing.

The Workflow

The process is not “press a button and publish.” It’s a structured pipeline:

Product Data (CSV/ERP) → AI Generation → Human Review → Bulk Upload → QA

Step 1: Prepare Your Product Data

AI is only as good as its input. For each product, gather:

  • Product name and SKU
  • Category and subcategory
  • Key specifications (dimensions, weight, material, color)
  • Target audience
  • Unique selling points
  • Competitor comparison points (optional)

Export this as a structured CSV:

sku,name,category,material,dimensions,weight,features,target_audience

WD-001,"Walnut Dining Table",Furniture,Solid Walnut,"180x90x76cm",45kg,"Extendable to 240cm; seats 6-8; oil finish",Homeowners with mid-century modern taste

Step 2: Craft Your Prompt Template

The prompt is everything. A generic “write a product description” prompt produces generic output. Be specific about tone, length, structure, and SEO requirements.

You are a product copywriter for a premium furniture ecommerce store.

Write a product description for:

  • Product: {name}
  • Category: {category}
  • Material: {material}
  • Dimensions: {dimensions}
  • Key Features: {features}
  • Target Audience: {target_audience}

Requirements:

  • Length: 150-200 words
  • Tone: Warm but professional, not salesy
  • Structure: Opening hook (1 sentence), key benefits (2-3 sentences), specifications paragraph, care/maintenance note
  • Include the primary keyword "{name}" in the first sentence
  • Do not use the words "stunning", "exquisite", "elevate", or "transform"
  • Do not start with "Introducing" or "Meet the"
  • Write in second person ("you", "your")

The banned words list is crucial. Without it, every AI description starts with “Introducing the stunning…” and sounds identical.

Step 3: Generate at Scale

Process your CSV through the AI API in batches:

const Anthropic = require('@anthropic-ai/sdk');

const fs = require('fs');

const csv = require('csv-parser');

const client = new Anthropic();

async function generateDescription(product) {

const prompt = buildPrompt(product); // Your template

const response = await client.messages.create({

model: 'claude-sonnet-4-20250514',

max_tokens: 500,

messages: [{ role: 'user', content: prompt }],

system: 'You are a product copywriter. Return ONLY the product description, no preamble.'

});

return response.content[0].text;

}

async function processCSV(inputFile, outputFile) {

const products = [];

// Read CSV

await new Promise((resolve) => {

fs.createReadStream(inputFile)

.pipe(csv())

.on('data', (row) => products.push(row))

.on('end', resolve);

});

// Process in batches of 10

const results = [];

for (let i = 0; i < products.length; i += 10) {

const batch = products.slice(i, i + 10);

const descriptions = await Promise.all(

batch.map(p => generateDescription(p))

);

batch.forEach((product, idx) => {

results.push({

...product,

description: descriptions[idx]

});

});

console.log(Processed ${Math.min(i + 10, products.length)}/${products.length});

// Rate limiting

await new Promise(r => setTimeout(r, 1000));

}

// Write output

// ... save to CSV or directly update WooCommerce

}

Step 4: Human Review

Never auto-publish AI descriptions. Build a review workflow:

  • Output to a spreadsheet with columns: SKU, Product Name, AI Description, Status (Approved/Edit/Reject)
  • Assign reviewers by category — someone who knows the products
  • Edit for accuracy — AI may hallucinate specs or features
  • Check for duplicates — AI can produce similar descriptions for similar products

Review typically takes 1-2 minutes per description vs. 10-15 minutes to write from scratch. That’s an 80-85% time reduction.

Step 5: Bulk Upload

Use WooCommerce’s built-in CSV importer or the REST API batch endpoint:

// Batch update via WooCommerce API

const batchSize = 100;

for (let i = 0; i < approved.length; i += batchSize) {

const batch = approved.slice(i, i + batchSize);

await wooApi.post('products/batch', {

update: batch.map(p => ({

id: p.woocommerce_id,

description: p.description

}))

});

}

Quality Control Checklist

Before publishing, verify each description:

  • ☐ Factually accurate (specs match the actual product)
  • ☐ No banned/overused words
  • ☐ Correct length (not too short, not bloated)
  • ☐ Primary keyword appears naturally
  • ☐ Unique (not too similar to other products in the same category)
  • ☐ Appropriate tone for the brand
  • ☐ No AI hallucinations (features the product doesn’t have)

Cost Estimate

For a 500-product catalog:

Item Cost
AI generation (Claude Sonnet) ~$7.50
Human review (8 hours @ $25/hr) $200
Bulk upload and QA (2 hours) $50
Total ~$260

Compare this to traditional copywriting at $10-20 per description: $5,000-$10,000 for 500 products.

Conclusion

AI product description generation is one of the most practical, highest-ROI applications of AI for WooCommerce stores. The key is treating AI as a first-draft generator, not a replacement for human judgment. Invest time in your prompt template, build a structured review workflow, and always verify factual accuracy before publishing. The 80%+ time savings is real and repeatable.

Leave a Reply

Your email address will not be published. Required fields are marked *

Close Search Window