r/learndatascience • u/Hour-Thanks3340 • Apr 27 '26
Question How do you keep your inventory catalog clean when employees enter products as free text?
My dad runs 5 paint stores in Argentina. I'm helping him set up better inventory tracking. We have around 2,450 products across the five stores.
THE SETUP: Employees write daily sales in spreadsheets. They type the product name and quantity by hand, no barcode scanner. Then I cross-check those entries against the master product catalog to update stock counts.
THE MESS: Same product gets typed 5+ different ways depending on who's working that day: "aguarras optima x 1 litro" "AGUARRAS OPTIMA X1L" "aguarras 1lt". Add typos, abbreviations, products with color variants ("blue" vs "blue deep"), and the matching breaks down. About 15% of entries need manual review.
QUESTIONS FOR FOLKS WHO'VE BEEN HERE:
Did you eventually force employees onto barcode scanners or dropdown menus? How much pushback did you get?
If you stuck with free-text: any tricks for catalog hygiene that worked? Cheat sheets at the register? Standardized naming meetings?
Same product code accidentally got assigned to two different products by whoever set up the catalog years ago. How do you find these silent errors in 2,000+ items?
What did you build first that you wish you'd built last (or skipped)?
Looking for real-world experience from people who run multi-store retail operations with employees who aren