This page explains how you can connect your inventory and sales data to power the Product Intelligence reporting engine. These data sources represent the foundation on which our AI calculates stock health, forecasts future demand, and provides strategic business advice.
Where to add data sources
To get started, log in to your account and navigate to: App / Data Sources
Integration methods
The platform offers two flexible methods for connecting your data:
- Upload physical file: Upload a .csv or .json file directly from your computer.
- Remote URL: Provide a link (URL) where the file is hosted. This allows for automatic synchronization and keeps your analytics up to date.
Accepted data fields
A. Products Data Source
This file defines your catalog and current inventory levels.
Required fields:
- sku: The unique identifier for the product.
- name: The descriptive title of the product.
- quantity: The current physical inventory (stock) available.
- price: The current selling price.
Optional fields:
- description: A detailed text about the product.
- category: The group or hierarchy (e.g., Gadgets > Smart Office).
- manufacturer: The brand or manufacturer.
- availability: The current status (e.g., in_stock, preorder, out_of_stock, discontinued).
- currency: The currency used (e.g., RON, EUR).
- image: A URL link to the product image.
- url: The link to the product page in your store.
- lang: The language code for the product data.
Sample files:
B. Orders Data Source
This source provides the sales history necessary to understand customer behavior and trends.
Required fields:
- order_id: The unique reference number for the transaction.
- date: The date and time of the sale (Format: YYYY-MM-DD HH:MM:SS).
- total: The total value of the order.
- sku: Must match exactly with the SKU in the Products file.
- name: The name of the product as it appears in the order.
- quantity: The number of units sold.
- price: The specific selling price at the time of the order.
Optional fields:
- customer_id: A unique reference for the buyer.
- currency: The currency used for the transaction.
- lang: The language code used during the checkout process.
Sample files:
Important integration rules
- SKU matching: The SKU is the “bridge” between your files. It must be identical in both the Products and Orders sources for the AI to correlate current stock with past sales.
- Logistics Parameters: Please note that Lead Time Days (supplier delivery time) and Safety Stock Days (safety stock) cannot be set through these files. They must be configured directly in the application settings for each product to ensure the accuracy of AI calculations for your specific operations.
Why do we use this data?
The information provided is processed to generate the Product Intelligence Report. This advanced analysis helps you manage your business like a professional by providing:
- Stock and Delivery Insights: Detailed alerts about when to replenish stock (Reorder Point) to avoid running out.
- Demand Forecast: AI-based predictions on the number of units you will sell in the next 3 to 12 months.
- Capital Efficiency: Analysis of turnover rates to identify money tied up in unsold products.
- Profit Optimization: Data-driven suggestions for price adjustments and promotions to maximize your revenue.