QuickBooks, spreadsheets, an online store and AI: what a small B2B seller really needs

You sell products to other companies. At some point somebody tells you that you need an ERP. Or a CRM. Or both, plus a new website and an integration between all of them.

This article explains in plain words what each of these systems does, which ones a small B2B seller needs, and which ones can wait. It also answers two questions we hear often: is QuickBooks an ERP, and is Atlaya an ERP.

How a small B2B business works today

A small B2B seller in 2026 usually runs on some mix of the tools below. You may use all of them or only two or three. See which ones you recognize:

  • Spreadsheets. Price lists arrive from suppliers as spreadsheets. The product catalog (names, attributes, descriptions) and the price calculation usually live there too.
  • QuickBooks. It holds the money: invoices, payments, taxes and, depending on how deep the owner went, stock. Prices are calculated outside it, because inside QuickBooks a price is one field with a fixed number.
  • A bookkeeper instead of your own accounting software. Some smaller businesses run no accounting software at all. They send bank statements with comments to an external bookkeeper, who enters everything into their own system.
  • An AI agent that works with files on your computer, such as Claude Cowork. More and more owners hand it the heavy lifting. It keeps written rules for each product line: how a product name is built, which attributes are required, how the price is calculated. From a supplier price list it prepares upload files for the store and for QuickBooks.
  • An online store. What customers see: the catalog, their prices, their orders.
A seller with a few thousand products and a very small team can run on exactly this set. Setting up the AI agent takes from a couple of days to a couple of weeks, including the time to read forums and watch tutorials. The time depends not on the number of products but on the number of product types. A seller with one type of product (only oils, or only end mills, or only tractors) is done in days. One honest note: this is the time for a person who already knows their catalog well. AI speeds up someone who understands the business. It does not replace that understanding.
Diagram: spreadsheets, an AI agent, QuickBooks and an online store, and what data each one keeps

Every tool is good at its own job. The hard part is where they meet

Sooner or later comes the moment "we need a website". QuickBooks has no storefront, so in Canada and the US most sellers start with Shopify. They expect a simple solution, and a basic site really is easy to launch.

QuickBooks and Shopify are excellent products. But connecting them, and filling them with a technical catalog, is not as easy as one-two-three. There are three places where it gets difficult:

  1. Supplier spreadsheet → store. Thousands of items with technical attributes have to become a catalog with working filters. This is real work, and it is usually underestimated.
  2. Store → QuickBooks. In QuickBooks the main key of a product is its name: it must be unique and no longer than 100 characters. In a store the key is the SKU. Without careful setup you get duplicates and manual matching. Sellers describe this on the Shopify community forum and on the QuickBooks community forum.
  3. Prices. QuickBooks keeps one main sales price per product. It has price rules, but they are limited and do not cover a full matrix of customers and products. Your spreadsheet has many prices: by customer group, by volume, by contract. The store shows as many as its plan allows. Shopify, for example, added basic B2B features to its regular plans in 2026, with up to three B2B catalogs; unlimited customer-specific catalogs stay on Plus.
All of this can be solved. It needs a person who understands both systems well, and a young business usually does not have one. So the owner starts looking for "one system for everything" and meets new words: ERP, CRM, warehouse management.
Diagram: three mismatches between a supplier spreadsheet, QuickBooks and an online store: catalog structure, product key and prices

What is what

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.

Is QuickBooks an ERP?

No. QuickBooks is accounting software. It does its job well, and it is often all the back office a small seller needs. What it does not do: a full price matrix by customer and product, stock by several warehouses, or bulk management of a large technical catalog.

More on this, and on how QuickBooks works together with an online store: Is QuickBooks an ERP?

Is Atlaya an ERP?

No, and it does not try to be. Atlaya is a B2B e-commerce platform: the online store and customer portal in the set of tools above. It sits next to your accounting software, not on top of it and not instead of it.

Do you need an ERP?

An ERP covers a lot: daily purchasing with demand forecasts, several warehouses with reservations and goods in transit, budgeting, money flows between legal entities, detailed profit reports, all product data in one database. For manufacturers it also plans production.

But look at what a small seller already has:

  • The order from start to finish is handled by the store and the accounting software.
  • Payroll is in QuickBooks.
  • Landed cost, reports and forecasts are calculated by an AI agent from your spreadsheets.
Our opinion: for a small B2B seller in 2026 an ERP takes more than it gives. Setup and daily management eat up the benefit.

Two caveats. First, AI solutions built for you are not free either: they cost tokens and they need a person who manages them. Second, an ERP does pay off in clear cases:

  • many people change the same data every day;
  • a bank, an auditor or an investor needs a full log of who did what;
  • you run your own production.
The signal is not turnover. It is the number of people who work with the same data at the same time.
Diagram: what a small B2B seller already covers with QuickBooks, an online store and an AI agent, and when an ERP pays off

What you need from day one

  • Accounting. Your own software or a bookkeeper with theirs.
  • Your product data in order. Spreadsheets are fine. An AI agent with saved rules makes them reliable.
  • An online store that calculates each customer's price itself and takes orders. This is the one thing spreadsheets and AI cannot give you: a place where your customers serve themselves.
A CRM, warehouse software and an ERP can be added later, when a specific problem appears.

Where Atlaya fits

Atlaya is the online store in this set of tools, built for B2B from the start:

Atlaya works without AI too: everything can be done by hand in the admin panel. See how we launch a store.

ERP, CRM and e-commerce: FAQ

More articles for you