IndustriesNewsletterAbout

Clean up product catalog descriptions

Standardize messy item descriptions for your website or ERP.

Estimated time saved

Estimated: hours per thousand SKUs versus manual editing. (Estimate; results vary.)

Tools
  • ChatGPT
  • Claude
  • Microsoft Copilot in Excel

The problem

Thousands of SKUs have inconsistent, abbreviated descriptions from different vendors.

Step by step

  1. 1Export SKU, vendor description and specs to a spreadsheet.
  2. 2Work in batches of 50–100 rows.
  3. 3Ask AI to rewrite in a fixed format with consistent units.
  4. 4Spot-check, then import back.

Copy-paste prompt

Prompt
Rewrite each product description below in this format: [Product type] - [Key spec] - [Material] - [Size]. Expand abbreviations, keep units consistent (inches), and do not add specs that are not in the source. Return a table with SKU and new description.

[paste rows]

Review AI output before using it. Don’t paste confidential, customer or patient data into tools your company hasn’t approved.

Get this built for your business

Want “Clean up product catalog descriptions” set up and running in your company? Tell us a little about your business.