Use case B6 · Business
Student running her family's grocery store uses ChatGPT to sort 8,000 products and plan promotions
- Operations
- Beginner
- ChatGPT, Custom GPT
- Source checked · news article
The short version
What they did
Used ChatGPT to categorize more than 8,000 products for a new point-of-sale system, to suggest revenue ideas such as minimum-spend vouchers, and built a custom GPT that remembers past promotions.
Result (as claimed)
The article estimates nearly a week manually for more than 8,000 products and reports that ChatGPT “completed the sorting process in just two days”. The store had carried “debts of more than S$30,000”; the article says she now pays her university fees from its income.
Prompt
I help run a neighborhood grocery store and am sorting products for our point-of-sale system. Our product list is [paste or attach names and product IDs]. Use only these departments and subcategories: [paste approved categories and how they fit together].
1. Assign each product to a department and subcategory from my list. Keep its original name and ID unchanged.
2. Return a table with product ID, product name, department, subcategory and a ‘check’ flag with a short reason wherever the name is unclear.
3. State the number of rows received and returned. If the batch is too large, tell me where you stopped.Use plain labels. Don’t create categories or guess what an unfamiliar product is. Keep duplicate rows visible for my review rather than deleting them. I’ll check the table before importing it.
Do it yourself
These steps are my suggested way in, not Lin Enqi’s setup.
What you need
- Your product list, exported from your point-of-sale system or supplier sheets.
- The departments and sub-categories you want.
- A chat assistant that can read spreadsheets, such as ChatGPT or Claude.
Start simple
- Write your category list first. Keep it short.
- Upload a batch of a few hundred products with the Prompt.
- Ask for a table with a confidence flag. Fix the flagged rows yourself.
- Repeat in batches until the whole list is done.
- Import the result into your point-of-sale system.
Take it further
- Share a few months of sales and ask for promotion ideas, such as a minimum-spend voucher.
- Keep a record of past promotions and results in a custom GPT or project so new ideas build on old ones.
- Ask it which items to reorder less, based on slow sales.
Check your work
- Spot-check 20 random products in each batch.
- Make sure the row count going in matches the row count coming out. Long lists can get cut short.
- Check promotion math so a voucher doesn’t cost more than it brings in.
Source checked. The link, author, date and quote were confirmed against the source. The result itself has not been reproduced. Prompt adapted for this library, inspired by the case. Business size: Neighbourhood grocery store with employees. Results are quoted as the source claimed them and never improved. Spot an error or a broken link? Email charlie@cbarmorecpa.com.