Products SEO & GEO Agent Paid Ads Agent Website Agent Conversion Agent
How it works Pricing FAQ Blog Book a call

Online Store Description Generator: Fill a Whole Catalog Fast

Updated · 7 min read

Short answer Export your catalog to a spreadsheet, add one column of real facts per product, generate every description from one tested prompt, check a sample plus every outlier, then import only the handle, title and description columns. Shopify and WooCommerce both update existing products from a CSV. Google allows AI text that helps shoppers.

Want help applying this to your business? Talk it through on a free 30-minute call.

Book a call

How to generate descriptions for a whole catalog

Treat it as a spreadsheet job, not a chat job. Pasting products one by one into a generator works for 20 items. For 500, you need rows in, rows out.

StepWhat you doWhy
1. ExportDownload your product CSV from the storeYou get every handle (the product's URL name) or SKU to match on later
2. Add factsOne column per fact: material, size, use, care, what's in the boxThe AI writes from these, not from guesses
3. Write one promptLength, tone, structure, words to avoidSame rules for every row
4. Test on 10Generate 10, fix the prompt, repeatCheap to fix now, costly after 500
5. Generate allRun the full sheetOutput lands in a new column
6. CheckRead a sample and every outlier (below)Catches invented facts
7. ImportUpload only the columns you changedProtects prices, stock and variants

The step most people skip is 2. A generator given only a product name fills the gaps with plausible claims. Shopify warns about this in its own tool:

"Generated text can include things such as product benefits even when you didn't list any explicitly, and facts based on other published content related to similar products." (Shopify Help Center: Generating product descriptions)

Shopify adds that you're responsible for the accuracy of everything you publish, AI-written or not.

Which generator fits how many products

Pick by catalog size, not by brand. Every tool below writes from the facts you give it; they differ in how many rows they handle at once.

ProductsTool typeHow it worksWatch out for
Under 30Your store's built-in writerShopify's generate button sits in each product's description boxOne product at a time; desktop only
30 to 500Chat assistant plus spreadsheetPaste 20 to 50 rows per message, ask for a table backRows get dropped or shuffled; match on SKU
30 to 2,000Store app built for bulkPicks products, writes, pushes to the storeCheck the price, and that it previews before saving
1,000+An AI API, run in batchA script sends each row as one requestNeeds someone who can run a script

On Shopify, the built-in option works one product at a time: open the product, click the AI icon in the description box's toolbar, prompt, then edit and save. Shopify says it isn't supported on the iPhone or Android apps. Shopify's assistant, Sidekick, can write descriptions and "presents changes for your review before applying them" (Shopify Help Center: Sidekick). Shopify doesn't document how many products it handles in one request, so test it on a small collection first.

For big catalogs, OpenAI's Batch API is built for this: a "50% cost discount compared to synchronous APIs," up to 50,000 requests per batch, and results within 24 hours (OpenAI API Docs: Batch API).

What to put in the prompt

One prompt runs every row, so make it strict. A good bulk prompt states:

  • Length: for example 80 to 120 words, plus 3 bullet points.
  • Order: who it's for, what problem it solves, then specs.
  • Only these facts: "Use only the facts in the columns given. If a fact is missing, leave it out."
  • Banned words: the filler your brand never says ("elevate," "game-changer," "must-have").
  • Variety: "Don't start two descriptions the same way." Without this, 500 descriptions open with the same sentence.
  • Format: plain HTML paragraphs and a list, if your store's description field takes HTML.

Add two or three of your best existing descriptions as examples. The AI copies a sample better than it follows adjectives like "friendly."

How to check 500 descriptions without reading every one

Read a random 1 in 20, and read every outlier. Sort the output column to find outliers fast:

CheckHow in a spreadsheetWhat it catches
Too short or too longA word-count column, sortedRows where the AI gave up or rambled
Numbers not in your factsSearch for digits, compare to spec columnsInvented sizes, weights, warranties
Risky claimsSearch "waterproof," "organic," "certified," "safe for," "guarantee"Claims you'd have to prove
Same openingSort by the first five wordsCopy-paste feel across the catalog
Empty cellsFilter blanksRows that will erase text on import

Health, safety, kids' and food products deserve a full read. A wrong claim there is a returns and legal problem, not just a style problem.

Importing descriptions back into your store

Upload a file with only the columns you changed. Both big platforms update existing products from a CSV, but a careless file can wipe other fields.

Shopify. When updating, Shopify says the only required columns are URL handle and Title. Keep those plus Description (and SEO description if you wrote one), and tick "Overwrite products with matching handles." Shopify's rule on blanks is strict:

"If a non-required column in the import CSV file is blank, then the matching value in the product list is overwritten as blank." (Shopify Help Center: Using CSV files to import and export products)

A column you leave out of the file stays as it is. So delete columns you didn't touch; don't leave them empty. If you write SEO descriptions, Shopify allows up to 320 characters and falls back to the product description when that column is blank.

WooCommerce. WooCommerce matches update rows by ID or SKU. Tick "Update existing products," or rows that already exist are skipped. Its columns are "Description" and "Short description." WooCommerce advises a backup and a small test import on a staging site before a large catalog (WooCommerce Docs: Product CSV Importer and Exporter).

On any platform, export a full backup first and import 10 products before the rest.

Will Google penalize bulk AI descriptions?

No, not for being AI-written. Google's line is:

"Appropriate use of AI or automation is not against our guidelines." (Google Search Central Blog: Google Search's guidance about AI-generated content)

What Google acts on is volume without value. Its spam policy lists, as scaled content abuse:

"Using generative AI tools or other similar tools to generate many pages without adding value for users" (Google Search Central: Spam policies)

Descriptions built from your real specs, sizing and use cases add value. Descriptions that reword the product name 500 times don't. Google also asks you to fact-check AI text before publishing, because models "predict a likely sequence of words" rather than look facts up (Google Search Central: Guidance on using generative AI content).

Duplicate text isn't spam by itself: "Some duplicate content on a site is normal and it's not a violation of Google's spam policies" (Google Search Central: What is URL canonicalization). But if you paste the maker's description, your page says nothing the other stores selling it don't. See duplicate content.

If you send a Merchant Center feed: Google says AI-generated title and description attributes "must be specified separately and labeled as AI-generated" (Google Search Central: Guidance on using generative AI content). In Merchant Center, that means the structured description attribute, not the plain description. Check what your feed app sends before a bulk change.

Example

A 40-item candle shop

The owner exports 40 products, adds scent notes, burn time and wax type, and uses Shopify's built-in writer product by product, editing each. About two evenings of work. No import file needed.

A 600-item hardware store on WooCommerce

The manager exports the catalog, adds 6 spec columns from supplier sheets, and runs 30 rows at a time through a chat assistant. A word-count sort flags 25 rows under 40 words; a digit search finds 9 invented measurements. After fixes, a 10-row test import, then the full file with only ID, SKU and the two description columns.

A 12,000-SKU parts seller

A developer runs one batch job overnight. The team reads 600 random rows plus every outlier, fixes the prompt once, reruns the failures, and imports in groups of 1,000.

FAQ

Is there a free online store description generator?

Yes. Shopify's built-in writer and the free tiers of chat assistants cost nothing extra. Free tools usually work one product at a time, which is fine for small shops and slow for large ones.

How long should a product description be?

Long enough to answer what a buyer would ask in the store: what it is, who it's for, size, material, care. For most products that's 50 to 150 words plus a short spec list.

Can I generate descriptions in French or Spanish too?

Shopify says its generator works in every language Shopify supports and writes in the language of your prompt. Have a native speaker check a sample, as you would in English.

Should I tell customers the descriptions are AI-written?

Google suggests adding context on how automated content was made where it makes sense for your audience. For product copy on your own site, accuracy matters more than a label. Merchant Center feeds are different: there the AI label is required.

How do I know the new descriptions work?

Compare conversion rate and search clicks for the changed products over the 4 to 8 weeks before and after. Change one batch first so you have a comparison.

Different for you?

Keep learning

NextClothing Descriptions With AI: Writing Fit, Fabric and FeelHow to get AI to write clothing descriptions that cover fit, fabric and styling: what to feed it, a prompt, the fabric words the law controls, and outfit tools.

Ask us one question

One line is enough. We reply by email.

Sources

  1. Shopify Help Center: Using CSV files to import and export products
  2. Shopify Help Center: Generating product descriptions
  3. Shopify Help Center: Sidekick
  4. WooCommerce Docs: Product CSV Importer and Exporter
  5. OpenAI API Docs: Batch API
  6. Google Search Central: Spam policies (scaled content abuse)
  7. Google Search Central: Guidance on using generative AI content
  8. Google Search Central Blog: Google Search's guidance about AI-generated content (2023)
  9. Google Search Central: What is URL canonicalization
  10. Google Merchant Center Help: Description and structured description