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
- 1Export SKU, vendor description and specs to a spreadsheet.
- 2Work in batches of 50–100 rows.
- 3Ask AI to rewrite in a fixed format with consistent units.
- 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.