Build a part-numbering system and troubleshoot shop machines with ChatGPT
Quick answer
Reno Salvage is an 86-year-old salvage and metal yard in Reno, Nevada. Its manager used ChatGPT to create a part-numbering system for over 1,000 products, a job the yard had put off because it would take weeks. When a plasma cutting table broke, he described the problem to ChatGPT and got a fix instead of waiting days for a technician. He also uses it to look up specs for customers' technical questions on the spot.
Business type: Retail shops. Tool used: ChatGPT. Result: The source reports the part-numbering for over 1,000 products was done in a single afternoon instead of weeks.
Tell ChatGPT the rule you want for part numbers, and ask for a spreadsheet.
Check a sample of the numbers with your shop team before using them.
When a machine acts up, describe the error and what you've tried; follow safety steps first.
Result
The source reports the part-numbering for over 1,000 products was done in a single afternoon instead of weeks. (as reported by the source)
Questions and answers
What does the AI agent do here?
Reno Salvage is an 86-year-old salvage and metal yard in Reno, Nevada. Its manager used ChatGPT to create a part-numbering system for over 1,000 products, a job the yard had put off because it would take weeks. When a plasma cutting table broke, he described the problem to ChatGPT and got a fix instead of waiting days for a technician. He also uses it to look up specs for customers' technical questions on the spot.
Which tool did they use?
ChatGPT.
What was the result?
The source reports the part-numbering for over 1,000 products was done in a single afternoon instead of weeks. (as reported by the source)
How did they set it up?
Export your product list with names and sizes. Tell ChatGPT the rule you want for part numbers, and ask for a spreadsheet. Check a sample of the numbers with your shop team before using them.
Answers come only from the source. Questions it doesn't answer are left out.
Starter prompt
Our own prompt for copying this setup. Swap in your details. Not quoted from the source.
Here is our product list: [paste]. Make a part number for each item using this rule: [item name code]-[thickness in decimals]-[width in decimals]. Keep them short and easy for the shop to remember. Give me a spreadsheet with part number and category.
Is this your business? Show you're featured. Paste this code into your website. The badge links back to this page.
<a href="https://smallbizagentusecases.com/use-cases/salvage-yard-chatgpt-part-numbers-and-repairs/" title="Featured on Small Biz Agent Use Cases"><img src="https://smallbizagentusecases.com/badge/featured.svg" alt="Featured on Small Biz Agent Use Cases" width="250" height="56"></a>
A family tea business with two stores and an online shop runs an agent the owner messages on Telegram. It places supplier orders, prints Shopify orders, tracks shipments, works out payroll, and checks timesheets every evening.
The owner of Discount Catholic Products, a store selling thousands of products, used to spend hours combining spreadsheets to see how fast each item sells and how much to order. He built a system with Claude that has all that data and context, and now gets it done with a handful of prompts.
Prospect Butcher Co. is a small, worker-owned butcher shop in Brooklyn, New York. It wrote its own set of Claude 'skills' (written playbooks the AI follows) to run its back office, and published them free for other small businesses. The kit includes a morning briefing that pulls email, calendar, tasks and sales numbers, a sales forecaster, a Google Ads check for wasted spend, and Gmail and Google Sheets helpers for vendor emails, sales logs and stock.