Spreadsheets. Excel or Google Sheets. The most flexible tool you have and the natural home for supplier data and price calculations. Their weak point: several people cannot safely change the same data at the same time.
A chatbot in the browser and an AI agent. These are different things.
Chatbots such as ChatGPT, Claude, Gemini or Grok have become much better with a single table. Upload one spreadsheet, ask a question, and the answer is usually correct: the best of them run code on the file instead of guessing.
But a product catalog is never one table. It is a supplier price list, your master file, a price calculation, the rules for product names, and the upload files for the store and for accounting. A chat works on copies of the files you upload. Projects and memory let it keep some files and instructions between conversations, but your working folder and the chat remain two separate places. Every new price list has to be uploaded, every result downloaded and put back by hand. You become the link between the files, and that is where mistakes come from.
An AI agent works inside your folder:
- All files at once. It reads the master spreadsheets and the new price list together and saves the result to the same folder.
- Code for every step. A 10,000-row table is processed by a small program, the same way each time.
- Saved rules. How a name is built and how a price is calculated is written down once and applied every time.
We do not recommend managing a product catalog in a browser chat alone, however strong the model is.
Accounting software. QuickBooks, Xero and similar. It records money: invoices, bills, payments, taxes, payroll. QuickBooks also has basic CRM features: your customer list, their contacts and their purchase history.
CRM (customer relationship management). A system for the sales team: contacts, deals, tasks, who talked to whom. While your sales team is small, you do not need a separate CRM: the basic CRM features of your accounting software are enough, and an AI agent covers the rest. A CRM becomes useful when several salespeople have to share customers and deals.
Online store (e-commerce platform). The place where the customer sees the catalog and their own price, and places an order without calling you.
ERP (enterprise resource planning). One large system that runs the whole company from a single database: purchasing, warehouses, finance, production. More on it below.