Spot Inventory connector for Claude — documentation
Overview
The Spot Inventory connector lets Claude answer questions about your KORONA POS stores. It is a remote connector (a Model Context Protocol server) hosted by Spot Inventory at https://app.spotinventory.com/mcp. There is nothing to install: you add the URL in Claude and sign in.
It reads the KORONA data Spot Inventory already syncs for your account: sales, stock, products, suppliers and purchase orders. It does not call KORONA on every question, and it never writes to KORONA.
Requirements
A Spot Inventory account with KORONA connected. Sign up on spotinventory.com. If you only want to look around, use the Fernway demo store (made-up data, no account needed).
A Claude account with custom connector access. Free accounts support one custom connector. On Team and Enterprise plans, an owner may need to add the connector for the organization.
Connect
Claude on the web, Claude Desktop: open Customize, then Connectors, choose Add, then Custom → Web. Name it "Spot Inventory" and paste https://app.spotinventory.com/mcp. Then click Connect. Claude mobile can use the connector once you have added it on the web or desktop.
In a chat, enable the connector from the tools menu and ask a question. You can also add it from Claude's connector directory: search for "Spot Inventory".
Claude Code: run claude mcp add --transport http spot-inventory https://app.spotinventory.com/mcp, then type /mcp and sign in.
Signing in and choosing an account
When you connect, Claude opens Spot Inventory's sign-in (OAuth). Sign in with your Spot Inventory login, choose which Spot Inventory account (and so which stores) Claude may read, and click Connect. Each owner connects their own stores. Claude never sees your password.
The same screen has a tick box, "Also let it manage the team". It is off unless you tick it. Leave it off and Claude cannot manage your team; the feature-request tool can still save a request you ask to send. Tick it and Claude can also invite people to that Spot Inventory account, change their roles and remove them, when you ask. It only works if you are that account's owner.
The demo store
On the sign-in screen you can choose the Fernway demo store instead of an account. It is a made-up three-store retailer with synthetic data, so anyone can try the inventory tools without an account. Team tools require a signed-in owner account.
Results from the demo store include a notice field saying they are sample data from a fictional retailer, with the link to start a trial with your own KORONA POS stores. Results from your own account do not have it.
Tools
The connector has three tools for inventory questions: list, query and request. list and query only read; request saves a feature request in Spot. Four more tools manage the Spot team and are described under "Team tools" below. The arguments below are the ideas each tool understands; Claude fills them in from your question, and they may evolve.
List
Lists your stores, suppliers, categories and items. It also shows which datasets are available, which fields you can use and when Spot last observed the data.
Tool:
listArguments: what to list, search, limit and offset. Choose datasets to discover reports, schema for field definitions, values for distinct dimension values, or freshness for coverage.
Example prompts:
- “Which stores and suppliers do I have?”
- “Find the items with "cold brew" in the name.”
- “What questions can you answer about my stock?”
Query inventory data
Answers seven preset inventory questions and builds custom reports. You can group several measures by store, supplier, product or business date using the fields available in each dataset.
Tool:
queryArguments: For a custom report use dataset, measures, dimensions, filters, orderBy and dates. For a preset use metric, or a short intent phrase describing what you want to know; period (yesterday, last 7, 30 or 90 days, this or last week, this or last month) or from/to dates; store; supplier; item; category; group by (item, category, supplier, store, or day, week or month, depending on the metric); sort; days ahead (low stock); limit.
Example prompts:
- “What should I reorder from each supplier this week?”
- “What were my top 10 sellers last month at Harbor?”
- “Which suppliers delivered fewer units than expected last month?”
For a custom report, Claude selects measures and dimensions from one dataset. For a preset, it can pass the metric or a short phrase describing what you want to know. That phrase is only used to choose the metric; it is not stored or logged.
The seven metrics
Reorder list
What to reorder now, by supplier (or by item or category), with quantities, cost and order-by dates.
Filters: supplier, store, group by (supplier, item or category), limit.
How it is computed: The reorder list is a set of suggestions only. Nothing is ordered, and nothing is sent to a supplier or to KORONA.
- “What should I reorder from each supplier this week?”
- “What do I need to order from my biggest supplier today?”
- “Which reorders are most urgent at Harbor?”
Low stock
What's out or will run out soon, by item and store, or counted by store, category or supplier.
Filters: store, days ahead (how far to look, default 7), group by (item, store, category or supplier), limit.
How it is computed: It compares what is on hand with how fast the item has been selling, and lists items that are out or would run out within the days ahead you ask about.
- “What will run out before the weekend?”
- “What is already out of stock at North?”
- “Which items will run out in the next 10 days?”
Sales by item
Units and revenue per item for any period, compared with the previous period, or grouped by category, supplier, store, day, week or month.
Filters: period or from/to dates, store, item (name, SKU or category words), group by (item, category, supplier, store, day, week or month), sort (units or revenue), limit.
How it is computed: Units and revenue are added up per item for the period, then compared with the period of the same length just before it.
- “What were my top 10 sellers last month at Harbor?”
- “Which items are selling faster than the month before?”
- “How did cold brew cans sell this week across all stores?”
Sell-through
How much of what you had was sold, per item, category, supplier or store, or over time by day, week or month.
Filters: period or from/to dates, store, group by (item, category, supplier, store, day, week or month), sort (lowest or highest), limit.
How it is computed: Sell-through is sold divided by (sold plus on hand), for the period and store you ask about. A sell-through of 50% means half of what you had was sold.
- “Which categories have the lowest sell-through this quarter?”
- “What is the sell-through of each item at Mill this month?”
- “Which items sold less than a third of what we had?”
Stockout cost
Estimated sales lost to out-of-stock days, per item and store or totalled by store, category or supplier.
Filters: period or from/to dates, store, item, group by (item, store, category or supplier), limit.
How it is computed: Stockout cost is an estimate, not a measured figure: average daily sales on the days the item was in stock, times the number of days it was out of stock, times its price.
- “How much did stockouts cost us last month?”
- “Which items cost us the most by being out of stock this quarter?”
- “What did stockouts cost at North last week?”
Stock on hand
How many units you have right now, and what they are worth at cost, per item, store, supplier or category.
Filters: store, supplier, item, category, group by (item, store, supplier or category), sort (units or value), limit.
How it is computed: It adds up the book stock Spot has for each item as of the last full day of synced data, and multiplies by the item cost where KORONA has one. Items with no known cost are left out of the value, never counted as zero.
- “How much stock do I have in each category?”
- “What is my inventory worth by supplier?”
- “How many of each tee do we have at Harbor?”
Open orders
Purchase orders placed with suppliers and not yet fully received: what is outstanding, what it is worth and when it is due.
Filters: store, supplier, item, group by (order, supplier or store), sort (soonest, value or units), limit.
How it is computed: It lists orders that are open or partly received, with the units still to come and the expected date. Value is outstanding units at the price on each order line, falling back to the current item cost for lines without one (the answer says which it used). Old orders whose delivery never completed are left out of the totals as stale. If your KORONA account has no purchase orders synced yet, it says so instead of showing an empty list as if nothing were on order.
- “What purchase orders are still open?”
- “What is on order from my biggest supplier and when is it due?”
- “Which open orders are overdue?”
Request a feature
Sends your idea to the Spot team. It saves the request in Spot and never touches KORONA.
Tool:
requestArguments: request text; an email if you use the demo store (signed in, we use your Spot account email).
Example prompts:
- “Tell Spot I want a tool for supplier lead times.”
- “Send Spot a request: show me slow movers by supplier.”
- “Ask Spot to add a weekly sales comparison by store.”
Team tools
These four tools list or manage who can sign in to your Spot account, so they are off by default. They work only when the person who connected is an owner of the account and ticked "Also let it manage the team" on the Spot screen. Without that, Claude is told how to turn it on and nothing changes. They are not available in the demo store. The rules are the same as in Spot's own Settings: the last owner cannot be removed or demoted, and store staff must be given at least one store.
List team members
Shows who is on the Spot account: email, role, the stores a store-staff member sees, and whether an invitation is still waiting. Reads only.
Tool:
team_listExample prompt:
- “Who is on my Spot team?”
Invite a team member
Changes data. Adds a person to the Spot account with a role and sends them an invitation email.
Tool:
team_inviteExample prompt:
- “Invite sam@example.com to Spot as store staff for the Harbor store.”
Change a team member's role
Changes data. Changes the role of someone already on the team, which can give or take away access. The last owner cannot be demoted.
Tool:
team_set_roleExample prompt:
- “Make sam@example.com a buyer.”
Remove a team member
Changes data. Removes someone from the Spot account; they lose access right away. The last owner cannot be removed.
Tool:
team_removeExample prompt:
- “Remove sam@example.com from my Spot team.”
Custom reports
Ask “What were my net sales and returned units by store last month?” for product receipt lines, or “How much tax did each register record?” for receipt header totals. The product sales report includes returns. The sales-by-item preset uses the positive sales lines Spot uses for inventory planning.
For receiving, ask which suppliers delivered short. For inventory, ask how many items had a recorded zero balance on each capture date. The dataset catalog shows the grain of each report and which sources your account has. Results identify missing amounts and give a next offset when there are more rows.
Buyer reports
Ask what changed stock between two captures, whether another store can spare a size before you buy, or which suppliers have been delivering late. You can also ask which sizes are missing within a style and which slow-selling items tie up the most known inventory cost.
Ask for the records behind an answer. For a supplier shortage, you can see the purchase order, receipt, SKU, destination and expected and received quantities on each contributing line.
Data freshness
Spot Inventory reports the last complete business day. Ask Claude to check freshness for that date, the last refresh time when available and coverage of the observed data.
Permissions
The connector never changes anything in KORONA. It can read sales, stock, products, suppliers and purchase orders for the account you chose. It never returns customer, cashier or payment data, because Spot Inventory's sync drops those.
In Spot Inventory it can save a feature request, when you ask Claude to use the request tool. If you ticked "Also let it manage the team" when connecting, and you are the account's owner, it can also invite people, change their roles and remove them, when you ask. Inviting someone sends them an invitation email. To take the team permission away, disconnect and connect again without the tick.
Disconnecting and revoking
Remove the connector in Claude (Settings, Connectors), or revoke the grant in Spot Inventory. Either one stops Claude from reading your data right away. You can add it again at any time.
Troubleshooting
"This account isn't connected to KORONA": connect KORONA in Spot Inventory first, then try again.
"The first sync is still running": a new account needs its first KORONA sync to finish before there is anything to read. Wait for it, then ask again.
"KORONA login failed": the KORONA login Spot Inventory uses was rejected, so the sync stopped. Update the KORONA connection in Spot Inventory, and the next sync will catch up.
Nothing works after a plan change: check that your Claude plan still allows custom connectors, and that the connector is switched on in the chat.
Support
Email support@spotinventory.com. See also the connector privacy policy.