Guides

Connect your data: files, API and automatic mapping

Which tables to load, what each one unlocks, how column mapping and quality reports work, and how to keep data fresh.

2 Nov 2026 · 1 min read

Agents work on your own products, stores, orders, stock and policies. You load them once into a standard data model. Your files can keep your own column names: the platform maps them for you.

What to load, and what it unlocks

Table Minimum columns Unlocks
Products sku, name, category Personal Shopper, Shop the Look, merchandising agents
Stores store_id, name, city (+ opening hours, time zone) Store Locator, Store Staff Copilot
Customers customer_id Loyalty Assistant, Clienteling, segments
Orders + Order lines order_id, customer_id, order_date / order_id, sku order status, returns, sales analytics
Inventory sku, location_id, on_hand Stock-out Sentinel, availability
Promotions promo_id Promotion Analyst
Knowledge docs .md / .txt files Customer Care, FAQ, HR assistant

Formats: Parquet (recommended), CSV, TSV and JSON. Policies and FAQs: Markdown or plain text.

1. Upload a file

In the console, open Data, choose the table (for example Products), pick your file and click Upload & map columns.

2. Check the column mapping

The platform proposes a match for each standard field (for example item_code → sku, sale_price → price, image_link → image_url) and shows sample values from your file. Required fields are marked; fix anything with the dropdowns, then click Process.

3. Read the quality report

Processing takes seconds (products a little longer, because they're indexed for AI search). The report shows rows loaded, duplicates removed, empty or unreadable values per field, and columns that weren't used.

Keeping data fresh

Upload the same table again whenever it changes. Each upload is a new version; the newest successful one becomes active automatically and agents use it from the next question. A knowledge document with the same file name replaces the old one.

Automate it

Push files from your own systems with the API:

curl https://servicebuddy.com/api/v1/datasets -H "Authorization: Bearer $API_KEY" \
  -F entity=product -F [email protected]

See API keys and integration. Connectors for e-commerce platforms such as Shopify and Magento are on our roadmap.

#onboarding#data#integration#csv#parquet

See it on your own catalog. Explore the agents

Popular AI Agent Buddies

🛍️ ● Live demo

Customer · Discovery & shopping

Personal Shopper

Finds products by intent, budget, colour and occasion; compares options and recommends the best fits.

For customers
Try it live →
💬 ● Live demo

Customer · Service

Customer Care

Answers policy questions from the retailer's own documents, checks orders and return eligibility.

For customers
Try it live →
🚚 ● Live demo

Customer · Service

Order Status (WISMO)

"Where is my order?": status, dates and what happens next.

For customers
Try it live →
📍 ● Live demo

Customer · Service

Store Locator

Nearest stores, live open/closed status in local time, hours and services.

For customers
Try it live →
👗 ● Live demo

Customer · Discovery & shopping

Shop the Look Stylist

Builds a complete, coordinated outfit around any product or occasion using only real catalog items.

For customers
Try it live →
📊 ● Live demo

Merchandising & assortment

Merchandising Copilot

Answers assortment and performance questions with numbers, then recommends actions.

For your team
Try it live →
🚨 ● Live demo

Inventory & supply chain

Stock-out Sentinel

Flags SKUs at risk of stock-out from on-hand stock vs recent sales velocity.

For your team
Try it live →
🤝 ● Live demo

Store operations

Clienteling Assistant

Prepares a client brief (tier, past orders) and suggests products to show a returning customer.

For your team
Try it live →
👥 ● Live demo

Marketing & CRM

Segment Builder

Builds customer segments from tiers, cities and purchase behaviour, with counts.

For your team
Try it live →